Haystack
← Back to Jobs
Technology
RIRIIM logo

Informatica Lead

RIIMSanta Ana, CA🇺🇸United StatesPosted Oct 20, 2026

Quick Overview

Seniority
Mid Senior
Work mode
Hybrid
Location
Santa Ana, CA, United States
Posted
Yesterday
SQLETLScrumTableauPythonReconciliationRoot Cause AnalysisRESTSOAPPower BIAgile

Job Description

  • Design, develop, test, and deploy data integration solutions using Informatica Intelligent Cloud Services (IICS), specifically Cloud Data Integration (CDI) and Cloud Application Integration (CAI).
  •  Build, manage, and optimize complex SQL queries, ETL pipelines, data warehouse solutions, and large-scale database workflows.
  • Develop batch and real-time/near-real-time integrations using REST/SOAP APIs, web services, application connectors, authentication, and pagination.
  • Perform source-to-target analysis, data profiling, mapping specifications, data validation, reconciliation, and defect identification.
  • Optimize ETL mappings, workflows, and database queries while supporting unit testing, quality assurance, and deployments.
  • Monitor production systems, analyze logs, troubleshoot failed data loads, manage incidents, perform root cause analysis (RCA), and maintain technical documentation.
  • Work with clients and data architects in Agile/Scrum environments. Good-to-have skills: Python scripting, Power BI/Tableau, and data architecture knowledge.

Similar jobs