ETL Developer_PT

Neurealm Company; Chennai District; Sur place; INR 1 800 000 - 2 500 000; Plein temps

Résumé du poste

Neurealm Company seeks an experienced IICS Developer specializing in CDI and CAI with advanced SQL skills to design, build, and maintain complex ETL pipelines and data integration workflows. You will lead production monitoring and issue analysis to ensure high availability and data reliability across API-driven integrations.

Responsibilities include integration design, data profiling and mapping, real-time data flows through APIs, performance tuning, and documentation.

Qualifications

• Advanced SQL skills for large-scale data pipelines and data warehousing contexts.
• Experience designing, building, and optimizing ETL workflows with IICS CDI/CAI.
• Strong understanding of data profiling, validation, and reconciliation in CI/CD environments.

Responsabilités

• Design and implement data integration solutions using IICS CDI/CAI.
• Analyze source/target systems, perform data profiling and mapping.
• Build real-time/near-real-time data flows via APIs and connectors.
• Tune ETL pipelines and DB queries for performance and scalability.
• Monitor production systems, analyze logs, and perform RCA for failures.
• Prepare technical design docs and mapping specifications; support testing and deployments.

Connaissances

SQL proficiency

ETL design

Data integration

API integration

Production monitoring

Outils

Informatica IICS (CDI/CAI)

REST/SOAP APIs

Description du poste

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.