We are seeking an experiencedย Data Migration Engineerย to support a Federal client in migrating enterprise data platforms fromย Snowflakeย toย AWS Cloud services. The ideal candidate will have strong hands-on experience withย Snowflake data extraction,ย AWS data lake and analytics services, andย secure data migration methodologiesย aligned with Federal compliance standards.ย
This role involves designing, executing, and validating large-scale data migrations while ensuring data integrity, security, performance, and compliance with Federal regulations.ย
ย
Design and implement end-to-endย data migration strategiesย from Snowflake to AWS cloud platformsย
Extract data from Snowflake usingย COPY INTO, Snowflake stages, and secure data sharing mechanismsย
Migrate data to AWS services includingย Amazon S3, Redshift, Athena, RDS/Aurora, and Glue Dataย Catalogย
Develop and optimize data pipelines usingย AWS Glue, Lambda, Step Functions, and Pythonย
Perform data validation, reconciliation, and quality checks post-migrationย
Convert Snowflake schemas, tables, views, and data types to AWS-compatible formatsย
Implementย incremental and batch migrationย strategies using Snowflake Streams and Tasksย
Ensure compliance withย Federal security and data governance standardsย (FedRAMP, FISMA, NIST)ย
Optimize data formats (Parquet/ORC) for cost, performance, and scalabilityย
Collaborate with cloud architects, security teams, and stakeholders to meet project milestonesย
Create technical documentation, migration runbooks, and operational guidesย
Monitor migration jobs and resolve performance, data consistency, or failure issuesย
Support post-migration testing, optimization, and production cutover activitiesย
Strong hands-on experience withย Snowflakeย (data unloading, stages, file formats, performance tuning)ย
Experience migrating data toย AWS Cloud, including:ย
Amazon S3ย
Amazon Redshiftย
AWS Glue (ETL & Dataย Catalog)ย
AWS Athenaย
Proficiency inย SQLย andย Pythonย
Experience withย data formats: Parquet, ORC, CSV, JSONย
Knowledge ofย AWS IAM, roles, policies, and secure access patternsย
Experience withย large-scale data migrationย and data warehousing conceptsย
Familiarity with CI/CD pipelines and automation for data workflowsย