GOURAV KUMAR

Operations Associate

Jharkhand, India5 yrs 8 mos experience

Key Highlights

3.5+ years of ETL and Data Analysis experience
Expertise in Informatica PowerCenter and SQL
Proficient in data visualization tools like Tableau and Power BI

Stackforce AI infers this person is a Data Engineering professional with a focus on ETL processes and data analytics.

Contact

Skills

Core Skills

Etl DeveloperData AnalyticsData Warehousing

Other Skills

ALMAWSAirflowAmazon EC2Amazon Elastic MapReduce (EMR)BMC Control-MData StructuresEngineeringExtractGitHubGroup DiscussionsInformatica PowerCenterLoad (ETL)LookerMicrosoft Excel

About

-- An experienced ETL Developer and Data Analyst with 3.5+ years of experience in designing and implementing ETL processes for large-scale data warehousing projects. Throughout my career, I have developed expertise in Informatica Power center, SQL and PL/SQL. I have experience on UNIX and Reporting tools like Tableau, MS Power BI and Looker as well. -- As an ETL Developer , I am responsible for Data migration and Analysis with Connection Profile changes. I work closely with stakeholders to understand their data needs and ensure that ETL processes are efficient, accurate, and scalable. -- Also I am responsible for the generation of reports and dashboards using Tableau based on client's requirements. I have done enhancement of existing looker dashboard and troubleshooting errors wherever required. -- Other skill sets I am exposed to are:- * AWS * Control M * Power BI * Data Analytics * Looker * ALM * Qubole * Jira * Airflow * Winscp * Putty * SSMS To know more about me you can reach me at gouravkumar7659@gmail.com.

Experience

5 yrs 8 mos

Total Experience

1 yr 11 mos

Average Tenure

1 yr 9 mos

Current Experience

Sun life

Analyst Development

Sep 2024 – Present · 1 yr 9 mos · Gurugram, Haryana, India · Hybrid

Globallogic india

Senior Software Engineer

Jun 2023 – Sep 2024 · 1 yr 3 mos · Bengaluru, Karnataka, India · Hybrid

Worked with renowned US based travel booking site on following things-
Development, Enhancement and support of ETL workflows using Informatica Power center and AWS EMR.
Migrated the ETL Jobs residing in Qubole and Airflow to Informatica Power center and AWS EMR after vigorous analysis so that there is uniformity in platform usage and reducing the Cost on licensing for Qubole and Airflow.
Preparing Medium to complex SQL queries for data analysis and providing it to Finance team for their decision making.
Published the daily, weekly and monthly reports based on daily ETL loads using Looker and Tableau.
Supporting the SITEOPS team by troubleshooting errors if any production issues arises or if any Data discrepancy is reported by end users.
Connecting to Stakeholders to understand their concerns on daily basis and implementation of solutions to ETL flows and reports generated.
Performance tuning of the ETL workflows and optimization of the SQL queries.

SQLInformatica PowerCenterData AnalyticsBMC Control-MTableauLooker+9

Capgemini

3 roles

Senior Analyst/Software E

Promoted

Aug 2021 – Jun 2023 · 1 yr 10 mos

During this tenure I got the chance to work with a Canada based client.As a part of this project, platforms and Application tools that were used are below:-
Informatica Power Center
SQL
Unix
Putty
Control M
Tableau
Roles and Responsibilities:-
As a part of Dev Team, done the analysis on various Oracle db Tables, ETL Mappings and Jobs on BMC Control M.
Connected with Stakeholders and Clients for proper understanding of the business critical needs and delivering it to there expectations.
Responsible for Migrating critical ETL process to a new DB.
Moved the Old Tables to Archival Database based on vigorous analysis done on a daily basis by our team.
Connection Profile changes from Mainframe to SDM . Repointing the AFT, MQ Jobs flow to the new created connection profile.
Helped the Production Support team for the ORT's of AFT and MQ Jobs.
Also, In the warranty phase of the project provided support to the Production team based on our AFT/MQ Job failures experience.
Handed over the documents(POC, Analysis sheets etc.) prepared during the development phase to Production support team.

BMC Control-MPL/SQLUnixSQLPuttyInformatica PowerCenter+5

Analyst

Oct 2020 – Aug 2021 · 10 mos

Explored and worked on Informatica Power center, MS SQL server , Power BI .
In this tenure , worked on solving the defects and finding the root cause of the ETL mappings, Models/Dashboards on Power BI developed by the Team.
Complex KPI analysis and verification. against the Database and Power BI models.
Writing Test cases and preparing complex SQL queries to validate data authenticity in the database.
Managed and tracked the defects on ALM.

Microsoft Power BIMicrosoft ExcelALMSQLExtractTransform+5