Developer (ETL) Developer (ETL) …

Ameriprise Financial, Inc.
in Noida, Uttar Pradesh, India
Permanent, Full time
Last application, 25 Jan 21
Competitive
Ameriprise Financial, Inc.
in Noida, Uttar Pradesh, India
Permanent, Full time
Last application, 25 Jan 21
Competitive
Developer (ETL)
Job Description

Develop, document, test, modify and maintain new and existing ETL components of software applications. Learn and apply standard techniques, procedures, and criteria to the development life cycle. Through time and exposure, gain specific application and technology knowledge to participate in and contribute to the specification and design development process for ETL components across the portfolio. Create system and operating documentation. Receive technical guidance and day-to-day direction from Sr. ETL Lead.

Responsibilities

--Under direct supervision, write new ETL code using prescribed specifications and design documentation in accordance with Informatica programming standards. Modify, test and troubleshoot existing programs/software utilizing the appropriate hardware, database, and development/programming technology. Contribute to feature and functionality planning. Execute coding/modification of new and existing programs/software with focus on user experience and optimal program/system performance.
--Maintain and modify ETL programs/software. Make recommendations for improvements and/or remedies to issues encountered. Implement approved changes by amending ETL flow charts, developing detailed ETL logic, and making changes to code. Write and maintain development/programming/systems documentation, as well as operations and user guides (as required). Document development/programming problems and resolutions for future reference.
--Effectively unit test all ETL code and programs prior to releasing them to SIT and UAT testing resources. Resolve unit test issues in a timely manner. Assist the testers in identifying test cases and aid in creating/mining test data to enable a thorough test of development deliverables. Respond to inquiries and issues in a timely manner as the developed code/program moves through the testing process and ultimately into production.
--Develop working knowledge in all systems, processes and data relating to the assigned business or projects. Develop expertise within the application development practice-including all processes, tools and best practices. Develop and maintain development/programming expertise and identify and pursue areas for development and training that will enhance job performance via on the job learning and best practices from prior projects, training and peer learning.
--Provide production support to the end-user and technical operations staff as required. Research system/application issues/problems within area/program(s) of responsibility and recommend innovative solutions to prevent recurrence.

Required Qualifications

•Provide production support to the end-user and technical operations staff as required. Research system/application issues/problems within area/program(s) of responsibility and recommend innovative solutions to prevent recurrence.
• Demonstrated experience coding in Informatica Power Center platforms with good understanding of techniques, procedures and various source types
• Knowledge of data warehouse solutions including data modeling, data flow diagramming and process modeling working with various DBMS types
• Demonstrated aptitude to quickly learn and apply new tools and processes.
•Effective oral and written communication skills along with logical, analytical and abstract thinking skills.
•Demonstrated understanding of the Software Development Life-Cycle (SDLC) and ETL programming/development procedures.

Preferred Qualifications

• Experience in troubleshooting and debugging Informatica mappings, sessions and workflows developed by others
• Strong attention to detail, follow-through and time management skills.
• Experience and/or comfort working in a multi-sourced, multi-vendor environment.
• Demonstrated aptitude to quickly learn and apply new tools and processes.
• Technology stack preferred: ETL - Informatica, PL/SQL - Oracle 12c, MS SQL, Shell Scripting, Mainframe
•Experience working with Informatica PowerExchange, Tivoli Work Scheduler (TWS), Mainframe
Ameriprise Financial, Inc. logo
More Jobs Like This
See more jobs
Close
Loading...
Loading...