Informatica

Infosys Limited; Bengaluru; On-site; INR 700,000 - 1,100,000; Full time

Job summary

Infosys Limited in Bengaluru is seeking an Informatica ETL Developer with 2–3 years of hands‑on experience to design, develop, and maintain ETL mappings using Informatica PowerCenter. You will analyze mappings, troubleshoot batch runs, and collaborate with cross‑functional teams to deliver changes within timelines.

The role requires a BE/BTech, MCA, MSc, or equivalent, plus strong debugging and documentation skills. Good knowledge of scheduling tools and Unix/Linux scripting is desirable.

Qualifications

• Bachelor’s degree (or equivalent) in Engineering/Technology/Computer Applications/Science or related field.
• 2–3 years hands‑on Informatica ETL development and support.
• Practical experience with Informatica PowerCenter including mappings, workflows, sessions, and troubleshooting.
• Ability to interpret ETL requirements and implement transformations.
• Experience supporting batch operations, monitoring loads, and resolving production issues.

Responsibilities

• Design, develop, and maintain ETL mappings, workflows, and sessions using Informatica PowerCenter.
• Analyze source-to-target mappings and implement transformations to meet requirements.
• Monitor, troubleshoot, and resolve ETL job failures and performance bottlenecks.
• Implement reusable components, parameterization, and scheduling practices.
• Perform data validation, reconciliation, and basic root-cause analysis for data accuracy.
• Collaborate with cross-functional teams to gather requirements and deliver changes on time.
• Maintain technical documentation for mappings, workflows, and runbooks.
• Support releases by promoting ETL objects across environments.

Skills

ETL development

Data integration

Data analysis

Documentation

Stakeholder collaboration

Education

Bachelor's / MCA / MSc / BTech / BE

Tools

Informatica PowerCenter

Control-M

Autosys

Unix/Linux shell scripting

Job description

Job ID/Reference Code

INFSYS-INDEED1-252682

Work Experience

2 - 3 Years

Job Title

Informatica

Educational Requirements

MCA,MSc,MTech,Bachelor of Engineering,BTech

Service Line

Data & Analytics Unit

Responsibilities

Key Responsibilities:

• Design, develop, and maintain ETL mappings, workflows, and sessions using Informatica and Informatica PowerCenter.
• Analyze source-to-target mappings and implement transformations to meet business and technical requirements.
• Monitor, troubleshoot, and resolve ETL job failures, data load issues, and performance bottlenecks in batch runs.
• Implement reusable components, parameterization, and scheduling practices to improve maintainability and operational efficiency.
• Perform data validation, reconciliation, and basic root-cause analysis to ensure data accuracy and completeness.
• Collaborate with cross-functional teams to gather requirements, clarify logic, and deliver changes within agreed timelines.
• Maintain technical documentation for mappings, workflows, operational runbooks, and deployment notes.
• Support releases by promoting ETL objects across environments and following standard change management processes.

Additional Responsibilities:

Minimum Qualifications:

• Bachelor’s degree (or equivalent) in Engineering/Technology/Computer Applications/Science (e.g., BTech, BE, MCA, MSc) or related field.
• 2–3 years of hands‑on experience working with Informatica ETL development and support.
• Practical experience with Informatica PowerCenter including mappings, workflows, sessions, and troubleshooting.
• Ability to interpret ETL requirements and implement transformations aligned to source-to-target specifications.
• Experience supporting batch operations, monitoring loads, and resolving production issues with a structured approach.

Preferred Qualifications:

• Experience optimizing PowerCenter performance (e.g., tuning sessions, improving mapping design, reducing load times).
• Exposure to deployment practices across multiple environments and adherence to release/change processes.
• Strong documentation habits and ability to create clear operational guides for recurring ETL processes.
• Experience collaborating with stakeholders to refine requirements and translate them into maintainable ETL solutions.
• Familiarity with data quality checks, reconciliation approaches, and supporting audit‑ready data pipelines.

Good to have skills:SQL, Unix/Linux Shell Scripting, Informatica Administration, Performance Tuning, Scheduling Tools (Control-M/Autosys)

Technical and Professional Requirements:

• Primary skills:Technology->Data Management - Data Integration->Informatica->Informatica Power Center

Preferred Skills:

Technology->Data Management - Data Integration->Informatica->Informatica - Informatica Power Center