Data Migration Platform Engineer

Role summary

Migration and platform responsibilities

• Build replication and migration solutions across AWS DocumentDB, PostgreSQL, DB2, and Snowflake; maintain integrity, latency, and SLA compliance.
• Develop ETL workflows with DMS, Glue, and other integration tools; migrate legacy on-premises systems to AWS with validation, reconciliation, cutover, and rollback planning.
• Support incidents around the clock, perform root-cause analysis, and optimize platform performance, scalability, and cost.
• Build AWS data services with Glue, Lambda, S3, Step Functions, and EventBridge; develop Hudi lakehouse ingestion patterns.
• Implement DevOps automation, CI/CD, IaC, testing, and environment promotion; deploy and support Windows and Linux AWS compute.
• Establish observability with logging, metrics, alerts, and dashboards.
• Administer Snowflake accounts, databases, schemas, warehouses, RBAC, SSO/SCIM integration, warehouse cost, queries, and ingestion.
• Implement Snowflake governance, including masking, row access policies, tagging, retention, and usage monitoring; maintain runbooks and documentation.
• Maintain encryption, IAM, vulnerability-management, and security controls; collaborate with architecture, security, business units, and vendors.
• Support service handovers and knowledge transfer across teams.

Experience and qualifications

• At least three years in data replication, migration, and integration engineering; qualifications list at least three years of AWS platform and Snowflake administration experience.
• Hands-on AWS DMS, Glue, Lambda, and S3-based Snowflake staging experience.
• Production experience with Apache Hudi or comparable formats such as Iceberg or Delta Lake.
• Strong Snowflake administration, including RBAC, warehouse and cost management, COPY INTO, and Snowpipe.
• Proficiency in PostgreSQL, DB2, and other relational databases; experience migrating legacy Windows Server workloads to cloud.
• Python and Shell scripting; PySpark is advantageous. Terraform or comparable IaC experience; familiarity with CI/CD and Jenkins, Git, or Docker.
• Understanding of TLS/SSL, encryption, IAM policies, and vulnerability management.
• Able to work 24x7; strong problem-solving and communication skills; Agile and ServiceNow/ITSM experience.
• Appropriate degree-level or equivalent qualification; AWS, Snowflake, and database technology experience.

Additional and preferred skills

• Qlik Replicate, Matillion, or Fivetran experience is a plus.
• CloudWatch, Prometheus, or Grafana knowledge is a plus.
• AWS Solutions Architect, Data Engineer Associate, or Data Analytics Specialty; Snowflake SnowPro Core or Administrator; and DevOps certifications are preferred.