Sign up free to see how well your resume matches this role.
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
