ETL Developer Job at Intent-Design, Santa Ana, CA

  • Intent-Design
  • Santa Ana, CA

Job Description

ETL Developer

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.

Job Description:

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

Minimum 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.
  • Ability to investigate production issues independently and communicate clearly with technical and business teams.

Work Location: Santa Ana, CA

Job Tags

Similar Jobs

Van Oord

Tender Manager Dredging Job at Van Oord

RotterdamEngineering, Tender OfficeFrom 32 hours per weekDo you want to broaden your expertise to international port and fairway maintenance dredging and beach nourishment projects around the world? Are you ready to bring the best proposals to the market together with... 

Healthcare Linen Services Group

Soil Sorter Job at Healthcare Linen Services Group

 ...Job Summary Responsible for the correct sorting of linen that has been placed on a moving conveyor belt in front of them. Picks up soil linen and places it in the corresponding sling/cart. Follows standard operating procedures. Must meet quality and production... 

CoachUSA

Mechanic Job at CoachUSA

 ...Job Description Bus Mechanic Full-time Location: Janesville, WI 4 day work week! Compensation: $26.00 - $32.00 per hour...  ...protected class. "lube", "mechanically inclined", "mechanic", "Mechanic apprentice", "auto mechanic", technical", "entry level mechanic"... 

Favorite Healthcare Staffing

Nuclear Med Technician Job at Favorite Healthcare Staffing

 ...has your back as you search for your next adventure.Favorite Healthcare Staffing is looking for an experienced Radiology Nuclear Med Technician (RAD NMT) for an assignment in Hartford, CT! This assignment is for 13 weeks and ideal candidates must have at least one year... 

Stantec

Manager of Mine Hoisting and Shafts Job at Stantec

 ...own future, with exciting opportunities for development and advancement.Your OpportunityStantec Consulting is seeking a Senior Mine Hoisting and Shaft Specialist Design Professional Engineer, to join our Professional Consulting Services team as a Manager of our Hoisting...