FREE ACCESS
5,000–10,000 jobs/day
See all jobs on JobTailor
Search thousands of fresh jobs every day.
Discover
- Fresh listings
- Fast filters
- No subscription required
Create a free account and start exploring right away.
Tech Stack
Tools & technologiesAirflowApacheCloudInformaticaPySparkPythonSQLSSIS
About the role
Key responsibilities & impact- Lead script-level repointing across 593 downstream scripts (PySpark, BTEQ, Shell, SQL, IICS, SSIS) and 154 Databricks MLOps scripts from Teradata/SQL Server/Minio to Snowflake.
- Execute SQL syntax conversion for Teradata BTEQ scripts to Snowflake-compatible SQL, leveraging utility frameworks provided by the SI Partner (Infosys).
- Drive Airflow variable and connection updates across all migrated workflows, ensuring pipelines point to Snowflake endpoints post-cutover.
- Manage the script modification and change management process, coordinating production-to-parallel sync within the required 1-business-day SLA.
- Own the deployment and sign-off process for each migration wave, maintaining runbooks and go/no-go checklists per domain group.
- Manage data copy requests for Minio-related assets and coordinate initial load and incremental sync activities with the SI Partner.
- Lead and coordinate a team of 6–8 Data Engineer I and Data Engineer II resources (onshore and offshore) across parallel migration workstreams.
- Assign scripts per complexity band (S/M/L) to team members, track daily progress against the LOE estimates, and escalate blockers promptly.
- Review code changes, validate SQL conversion quality, and enforce engineering standards before submission to EBI team for review.
- Mentor junior engineers on Snowflake-specific constructs (virtual warehouses, stages, Snowpark, streams & tasks) and Teradata-to-Snowflake syntax differences.
- Conduct daily stand-ups and provide weekly migration status reports to the Program Manager and client stakeholders.
- Own the parallel run and reconciliation cycle — execute data validation against Teradata source and Snowflake target, targeting sign-off within 2–3 reconciliation iterations per workflow.
- Drive automation of unit testing and validation frameworks in collaboration with the SI Partner, tracking outcomes in the centralized validation dashboard.
- Triage and root-cause data mismatches, performance gaps, and pipeline failures during the parallel run phase; coordinate resolution with SI Partner support as needed.
- Ensure UAT sign-off from the EBI Data team on each domain group before scheduling production cutover.
- Conduct performance and load testing on migrated Snowflake workloads; incorporate SI Partner guidance on query optimization and warehouse sizing.
- Serve as the EXL technical point of contact with the EBI client team for the repointing workstream — attending daily syncs, steering calls, and design reviews.
- Coordinate with Infosys (SI Partner) on alignment of major SQL conversion utilities prior to team execution, ensuring conversion frameworks are available at program kick-off.
- Translate migration risks and data reconciliation issues into clear business-impact language for non-technical stakeholders.
- Maintain shared documentation: migration decision log, runbooks, issue trackers, and lessons learned repository.
Requirements
What you’ll need- 8+ years of data engineering experience; minimum 3 years hands-on with Snowflake (architecture, SQL dialect, performance tuning, RBAC).
- Proven experience migrating Teradata workloads to Snowflake — including BTEQ/ANSI SQL translation, macro conversion, and stored procedure migration.
- Strong PySpark and Python skills; experience working with Databricks is required (MLOps pipelines a strong plus).
- Working knowledge of Apache Airflow — DAG management, variable configuration, connection updates across environments.
- Familiarity with IICS (Informatica Intelligent Cloud Services) and/or SSIS (.dtsx) pipelines in a migration context.
- Solid understanding of data lake and object store patterns (Minio, S3, ADLS) and how they integrate with Snowflake external stages.
- Experience with SQL Server, Teradata, and/or Netezza as source platforms is required.
- Strong Git proficiency; experience with CI/CD pipelines and code change coordination across environments (dev → parallel → prod).
- Proven experience leading a team of 5+ engineers in a fast-paced, time-bound migration or repointing program.
- Ability to manage scope across complexity bands (S/M/L scripts) and balance team capacity against tight delivery timelines.
- Strong stakeholder management — able to communicate migration status, risks, and escalation paths clearly to both technical and business audiences.
- Experience working in a client-facing consulting or managed services model is strongly preferred.
- Comfortable coordinating with an SI Partner — understanding scope boundaries, handoff points, and utility dependencies without micromanaging.
Benefits
Comp & perks- 🌐 Worldwide ❌ Jobs You've Hidden ⭐️ Saved Jobs ✅ Applied Jobs ✉️ Email Alerts 👤 Account EXL Website LinkedIn All Job Openings 10,000+ employees 💰 $2M Venture Round on 2015-01 Choosing a digital partner is about more than capabilities — it’s about collaboration and character. Senior Data Engineer – Snowflake Migration Lead 🔥 43 minutes ago 🏢🏡 Gurugram – Hybrid ⏰ Full Time 🟠 Senior 🚰 Data Engineer Airflow Apache Cloud Informatica PySpark Python SQL SSIS Apply Now Find Hiring Managers Customize resume + cover letter Report problem ☆ Save ☑️ Mark as applied ❌ Hide 📋 Description
- Lead script-level repointing across 593 downstream scripts (PySpark, BTEQ, Shell, SQL, IICS, SSIS) and 154 Databricks MLOps scripts from Teradata/SQL Server/Minio to Snowflake.
- Execute SQL syntax conversion for Teradata BTEQ scripts to Snowflake-compatible SQL, leveraging utility frameworks provided by the SI Partner (Infosys).
- Drive Airflow variable and connection updates across all migrated workflows, ensuring pipelines point to Snowflake endpoints post-cutover.
- Manage the script modification and change management process, coordinating production-to-parallel sync within the required 1-business-day SLA.
- Own the deployment and sign-off process for each migration wave, maintaining runbooks and go/no-go checklists per domain group.
- Manage data copy requests for Minio-related assets and coordinate initial load and incremental sync activities with the SI Partner.
- Lead and coordinate a team of 6–8 Data Engineer I and Data Engineer II resources (onshore and offshore) across parallel migration workstreams.
- Assign scripts per complexity band (S/M/L) to team members, track daily progress against the LOE estimates, and escalate blockers promptly.
- Review code changes, validate SQL conversion quality, and enforce engineering standards before submission to EBI team for review.
- Mentor junior engineers on Snowflake-specific constructs (virtual warehouses, stages, Snowpark, streams & tasks) and Teradata-to-Snowflake syntax differences.
- Conduct daily stand-ups and provide weekly migration status reports to the Program Manager and client stakeholders.
- Own the parallel run and reconciliation cycle — execute data validation against Teradata source and Snowflake target, targeting sign-off within 2–3 reconciliation iterations per workflow.
- Drive automation of unit testing and validation frameworks in collaboration with the SI Partner, tracking outcomes in the centralized validation dashboard.
- Triage and root-cause data mismatches, performance gaps, and pipeline failures during the parallel run phase; coordinate resolution with SI Partner support as needed.
- Ensure UAT sign-off from the EBI Data team on each domain group before scheduling production cutover.
- Conduct performance and load testing on migrated Snowflake workloads; incorporate SI Partner guidance on query optimization and warehouse sizing.
- Serve as the EXL technical point of contact with the EBI client team for the repointing workstream — attending daily syncs, steering calls, and design reviews.
- Coordinate with Infosys (SI Partner) on alignment of major SQL conversion utilities prior to team execution, ensuring conversion frameworks are available at program kick-off.
- Translate migration risks and data reconciliation issues into clear business-impact language for non-technical stakeholders.
- Maintain shared documentation: migration decision log, runbooks, issue trackers, and lessons learned repository. 🎯 Requirements
- 8+ years of data engineering experience; minimum 3 years hands-on with Snowflake (architecture, SQL dialect, performance tuning, RBAC).
- Proven experience migrating Teradata workloads to Snowflake — including BTEQ/ANSI SQL translation, macro conversion, and stored procedure migration.
- Strong PySpark and Python skills; experience working with Databricks is required (MLOps pipelines a strong plus).
- Working knowledge of Apache Airflow — DAG management, variable configuration, connection updates across environments.
- Familiarity with IICS (Informatica Intelligent Cloud Services) and/or SSIS (.dtsx) pipelines in a migration context.
- Solid understanding of data lake and object store patterns (Minio, S3, ADLS) and how they integrate with Snowflake external stages.
- Experience with SQL Server, Teradata, and/or Netezza as source platforms is required.
- Strong Git proficiency; experience with CI/CD pipelines and code change coordination across environments (dev → parallel → prod).
- Proven experience leading a team of 5+ engineers in a fast-paced, time-bound migration or repointing program.
- Ability to manage scope across complexity bands (S/M/L scripts) and balance team capacity against tight delivery timelines.
- Strong stakeholder management — able to communicate migration status, risks, and escalation paths clearly to both technical and business audiences.
- Experience working in a client-facing consulting or managed services model is strongly preferred.
- Comfortable coordinating with an SI Partner — understanding scope boundaries, handoff points, and utility dependencies without micromanaging. Apply Now 📊 Check your resume score for this job Improve your chances of getting an interview by checking your resume score before you apply. Check Resume Score Similar Jobs Senior Data Engineer 🕒 April 20 Alkami Technology 501 - 1000 🏦 Banking 💳 Fintech ☁️ SaaS Website LinkedIn All Job Openings Senior Data Engineer building data lakes and warehousing solutions for a B2B multi-tenant SaaS. Leading technical processes and collaborating with cross-functional teams. 🏢🏡 Gurugram – Hybrid 💰 $300M Post-IPO Debt - Alkami Technology on 2025-03 ⏰ Full Time 🟠 Senior 🚰 Data Engineer AWS Cassandra Cloud DynamoDB ETL Kafka Kubernetes MongoDB NoSQL Postgres Python SQL Terraform View More Data Engineer Jobs 🌐 Worldwide Built by Lior Neu-ner. I'd love to hear your feedback — Get in touch via DM or support@remoterocketship.com Search Search Jobs by country Search jobs by city Search jobs by job title Search entry-level jobs Search junior-level jobs Search senior-level jobs Search jobs by tech stack Search jobs by contract type Search remote internships Search remote part-time jobs Remote jobs Anywhere in the World Companies Hiring Anywhere in the World Companies Hiring Sales People Anywhere in the World Companies Hiring Software Engineers Anywhere in the World Resources Advice Tips for finding remote jobs Interview questions and answers Resume examples Cover letter examples Post a job Affiliates Privacy policy Terms of service Job board SEO course AI Apply Copilot OpenClaw job finder Jobs by Country Remote jobs anywhere in the world (Worldwide remote jobs) Remote jobs United States Remote jobs Australia Remote jobs Brazil Remote jobs Canada Remote jobs France Remote jobs Ireland Remote jobs Germany Remote jobs Netherlands Remote jobs Spain Remote jobs UK Popular Jobs Remote data analyst jobs Remote customer support jobs Remote executive assistant jobs Remote marketing jobs Remote product designer jobs Remote product manager jobs Remote project manager jobs Remote recruiter jobs Remote sales jobs Remote software engineer jobs Jobs by Type Remote full-time jobs Remote part-time jobs Remote contract jobs Remote internship jobs Remote entry-level jobs Remote jobs with no experience required Remote junior jobs (1-3 years of experience) Digital nomad jobs Remote jobs with no degree required Freelance remote jobs Temporary remote jobs Remote jobs hiring now Stay at home mom jobs
ATS Keywords
✓ Tailor your resumeApplicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills & Tools
SnowflakeSQLPySparkPythonDatabricksApache AirflowIICSSSISSQL ServerTeradata
Soft Skills
team leadershipstakeholder managementcommunicationproblem-solvingmentoringchange managementtime managementcollaborationdocumentationrisk management