ETL Developer (IICS/IDMC)

Solugenix; Santa Ana (CA); On-site; USD 140,000 - 150,000; Full time

Job summary

Solugenix is seeking an ETL Developer to design, develop, and maintain data pipelines and data warehouse solutions using Informatica CDI, CAI, and Azure Synapse Analytics. You will integrate data from databases, enterprise apps, and APIs to support enterprise reporting and operations.

The role requires strong SQL skills, experience with IDMC/IICS, and ability to troubleshoot production issues while collaborating with business and technical teams.

Qualifications

• Hands-on experience developing integrations using Informatica IDMC/IICS, CDI and CAI.
• Strong experience with Azure Synapse Analytics, including dedicated SQL pools and performance tuning.
• Advanced SQL skills including complex joins, window functions, stored procedures, and troubleshooting.
• Experience with REST APIs, JSON/XML, OAuth 2.0, pagination, retries, and exception handling.

Responsibilities

• Design, develop, and maintain ETL/ELT pipelines using Informatica CDI for data integration from databases, applications, APIs, and files.
• Build mappings, mapping tasks, reusable components, and taskflows for full and incremental loads.
• Develop CAI processes, service connectors, and REST API integrations with authentication, orchestration, error handling, and monitoring.

Skills

Advanced SQL

ETL/ELT design

Data warehousing

Communication

Problem solving

Tools

Informatica IDMC/IICS

Azure Synapse Analytics

SQL

REST APIs

Job description

We are seeking an ETL Developer with strong experience in Informatica Intelligent Data Management Cloud (IDMC/IICS), including Cloud Data Integration (CDI) and Cloud Application Integration (CAI), along with Azure Synapse Analytics. This role will develop and support data pipelines, application integrations, and data warehouse solutions for enterprise reporting and business operations.

Qualifications:

• Hands-on experience developing integrations using Informatica IDMC/IICS, with strong expertise in both CDI and CAI.
• Strong experience with Azure Synapse Analytics, particularly dedicated SQL pools, distributed tables, and query performance tuning.
• Advanced SQL skills, including complex joins, window functions, stored procedures, and troubleshooting.
• Experience with REST APIs, JSON/XML, OAuth 2.0, pagination, retries, and exception handling.
• Strong understanding of data warehousing, dimensional modeling, incremental loading, and ETL/ELT design.
• Experience integrating relational databases, cloud storage, flat files, and enterprise applications.
• Ability to investigate production issues independently and communicate clearly with technical and business teams.

Responsibilities:

• Design, develop, and maintain ETL/ELT pipelines using Informatica CDI to integrate data from databases, enterprise applications, APIs, and files.
• Build mappings, mapping tasks, reusable components, and taskflows for full and incremental data loads.
• Develop CAI processes, service connectors, and REST API integrations, including authentication, orchestration, error handling, and monitoring.
• Develop and optimize Azure Synapse SQL queries, stored procedures, and data loading processes.
• Implement data warehouse solutions, including fact and dimension tables, slowly changing dimensions, deduplication, and deletion handling.
• Perform source-to-target mapping, data validation, reconciliation, and data quality checks.
• Troubleshoot production failures, resolve data discrepancies, and improve integration performance.
• Collaborate with business analysts, application teams, and reporting teams to translate requirements into technical solutions.
• Maintain technical documentation, test plans, deployment instructions, and operational support procedures.

Annual Base Salary Range for CA, CO, IL, NJ, NY, WA, and DC: $140,000 to $150,000. Actual compensation offered may vary depending on factors including but not limited to, position offered, location, education, training, and/or experience.

Solugenix will consider qualified applicants with a criminal history pursuant to the California Fair Chance Act and Ordinance. Applicants do not need to disclose their criminal history or participate in a background check until a conditional job offer is made to you. After making a conditional offer and running a background check, if we are concerned about conviction that is directly related to the job, applicants will be given the chance to explain the circumstances surrounding the conviction, provide mitigating evidence, or challenge the accuracy of the background report.

About The Client

Our client is a leading North American distributor of building materials.

About Solugenix

Solugenix is a leader in IT services, delivering cutting-edge technology solutions, exceptional talent, and managed services to global enterprises. With extensive expertise in highly regulated and complex industries, we are a trusted partner for integrating advanced technologies with streamlined processes. Our solutions drive growth, foster innovation, and ensure compliance providing clients with reliability and a strong competitive edge.

Recognized as a 2024 Top Workplace, Solugenix is proud of its inclusive culture and unwavering commitment to excellence. Our recent expansion, with new offices in the Dominican Republic, Jakarta, and the Philippines, underscores our growing global presence and ability to offer world-class technology solutions. Partnering with Solugenix means more than just business it means having a dedicated ally focused on your success in today's fast-evolving digital world.