Tech Lead

Tech Mahindra; Dallas (TX); On-site; USD 120,000 - 150,000; Full time

Benefits offered by this job

Medical insurance

Dental insurance

Paid time off

Job summary

Tech Mahindra in Texas is seeking a data migration specialist to rationalize legacy DataStage environments as they move to Databricks. You will map end-to-end data lineage and identify dead code to streamline migration.

You will implement automated tests with PyTest and Great Expectations, validate schemas and row counts, and collaborate with PySpark teams to ensure zero data loss during cutovers.

Qualifications

• Bachelor’s or higher degree required.
• Experience migrating DataStage to Databricks environments.
• Strong knowledge of automated testing frameworks and data validation.

Responsibilities

• Analyze DataStage exports and metadata to map end-to-end data lineage.
• Identify dead jobs, redundant code, and duplicate logic to streamline migration.
• Explain complex parallel/server PySpark logic to the development team.
• Deploy automated test frameworks to validate data reconciliation between DataStage and Databricks.
• Build scripts to validate schemas, row counts, and transformations across environments.
• Execute regression tests on refactored PySpark code with legacy data.
• Document validation KPIs and sign off on data accuracy before live cutovers.
• Analyze legacy ETL data and metadata for migration readiness.

Skills

Advanced SQL

Python

PySpark

XML/JSON parsing

Great Expectations

PyTest

Databricks

DataStage

Education

Bachelor's degree or higher

Tools

Databricks

PySpark

IBM InfoSphere DataStage

Job description

A Bachelor’s or Higher Degree is the minimum entry required for the position

Objective
Drive the end-to-end rationalization, reverse-engineering, and automated validation of legacy DataStage environments migrating to modern Databricks architectures. This role is critical to eliminating legacy code redundancies, mapping complex data lineage, and implementing automated testing frameworks to guarantee zero data loss and business disruption during system cutovers.

Key Responsibilities

• Legacy Rationalization: Analyze DataStage .dsx/.isx exports and metadata to map end-to-end data lineage.
• Code Elimination: Identify and isolate "dead jobs", redundant code, and duplicate logic to streamline migration waves.
• Technical Translation: Provide functional logic explanations of complex parallel/server jobs to the PySpark development team.
• Test Automation: Deploy automated test frameworks to execute large-scale data reconciliation between DataStage and Databricks.
• Data Validation: Build automated scripts to validate data schemas, row counts, and complex transformations across dual-run environments.
• Regression Testing: Execute regression testing on newly refactored PySpark code against historical legacy data.
• Migration Sign-off: Document validation execution KPIs and formally sign off on data accuracy before live migration cutovers.
• Legacy ETL: IBM InfoSphere DataStage (Parallel/Server jobs, Sequences) and operational metadata analysis.
• Data Quality & Testing: Automated ETL Testing tools, PyTest, and Great Expectations.
• Languages & Querying: Advanced SQL, Python, and XML/JSON parsing.
• Target Platforms: Familiarity with Databricks, PySpark, and modern cloud data warehouses.

The pay range for this role is $120k - $150kper annum including any bonuses or variable pay. Tech Mahindra also offers benefits like medical, vision, dental, life, disability insuranceand paid time off (including holidays, parental leave, and sick leave, as required by law). Ask our recruiters for more details on our Benefits package. The exact offer terms will depend on the skill level, educational qualifications, experience, and location of the candidate.

Tech Mahindra is an Equal Employment Opportunity employer. We promote and support a diverse workforce at all levels of the company. All qualified applicants will receive consideration for employment without regard to race, religion, color, sex, age, national origin or disability. All applicants will be evaluated solely on the basis of their ability, competence, and performance of the essential functions of their positions with or without reasonable accommodations. Reasonable accommodations also are available in the hiring process for applicants with disabilities. Candidates can request a reasonable accommodation by contacting the company ADA Coordinator at [e-mail].