Senior Informatica ETL Developer - Data Warehouse Expert

ENIN Systems, INC; Chicago (IL); On-site; USD 110,000 - 160,000; Full time

Job summary

ENIN Systems, INC in Chicago seeks a Senior Informatica Developer to design, develop, implement, and maintain enterprise data integration and ETL solutions. You will leverage Informatica PowerCenter, data warehousing concepts, and SQL to build scalable data pipelines.

Collaborate with analysts and DBAs, optimize queries, ensure data quality, and support BI initiatives. You will mentor junior developers and contribute to SDLC practices, governance, and deployment standards.

Qualifications

• Bachelor’s degree or equivalent practical experience in CS/IT/Engineering.
• Strong ETL and SQL/PL/SQL skills with data warehousing experience.
• Experience designing and implementing data integration and ETL workflows.
• Familiarity with Unix/Linux shell scripting and scheduling tools (Autosys/Control‑M).
• Knowledge of data governance, data quality, and SDLC/Agile practices.

Responsibilities

• Design, develop, test, and deploy ETL workflows using Informatica PowerCenter.
• Develop mappings, mapplets, sessions, and workflows and promote reusable transformations.
• Translate business requirements into technical specifications for data integration.
• Optimize SQL queries and database objects; perform ETL performance tuning.
• Monitor ETL jobs, troubleshoot issues, and resolve production incidents.
• Collaborate with analysts, DBAs, and cross‑functional teams; mentor junior developers.
• Maintain documentation and adhere to data governance and deployment standards.

Skills

Informatica PowerCenter

SQL

ETL development

Data warehousing

Performance tuning

Data quality

Unix/Linux shell scripting

Education

Bachelor’s degree in Computer Science, Information Technology, Engineering, or related field

Tools

Informatica PowerCenter

Oracle

SQL Server

DB2

Teradata

Job description

ENIN Systems, INC in Chicago seeks a Senior Informatica Developer to design, develop, implement, and maintain enterprise data integration and ETL solutions. You will leverage Informatica PowerCenter, data warehousing concepts, and SQL to build scalable data pipelines.

Collaborate with analysts and DBAs, optimize queries, ensure data quality, and support BI initiatives. You will mentor junior developers and contribute to SDLC practices, governance, and deployment standards.