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
Every day, System One focuses on services and solutions that require a high degree of specialization, in-demand technical skills, and large-scale operational expertise. We are essential partners to those on the front lines of our nation’s most critical infrastructure, technology, and life sciences initiatives.
Founded more than 40 years ago as a staffing partner to the engineering industry, today System One is a diversified organization operating in over 50 locations and putting more than 9,000 people to work in the United States, Canada, and the United Kingdom.