Offshore Technical Lead/Architect

Job Summary

NTT DATA strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization.

We are currently seeking an Offshore Technical Lead/Architect to join our team in Gurgaon, Haryana (IN-HR), India (IN).

Key Responsibilities Technical Leadership Governance

• Own and enforce dbt architectural standards, coding conventions, and model layering (staging - intermediate - marts).
• Act as the primary technical escalation point for Data Engineers and SMEs.
• Ensure consistency of implementation across SWP and IMS migration streams.
• Review and approve dbt models, Python extract/load scripts, and testing artifacts.

Delivery Execution

• Lead day-to-day development activities across wave-based migration plans.
• Coordinate task breakdown, sequencing, and dependency management with the Offshore Project Manager.
• Ensure accurate implementation of Informatica logic as translated into dbt and Python EL.
• Support defect triage, root-cause analysis, and remediation during SIT and UAT.

Informatica to dbt Translation Oversight

• Partner with Informatica SMEs to validate correct interpretation of legacy mappings, sessions, and workflows.
• Guide Data Engineers on translating Informatica constructs (lookups, aggregators, routers) into efficient SQL/dbt patterns.
• Validate non-CDC load assumptions and idempotent batch processing logic.

Airflow Experience Control-M Exposure

• Hands-on experience with Apache Airflow DAG development and configuration management.
• Demonstrated experience with Docker and Docker Compose in enterprise or production environments, including multi-service deployments on Linux VMs.
• Experience troubleshooting containerized application issues, including image compatibility problems, networking failures, volume mount errors, and startup sequencing.
• Experience integrating Airflow with enterprise scheduling tools such as BMC Control-M, including REST API-based job triggering and authentication configuration.

Quality, Testing Performance

• Ensure unit testing, dbt tests, and validation checks are consistently implemented.
• Review performance considerations (incremental models, partitioning strategies, warehouse usage).
• Ensure parity with legacy Informatica outputs based on agreed validation criteria.

Knowledge Transfer Sustainability

• Produce and maintain technical runbooks, design artifacts, and coding standards.
• Support training and onboarding of new engineers as migration scales.
• Ensure smooth transition to steady-state operations during hypercare and handover.