What are the responsibilities and job description for the Senior ETL Informatica Developer position at System One?
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