Job Title: Informatica Lead
Location: Santa Ana, CA
Role Overview:
We are looking for an experienced and detail-oriented IICS Developer specializing in Cloud Data Integration (CDI) and Cloud Application Integration (CAI), backed by advanced SQL expertise. In this role, you will design, build, optimize, and maintain complex ETL pipelines, data integration workflows, and API-driven application integrations, while actively leading production monitoring and issue analysis to ensure high availability and data reliability.
Key Responsibilities:
Integration Design & Development: Design, develop, test, and deploy robust data integration solutions using IICS (CDI and CAI) to support enterprise data warehousing and application connectivity.
Analysis & Mapping: Conduct thorough source and target system analysis, data profiling, gap analysis, and create precise mapping specifications.
API & Real-time Integration: Build and manage real-time/near-real-time data flows using CAI, integrating data through APIs, web services, and application connectors (handling authentication, security, and pagination).
Performance Tuning & Optimization: Optimize complex ETL workflows, mappings, and database queries to ensure high performance and scalability.
Data Quality & Validation: Perform comprehensive data validation, reconciliation, and defect identification throughout the implementation lifecycle.
Documentation & Quality Assurance: Create detailed technical design documents, mapping specifications, and development guidelines while supporting unit testing, and deployments.
Collaboration: Work closely with clients and data architects to understand business needs, define technical approaches, and deliver scalable data solutions.
Production Monitoring & Support: Actively monitor production systems, analyze logs, manage incidents, and perform root cause analysis (RCA) for any failed data loads.
Mandatory Technical Skills:
Core Tools: Extensive hands-on experience with Informatica Intelligent Cloud Services (IICS), specifically CDI and CAI.
Database & SQL: Advanced SQL skills with proven experience designing, managing, and optimizing large database systems.
Data Integration: Expertise in building Data Warehouse ETL solutions, handling batch and real-time data flows.
API Integration: Strong understanding of REST/SOAP APIs, application connectors, authentication protocols, and handling paginated payloads.
Data Governance & Testing: Proficient in data profiling, validation, reconciliation, performance tuning, and structured testing methodologies.
Documentation & SDLC: Experience creating technical specifications/mapping documents and working in Agile/Scrum environments.
Production Support & Debugging: Proven experience in production monitoring, log analysis, incident management, and performing root cause analysis (RCA) for failed data loads.
Good-to-Have Skills:
Python Programming: Experience using Python for data scripting, automation, or custom API integrations.
Working knowledge of BI and visualization tools like Power BI or Tableau is a plus.
Background in broader data architecture and solution design principles.
