ETL Developer_PT | Careers | Neurealm

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 Service AI-as-a-Service AI-powered SDLC Enterprise AI Adoption Engineering Silicon Design Embedded AI-powered Modernization Digital Platform Engineering AI-powered SDLC Robotics Data Data Overview Data Engineering Data Migration Data Visualization & Analytics Master Data Management & Governance Run Ops AI Led ITOps Cybersecurity Intelligent Automation Industries Semiconductor Automotive Healthcare BFSI Technology Telecom Industrial Global Capability Centers (GCCs) Neu GAIN About Us Company Leadership Life at Neurealm Awards & Recognitions Events Press Releases Partners Careers Contact Us search Menu Job Description Back ETL Developer_PT Job Posted On 08-10-2026 23:02:09 Company Group Neurealm --> Department Internal Data Warehouse Development & Administration --> Employee Type Full Time Employee --> Designation Lead - ETL Developer --> Job Code Job_304814 Experience Required 8 - 15 years Location Chennai, Tamil Nadu, India (CHN) Job Summary 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.