Open to opportunities

ksantanu User

@ksantanuuser

Message

Technical & data architect turning enterprise ETL into secure GCP cloud platforms.

India

Message

What I'm looking for

I’m looking to lead GCP data engineering and architecture—designing secure, scalable ETL/ELT, lakehouse/warehousing solutions, and mentoring teams to deliver high-quality outcomes on time.

I’m a Technical & Data Architect with 20 years of IT experience, specializing in Data Warehousing, Business Intelligence (BI), Enterprise Data Architecture, and Cloud Data Engineering.

Over 6+ years on Google Cloud Platform (GCP), I’ve architected and delivered 4–5 enterprise-scale data migrations from on-premises to GCP—building secure, scalable, and high-performance cloud data platforms.

I lead cloud-native data engineering initiatives end-to-end: designing ETL/ELT pipelines, ingestion frameworks, and orchestration workflows, with enterprise data warehouses on GCP. I also bring hands-on lakehouse expertise using Databricks and Databricks Lakehouse concepts for scalable analytics workloads.

As a Legacy & Modern ETL SME, I modernize complex transformations from IBM InfoSphere DataStage into optimized cloud workloads, combining deep SQL/PL/SQL skills with strong data modeling foundations (Star/Snowflake, Data Vault, Data Lake, Lakehouse). I also manage SDLC through Agile/Scrum, mentoring teams and setting delivery standards to align technical execution with business outcomes.

Experience

Work history, roles, and key accomplishments

Data Engineer (GCP Lead)

Globant

Sep 2025 - Jul 2026 (10 months)

Architected and implemented end-to-end ETL/ELT strategies on Google Cloud for enterprise-scale data processing. Built pipelines with BigQuery, Cloud Composer (Airflow DAGs), Dataflow, Cloud Functions (Python), and Cloud SQL, and mentored an engineering team.

ETL ELT BigQuery Cloud Composer Dataflow Cloud Functions Cloud SQL Mentor

Data Architect Manager (GCP Lead)

Accenture

Feb 2022 - Sep 2025 (3 years 7 months)

Led architecture and execution of cloud data warehousing projects across global business units for L’Oréal and ULTA. Designed modular streaming and batch pipelines on GCP using BigQuery, Composer/Airflow, Cloud Functions, and Dataflow.

GCP BigQuery Cloud Composer Cloud Functions Dataflow Streaming Pipelines Quality Standards Resource Allocation

Technical Architect (GCP DataStage SME)

Datametica

Sep 2019 - Feb 2022 (2 years 5 months)

Served as an SME for legacy-to-cloud data migrations, converting complex IBM DataStage ETL logic into optimized BigQuery workloads. Performed source-to-target mapping, cost estimation, and pipeline optimization for on-premise to GCP lift-and-shift projects, integrating sources into a unified GCP data lake and enterprise data warehouse.

DataStage BigQuery Data Lake Enterprise Data Warehouse Source To Target Mapping Cost Estimation Data Migration ETL Logic Optimization

Managing Consultant (Technical Architect)

Exusia

Apr 2015 - Sep 2019 (4 years 5 months)

Managed a 10-person engineering team to design real-time/hourly ETL jobs using IBM InfoSphere DataStage 11.5 and SQL Server. Established secure data integration architecture for healthcare data across eight disparate source systems and defined delivery governance and estimates.

SQL Server ETL Real Time Hourly Batch ETL Healthcare Data Integration Secure Architecture Team Management Estimation

Technical Architect

Tech Mahindra

Apr 2014 - Apr 2015 (1 year)

Architected a central MIS data repository integrating CRM (Siebel), ERP (Oracle), Balance Management (Comviva), and VMS systems. Enabled mobile application and canned email reporting using BusinessObjects XI and TIBCO interfaces.

Oracle ERP Comviva SAP BusinessObjects XI (BOXI)Reporting

Advisory System Analyst

IBM

Dec 2011 - Apr 2014 (2 years 4 months)

Designed and maintained end-to-end Network Intelligence (NI) data solutions using DataStage 8.1, IBM DB2, and InfoSphere Warehouse Design Studio. Built transformation pipelines across Landing, Staging, As-Today (AT), and Analytical Warehouse layers to support BI reporting.

DataStage IBM DB2 InfoSphere Warehouse Design Studio Network Intelligence Data Solutions BI Reporting Data Pipelines

Senior Technical Associate

Tech Mahindra

Jun 2006 - Dec 2011 (5 years 6 months)

Developed ETL jobs in IBM InfoSphere DataStage 8.1 to consolidate data from SingleView Billing, PeopleSoft CRM, and Retail POS into enterprise data warehouses/enterprise data marts. Supported enterprise data warehousing data consolidation for telecom-related systems.

ETL Development Data Warehouse Data Marts Peoplesoft POS systems

Software Engineer

Subex Systems

Feb 2005 - Jun 2006 (1 year 4 months)

Developed PL/SQL and Unix Shell Scripting routines for fraud management systems processing call detail records (CDRs) on Linux/Oracle platforms. Built data processing functionality to support fraud management workflows.

Pl SQL Shell Scripting Linux Oracle Fraud Management CDR

Programmer Analyst

Syntel (India)

Jul 2003 - Feb 2005 (1 year 7 months)

Developed application modules for underwriting, rating, and binding workflows for AIG Insurance. Implemented functionality using Oracle, PL/SQL, and C++.

Oracle Pl SQL C++Underwriting Rating