> Markdown version of [/jobs/ext/3850458-informatica-lead-developer](https://www.wearedevelopers.com/jobs/ext/3850458-informatica-lead-developer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Informatica Lead Developer

- **Company:** Elint Pro Solutions LLC
- **Location:** Santa Ana, CA, United States
- **Experience:** Expert
- **Contract:** Contract
- **Skills:** Application Programming Interfaces (APIs), User Authentication, Authentication Protocols, Unit Testing, Software as a Service, Cloud Database, Databases, Data Validation, Data Governance, Data Integration, Data Integrity, Extract Transform Load (ETL), Data Profiling, Data Warehousing, Database Queries, Software Debugging, Systems Analysis, Log Analysis, Performance Tuning, Scrum Methodology, Systems Development Life Cycle, Cloud Services, Web Services, Sql Optimization, System Availability, SOAPAPI, Real Time Data, Api Design, Pagination, Data Pipelines
- **Published:** October 21, 2026
- **Apply:** https://www.dice.com/job-detail/aae140cf-6339-4f0b-9d1a-dd4dd65bca8a

## About the Role

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

## Description

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.