Saurabh Dalvi

Associate Consultant

CAPGEMINI

Mumbai

03.2022 - Current

Client: European pharmaceutical client.
Designed and developed 20+ end-to-end ETL/ELT data pipelines using AWS Glue (PySpark), S3, and Athena to ingest and transform diverse file formats (CSV, JSON, Parquet). Implemented scalable workflows to ensure reliable data availability for analytics, reporting, and regulatory compliance.
Orchestrated workflows with AWS Step Functions and Lambda, implementing retries, alerting (SNS/SES), and automated error handling to improve pipeline reliability and reduce manual interventions.
Engineered secure, scalable Snowflake layers; created internal/external tables, views, stored procedures, and scheduled tasks to automate transformations and refreshes, improving downstream data freshness and reliability.
Implemented comprehensive data quality, validation, and integrity checks via an in-house framework, increasing data trust and reducing UAT/production defects
Managed and maintained over 400 production interfaces with proactive monitoring and root-cause analysis, stabilizing operations.
Led end-to-end interface enhancement initiatives—including requirements gathering, impact analysis, development, testing, deployment, and documentation—while coordinating with clients and support teams to accelerate release cycles, optimize performance, and ensure compliance.
Delivered curated Snowflake datasets and BI-ready views by leveraging advanced SQL to create internal/external tables, stored procedures, views, and tasks, enabling faster reporting, dashboards, and data-driven decision-making.

Similar Profiles