Pramod Kumar Yadav
New Delhi
Summary
Results-driven data engineering professional with over 15 years of extensive IT experience, specializing in data engineering, master data management, ETL development, and business intelligence. Proven expertise in designing and optimizing data pipelines using Informatica PowerCenter, Azure Databricks, and Snowflake, ensuring seamless data flow and accuracy. Strong foundation in developing efficient ETL processes that contribute to impactful business insights while adapting to dynamic project requirements. Demonstrated ability to lead teams and implement scalable solutions that enhance data integrity and support informed decision-making.
Overview
15
15
years of professional experience
1
1
Certification
5
5
years of post-secondary education
Work History
Data Engineer Lead
Eaton Corporation
New Delhi, India
05.2025 - Current
- Led the TAXONOMY project to integrate and unify time tracking data from multiple disparate systems into Snowflake using Medallion architecture for scalable data processing. Implemented ELT pipelines to ingest raw data into the Bronze layer, applied cleansing in Silver, and created business-ready aggregates in Gold for analytics and reporting.
- Provide support for different end to end application leveraging Azure Databricks.
- Architected Medallion architecture with ADF pipelines and Snowflake to unify multi-source time tracking data (e.g., Tenrox, Vision etc).
- Designed ADF activities for Bronze layer raw ingestion into Snowflake with full traceability.
- Authored all Snowflake SQL queries for Silver layer cleansing, deduplication, and joins.
- Built Gold layer aggregates via custom Snowflake queries for BI insights like billable hours.
- Implemented Snowflake dynamic masking for PII protection (e.g., employee data).
- Conducted code reviews for pipelines and queries to ensure data quality.
- Defined monitoring, governance, and alerting in ADF for reliable operations.
- Collaborated with stakeholders to deliver requirements on time, managing escalations.
- Solution Environment: Microsoft Azure
- Tools: Snowflake, Azure Data Factory, SSMS, SQL Developer, GIT, MS Office
Data Engineer
Archer Daniels Midland Company
New Delhi, India
04.2024 - 05.2025
- This project will implement a centralized architecture with capabilities to ingest, cleanse and standardize data from diverse ERPs and applications. As a modern data platform, Databricks will enable data integration in a secure, scalable, and supportable architecture.
- Provide support for different end to end application leveraging Azure Databricks.
- Working with various Azure services e.g. Azure Data factory, Azure storages that integrate with Databricks.
- Diagnose and resolve issues related to Azure Databricks jobs and ADF pipelines.
- Migrating code from one environment to another environment using Databricks CLI, DAB and Devops.
- Monitor the health, performance, and stability of Databricks clusters and workspaces.
- Analyzing logs, metrics, and error messages to identify the root causes.
- Implement and maintain security controls to protect the Databricks platform and its data.
- Collaborating with Databricks support for complex platform issues.
- Monitor the Databricks and Data Factory Jobs.
- Solution Environment: Microsoft Azure
- Tools: Azure Databricks, Azure Data Factory, SSMS, SQL Developer, GIT, MS Office
Tower Lead
Archer Daniels Midland Company
New Delhi, India
12.2021 - 04.2024
- This Project involves creating and maintaining master data for customers, supplier, Item and Reference data.
- Provide oversight and guidance to all team members.
- Provide continuous monitoring and support for Managed Services operations across all delivery centers, including coordination for resource arrangements.
- Establishes clear roles and responsibilities for team members and fosters a collaborative and high-performance culture.
- Implements incident management processes and protocols to promptly identify, escalate, and resolve incidents affecting service delivery in a timely manner.
- Monitor and enforcing SLA compliance, ensuring that all incidents and service requests are resolved within agreed timelines.
- Proactively addresses potential SLA breaches and implements corrective actions.
- Identifies opportunities for process optimization and service improvement, driving efficiency and excellence in the Managed Services environment.
- Conducts quality reviews and audits to ensure that service delivery aligns with established standards and client expectations.
- Acts as a primary point of contact for clients during critical incidents, providing timely and accurate updates on incident resolution progress.
- Engages in regular service review meetings with clients to address concerns and gathers feedback.
- Driving daily SCRUM meetings with BAU team and NPD team.
- Maintaining Annual Operating Plan for MDM.
- Solution Environment: Informatica MDM 10.1/10.3/10.4, Oracle, PL SQL Developer, Unix, SQL Server
- Tools: Informatica MDM HUB Console, SQL server management studio, Service Now, Azure Devops, Microsoft Project, MS Office
MDM Admin Lead
Archer Daniels Midland Company
Erlanger, KY, US
02.2019 - 11.2021
- This Project involves creating and maintaining master data for customers, supplier, Item and Reference data.
- Managing and guiding MDM administrator team.
- Administration activities of Informatica MDM, IDQ, activeVos.
- Installing Informatica MDM 10.3 HF3 and 10.4 HF2
- Upgrading Informatica from 10.1 HF1 to 10.3 HF3
- Migrating code from one environment to other environment.
- Responsible for releasing code into production.
- Handle several Change Requests as part of correcting the functionality of the current working code.
- Installing Emergency bug fixes on the environment.
- Applying software upgrades and license patches.
- Installing and upgrading address doctor and Elastic search
- Automated services restart for MDM
- Solution Environment: Informatica MDM 10.1/10.3/10.4, Oracle, PL SQL Developer, Unix, SQL Server, Windows
- Tools: Informatica MDM HUB Console, ActiveVos console, IDQ Admin, IDQ Developer, SQL server management studio, Winscp, putty, SOAP UI, MDM E360, MDM provisioning tool.
ETL Lead
Eaton Corporation
Eaton Center, Cleveland, Ohio, US
05.2014 - 01.2019
- This project involves development of data warehouse for the Eaton cooperation. We are making reports for analysis of Sales, Products, Corporate etc.
- Successfully delivered CERP global vista and vista migration, Cognos conversion project while working as Technical Lead.
- Designed the architecture for CERP project.
- Lead and supported production support project.
- Developed ETL mappings, transformations using Informatica Power Center 9.X.
- Data Profiling for pulling the correct and desired data which needs to be loaded into data warehouse.
- Handle several Change Requests as part of correcting the functionality of the current working code.
- Preparations of the High Level analysis, design documents and the detailed level design documents
- Optimization of the code.
- Preparation of test cases and testing of mapping.
- Creating ad hoc reports for user.
- Creating OBIEE Reports.
- Create Models in RPD.
- Solution Environment: Informatica 9.1- 9.5, Oracle, PL SQL Developer, Unix, Control-M scheduling tool, OBIEE 11g, OBIEE 12c
- Tools: Informatica Power Center, PL SQL Developer & Oracle
ETL Developer
Royal Bank of Scotland
Gurgaon, Haryana, India
10.2012 - 05.2014
- This is a Data transformation project of RBS carried under FiRST programme to migrate the data from different source systems into OFSAA DWH. This involves transforming and harmonizing the data using Informatica. The aim of the project is to remove data redundancy, duplication across systems, centralized control and refinement of data.
- Developed ETL mappings, transformations using Informatica Power Center 9.1.
- Data Profiling for pulling the correct and desired data which needs to be loaded into data warehouse.
- Developed mappings using various transformations.
- Involved in Optimization of the Informatica code.
- Preparations of the High Level design documents and the detailed level design documents.
- Involved in preparation of test cases and testing of mapping.
- Interaction with Client’s at every stage of the project.
- Solution Environment: Informatica 9.1, Oracle 10g, Toad, Unix, Control-M scheduling tool
- Tools: Informatica Power Center, Toad
ETL Developer
American Express
Kochi, Kerala, India
05.2011 - 10.2012
- AMEX Loyalty is a program offered by AMEX to its member for membership rewards. Like any other loyalty program it is an extension of the American Express offerings along with various partners to the customers. A customer is offered to enroll into this program along with the initial application for the card for minimal fees. Once a member enrolls for the offer, the member earns points for shopping, recreation, travel etc. as per various offers. These points maybe redeemed as per the offers and members choice.
- Developed ETL mappings, transformations using Informatica Power Center 8.6.
- Developed mappings using various transformations like Expression, lookup, Router, Filter, joiner, aggregate transformation.
- UNIX Shell scripts to run informatica workflows.
- Handled several Change Requests as a new requirement while working for AMEX.
- Preparations of the High Level analysis, design documents and the detailed level design documents
- Preparation of test cases and testing of mapping.
- Interaction with Client’s at every stage of the project.
- Solution Environment: Informatica 8.6, PUTTY, WINSCP, SQL Developer, Unix, Oracle 10g
- Tools: Informatica Power Center, SQL Developer
Skills
- ETL development
- Data warehousing
- Data modeling
- Data pipeline design
- Data migration
- SQL expertise
- Real-time analytics
- Metadata management
- Data integration
- SQL and databases
- Data analysis
- Relational databases
- Team building
Certification
- AWS Certified Solutions Architect
- Databricks Fundamentals
- Snowflake SnowPro Core Associate
Education
Bachelor of Technology - Electrical Engineering
Uttar Pradesh Technical University
Lucknow 08.2005 - 07.2009
Post Graduate - Additional General Management
Indian Institute Of Management
Shilllong 05.2023 - 05.2024
Timeline
Data Engineer Lead
Eaton Corporation
05.2025 - Current
Data Engineer
Archer Daniels Midland Company
04.2024 - 05.2025
Post Graduate - Additional General Management
Indian Institute Of Management
05.2023 - 05.2024
Tower Lead
Archer Daniels Midland Company
12.2021 - 04.2024
MDM Admin Lead
Archer Daniels Midland Company
02.2019 - 11.2021
ETL Lead
Eaton Corporation
05.2014 - 01.2019
ETL Developer
Royal Bank of Scotland
10.2012 - 05.2014
ETL Developer
American Express
05.2011 - 10.2012
Bachelor of Technology - Electrical Engineering
Uttar Pradesh Technical University
08.2005 - 07.2009