Unison Consulting Pte Ltd is seeking a skilled Data Migration Developer who will be responsible for all activities related to detailed design, development, and unit testing of data migration jobs during the implementation project. As a Data Migration Developer, you will utilize Azure Data Factory (ADF) and SQL to design, develop, and implement data migration solutions.
Responsibilities:
- Collaborate with project managers, data architects, and other stakeholders to understand data migration requirements and objectives.
- Create and maintain ETL pipelines to extract, transform, and load data from various sources to target systems.
- Develop SQL scripts, stored procedures, and queries to support data migration and integration tasks.
- Ensure data integrity, accuracy, and consistency throughout the migration process.
- Perform data mapping, data profiling, and data validation to identify and resolve data quality issues.
- Monitor and optimize data migration processes to improve performance and efficiency.
- Document data migration processes, workflows, and technical specifications.
- Provide support and troubleshooting for data migration issues and incidents.
- Stay updated with the latest trends and best practices in data migration, ADF, and SQL technologies.
- Proven experience in data migration projects, specifically using Azure Data Factory (ADF) and SQL.
- Strong proficiency in SQL, including writing complex queries, stored procedures, and functions.
- Experience with ETL tools and data integration techniques.
- Knowledge of data modeling, data mapping, and data profiling.
- Familiarity with cloud platforms, particularly Microsoft Azure.