Offshore Technical Lead/Architect

Job Summary 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.