Ankit Dubey

Migration Strategist / Data Architect / Lead Data Engineer with 13 years of experience in enterprise data warehousing, cloud modernization, ETL migration, and large-scale data platform delivery. Led end-to-end migration of nearly 100 Informatica PowerCenter workflows using Amazon Redshift into Snowflake on AWS, converting legacy ETL into Snowflake SQL and stored procedure based pipelines and standardizing target environments through Terraform. Strong track record in target-state architecture, migration planning, data validation and reconciliation, performance tuning, stakeholder management, Agile delivery, and production support leadership.

Technical Manager / Lead Data Engineer at HCL Technologies (2020-10 – Present)

Clients: Humana, Restaurant Brands International (RBI)

• Lead a 14-member data engineering team delivering cloud data modernization, production support, and release execution for enterprise data platforms.
• Owned migration strategy and target-state design for the move from Informatica PowerCenter and Amazon Redshift to Snowflake on AWS, positioning the solution across architect, migration strategist, and lead engineer responsibilities.
• Converted nearly 100 legacy workflows into Snowflake SQL and stored procedure based pipelines while preserving business rules, restartability, dependency handling, and operational controls.
• Designed reusable migration patterns covering staging, transformation, incremental loads, control tables, audit logging, validation checkpoints, and exception handling.
• Implemented Terraform-based Infrastructure as Code to provision and manage Snowflake databases, schemas, warehouses, roles, grants, and environment-specific configurations across dev, test, and production.
• Led architecture discussions, source-to-target design reviews, stakeholder communication, sprint planning, delivery tracking, defect triage, and cutover readiness activities.
• Acted as support lead for RBI production workloads, driving root cause analysis, issue prioritization, SLA adherence, and system stability improvements.
• Delivered end-to-end migration for supply chain and operational data domains by moving Redshift-centric ETL workloads into Snowflake on AWS.
• Built ingestion and processing patterns using Amazon S3 and Snowflake features such as stages, Streams, Tasks, and virtual warehouses to support scalable ELT.
• Established data reconciliation using row counts, key-level checks, and business-rule validation to support UAT, parallel runs, and cutover confidence.
• Improved environment consistency, deployment repeatability, and maintainability by standardizing platform provisioning and access control through Terraform.

Lead Data Engineer at Tata Consultancy Services (2014-01 – 2020-09)

• Designed and developed enterprise ETL solutions using Informatica PowerCenter for data warehousing and reporting initiatives.
• Built PL/SQL and T-SQL scripts for transformation, validation, reconciliation, and performance-oriented data processing.
• Performed data migration, PHI masking, source-to-target validation, and support activities across development, testing, and production environments.
• Collaborated with architects, business analysts, QA teams, and support teams on solution design, deployment planning, defect resolution, and release cycles.
• Built a strong foundation in dimensional data warehousing, operational support, and ETL standards that enabled later cloud modernization and migration programs.

B.Tech – GL Bajaj Institute of Technology & Management (2013-01)