Conduct a comprehensive assessment of existing databases and systems, including schema, data, stored procedures, and applications.
Support the data migration effort, utilizing tools, custom scripts, or ETL processes to transfer data.
Provide technical experience regarding data models (logical and physical) database design development, data mining and segmentation techniques
Perform mass data imports/exports using the API or various import tools
Apply strong analytical skills to collect, organize, analyze, and distribute substantial amounts of information with meticulous attention to detail and accuracy
Ensure data integrity and accuracy during the migration process.
Implement effective indexing and caching strategies.
Document the entire migration process, including best practices, procedures, and configurations.
Assist with training and knowledge transfer to internal teams for ongoing support and maintenance.

Ability to obtain a DHS Public Trust security clearance (US Citizenship Required)
Bachelor’s degree in information technology or related field, or the equivalent combination of education, professional training, or commensurate work experience
5+ years of work experience
3+ years of experience in data migration or related roles
Experience with ETL development tools and data warehouse architecture techniques
Working knowledge of databases (Microsoft SQL, Oracle, DB2), programming (XML, JavaScript, or ETL frameworks)
Knowledge of and experience using analytical reporting tools
Familiar with effective approaches and practical experience in data migration, data quality, master data management, and data security, including the use of relevant tools
Strong proficiency in scripting and automation for data migration tasks
Experience with performance tuning and optimization of PostgreSQL databases
Excellent problem-solving and troubleshooting skills.

Data Migration Specialist

Key skills