Overview:
ITKnocks is looking for an 8-10 years experienced Senior Data Migration Consultant to join our team. The ideal candidate will possess deep technical expertise in Azure Data Factory pipelines, SSIS SQL Server Integration Services, SQL database management, and a solid understanding of basic database design concepts. You will play a crucial role in ensuring the successful migration of data across various systems while maintaining data integrity and
performance.
Key Responsibilities:
1. Data Migration Planning:
Collaborate with clients and project teams to assess data migration needs, define migration strategies, and develop detailed migration plans.
2. Azure Data Factory Expertise:
Design, develop, and manage data pipelines using Azure Data Factory to facilitate efficient and secure data migration processes.
3. SSIS Proficiency:
Leverage SSIS to extract, transform, and load ETL data between various source and target systems, ensuring data accuracy and consistency.
4. SQL Database Management:
Manage SQL databases, including schema design, optimization, and performance tuning, to support data migration activities.
5. Data Mapping and Transformation:
Define data mapping rules and transformation logic to ensure data is migrated accurately and in accordance with business requirements.
6. Data Quality Assurance:
Implement data validation and quality checks to identify and rectify data inconsistencies or anomalies during migration.
7. Monitoring and Troubleshooting:
Monitor data migration processes, identify and address issues promptly, and optimize performance for large-scale data transfers.
8. Documentation:
Maintain detailed documentation of data migration processes, including source-to target mappings, ETL workflows, and data lineage.
9. Collaboration:
Collaborate with cross-functional teams, including data analysts, developers, and business stakeholders, to ensure successful data migration outcomes.
10. Best Practices:
Stay current with industry best practices and emerging technologies in data migration and database management.
Qualifications:
- Bachelors degree in a related field e.g., Computer Science, Information Systems.
- Proven experience as a Data Migration Consultant, with a focus on Azure Data Factory, SSIS, SQL database management, and database design concepts.
- Strong proficiency in Azure Data Factory pipelines and SSIS development.
- Extensive experience with SQL database management and optimization.
- Familiarity with database design principles and data modelling.
- Excellent problem-solving and troubleshooting skills.
- Strong communication and interpersonal skills for effective collaboration with clients and teams.
- Relevant certifications in Azure Data Factory or SSIS are a plus.
Last Date to Apply: 31 July, 2024
Apply today and embark on a journey of innovation, growth, and endless possibilities – where every day brings new challenges and rewards.