ETL Developer_PT

Ignitarium Inc.

Chennai

On-site

INR 900,000 - 1,500,000

Full time

14 days+

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Neurealm Company seeks an experienced ETL Developer to design and optimize data integration solutions using Informatica IICS CDI and CAI. The role focuses on building robust pipelines, API-driven integrations, and real-time data flows with strong SQL expertise.

You will monitor production loads, analyze issues, and collaborate with data architects to deliver scalable data warehousing solutions. Chennai-based, on-site role requiring detail-oriented approach.

Qualifications

  • Hands-on experience with Informatica IICS CDI/CAI.
  • Strong SQL skills and experience with large data sets.
  • Experience building data pipelines, APIs, and real-time integration.

Responsibilities

  • Design, develop, test, and deploy CDI/CAI data integrations.
  • Analyze source/target mappings, profile data, and create mappings.
  • Build real-time data flows via APIs and application connectors.
  • Optimize ETL workflows and database queries for performance.
  • Monitor production jobs, investigate incidents, and perform RCA.

Skills

Advanced SQL
IICS CDI/CAI
Data Warehousing
API Integration
Performance Tuning

Tools

Informatica IICS (CDI/CAI)

Job description

## ETL Developer\\_PT08-10-2026 13:11:17Job\\_3048148 - 15 years* Chennai, Tamil Nadu, India (CHN)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 SkillsCore 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.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Informatica Developer – IICS / IDMC
Informatica Developer – IICS / IDMC

ValueMomentum • Hyderabad

On-site
INR 900,000 - 1,200,000
Tcs hiring For Senior Informatica IICS / IDMC Developer
Tcs hiring For Senior Informatica IICS / IDMC Developer

Tata Consultancy Services Limited • India

On-site
INR 1,800,000 - 2,800,000
ETL Senior Engineer
ETL Senior Engineer

Honeybee Tech Solutions • Navi Mumbai

On-site
INR 900,000 - 1,400,000
Senior Informatica IICS / IDMC Developer
Senior Informatica IICS / IDMC Developer

Tata Consultancy Services Limited • Hyderabad, Chennai, Bengaluru

On-site
INR 1,500,000 - 2,100,000
IICS Senior Data Engineer
IICS Senior Data Engineer

HCL Technologies Limited • India

On-site
INR 1,200,000 - 2,000,000
IICS / Informatica Developer
IICS / Informatica Developer

Infosys • Hyderabad, Pune District, Bengaluru

On-site
INR 1,200,000 - 2,400,000
IICS Developer
IICS Developer

Infosys • Dadri, Pune District, Mumbai

Hybrid
INR 1,200,000 - 1,800,000
Software Engineer - IICS
Software Engineer - IICS

Pivotree Solutions India • Mumbai

On-site
INR 1,800,000 - 4,200,000
Data Integration Developer (Informatica CDI)
Data Integration Developer (Informatica CDI)

NucleusTeq • Indore District, Raipur, Gurugram District, Bengaluru

On-site
INR 900,000 - 1,300,000
Senior Data Integration Engineer – IICS | Snowflake | Openflow | DBT
Senior Data Integration Engineer – IICS | Snowflake | Openflow | DBT

Philodesign Technologies Inc • India

Remote
INR 1,200,000 - 2,000,000