Sachin Kumar

linkedin.com/in/sachin-kumar-***a**a1

Work Experience

Enterprise Resource Planning Integration Client - GE

The application reuses multiple parameter configuration to import data from various servers and load data into ERP tables for downstream application for report purpose.

Designed, developed and tested ETL Mappings, Mapplets, Workflows, Worklets using Informatica PowerCenter.

Encoded, tested, debugged, enhanced code reusability. Consultant, Capgemini

Centrepiece Integration Client - GE

09/2019 – 4/2020 Bangalore, India

Accomplishments

The application processes data from various sources, loads data into transactional tables passing the validation of data and creates invoices for downstream applications.

Implemented OLAP ETL data pipeline (Real-time BI) using Informatica PowerCenter as part of the DWH Dev team.

Developed mappings, workflow and set up connections to oracle database, applied SCD, used transformations like routers, joiner, performed SQL tuning, bug fixes.

10/2017 – 08/2019 Bangalore, India

Accomplishments

Education

B. Tech – Information Technology

B.P. Poddar Institute of Mgmt and Technology

08/2011 – 07/2015 Kolkata, India

Skills & Competences

CGPA: 7.8 / 10

Percentage: 61.4 %

Percentage: 76 %

Secondary School

Mother Khazani Convent School

05/2008 – 05/2010 New Delhi, India

Primary School

Pratiha Pallavan Public School

05/2007 – 05/2008 Jehanabad, India

Business Intelligence

Informatica PowerCenter

Data & Analytics

A full-time position in solving complex problems that requires skills coupled with solid technical knowledge.

+91 - 990-***-****

Whitefield, Bangalore

SQL

Data Warehouse

Unix

ETL

Tools Knowledge

Tools: Informatica PowerCenter

9.x/10.x, Oracle SQL Developer,

WinSCP, Appworx, SQL Workbench,

pgAdmin III, AWS Redshift, Jira, Rally

Awards and Leadership

Star Award, Capgemini - 2019

Rising Star Award, Capgemini - 2018

Member of NAV-PRAYAS, AN NGO,

MANPUR, GAYA.

Member of VRIKSH BE THE

CHANGE, AN NGO, GAYA, BIHAR

Workshop and Training

AI Cadet Certification – Capgemini

Participated in Advance computing

Languages

Hindi, English

Hobbies

Playing Football, Photography

03/2016 – Present Bangalore, India

Informatica

WinSCP

Appworx

Engine Modernization Integration Client - GE

08/2016 – 09/2017 Bangalore, India

Translated the data warehouse business requirement to build data integration pipeline using Informatica

PowerCenter & build mapping to populate data into target.

Followed best practices such as creating shared objects for reusability, naming conventions, error handling, emailing. Accomplishments

Excel

adl6so@r.postjobfree.com

Putty

HC Data Lake – SR Track Client - GE

05/2020- 09/2020 Bangalore, India

Accomplishments

The application is based on AWS DW which loads data from file passing through compaction layer and processing data into mirror, entity and CDS layer where all layer data is used by downstream applications.

Written Redshift SQL code similar to existing PostgreSQL, performed code optimization, profiling for ddls.

SQL Workbench

AWS Redshift

PL/SQL

Data Integration

The application is based on Data Warehouse system where the flow of data is from Landing zone to Raw zone to Curated zone.

The application brings instrumental data (Equity, Investment, Stock Market, Government Bond).

The NG application collects all data in a master application from where we populate data from File to S0, S1, S2, S3 and core layer using Informatica workflow with the help of Unix script which is used to run workflow to populate data into various layers.

NG Application – Cumulus Track Client - UBS

10/2020- Present Bangalore, India

Accomplishments

Contact this candidate