Senior ETL / Informatica PowerCenter Engineer (Mainframe + Oracle)

Job at a Glance

• Title: Senior ETL / Informatica PowerCenter Engineer (Mainframe + Oracle)
• Location: Strongsville, OH (Preferred), Pittsburgh, PA (Secondary), Birmingham, AL, Farmers Branch, TX, Phoenix, AZ
• Contract: W2 only, 6-12 month contract with potential for extension or conversion to full time with either the client or CEI
• Pay: $60/hour + optional medical, dental, vision, 401(k) match

Overview

Design, develop, and maintain ETL workflows and mappings for enterprise data integration. Build and support data pipelines using Informatica PowerCenter, extracting and processing data from mainframe sources and other systems. Implement complex data transformations and business rules, ensuring data quality, accuracy, and completeness. Collaborate with cross-functional teams to clarify data requirements and support enterprise data initiatives.

Key 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

Preferred Skills

• CI/CD pipelines
• Confluence
• Java
• Kafka
• Jira

Why Should I Apply?

This position offers an opportunity to work on enterprise-scale data integration projects within a dynamic team environment. If you have a strong background in Informatica PowerCenter and mainframe data sources, this role provides a challenging and rewarding environment to advance your career.

About CEI:

As a trusted technology partner, CEI delivers solutions that help our customers transform their business and achieve meaningful results. From strategy and custom application development through application management - our technology and digital experience services are tailored to meet each unique need of our customers. Our staffing solutions bring specialized skills to complement our customers'' workforce and project requirements.

#ZR
#INDGEN