Informatica Developer

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

We are seeking an experienced Senior Informatica Developer to design, develop, implement, and maintain enterprise data integration and ETL solutions. The ideal candidate will have strong expertise in Informatica PowerCenter, data warehousing, SQL, performance tuning, and data quality management. The candidate will collaborate with business analysts, data architects, database administrators, and other technical teams to deliver reliable and scalable data solutions.

Key Responsibilities:

• Design, develop, test, and deploy ETL workflows using Informatica PowerCenter.
• Develop complex mappings, mapplets, sessions, workflows, and reusable transformations.
• Analyze business requirements and translate them into technical specifications.
• Develop and optimize SQL queries, stored procedures, and database objects.
• Perform ETL performance tuning and troubleshoot data integration issues.
• Integrate data from multiple sources, including relational databases, flat files, APIs, and enterprise applications.
• Support data warehouse, data mart, and business intelligence initiatives.
• Implement data validation, data cleansing, reconciliation, and quality checks.
• Monitor production ETL jobs, investigate failures, and resolve incidents.
• Work with Oracle, SQL Server, DB2, Teradata, or other enterprise databases.
• Participate in code reviews, unit testing, system integration testing, and deployment activities.
• Maintain technical documentation, data mappings, and operational procedures.
• Collaborate with cross-functional teams and mentor junior developers.
• Follow data governance, security, and development standards.

Required Technical Skills:

• Strong experience with Informatica PowerCenter and ETL development.
• Advanced SQL and PL/SQL programming skills.
• Experience with data warehousing concepts, dimensional modeling, and data integration.
• Knowledge of relational databases such as Oracle, SQL Server, DB2, or Teradata.
• Experience with ETL optimization, debugging, and production support.
• Familiarity with Unix/Linux shell scripting.
• Understanding of data quality, data profiling, and data reconciliation.
• Experience with scheduling tools such as Autosys, Control-M, or similar tools.
• Proficiency in SDLC, Agile methodologies, version control, and deployment processes.
• ETL/ELT Development
• SQL and PL/SQL
• Data Warehousing
• Unix Shell Scripting
• ETL Performance Tuning
• Production Support

Preferred Qualifications:

• Experience with Informatica Intelligent Data Management Cloud (IDMC), Informatica Cloud Data Integration, or Informatica Data Quality.
• Exposure to cloud data platforms such as AWS, Azure, or Snowflake.
• Experience with big data technologies such as Hadoop or Spark.
• Knowledge of CDC (Change Data Capture) and incremental data loading.
• Familiarity with CI/CD pipelines and automated ETL testing.
• Experience in banking, healthcare, insurance, retail, or other enterprise environments.

Education:

Bachelor’s degree in Computer Science, Information Technology, Engineering, or a related field, or equivalent practical experience.

• Strong analytical and problem-solving skills.
• Excellent communication and collaboration abilities.
• Ability to manage multiple priorities and meet project deadlines.
• Attention to detail and commitment to data accuracy.
• Ability to work independently and provide technical leadership.
• High-quality, reusable ETL mappings and workflows.
• Optimized data integration processes.
• Accurate and reliable data warehouse loads.
• Production issue resolution and root-cause analysis.
• Technical documentation and deployment support.