Apurba Orang

Results-driven Azure Data Engineer with 4 years of experience building and optimizing cloud-based data solutions. Skilled in Azure Data Factory, Azure Databricks, ADLS, PySpark, SQL, and ETL/ELT pipeline development. Proven track record of improving data processing performance by up to 60% while delivering scalable and reliable data solutions in Agile environments.

Consultant at Capgemini Technology Services (2026-07 – Present)

• Collaborated with client stakeholders and cross-functional teams to gather business requirements, estimate user stories, define delivery timelines, and ensure the successful delivery of data engineering solutions for an FMCG client in an Agile environment.
• Architected and implemented a scalable, metadata-driven ETL framework using parameterized configurations, enabling highly reusable, configurable, and maintainable data pipelines across multiple business units.
• Developed reusable utilities and generic notebooks that automated common ETL processes, reducing development effort by 70% while improving development consistency and accelerating solution delivery.

Associate Consultant at Capgemini Technology Services (2025-01 – 2026-06)

• Built and optimized ETL/ELT pipelines for an FMCG client using Azure Data Factory and Azure Databricks, improving data processing performance by 75%.
• Processed and managed over 100+ GB of data using scalable cloud-based solutions while ensuring high performance and reliability.
• Worked in client-facing roles to drive automation and innovative solutions, contributing to significant operational cost reduction.
• Collaborated with client SMEs to gather requirements and deliver business-focused data solutions.
• Performed unit testing, functional testing, schema validation, and source-to-target reconciliation to ensure data quality.
• Acted as the Release SPOC, managing production deployments and ensuring stable, error-free releases.

Senior Analyst at Capgemini Technology Services (2022-10 – 2024-12)

• Developed and maintained data pipelines for an FMCG client using Azure Databricks, Azure Data Factory, and Azure Data Lake Storage (ADLS).
• Optimized Databricks notebooks and PySpark code, improving execution performance.
• Implemented Unity Catalog for centralized data governance, access control, and metadata management.
• Collaborated in an Agile environment and tracked work using Jira to ensure timely project delivery.

B.E. in Production Engineering – Jadavpur University (2022)