Varun Singh

Data Engineer with 5 years of experience designing and delivering scalable ETL pipelines, data warehousing solutions, and cloud-based data platforms. Proven track record at AGL-Hakuhodo and Accenture working with Teradata, Informatica PowerCenter, Oracle SQL, and Google Cloud Platform. Adept at translating complex business requirements into robust data architectures that drive analytics and reporting at scale.

Passionate about data quality, pipeline automation, and enabling data-driven decision-making.

Data Engineer at AGL – Hakuhodo (2023-06 – Present)

• Architected and maintained end-to-end ETL pipelines for marketing data ingestion, transformation, and loading into the enterprise data warehouse, reducing data latency by streamlining batch processing workflows.
• Designed and optimized Teradata-based data models (star and snowflake schemas) supporting large-scale analytical queries for business intelligence and marketing performance reporting.
• Leveraged Google Cloud Platform (GCP) for scalable data storage and processing, enabling cloud-first data solutions for cross-functional analytics teams.
• Built and maintained Customer Data Platform (CDP) pipelines integrating first-party and third-party data sources, improving audience segmentation and targeting precision for marketing campaigns.
• Collaborated with data analysts, BI engineers, and business stakeholders to translate requirements into robust data solutions, ensuring data quality and SLA compliance.
• Implemented automated data quality checks and monitoring frameworks to proactively detect anomalies and reduce pipeline failures in production environments.
• Utilized Qlik Compose for automation of data warehouse lifecycle management, accelerating delivery of new data marts from weeks to days.

Data Engineer at Accenture (2021-05 – 2023-06)

• Developed and maintained Informatica PowerCenter ETL workflows for multiple enterprise clients, handling complex data transformations across heterogeneous source systems.
• Wrote advanced Oracle SQL and PL/SQL scripts for data extraction, cleansing, and aggregation, contributing to a 30%+ improvement in query performance through indexing and query optimization.
• Contributed to continuous integration and deployment (CI/CD) of project releases, including version control practices and release coordination across multiple data engineering teams.
• Performed thorough data quality analysis and profiling on source-to-target mappings, ensuring data accuracy and consistency across the data warehouse layers (staging, ODS, DWH).
• Worked within Agile/Scrum teams in two-week sprint cycles, participating in daily stand-ups, sprint planning, retrospectives, and code reviews.
• Collaborated with cross-functional teams including data architects, QA analysts, and business analysts to deliver end-to-end data integration solutions for financial and retail domain clients.
• Authored technical documentation for ETL mappings, data flow diagrams, and operational runbooks to ensure maintainability and knowledge transfer.

Engineering Intern at Delhi Metro Rail Corporation Ltd (DMRC) (2018-06 – 2018-07)

• Gained hands-on exposure to large-scale operational data management and infrastructure systems in a high-volume transit environment.
• Supported the operations team in analyzing system logs and reporting, developing an early interest in data-driven decision-making.

Bachelor of Technology in Information Technology – Ch. Brahm Prakash Govt. Engineering College (2015-08 – 2019-08)