ETL Developer — Informatica IDMC + Azure Synapse

Ethereum Technologies

Santa Ana (CA)

On-site

USD 84,000 - 120,000

Full time

27 hours ago

Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Ethereum Technologies in Santa Ana, CA is seeking an ETL Developer with deep experience in Informatica IDMC/IICS (CDI and CAI) and Azure Synapse Analytics. You will design and support data pipelines, application integrations, and data warehouses for enterprise reporting and operations.

You will build mappings, CAI processes, and REST API connections, optimize SQL queries, implement dimensional models, and ensure data quality.

Qualifications

Hands-on experience with Informatica IDMC/IICS CDI/CAI
Strong Azure Synapse Analytics experience with dedicated SQL pools
Advanced SQL skills including complex joins and window functions
Experience with REST APIs, JSON/XML, OAuth 2.0, pagination, retries
Understanding of data warehousing, dimensional modeling, ETL/ELT design
Experience integrating relational databases, cloud storage, and enterprise applications
Ability to troubleshoot production issues and communicate with technical & business teams

Responsibilities

Design, develop, and maintain ETL/ELT pipelines using Informatica CDI
Build mappings, mapping tasks, and workflow for full and incremental loads
Develop CAI processes, service connectors, and REST API integrations with authentication and error handling
Develop and optimize Azure Synapse SQL queries, stored procedures, and data loading
Implement data warehouse schemas including facts, dimensions, and slowly changing dimensions
Perform source-to-target mapping, data validation, reconciliation, and data quality checks
Troubleshoot production issues and improve integration performance
Collaborate with business analysts, application and reporting teams to translate requirements
Maintain technical documentation, test plans, deployment instructions, and operational procedures