Senior-KDNI

The Consultant will bring 4–6 years of experience in data migration, data integration, and data engineering initiatives. The role involves designing, developing, and executing end-to-end data migration solutions, including data extraction, transformation, validation, reconciliation, and loading activities, while ensuring data quality, integrity, and the successful migration of business-critical data across platforms.

• Analyze source and target data models to define migration strategies, mapping specifications, transformation rules, and migration processes.
• Design, develop, and execute data migration workflows, including data extraction, cleansing, transformation, enrichment, validation, and loading activities.
• Develop and optimize SQL queries, stored procedures, and scripts to support large-scale data migration, reconciliation, and quality assurance activities.
• Perform data profiling, data quality assessments, and data validation to ensure the completeness, accuracy, consistency, and integrity of migrated data.
• Create and maintain migration documentation, mapping specifications, validation reports, reconciliation reports, and deployment runbooks.
• Collaborate with business stakeholders, functional teams, architects, and developers to understand migration requirements and resolve data-related issues.
• Support migration testing activities, including unit testing, system integration testing (SIT), user acceptance testing (UAT), and production cutover.
• Participate in Agile ceremonies and contribute to sprint planning, backlog refinement, estimation, and delivery activities.
• Identify migration risks, dependencies, and data quality issues, and proactively recommend mitigation strategies.

• Must-Have Skills
• Excellent communication skills, with the ability to explain technical concepts, migration challenges, and business impacts to technical and non-technical stakeholders.
• Strong experience in data migration projects, including data mapping, transformation, reconciliation, validation, and cutover activities.
• Strong proficiency in SQL, including query development, performance tuning, data analysis, and troubleshooting.
• Good experience in Python scripting for data processing, automation, validation, and migration support activities.
• Hands-on experience with ETL and data integration tools such as Talend, Alteryx, CloverDX, Informatica, SSIS, or similar platforms.
• Good understanding of relational databases, data warehousing concepts, data modelling, and data quality principles.
• Experience working in Agile delivery environments and collaborating effectively within cross-functional teams.
• Strong analytical and problem-solving skills, with the ability to work independently and manage multiple priorities.
• Nice-to-Have Skills
• Exposure to cloud-based data platforms such as Microsoft Azure, Microsoft Fabric, Databricks, AWS, or Google Cloud.
• Experience with cloud data migration, modernization, or platform migration initiatives.
• Working knowledge of Power BI, including data models, datasets, and reporting concepts.
• Understanding of data governance, metadata management, and data quality frameworks.
• Experience supporting ERP, CRM, Finance, HR, or other enterprise application migration programmes.