Skip to content
Six Figure Jobs
Solugenix logo

Solugenix

ETL Developer (IICS/IDMC)

Salary

$140K - $150K

Listed in the posting

Pays more than 23% of 191 data engineer listings in USD.

This job
$140k–$150k
Typical
$168k
Most pay
$148k–$200k
Apply on LinkedIn

Requirements

  • 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.

Skills

Analytics
API
Authentication
Azure
Azure Synapse
Cloud Computing
Data Pipelines
Data Quality
Data Warehousing
Dimensional Modeling

Nice to have

ELT
ETL
["Azure"]

Full job description

ETL Developer (IICS/IDMC)

Santa Ana, CA (Onsite)

Direct Hire

SGX20839

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.

Apply on LinkedIn

Opens Solugenix’s listing on LinkedIn in a new tab.

Similar six-figure roles

Browse all Data Engineer jobs →
NEW
Stuut logo
Stuut

Lead Data Engineer

$275k - $315k
Salary shown
San Francisco, USAHybridLead

At Stuut, you’ll build and lead the data engineering team. You’ll hire and manage the data engineers, own the roadmap, a...

Posted 2d ago
TikTok logo
TikTok

Data Engineer - Data Platform

$162k - $388k
Salary shown
San Jose, USAOnsite

As a data engineer in the data platform team, you will have the opportunity to build, optimize and grow one of the large...

KafkaBig DataClickhouseData IngestionData Modeling+6 more
Posted 4d ago
Oscar Health logo
Oscar Health

Staff Data Engineer

$199k - $261k
Salary shown
New York, USAHybridStaff

In this role, you will build the trusted member-context and event-data foundation that powers personalization, predictiv...

Posted 4d ago
Horizon3.ai logo
Horizon3.ai

Senior/Staff Data Engineer

$199k - $270k
Salary shown
USARemoteStaff

We are seeking a Senior or Staff Data Engineer to design, build, and own the data platform underneath our business-criti...

PythonAWSAirflowAnalyticsAWS Glue+8 more
Posted 6d ago
Triumph logo
Triumph

Data Engineer

$200k - $400k
Salary shown
San Francisco HQ, USAOnsite

The right candidate is passionate about building and has the ability and agency to drive projects to completion.

Data EngineeringData ScienceData WarehousingStatistics
Posted 8d ago

Get jobs like this one by email

Data Engineer jobs · USA

Only new matching jobs, nothing else. Confirm by email; unsubscribe in one click.

Explore more

Salary

$140K - $150K

Apply