Having 9+ years of IT experience in Business Requirements Gathering/Analysis, Application Design, Development, Implementation, Testing of Cloud Based Data Warehousing and Data Integration Solutions using Snowflake SaaS.This is Canadian Telecom project where we are getting external data from Single View Billing Team to AWS S3. We are loading those external data into Snowflake Internal Stages and massaging data by using transformation logic as per business requirement then we are loading those data into Snowflake Tables.
Tech Mahindra
View- Website:
- techmahindra.com
- Employees:
- 109765
-
Senior Software EngineerTech Mahindra Jan 2021 - PresentNoida, Uttar Pradesh, India• Bulk loading from the external stages (AWS S3), internal stage to snowflake cloud using copy command.• Loading data into snowflake tables from the internal stage using snowsql.• Used COPY, GET, PUT and LIST command for validating the internal stage files.• Used import and export from internal stage (snowflake) from the external stage (AWS S3).• Wrinting complex snowsql scripts in snowflake for analysis and reporting.• Good exposure in working with Semi-Strctured data like XML, JSON by using VARIANT.• Used SNOW PIPE for continuous data ingestion from the S3 bucket.• Created cloned object to maintain zero copy cloning. Also cloned Production to sync with lower enviournment like UAT, PRE PROD.• Data validation have been done through Information Schema metadata.• Involved in writing SQL, PL/SQL procedures and functions.• Exposure with AWS cloud services: S3, EMR.• Good understanding with snowflake architecture, Virtual Warehouse, Time Travel, Fail Safe, Objects, Roles etc.
-
Seniour Engineering AnalystQualtechedge Jul 2019 - Jan 2021Gurgaon, IndiaETL, Informatica power center developer, Oracle Sql, PLSQL, Unix
-
Software EngineerEt&It For Tcs Jan 2017 - Jun 2019Gurgaon, IndiaDesign the Oracle SQL /PLSQL Database objects like table, views, synonyms, indexes, procedure, function, trigger, cursor, collection depending on requirement to implement and modify in application. Also developing report regarding this application and pushing the report on particular server and managing same.
-
Software EngineerExperis It India Jan 2016 - Jan 2017Gurugram, Haryana, IndiaWorking as Oracle SQL/PLSQL Developer for IBM.
Dinesh Kumar Yadav Education Details
-
Uttar Pradesh Technical UniversityA -
U P BoardA+
-
S L CA
Frequently Asked Questions about Dinesh Kumar Yadav
What company does Dinesh Kumar Yadav work for?
Dinesh Kumar Yadav works for Tech Mahindra
What is Dinesh Kumar Yadav's role at the current company?
Dinesh Kumar Yadav's current role is Data Engineer.
What schools did Dinesh Kumar Yadav attend?
Dinesh Kumar Yadav attended Uttar Pradesh Technical University, Deen Dayal Upadhyay Gorakhpur University, Gorakhpur, U P Board, S L C.
Who are Dinesh Kumar Yadav's colleagues?
Dinesh Kumar Yadav's colleagues are Dev Awasthi, Joe Varghese Padassaril, Kuppam Venkata Saidinesh, Sima Nayak, Mahesh B, Shanmuga Priya, Javed Parvez.
Not the Dinesh Kumar Yadav you were looking for?
-
Dinesh Kumar Yadav
Senior Technology Leader | Linkedin Top Voice | 20+ Years Of Innovation, Strategic Leadership & It Delivery | Advocate For Diversity, Equity & Inclusion | People-Centric Approach | Cspo® | Sfc™Ghaziabad1hays.com -
1yahoo.co.in -
Dinesh Kumar Yadav
Regional Hr Head Operation(East)- Pernod Ricard India (Earlier Seagram'S)Kolkata -
2gmail.com, gmail.com -
Dinesh Kumar Yadav
Executive And Service Engineer At Elecon Engineering Limited. Ex- Project Mechanical Engineer At Puzzolana Machinery Fabricators Llp HyderabadJharkhand, India
Free Chrome Extension
Find emails, phones & company data instantly
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial