Etl Informatica Developer

Aziro; Pune District, Chennai, Bengaluru; Hybrid; INR 1,200,000 - 1,800,000; Full time

Job summary

Aziro is seeking an experienced Informatica Developer to join our Enterprise Data Warehouse team. You will develop and maintain ETL processes using Informatica PowerCenter and IICS, and implement data integration solutions across cloud and on-prem environments.

You will collaborate with cloud architects and data stakeholders to ensure reliable CAI integrations, scalable CDI workflows, and high-quality data for EDW reporting. Strong SQL and data warehousing knowledge are required.

Qualifications

• 5+ years of experience in Informatica ETL development.
• 3+ years of experience with Informatica IICS and CAI.
• Proven experience in developing and maintaining on-premise ETL processes.

Responsibilities

• Design, develop, and maintain ETL processes using Informatica PowerCenter and IICS.
• Implement data integration solutions to support EDW requirements.
• Optimize ETL workflows for performance and scalability.
• Develop and maintain integrations using Informatica CAI and build RESTful APIs for data exchange.
• Design and develop on-prem ETL processes for legacy data sources.
• Collaborate with data architects to design scalable data warehouse schemas and monitor EDW performance.
• Document ETL processes and provide training and support to team members.

Skills

Informatica PowerCenter

IICS

CAI

SQL/PLSQL

Data warehousing concepts

Problem solving

Communication & collaboration

Education

Bachelor's degree in CS/IT or related field

Job description

Job Summary

We are seeking an experienced Informatica Developer with expertise in Cloud Data Integration, Cloud Application Integration (CAI), Informatica Intelligent Cloud Services (IICS), and on-premise development to join our Enterprise Data Warehouse (EDW) team. The ideal candidate will possess strong technical skills in developing and maintaining ETL processes, integrating data from various sources, and ensuring the efficient operation of our data warehouse environment.

Key Responsibilities

1. ETL Development:

• Design, develop, and maintain ETL processes using Informatica PowerCenter and IICS.
• Implement data integration solutions to support EDW requirements.
• Optimize ETL workflows for performance and scalability.

2. Cloud Data Integration (CDI):

• Experience with Mappings, Mapping Task, Taskflow, Replication & Synchronization jobs.
• Handling dynamic parameter values.
• Designing Taskflow with loops, IF-ELSE, and exception handling.
• Design and implement scalable data integration solutions using cloud platforms

3. Cloud Application Integration (CAI):

• Develop and maintain integrations using Informatica CAI.
• Collaborate with cloud architects to ensure seamless integration of cloud- based applications.
• Monitor and troubleshoot CAI integrations to ensure reliability and performance.
• Build and manage RESTful APIs for data exchange and automation
• Defining Custom APIs and Policy Rates
• Familiarity with API authentication techniques
• Good knowledge of XQuery
• Creating Service Connectors, App Connectors, and Process Objects

4. On-Prem Development:

• Design and develop on-premise ETL processes to integrate data from legacy systems.
• Maintain and enhance existing on-prem ETL workflows.
• Ensure data quality, consistency, and integrity in the on-premise environment.
• Good to have cloud modernization experience.

5. Data Warehouse Support:

• Collaborate with data architects to design and implement scalable data warehouse schemas.
• Support the Enterprise Data Warehouse (EDW) environment by monitoring performance and resolving issues proactively.
• Conduct data profiling and quality assessments to ensure accuracy and consistency in reporting.
• Demonstrate strong SQL skills and a solid understanding of data warehouse concepts, with hands‑on experience in writing and validating queries through unit testing and user acceptance testing (UAT).
• in implementing complex logic using JOINs, IF-ELSE conditions, CASE statements, and looping constructs.
• Experienced in developing and maintaining Stored Procedures, Packages, and Functions for data transformation and business logic implementation.

6. Collaboration and Communication:

• Work closely with business analysts and stakeholders to understand data requirements.
• Collaborate with cross-functional teams to design and implement data solutions.
• Provide technical guidance and support to team members.

7. Documentation and Training:

• Document ETL processes, data flows, and integration solutions.
• Conduct training sessions and provide support to end-users and team members.

Qualifications

Education

• Bachelors degree in Computer Science, Information Technology, or a

related field.

Experience

• 5+ years of experience in Informatica ETL development.
• 3+ years of experience with Informatica IICS and CAI.
• Proven experience in developing and maintaining on-premise ETL processes.

Skills

• Strong proficiency in Informatica PowerCenter, IICS, and CAI.
• Knowledge of SQL, PL/SQL, and database design principles.
• Experience with data warehousing concepts and best practices.
• Excellent problem-solving and analytical skills.
• Strong communication and collaboration abilities.

Preferred Qualifications

• Experience with other ETL tools and data integration technologies.
• Knowledge of cloud-based data warehousing solutions.
• Certification in Informatica or other relevant technologies.