ETL informatica Developer

ETL Informatica Developer

Location: Jersey City, NJ Work Arrangement: Hybrid Client Industry: Financial Services Duration: 12 Months Contract Schedule: Standard Time (8 AM to 5 PM EST)

Job Summary:

We are seeking an experienced Senior ETL Informatica Developer with strong expertise in Informatica ETL, PL/SQL, and SQL. The ideal candidate will have hands-on experience working with Informatica IDMC, along with exposure to Rational and Dyimedial databases. This role involves designing, developing, and optimizing data integration solutions in a high-performance environment.

Key Responsibilities:

• Design, develop, and maintain ETL workflows using Informatica (PowerCenter / IDMC)
• Develop and optimize complex PL/SQL procedures, functions, and packages
• Work extensively with SQL for data extraction, transformation, and loading
• Integrate data from multiple sources including Rational and Dimensional databases
• Perform data analysis, data mapping, and data validation
• Troubleshoot ETL issues and optimize performance of data pipelines
• Collaborate with cross-functional teams including business analysts and data architects
• Ensure data quality, consistency, and governance standards are maintained
• Support production deployments and provide post-production support

Required Skills & Qualifications:

• 10–15 years of experience in ETL development using Informatica
• Strong hands-on experience with Informatica IDMC (Intelligent Data Management Cloud)
• Expertise in PL/SQL and SQL with performance tuning knowledge
• Experience working with Rational Database and Dimensional Database
• Strong understanding of data warehousing concepts and ETL best practices
• Experience in debugging, performance tuning, and optimization
• Good understanding of data models, data mapping, and transformation logic
• Strong analytical and problem-solving skills

Compensation:

• Hourly Rate: $65 - 68 per hour This reflects base compensation and may vary based on candidate qualifications.

Benefits:

The Company offers the following benefits for this position, subject to applicable eligibility requirements: medical insurance, dental insurance, vision insurance, 401(k) retirement plan, life insurance, long-term disability insurance, short-term disability insurance, paid parking/public transportation, paid time off, paid sick and safe time, hours of paid vacation time, weeks of paid parental leave, and paid holidays annually – as applicable.

About Us:

At Collabera, we don't just offer jobs—we build careers. As a global leader in talent solutions, we provide opportunities to work with top organizations, cutting-edge technologies, and dynamic teams. Our culture thrives on innovation, collaboration, and a commitment to excellence. With continuous learning, career growth, and a people-first approach, we empower you to achieve your full potential. Join us and be part of a company that values passion, integrity, and making an impact.