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.