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.
- 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.
- 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.
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.
- 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.
Benefits
Comp & perks- Health insurance
- Retirement plans
- Paid time off
- Flexible work arrangements
- Professional development
- Bonuses
- Stock options
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 AirflowIICSSSISGitCI/CD
Soft Skills
stakeholder managementteam leadershipcommunicationchange managementdata validation