Senior ETL Informatica Developer

Tittle:

Sr.

Software Engineer Location:

PA

• Pittsburgh, OH
• Cleveland, AL
• Birmingham, TX
• Dallas, AZ

•

Phoenix Work Mode :

5

Days Onsite Duration:

Contract to

Hire Years Of Exp Required:

12+ Years Function of the

Group:

Informatica, ETL and Database Development Project :

Informatica, ETL and Database Development, Analysis Industry Background:

Banking or Finance Job Responsibilities:

• Design, develop, and maintain ETL workflows and mappings for enterprise data integration
• Build and support data pipelines using Informatica PowerCenter
• Extract and process data from mainframe sources and other sources
• Implement complex data transformations and business rules
• Write and optimize SQL queries for data validation, reconciliation, and performance tuning
• Work with relational databases such as Oracle, etc.
• Monitor ETL jobs, troubleshoot issues, and provide support
• Ensure data quality, accuracy, and completeness
• Create and maintain technical documentation (mappings, workflows)
• Collaborate with Business Analysts, QA, and application teams to clarify data requirements Required Skills
• Hands-on experience in ETL development using Informatica PowerCenter
• Strong experience designing, building, and supporting enterprise-scale data pipelines
• Proven ability to work with relational databases such as Oracle
• Solid understanding of data integration from mainframe sources, including VSAM, flat files, COBOL copybooks, and DB2
• Advanced SQL skills for data validation, reconciliation, and performance tuning
• Experience implementing complex data transformations, business rules, and data quality checks
• Knowledge of ETL job monitoring, troubleshooting, and production support processes
• Strong background in technical documentation, including ETL mappings, workflows, and design specifications
• Ability to collaborate effectively with Business Analysts, QA, and application teams to translate business requirements into technical solutions
• Experience ensuring data quality, accuracy, and completeness across enterprise data systems Flex Skills/Nice to

Have:

• Java
• Kafta
• Jira
• CI/CD pipelines

Confluence Ref:

#404-IT Pittsburgh