Etl Developer Informatica

Mukul Jain Email: *************@*****.***

ETL DEVELOPER/ AZURE DATA ENGINEER M.: +91-955*******

SUMMARY

Experienced Data Engineer with a demonstrated history of working in the information technology and services industry. Skilled in Cloud Data Integration, Cloud Application Integration, Cloud Administration, Cloud Monitor, Shell Scripting, Microsoft Management Server Studio, SQL Developer, Post Man, Business Intelligence, Azure SQL Database, Azure Power BI. Strong Information Technology - BTech focused on Computer Science & Engineering from TMU University.

ACADEMIC CREDENTIALS

Bachelor of Technology (B.Tech) in June 2019 from Teerthankar Mahaveer University, Moradabad.

TECHNICAL SKILLS

Experience in (Skills)

Total Experience - 4 Years

IICS – 3.10 year,

Informatica PowerCenter- 1.2 years,

SQL – 3.10 years,

Snowflake – 1 year

Shell Scripting-2.5 Years

ETL- 3.10 years

AWS Buckets-1 Year

Azure Data Factory - 6 Month,

Azure SQL database- 6 Month,

Azure Power BI- 6 Month

Database

SQL Database, Microsoft Management Server Studio, Snowflake, Azure, PostgreSQL

Servers

Putty (Dev, Dev2, QA, QA2, Prd)

Operating Systems

Window, Linux

Debugger Tools

Informatica

Framework

PowerCenter, IICS

PROFFESIONAL EXPERIENCE: 3.10 years

Infogain India Pvt Ltd. Noida

Duration: May2021– Till Date

Project Title

Bio-Rad Project

Project Description

Bio-Rad Laboratories is an American developer and manufacturer of specialized technological products for the life science research and clinical diagnostics markets.

Bio-Rad’s diagnostic products and systems use a range of technologies and provide clinical information in the blood transfusion, diabetes monitoring, autoimmune, and infectious disease testing markets.

Technologies

CDI, CAI, Microsoft Management Server Studio, Shell Scripting, Postman, SOAP UI, PI

Role

ETL Developer

Responsibilities

Design, Develop and Test ETL Data Mappings, Mapping Task, Workflows using Informatica Cloud.

Re-designed multiple existingmappings to implement change request (CR) representing the updated business logic as part of BAU work.

Re-designed multiple existing mapping from PI to IICS.

Identifying bugs using Debugger in existing and newly created mappings by analyzing data flow, evaluating transformations.

To accomplish the mapping design by using various IICS Transformations like Connected and Unconnected Lookup, Joiner, Expression, Router, Source Qualifier, Aggregator, Filter, Sequence Generator, Normalizer, Union, Stored Procedure, Assignments, Service, Subprocess, Receive, Wait, End.

Call Error-Handler & Success Logger in both CAI & CDI

PREVIOUS EXPERIENCE:

Voto Technologies Pvt ltd, Ghaziabad

Duration: Jan 2019 –Feb 2020

Project Title

Bayer Data Loads

Project Description

Bayer U.S is a subsidiary of BAYER A.G. The Pharmaceuticals Division focuses on prescription products,

especially for women’s healthcare and cardiology and, also on specialty therapeutics in the areas of oncology,

hematology and ophthalmology. The division also comprises the Radiology Business Unit which markets contrast-

enhanced diagnostic imaging equipment together with the necessary contrast agents.

Technologies

Power Center, Postgre SQL, AWS

Role

ETL Developer

Responsibilities

Designed and developed the complete ETL process for efficiently loading data. Created complex queries to get relevant data based on business needs. Designed the data validations to be done before publishing the data to down streams. where we stored data in AWS buckets.

Voto Technologies Pvt ltd, Ghaziabad

Duration: Feb 2020– May 2021

Project Title

BAYER CLOUD MIGRATION

Project Description

Bayer U.S is a subsidiary of BAYER A.G. The Pharmaceuticals Division focuses on prescription products,

especially for women’s healthcare and cardiology and, also on specialty therapeutics in the areas of oncology,

hematology and ophthalmology. The division also comprises the Radiology Business Unit which markets contrast-

enhanced diagnostic imaging equipment together with the necessary contrast agents.

Technologies

IICS, PowerCenter, Amazon S3

Role

ETL Developer

Responsibilities

The current project that runs on Informatica Power Centre and Teradata needs to be migrated on cloud. The new technologies used are IICS & Amazon S3. All the mappings created to extract transform and load the data are re-designed in these new technologies.

Self-Project on Azure

Project Title

Sandbox Project

Project Description

Project was based on validation of Employee working hours using Databricks and creating the SCD 1 tables on Azure SQL using Data Factory. Create reports on the validated data using Power BI.

Technologies

Azure Data Factory, Databricks, Power BI, Azure Data Lakes, Azure Data Explorer

Role

-

Responsibilities

Generated employee related files using Azure SQL and exported these files into Azure Data Lake storage using Data Factory. Mounted this data into Databricks to create Data frames. Performed validations on employee data on Databricks and exported these files into Data Lake storage. Created SCD1 tables in Azure SQL using Data Factory and created reports from these tables using Power BI.

Contact this candidate