Senior Informatica Developer

Job Summary

We are seeking dedicated professionals to join our team in supporting large-scale data integration initiatives within a leading technology-driven environment. Our team focuses on enterprise-level ETL development and data pipeline support essential for critical business functions.

Responsibilities

• Design, develop, and maintain ETL workflows and mappings for enterprise data integration projects.
• Build and support data pipelines using Informatica PowerCenter, extracting and processing data from mainframe and other sources.
• Write and optimize SQL queries for data validation, reconciliation, and performance tuning, ensuring robust system performance.
• Create and maintain technical documentation, collaborating closely with Business Analysts, QA, and application teams to clarify data requirements and ensure data quality.

Required

• Hands-on experience in ETL development using Informatica PowerCenter, including design and support of enterprise-scale data pipelines.
• Proven ability to work with relational databases such as Oracle and manage data integration from mainframe sources like VSAM, flat files, COBOL copybooks, and DB2.
• Advanced SQL skills for data validation, reconciliation, and performance tuning, alongside experience implementing complex data transformations and quality checks.
• Strong background in ETL job monitoring, troubleshooting, and production support, with demonstrable experience in creating technical documentation and maintaining enterprise data systems.

About SSI People

With over 26 years of industry experience, SSi People has built its reputation and expertise on putting people first. Everything we do works toward delivering exceptional experience for our consultants, our clients, and our internal team. Through a genuine commitment to people in everything we do. We have developed refined processes and a stellar internal team to deliver talent quickly. More importantly, we focus on building long-term relationships, not transactions. Putting people first is just what we do well.