Sachin Bijwar

Data Architect • CDP Specialist • Cloud Data Consultant
Helping businesses modernize their data ecosystems with performance and precision.

About Me

A senior data professional passionate about transforming raw data into meaningful insights and optimized architectures.

With over a decade of experience in data engineering, I’ve led and executed enterprise-scale data platforms, working at the intersection of Hadoop ecosystems, Hive optimization, and cloud modern data warehouses. My core strength lies in architecting performance-oriented pipelines, resolving production bottlenecks, and creating long-lasting validation frameworks that ensure trust in data.

15+

20+

Projects

Years Of Experience

My Professional Journey

Core Focus Areas

In the CDP 7.1.9 implementation, I architected and managed external Hive tables using the Parquet format at scale. I optimized complex Hive queries to improve performance and reduce costs, while also addressing production issues like column shifts, multiple active SCD records, and expired key handling. I built robust data validation frameworks leveraging natural keys and hashing logic, and created reusable SCD Type 1 and Type 2 strategies for both dimension and lookup layers.

As part of the GCP migration, I led the transition from Teradata and Hadoop to BigQuery. This included source-to-target mapping, data model redesign, and orchestration using Airflow (Composer) and Control-M. I developed scalable ingestion pipelines with Dataflow and ensured smooth production cutovers. Collaborating closely with US-based client teams, I helped shape the cloud architecture, align KPIs, and fine-tune post-migration performance, delivering a cost-effective and scalable cloud-native platform.

By combining deep platform knowledge with cross-functional collaboration, I’ve been able to help businesses trust their data, accelerate performance, and reduce operational inefficiencies. Whether it’s Hadoop or the cloud, I aim to build systems that are robust, resilient, and future-ready.

I’m currently working as a Sr. Tech Project Manager at Smartavya Pvt. LTD, where I architect and drive enterprise-scale data modernization initiatives using both Cloudera Data Platform and Google Cloud Platform.

With deep expertise in big data engineering, I focus on transforming legacy platforms into scalable, cloud-native solutions while ensuring performance, accuracy, and maintainability across the board

Data Projects

Leading initiatives in data engineering and cloud migration solutions.

A cloud-shaped object with server racks is connected via cables to a computer monitor. The setup is surrounded by several black squares on a blue background, evoking concepts of cloud computing and data networks.
A cloud-shaped object with server racks is connected via cables to a computer monitor. The setup is surrounded by several black squares on a blue background, evoking concepts of cloud computing and data networks.
Enterprise Data Platform Migration to CDP & GCP
A large, sturdy bridge with complex lattice work and structural beams, showcasing its engineering design. The bridge has an industrial look, with overhead clouds creating a dramatic background.
A large, sturdy bridge with complex lattice work and structural beams, showcasing its engineering design. The bridge has an industrial look, with overhead clouds creating a dramatic background.
A large steel bridge spans across a river, under an expansive sky filled with fluffy white and grey clouds. Below the bridge, a small dock area with people can be seen near the water's edge. The structure conveys a sense of engineering prowess against a dramatic cloudy backdrop.
A large steel bridge spans across a river, under an expansive sky filled with fluffy white and grey clouds. Below the bridge, a small dock area with people can be seen near the water's edge. The structure conveys a sense of engineering prowess against a dramatic cloudy backdrop.
A large, dramatic cloud dominates the sky above a partially constructed building. The structure has an exposed concrete frame, and several people are visible on the right side, wearing construction gear. The atmosphere is calm, with soft lighting creating a tranquil scene.
A large, dramatic cloud dominates the sky above a partially constructed building. The structure has an exposed concrete frame, and several people are visible on the right side, wearing construction gear. The atmosphere is calm, with soft lighting creating a tranquil scene.
Customer 360 Platform for a Retail Client

Seamless transitions across Azure, GCP, and AWS platforms.

Seamless transitions across Azure, GCP, and AWS platforms.

A cloud-shaped object with server racks is connected via cables to a computer monitor. The setup is surrounded by several black squares on a blue background, evoking concepts of cloud computing and data networks.
A cloud-shaped object with server racks is connected via cables to a computer monitor. The setup is surrounded by several black squares on a blue background, evoking concepts of cloud computing and data networks.
Modern Reporting Layer on Cloud Data Warehouse
A large, sturdy bridge with complex lattice work and structural beams, showcasing its engineering design. The bridge has an industrial look, with overhead clouds creating a dramatic background.
A large, sturdy bridge with complex lattice work and structural beams, showcasing its engineering design. The bridge has an industrial look, with overhead clouds creating a dramatic background.
A large steel bridge spans across a river, under an expansive sky filled with fluffy white and grey clouds. Below the bridge, a small dock area with people can be seen near the water's edge. The structure conveys a sense of engineering prowess against a dramatic cloudy backdrop.
A large steel bridge spans across a river, under an expansive sky filled with fluffy white and grey clouds. Below the bridge, a small dock area with people can be seen near the water's edge. The structure conveys a sense of engineering prowess against a dramatic cloudy backdrop.
A large, dramatic cloud dominates the sky above a partially constructed building. The structure has an exposed concrete frame, and several people are visible on the right side, wearing construction gear. The atmosphere is calm, with soft lighting creating a tranquil scene.
A large, dramatic cloud dominates the sky above a partially constructed building. The structure has an exposed concrete frame, and several people are visible on the right side, wearing construction gear. The atmosphere is calm, with soft lighting creating a tranquil scene.
CI/CD Pipeline for Data Engineering Projects

Seamless transitions across Azure, GCP, and AWS platforms.

Seamless transitions across Azure, GCP, and AWS platforms.

gray computer monitor

Get in Touch

Connect with Sachin for data consulting and community initiatives.