Informatica IDMC Developer

Introduction

We are seeking a talented and experienced professional to design, develop, and maintain data integration solutions using Informatica Intelligent Data Management Cloud. This role involves working with cutting-edge technologies to build robust data integration workflows.

Required Skills & Qualifications.

• Experience in building and maintaining data integration workflows using Informatica IDMC services (Cloud Data Integration, Cloud Application Integration, Data Quality).
• Proven experience in developing mappings, tasks, and pipelines for ETL/ELT processes.
• Hands-on experience with Informatica PowerCenter to IDMC migration.
• Familiarity with standard data warehousing objects (type-2 dimensions, aggregations, star schema, etc.).
• Strong SQL/PLSQL skills and experience with Oracle databases (11g/12c/19c).

Preferred Skills & Qualifications

• Experience with complex transformations such as XML, XML parser, Java, and HTTP transformation.
• Familiarity with Autosys for job scheduling.
• Experience working with Informatica Data Quality tools (Analyst and Developer).

Day-to-Day Responsibilities

• Design and build integrations supporting standard data warehousing objects.
• Perform source system analysis as required.
• Collaborate with DBAs and Data Architects to plan and implement appropriate data partitioning strategy.
• Implement versioning of the ETL repository and supporting code as necessary.
• Develop stored procedures, database triggers, and SQL queries where needed.
• Implement best practices and tune SQL/queries for optimization.
• Load and transform data from various external sources to Relational databases using Informatica.

Company Benefits & Culture

• Inclusive and diverse workplace culture.
• Opportunities for professional growth and development.
• Comprehensive benefits package.

For immediate consideration please click APPLY to begin the screening process with Alex.