Informatica Developer

Job Title: Informatica Developer

Location: Bangalore

Experience: 5-8 Years

Job Summary

We are looking for a skilled Informatica Developer with strong experience in Informatica

PowerCenter and SQL to design, develop, and maintain scalable data integration solutions.

The candidate will be responsible for building ETL pipelines, optimizing performance, and

ensuring efficient data movement across systems while supporting business intelligence and

data warehousing initiatives.

Key Responsibilities

Design, develop, and maintain ETL workflows, mappings, and sessions using

Informatica PowerCenter.

Analyze and understand business requirements and translate them into efficient

data integration solutions.

Develop and optimize complex SQL queries, stored procedures, and scripts for data

extraction, transformation, and loading.

Troubleshoot and debug ETL workflows, data integration issues, and performance

bottlenecks.

Collaborate with business analysts, data architects, and development teams to

implement scalable data solutions.

Perform performance tuning and optimization of ETL processes and database

queries.

Maintain existing Informatica applications and infrastructure, including upgrades,

patches, and enhancements.

Ensure data quality, consistency, and integrity across data integration processes.

Create and maintain technical documentation for ETL designs, mappings, workflows,

and data flow processes.

Support production environments by monitoring ETL jobs and resolving issues

promptly.

Required Skills & Qualifications

Strong hands-on experience in Informatica PowerCenter development.

Good knowledge of ETL concepts and Data Warehousing architecture.

Strong expertise in SQL and relational databases.

Experience working with Oracle, SQL Server, or DB2 databases.

Experience in developing complex mappings, workflows, and transformations in

Informatica.

Good understanding of data integration, data modeling, and ETL best practices.

Experience in debugging and performance tuning ETL jobs.

Strong analytical and problem-solving skills.

Preferred Skills

Experience with performance optimization techniques in Informatica.

Knowledge of Unix/Linux scripting.

Experience working in Agile development environments.

Exposure to data governance and data quality frameworks.

Education

Bachelor's degree in Computer Science, Information Technology, or a related field.

Key Competencies

Strong analytical and troubleshooting skills

Good communication and stakeholder collaboration

Attention to detail

Ability to work in a fast-paced environment