Intermediate Database Analyst

Bachelor’s Degree in Computer Science, Information Systems, or a related field
3-5 years of hands-on experience in data migration and ETL
Proficient in SQL (MySQL, SQL Server), ETL tools (ADF, SSIS), and scripting (Python, PowerShell, Bash)
Experienced in automating data migration workflows
Able to troubleshoot migration issues
Strong in stakeholder collaboration
Able to handle multiple projects in a fast-paced environment with minimal supervision

Availability to provide data migration support during off-business hours and on weekends is required
Analyze and assess data structures in source and target systems to develop effective migration strategies
Migrate data from legacy systems to new platforms, ensuring data integrity, accuracy, and consistency throughout the process
Handle multiple data migration projects in parallel, managing priorities and troubleshooting issues efficiently
Develop, test and optimize scripts and processes to enhance migration performance and minimize downtime
Write and optimize SQL queries for data extraction, transformation, and validation
Identify data quality issue, perform data cleansing, and apply necessary information
Collaborate with stakeholders to define data mapping, business rules and, validation checks
Monitor and troubleshoot migration processes, ensuring timely and accurate data transfer
Automate repetitive data migration tasks to improve efficiency and reduce manual effort
Document data migration process, transformation rules, and troubleshooting steps for future reference
Ensure compliance with data security, data governance, and regulatory standards

Exposure to AI tools and a desire to leverage them to enhance your work content and user experience