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