ETL developer

Mukesh Jaiswal

Email: ***************@*****.***

Mobile: +91-990*******

Summary:

Around 2 years of experience in Data warehousing experience using Informatica Power Center 8.6

Extensively worked on Informatica Designer Components -Source Analyzer, Warehouse Designer, Mapping Designer & Mapplet Designer, Transformation Developer, and Workflow Manager.

Extensive experience in extraction, transformation and loading of data directly from different heterogeneous source systems like flat files, Oracle.

Good Knowledge on Datawarhouse Concepts.

Developed complex mappings in Informatica to load the data from various sources into the Data Warehouse, using different transformations like Update Strategy, Router, Lookup, Sequence Generator, Filter, Sorter, Joiner, Aggregator, etc.

Extensively worked on data extraction, Transformation and loading data from various sources like Oracle, SQL Server and Flat files.

Responsible for all activities related to the development, implementation, administration and support of ETL processes for large scale data warehouses using Informatica Power Center.

Strong experience in Data Warehousing and ETL using Informatica Power Center 8.6.

Strong skills in Data Analysis, Data Requirement Analysis and Data Mapping for ETL processes.

Knowhow on Kimball/Inmon methodologies.

Hands on experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.

Extensive experience in ETL design, development and maintenance using Oracle SQL, PL/SQL, SQL Loader, Informatica Power Center 8.x.

Well versed in developing the complex SQL queries, unions and multiple table joins and experience with Views.

Basic knowledge in UNIX scripting.

Experienced at Creating effective Test data and development thorough Unit test cases to ensure successful execution of the data & used pager for notifying the alerts after successful completion.

Developed Slowly Changing Dimension Mappings of type I, and II.

Used Mapping Parameters and session parameters in various projects in the development.

Extensively worked on third party tool like TOAD, SQL*PLUS.

Excellent problem solving skills with a strong technical background and good interpersonal skills.

Quick learner and excellent team player, ability to meet tight deadlines and work under pressure.

Education:

Pursuing MBA in Information Systems Management from Sikkim Manipal University.

BCA – Bachelor of Computer Applications from Madras University(2013)

Technical Skills:

ETL Tool : Informatica Power Center 8.6, 9.1

Databases : Oracle 10g/11g.

Operating Systems : Windows, UNIX.

Database GUI Tools : SQL *Plus, Toad

Programming Languages : SQL, PL/SQL

Professional Experience:

Worked as an ETL Developer/Analyst in XLNC Media Pvt.Ltd.,Kolkata – August 2013 to May 2015.

Details of Project & Work Experience:

Project # 1:

Project Name : Digital Marketing Warehouse Analysis System

Environment : Informatica 8.6,Oracle 10g/11g

Project Description:

XLNC Media is one of pioneer Event and Media Management Company in Eastern India who is predominantly engage with the state government of eastern and north eastern states for the promotional events and state level campaigns. Event management is the application of project management to the creation and development of festivals, events and conferences. It involves studying the intricacies of the brand, identifying the target audience, devising the event concept, planning the logistics and coordinating the technical aspects before actually executing the modalities of the proposed event.

Marketing is the ability to offer your product or service to your customers and satisfy their need or want, while making a profit. A tailored understanding of market place, customers, competitors and overall marketing environment will enable your business to target profitable customers, saving time, money and effort, capable in both online and offline marketing support. To cater to digital marketing needs, Digital marketing warehouse was build to support the function. A component of Digital marketing is Digital Brand Engagement. Digital marketing applies technologies or platforms such as websites, e-mail, apps (classic and mobile) and social networks. Digital Marketing can be through Non-internet channels like TV, Radio, SMS, etc or through Internet channels like Social Media, E-mails ads, Banner ads, etc.

Responsibilities:

Worked on Informatica tool -Source Analyzer, Data warehousing designer, Mapping Designer & Mapplet, and Transformations Developer.

Created mappings using Informatica Designer to build business rules to load data.

Used flat file and Oracle as the source and the target is Oracle database.

Most of the transformations were used like the Source qualifier, expressions, and joiner, Aggregators, Lookups, Filter, Rank and Update Strategy.

Used the Workflow Manager, to create the session, worklets.

Developing and modifying changes in mappings according to business logic.

Performing Unit Testing.

Analyzed the business requirements and functional specifications.

Extracted data from oracle database and spreadsheets and staged into a single place and applied business logic to load them in the central oracle database.

Used Informatica Power Center 8.6 for extraction, transformation and load (ETL) of data in the data warehouse.

Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression and Lookup, Update strategy and Sequence generator and Stored Procedure.

Developed complex mappings in Informatica to load the data from various sources.

Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.

Parameterized the mappings and increased the re-usability.

Used Informatica Power Center Workflow manager to create sessions, workflows and batches to run with the logic embedded in the mappings.

Created procedures to truncate data in the target before the session run.

Extensively used Toad utility for executing SQL scripts and worked on SQL for enhancing the performance of the conversion mapping.

Used the PL/SQL procedures for Informatica mappings for truncating the data in target tables at run time.

Extensively used Informatica debugger to figure out the problems in mapping. Also involved in troubleshooting existing ETL bugs.

Created a list of the inconsistencies in the data load on the client side so as to review and correct the issues on their side.

Created the ETL exception reports and validation reports after the data is loaded into the warehouse database.

Written documentation to describe program development, logic, coding, testing, changes and corrections.

Created Test cases for the mappings developed and then created integration Testing Document.

Followed Informatica recommendations, methodologies and best practices.

Personal Details:

Marital Status : Single

Sex : Male

Nationality : Indian

Language Known : English, Hindi, Assamese, Bengali.

Extracurricular activities:

Creative writing, Traveling, Sports, Music, Television, Internet surfing.

Declaration:

I hereby declare that all the information provided above by me is true to the best of my knowledge.

Date:

Place: Bangalore (Mukesh Jaiswal)

Contact this candidate