Imformatica Lead

Diligent Tec, Inc; Santa Ana (CA); Vor Ort; USD 110.000 - 160.000; Vollzeit

Zusammenfassung

Diligent Tec, Inc is seeking an experienced IICS Developer specialized in CDI and CAI to design, build, and optimize complex ETL pipelines and API-driven integrations. You will lead production monitoring and issue analysis to ensure high availability and data reliability in enterprise environments.

You will collaborate with data architects and clients, perform data profiling, mapping, and validation, and contribute to technical design documents and SDLC processes.

Qualifikationen

• Extensive hands-on experience with Informatica Intelligent Cloud Services (IICS) CDI and CAI.
• Advanced SQL skills for designing and optimizing large databases.
• Experience building Data Warehouse ETL solutions with batch and real-time data flows.
• Strong understanding of REST/SOAP APIs and application connectors.
• Experience in production monitoring, log analysis, and RCA for failed data loads.
• Experience in Agile/Scrum environments and SDLC documentation.

Aufgaben

• Design, develop, test, and deploy data integration solutions using IICS CDI and CAI.
• Analyze source/target systems, profiling, gap analysis, and mapping specs.
• Build real-time data flows via CAI and API integrations with proper security.
• Tune ETL workflows and queries for performance and scalability.
• Ensure data quality, validation, reconciliation, and issue handling in lifecycle.
• Create technical design docs, mapping specs, and development guidelines.
• Collaborate with clients and data architects to deliver scalable solutions.
• Monitor production systems, analyze logs, manage incidents, perform RCA.

Kenntnisse

IICS CDI CAI

Advanced SQL

ETL pipelines

API integration

Production monitoring

Data profiling

Data governance

Agile/Scrum

Tools

Informatica Intelligent Cloud Services (IICS)

Power BI

Tableau

Jobbeschreibung

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.