Design, develop, and implement complex ETL processes using Informatica PowerCenter. Create and maintain high-quality, efficient, and scalable ETL map..
Design, develop, and implement complex ETL processes using Informatica PowerCenter.
Create and maintain high-quality, efficient, and scalable ETL mappings, workflows, and sessions.
Collaborate with business analysts and data architects to understand data requirements.
Perform data profiling and analysis to ensure accurate mapping of source system data to target structures.
Identify and resolve performance issues in ETL processes to ensure optimal data integration performance.
Implement best practices for optimization and tuning of Informatica mappings and workflows.
Implement data validation and cleansing routines to ensure the integrity and quality of the data.
Collaborate with stakeholders to define and enforce data quality standards.
Create and maintain technical documentation for ETL processes, data models, and data integration solutions.
Ensure that all development activities are well-documented for future reference and knowledge sharing.
Minimum of 5 years of hands-on experience with Informatica PowerCenter.
Strong understanding of data warehousing concepts, ETL methodologies, and data integration best practices.
Proficiency in SQL for data analysis and troubleshooting.
Experience in performance tuning and optimization of ETL processes.
