Responsibilities
️ Design, develop, and implement ETL solutions using Informatica PowerCenter and Informatica Data Quality (IDQ).
️ Conduct data profiling, data quality assessment, data mapping, and migration from legacy to strategic systems.
️ Work with PL/SQL to optimize data extraction, transformation, and loading processes.
️ Develop and execute test plans for ETL pipelines, ensuring data accuracy and completeness.
️ Automate test data preparation and validation to improve testing efficiency.
️ Collaborate with business stakeholders, business analysts (BAs), and technical teams to understand requirements and deliver high-quality solutions.
️ Provide technical leadership and guidance on best practices in ETL development and data quality management.
Skills/Requirement
10+ years of experience in ETL development and solution design.
5+ years of hands-on experience with Informatica PowerCenter (PC) and Informatica Data Quality (IDQ).
1+ years of experience with Informatica Intelligent Cloud Services (IICS) / Informatica Cloud Data Quality (ICDQ).
Strong proficiency in PL/SQL and relational databases.
Expertise in data profiling, cleansing, transformation, and migration.
Experience with ETL testing, test data preparation, and automation.
Excellent analytical, problem-solving, and communication skills.