Urgent Job Opening- Data Migration Engineer- USC or GC only- Local to Washington, DC

Job Description

Title Data Engineer

Location: Washington, DC

USC/GC

Need LinkedIn, VISA DL

No FAKE GC

3-4 DAYS ONSITE

Locals or within 60 miles

11-12+ Years

Background and Context
The Data Engineer in this role will support programs involving one or more of the following:

Focuses explicitly on the one-time and phased mass migration efforts, ensuring zero data loss, strict adherence to mapping rules, and the successful execution of technical cutover protocols.

2. Scope of Work
2.1 Pipeline Development and Implementation

Build automated ETL/ELT pipelines to extract legacy data (Oracle, SharePoint) and load it into AWS RDS and Azure ADLS Gen2.
Program data cleansing, standardization, and validation logic into the pipelines based on the Data Quality Rulebook.
Execute the physical data extraction and load during pre-production and production cutovers.

2.2 Solution Design and Optimization

Tune extraction queries to minimize performance impacts on legacy production systems during sync operations.
Implement physical data models for the target databases.
Code and automate the technical rollback mechanisms and data reconciliation scripts.

2.3 Stakeholder Engagement and Change Management

Collaborate directly with the Business Analyst to interpret and implement STTM documents.
Provide feedback on technical feasibility and performance implications of proposed data transformation rules.
Participate in daily agile ceremonies and sprint planning.

2.4 Governance, Ethics, and Risk

Embed automated pre- and post-migration data quality checks directly into the ETL scripts.
Implement encryption standards at rest (AWS KMS) and in transit (TLS 1.2+).
Apply role-based access control (RBAC) schemas within the database layers via IAM and Microsoft Entra ID.

2.5 Documentation and Reporting

Document migration code repositories, operational runbooks, and cutover execution scripts.
Generate automated migration success/failure logs for auditing.

3. Required Qualifications and Experience
3.1 Education

Bachelor’s or Master’s in Computer Science, Data Engineering, or a related quantitative field.

3.2 Certifications Required

AWS Certified Data Engineer – Associate or Microsoft Certified Azure Data Engineer.

3.3 Mandatory Experience

5+ years building ETL pipelines, with heavy emphasis on one-time mass data migrations from legacy relational databases.

3.4 Technical Knowledge

Expert SQL and Python.
Hands-on experience with database migration tools (e.g., AWS DMS), Databricks, and legacy Oracle ecosystems.

3.5 Core Competencies

Rigorous attention to detail regarding data integrity, strong problem-solving skills for schema mismatches, and ability to work under

Kind Regards,

Deep Patel

Sr. Technical Recruiter

ZealHire Inc.

Email: Deep@zealhire.com

14 Wall Street 20th Floor | New York, NY 10005