Informatica Developer (RARR Job 6230)

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.

• 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.

• 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.

• 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.

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

• Strong analytical and troubleshooting skills
• Good communication and stakeholder collaboration
• Attention to detail
• Ability to work in a fast-paced environment