Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Apoorva Sinha

Lead Data Engineer
Pune

Summary

Versatile Data Engineer with 8+ years of experience in data modeling, analytics, and end-to-end ELT/ETL solutions across Hadoop, Snowflake, and BI platforms. Skilled in designing scalable data pipelines, integrating diverse sources, and delivering impactful insights through tools like Power BI, Tableau, and SSAS. Quick to learn and always keen to explore emerging technologies—currently delving into AI applications within data engineering to enhance project outcomes and drive innovation.

Overview

9
9
years of professional experience
4
4
years of post-secondary education
1
1
Certification

Work History

Lead Data Engineer, Amdocs

Amdocs Data Office
Pune
12.2022 - Current
  • Led migration of 500+ Hive tables to Snowflake, also changing Integration tool from Apache NiFi to SnapLogic and reducing processing time by 30%.
  • Built and maintained scalable data pipelines using SnapLogic iPaaS and Python for Snowflake Data Lake implementation for over 20 different sources and loading strategies.
  • Integrated data from SAP HANA, SuccessFactors, SharePoint, Jira, and Octane using REST APIs and GraphQL.
  • Developed complex finance data workflows from BW systems, processing 2M+ records per entity in near real-time.
  • Created reusable data pipeline as modular functions, cutting implementation time by 70%.
  • Improved data flow performance by 40% through calculation pushdown to Snowflake.
  • Mentored junior engineers and enforced GDPR, RLS, and masking for data compliance.

Data Engineer, Amdocs

Amdocs Data Platform
07.2021 - 12.2022
  • Designed and developed ELT solutions to ingest data into Hadoop HDFS and Hive-based Data Lake.
  • Built generic pipelines in Apache NiFi with Python customization to ingest data from APIs, AWS S3, Kafka, databases, and files.
  • Developed client-specific pipelines for API pagination and request parameterization.
  • Created and maintained Informatica BDM workflows for delta, snapshot, and merge transformations using staging layers.
  • Streamlined file structures using Python scripts and JOLT transformations.
  • Collaborated with Product Owners to translate business needs into technical specs and authored functional/technical documentation.

DWH/BI Developer, Amdocs

Viewpoint and Hawkeye Analytics
01.2017 - 07.2022
  • Designed a multi-layered BI solution and Data Warehouse with facts and dimensions to deliver global ticketing insights for Amdocs Product Support.
  • Collaborated with customers from project inception, driving requirement gathering and solution design.
  • Built ETL pipelines using SSIS with flags and parameterization for incremental loads and process synchronization.
  • Developed complex ad-hoc SQL queries for analysis and debugging.
  • Created SSAS Tabular models with DAX in a Snowflake schema.
  • Built and scheduled custom Power BI reports using PBRS; delivered impactful Tableau dashboards aligned with client KPIs.
  • Engineered complex data sources with multi-join and blend logic for reporting processes.
  • Operated in agile teams, managing analysis, development, deployment, and debugging within tight timelines.

Education

Bachelor of Engineering - Computer Science, GPA: 8.06/10

Rajiv Gandhi Technical University
Bhopal
08.2012 - 06.2016

Skills

Data Modeling, Data Warehouse, Data Lake

ELT Tools: SnapLogic iPaaS, Apache NiFi, Informatica BDM

ETL Tools -MSBI SSIS, SSAS, Informatica Powercenter 951, Jedox 6

Data Visualisation : Tableau 20182/10x/9x, Power BI

Database - Snowflake, Hive, Oracle 11g, SQL Server 2017

Big Data Framework : Cloudera Hadoop Hbase, Hive, HDFS, Schema Registry

Programming Languages: Python

Certification

SnowPro Core Certification

Timeline

SnowPro Core Certification

08-2025

Lead Data Engineer, Amdocs

Amdocs Data Office
12.2022 - Current

Data Engineer, Amdocs

Amdocs Data Platform
07.2021 - 12.2022

DWH/BI Developer, Amdocs

Viewpoint and Hawkeye Analytics
01.2017 - 07.2022

Bachelor of Engineering - Computer Science, GPA: 8.06/10

Rajiv Gandhi Technical University
08.2012 - 06.2016

Similar Profiles

CREATE PROFILE
Apoorva SinhaLead Data Engineer