Ashwani Bhatnagar
Noida
Summary
Accomplished Technical Architect with extensive experience at IBM, specializing in ETL pipeline development and data warehousing. Proficient in Snowflake and DataStage, I excel in optimizing performance and enhancing data integrity. A collaborative leader, I effectively translate complex business requirements into actionable solutions, driving project success and efficiency. Detail-oriented Technical Architect with a strong foundation in ETL development and data migration. Known for successful troubleshooting and performance tuning, dedicated to delivering high-quality data solutions and enhancing operational efficiency.
Overview
19
19
years of professional experience
1
1
Certification
Work History
Technical Architect (Designer & Developer)
HINDUSTAN COMPUTERS LTD TECHNOLOGY(HCLTECH)
09.2024 - Current
- Prepared ETL Mapping Documents for every mapping and Data Migration Document for smooth transfer of project from development to testing environment.
- Perform unit testing and system testing to validate data loads in the target.
- Troubleshooting Long running jobs and fixed the issues.
- Used ETL, methodologies and best practice to create DBT pipeline.
- Followed and enhanced programming and naming standards.
- Developed jobs components and schedule job in control -m.
- Created and deployed physical Objects including custom tables, custom views, stored procedures, and indexes to SQL server for Staging and Data-Warehouse environment.
- Involved in writing SQL queries and Used joins to access data from Oracle.
- Created Incremental and Ephemeral Models and Macros as reusable components.
- Create Pre & Post Validation Rules, using the Reusable component Macros.
- Define the Pre & Post validation rule in incremental Model.
- Deploy tables and Data movement from on premises to snowflake using the MFP framework.
Technical Architect (Designer & Developer)
TATA CONSULTANCY SERVICES(TCS)
09.2021 - 09.2024
- Develop the documentation (Desigen Document & Use Cases)
- Used ETL, methodologies and best practice to create DBT pipeline.
- Followed and enhanced programming and naming standards.
- Developed jobs components and schedule job in control -m.
- Created and deployed physical Objects including custom tables, custom views, stored procedures, and indexes to SQL server for Staging and Data-Warehouse environment.
- Involved in writing SQL queries and Used joins to access data from Oracle.
- Created Incremental and Ephemeral Models and Macros as reusable components.
- Create Pre & Post Validation Rules, using the Reusable component Macros.
- Define the Pre & Post validation rule in incremental Model.
- Deploy tables and Data movement from on premises to snowflake using the MFP framework.
Senior Technical Lead (Admin & Developer Role)
IBM GLOBAL SERVICES (IBM)
12.2017 - 08.2021
- Used ETL, methodologies and best practice to create ETL DataStage jobs.
- Followed and enhanced programming and naming standards.
- Developed jobs components and job lets in DataStage.
- Created and deployed physical Objects including custom tables, custom views, stored procedures, and indexes to SQL server for Staging and Data-Warehouse environment.
- Involved in writing SQL queries and Used joins to access data from Oracle.
- Created and managed source to target mapping documents for all Facts and Dimension tables.
- Broad Design Development and testing experience with Talend Integration Suite and knowledge in performance tuning of Mappings.
- Developed mappings to Load Fact and Dimension tables, SCD type1 and SCD type2 Dimensions and Incremental Loading and unit tested the mappings.
- Developed framework Integrated job which schedule multiple jobs at a time and update the last successful runtime, success status, sending mail for failed jobs, maintain the counts in SQL database.
- Extracted data from Flat files/Databases applied business logic to Load them in the staging database as well as flat files.
ETL Technical Lead
IBM GLOBAL SERVICES (IBM)
05.2016 - 11.2017
- Active participation in decision making and regularly interacted with the Business Analysts & development team to gain a better understanding of the Business Process, Requirements & Design.
- Solid experience translating business requirements into conceptual, logical, and physical data models.
- Prepared Data Mapping Documents and Design the ETL jobs based on the DMD with required Tables in the Dev Environment.
- Maintained Data Warehouse by loading dimensions and facts as part of project.
- Also worked for different enhancements in FACT tables.
- Worked on Optimizing and Performance tuning on targets, sources and mappings to increase the efficiency of the process.
ETL Technical Lead
IBM GLOBAL SERVICES (IBM)
10.2015 - 05.2016
- Active participation in decision making and regularly interacted with the Business Analysts & development team to gain a better understanding of the Business Process, Requirements & Design.
- Solid experience translating business requirements into conceptual, logical, and physical data models.
- Prepared Data Mapping Documents and Design the ETL jobs based on the DMD with required Tables in the Dev Environment.
- Converted complex job designs to different job segments and executed through job sequencer for better performance and easy maintenance.
- Maintained Data Warehouse by loading dimensions and facts as part of project.
- Also worked for different enhancements in FACT tables.
Data Analytics
IBM GLOBAL SERVICES (IBM)
03.2015 - 10.2015
- Implement best practices and methodologies in data analysis, design and modelling.
- Vast experience on Extraction, Transformation and Load (ETL) strategy, design and implementation.
- Expert in data analysis, migration, modelling, integration and data warehousing concepts and application.
- Involved in functional and technical meetings and responsible for creating ETL Source - to - Target mappings.
- Used DataStage Director and its run-time engine to schedule running the solution, testing and debugging its components, and monitoring the resulting executable versions (on an ad hoc or scheduled basis).
- Worked on troubleshooting, performance tuning, performance monitoring and enhancement of DataStage jobs.
Informatica Developer
IBM GLOBAL SERVICES
03.2013 - 02.2015
- Created the process design documentation of the Corporate Data Warehouse CDW Upgrades.
- Created Workflow & Mappings using different Transformations like Aggregator, Router, Joiner, Sort, Lookup, Normalizer.
- Provided training and direction to Support Team and Created the Document with the solution Steps.
- Participated in migration from Oracle 11g to 12C.
- Documented ETL test plans, test cases, and validations based on design specifications for unit testing.
Data Analytics
IBM GLOBAL SERVICES(IBM)
07.2012 - 03.2013
- Performance tuning of end-to-end integration processes within DataStage sequencers or in the source/target database endpoints as needed.
- Coordinating with architects, business users, DBAs to resolve any issues related to data mismatches, integrity constraints, load orders and creating mapping documents.
- Analyzed the defects and applied fixes in the Data stage jobs and Sequencers.
ETL DataStage Developer
IBM GLOBAL SERVICES(IBM)
01.2010 - 07.2012
- Performance tuning of end-to-end integration processes within DataStage sequencers or in the source/target database endpoints as needed.
- Coordinating with architects, business users, DBAs to resolve any issues related to data mismatches, integrity constraints, load orders and creating mapping documents.
- Analyzed the defects and applied fixes in the Data stage jobs and Sequencers.
- Verified the results using orchardman commands in UNIX environment.
DataStage Developer
IBM GLOBAL SERVICES (IBM)
02.2008 - 11.2010
- Effectively handling new/change requests from clients by proposing and implementing cost and effort efficient solutions.
- Ensuring that all the requests are well documented and are deployed as per plan.
- Providing technical and functional support for team members involved in the project.
- Utilized Parallelism through different partition methods to optimize performance in a large database environment.
.Net Developer
ADONIS ELECTRONICS PVT LTD
02.2007 - 01.2008
- Development of application using Claim Components as a base Architecture using ASP.NET, C#.NET, SQL 2000, ADO.NET.
- Integration of the application.
Skills
- DBT Cloud 12
- Snowflake
- Data Stage
- Informatica
- SQL Server
- Control -M
- Azure
- Python
- MFP
- Talon
- Software Development Lifecycle (SDLC)
- Agile & Scrum Methodologies
- ETL pipeline development
- GIT CI/CD Pipeline
- Scheduling
- AWS
Certification
• CSM Certified
• DataStage 8.5 Certified
• Siebel Certified
• AIX Certified
• Azure Solution Architect Expert
• DataStage 8.5 Certified
• Siebel Certified
• AIX Certified
• Azure Solution Architect Expert
Websites
Timeline
Technical Architect (Designer & Developer)
HINDUSTAN COMPUTERS LTD TECHNOLOGY(HCLTECH)
09.2024 - Current
Technical Architect (Designer & Developer)
TATA CONSULTANCY SERVICES(TCS)
09.2021 - 09.2024
Senior Technical Lead (Admin & Developer Role)
IBM GLOBAL SERVICES (IBM)
12.2017 - 08.2021
ETL Technical Lead
IBM GLOBAL SERVICES (IBM)
05.2016 - 11.2017
ETL Technical Lead
IBM GLOBAL SERVICES (IBM)
10.2015 - 05.2016
Data Analytics
IBM GLOBAL SERVICES (IBM)
03.2015 - 10.2015
Informatica Developer
IBM GLOBAL SERVICES
03.2013 - 02.2015
Data Analytics
IBM GLOBAL SERVICES(IBM)
07.2012 - 03.2013
ETL DataStage Developer
IBM GLOBAL SERVICES(IBM)
01.2010 - 07.2012
DataStage Developer
IBM GLOBAL SERVICES (IBM)
02.2008 - 11.2010
.Net Developer
ADONIS ELECTRONICS PVT LTD
02.2007 - 01.2008