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
Recommended Jobs
Community Business Sales Representative
About Hometown Hometown Urgent Care & Occupational Health proudly serves communities across Ohio with 33 clinic locations and nearly 20 years of trusted care. As Ohio’s largest urgent care network…
Order Selector
Job Description Job Description Sirna & Sons Produce is a fourth-generation, family-run, wholesale food distributor. In our 81 years of service, we have continually provided premium produce, comp…
OTR Dry Van Company Driver W2 Job in Hamilton, OH by American Trucking Group
Dry Van Company Driver W2 Truck Driving Jobs - Hamilton, OH Have you ever dreamed of a career that allows you to blend your passion for CDL A driving with the freedom to explore America's divers…
Psychology Adjunct Faculty
Job Description Job Description Ohio Dominican's Psychology program prepares graduates who are grounded in our liberal arts tradition and well versed in the science and application of psychology …
PRN Clinician I
PRN Group Clinician Shifts Available: 8am-5pm, 7 days a week. *Ideal candidates will be able to pick up shifts between Fridays and Mondays Pay Ranges: $35.94 - $46.73, based on license and year…
Banquet Server - On Call
Job Description Job Description The Banquet Server supports and works with the banquet teams to provide an exceptional experience for all guests. This role assists with setup, breakdown, and serv…
EPC Project Engineer
Who we are Demand for critical minerals to power the energy transition is growing exponentially. Yet, we know mining deeper and broader, and building landfills higher and wider, works against our fi…
Chemical Mix Operator
Chemical Mix Operator Work with a busy team in a clean, safe, air-conditioned building, in a healthy, growing business. About Renegade Materials Corporation We are building our production an…
Mailing Helper
Job Description Job Description Lahlouh’s business model is built on solving end to end supply chain problems not simply processing transactional print orders. Lahlouh is a partner that focuses o…
Sr. Infrastructure Engineer
Job Description Serves as the primary resource responsible for making recommendations and proactively monitoring the organization’s architecture and network technologies to ensure optimal capacity…