Informatica PowerCenter Engineer

Computer Enterprises, Inc.

Strongsville, OH, United States

3 months ago

Role details

Contract type

Temporary to permanent

Employment type

Full-time (> 32 hours)

Experience level

Expert

Compensation

$124,800.0

Working hours

Regular working hours

Job source

indeed.com

Tech stack

Java (Programming Language) Confluence JIRA COBOL (Programming Language) Data Validation Data Integration Extract Transform Load (ETL) Data Transformation IBM DB2 Relational Databases Mainframes Oracle (Applications)

+8 more

Performance Tuning SQL Databases Virtual Storage Access Methods Data Processing Sql Optimization Informatica Powercenter Apache Kafka Data Pipelines

Job description

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., * 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, 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.

Requirements

Do you have experience in Technical writing?, * 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

Benefits & conditions

3.33.3 out of 5 stars Strongsville, OH 44136 $60 an hour - Contract, Pulled from the full job description

Health insurance
401(k) matching
Vision insurance
Dental insurance, * 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