Umesh Gurav

About Umesh Gurav

11+ years’ experience of working in IT industry with strong background in ETL process using Informatica PowerCenter, data warehousing, business intelligence, AWS and Big data Hadoop.Skilled in integrating data from diverse sources and formats, such as databases (Oracle, SQL Server, MySQL, Teradata, and PostgreSQL), flat files, Mainframe, HDFS. Familiar with data profiling, data mapping, data validation and data quality techniques.Experience in developing ETL GLUE job in AWS with PySpark and Python that reads data file(CSV, Json) from S3 and loads into other cloud relational databases after applying required transformations.Experience in writing Terraform script to automate the process of provisioning AWS resources required for the tasks.Experience in writing PL/SQL unit such as procedures, functions, packages, triggers, and types.Experience in writing BTEQ (Basic Teradata Query) scripts and using Teradata utilities like FastLoad, MultiLoad, Tpump for data loads using Informatica.Designed and implemented SCD Type 1, 2 mapping strategy for a large-scale data warehousing project, ensuring accurate historical tracking and analysis of dimension changes.Developed and maintained Data ingestion pipeline to load data from local file, relational databases into HDFS using Sqoop and other methods.Experience in designing and implementing ETL process using Hive and Pspark to clean, transform and load the data into HDFS. Experience in scheduling jobs for Informatica using CA7 and Autosys scheduler.Creation of CICD pipeline for deployment of Informatica/Unix/database components through IBM Udeploy/Ansible, Artifactory and SVN, Git and Jenkins.Maintenance and design of database systems and tables, ensuring their security, reliability, and performance.I am certified Azure professional and have knowledge in Azure cloud process and techniques.

Experience

1. Senior Consultant

   CGI

   Apr 2025 — Present

Education

• TKIET warnanagar, kolhapur

  B.E.(computer sci. and engg.), Data Modeling/Warehousing and Database Administration

  2008 — 2012

Skills

• Mysql
• Core Java
• Css
• Microsoft Office
• Java
• C++
• C
• Windows
• Sql
• Php
• Html
• Javascript
• C#
• .net