Senior Data Engineer with an experience of 7 years in the development/implementation of various projects using SAP HANA, Native SQL, Snowflake and BODS in the IT field.
Creates information models using SQL scripting methods in HANA.
Worked in creating complex Table Functions and Stored Procedures as per the requirement.
Monitor Informatica jobs.
Created command tasks and workflows in informatica to replicate tables from HANA to Hive.
Created data ingestion to replicate jobs from HANA to Hive.
Tracked performance of views after every change to ensure the report performance and present it for Architecture Review if major change occurs.
Worked in SAP HANA to Snowflake Migration project wherein worked in analyzing the tool to be used for Data Validations, optimizing Snowflake models and redesigning critical HANA objects in Snowflake.
Leading the team in Snowflake migration and conducting KT sessions for up skilling them in Snowflake.
Creating optimized views, UDFs and Stored Procedures in Snowflake.
Creating Tasks depending on the orchestration needs and creating role/row based access as per the requirement.
Using Streams, Tasks and SnowPipe for various orchestration jobs and data loads.
Using Dynamic Tables and query optimizations in Snowflake.
Carried out Performance Tuning for Snowflake objects.
Worked on Data Sharing in Snowflake
❖ Creates information models using SQL scripting methods in HANA.
❖ Worked in creating complex Table Functions and Stored Procedures as per the requirement.
❖ Monitor Informatica jobs.
❖ Created command tasks and workflows in informatica to replicate tables from HANA to Hive.
❖ Created data ingestion to replicate jobs from HANA to Hive.
❖ Tracked performance of views after every change to ensure the report performance and
present it for Architecture Review if major change occurs.
❖ Worked in SAP HANA to Snowflake Migration project wherein worked in analyzing the tool to
be used for Data Validations, optimizing Snowflake models and redesigning critical HANA
objects in Snowflake.
❖ Leading the team in Snowflake migration and conducting KT sessions for up skilling them in
Snowflake.
❖ Creating optimized views, UDFs and Stored Procedures in Snowflake.
❖ Creating Tasks depending on the orchestration needs and creating role/row based access as
per the requirement.
❖ Using Streams, Tasks and SnowPipe for various orchestration jobs and data loads.
❖ Using Dynamic Tables and query optimizations in Snowflake.
❖ Carried out Performance Tuning for Snowflake objects.
SQL analytical privileges to implement row level security.
Optimized the report performance using various optimizing techniques.
Carried out Currency Conversion for various Business Units involved.
Materialized reporting views and retrieved through Direct Query from Power BI which improved data refresh time.
Developed level hierarchies for the master data.
Achieved Slowly Changing Dimensions (SCD) Implementation using BODS.
Accomplished Case Transform and Validation Transform for data cleansing which corrected data.
Modelled Information Views using proper optimized approach.
Optimized SAP HANA views design using appropriate join options.
Formulated HDBDD tables for providing scalability to the tables.
Created cells for the cell level restrictions given by the client requirement.
Executed Bex queries using calculated key figures, restricted key figures, variables, exceptions, and conditions.
The AI-first Recruitment Operating System that unifies and automates the entire hiring lifecycle for modern enterprises worldwide.
Dr Job FZ LLC. 2026 © All Rights Reserved
