Job Title: Data Migration Specialist

Job Summary:

We are seeking a Junior Data Migration Specialist to support data extraction, transformation, validation, and migration processes across different database systems. The ideal candidate should have hands-on experience with SQL, ETL processes, data mapping, and migration tools. This role involves working closely with data engineers, database administrators, and business teams to ensure accurate, efficient, and secure data migration.

Key Responsibilities:

• Extract, transform, and load (ETL) data from various sources into target systems
• Develop and optimize SQL scripts, queries, and stored procedures for data migration
• Validate and clean data before migration to ensure accuracy and integrity
• Assist in data mapping and transformation rules between legacy and modern systems
• Support data migration tools (Talend, Apache NiFi, SSIS, Informatica) and troubleshoot issues
• Work with IT teams to ensure seamless data migration with minimal downtime
• Identify and resolve data inconsistencies, duplicates, and formatting errors
• Implement data security best practices, ensuring compliance with GDPR, HIPAA, and other regulations
• Document data migration procedures, challenges, and resolutions
• Stay updated on data integration best practices, cloud data migration, and automation techniques

Skills and Knowledge Required:

• Proficiency in SQL and relational databases (MySQL, PostgreSQL, Microsoft SQL Server, Oracle)
• Experience with ETL processes and data migration tools (Talend, Apache NiFi, SSIS, Informatica)
• Familiarity with cloud-based databases (AWS RDS, Google Cloud SQL, Azure SQL) (optional)
• Understanding of data structures, normalization, and indexing
• Basic knowledge of scripting languages (Python, Bash, PowerShell) for data automation
• Experience in troubleshooting data migration issues and optimizing query performance
• Awareness of data governance, security, and compliance standards
• Strong analytical and problem-solving skills

Educational Qualifications:

• Bachelor’s degree in Computer Science, Information Technology, Data Science, or a related field
• Certifications in SQL, ETL, Cloud Databases, or Data Migration Tools are a plus

Experience:

• 1-2 years of experience in data migration, database management, or ETL development
• Hands-on experience with SQL query optimization and data transformation techniques

Key Focus Areas:

• Data Extraction, Transformation & Migration (ETL)
• Query Optimization & Data Cleansing
• Data Mapping & Validation
• Cloud-Based Data Migration & Automation

Tools and Technologies:

• Databases: MySQL, PostgreSQL, Microsoft SQL Server, Oracle
• ETL & Data Migration Tools: Talend, Apache NiFi, Informatica, SSIS, AWS Glue
• Query Languages: SQL, PL/SQL, T-SQL
• Cloud Databases: AWS RDS, Google Cloud SQL, Azure SQL (optional)
• Version Control & Automation: Git, Terraform, Ansible, Docker
• Data Quality & Validation: Data Profiling Tools, Power BI, Tableau

Other Requirements:

• Ability to analyze data requirements and optimize migration strategies
• Strong problem-solving and troubleshooting skills
• Passion for database optimization, cloud computing, and data automation
• Ability to work collaboratively with teams and manage migration timelines