Data Project

ANKITA LAL

B.E, Information Science Eng.,

New Horizon College of Engineering, Marathalli Bangalore, Karnataka.

Two Years and Four months experience in Informatica Development

Email ID:***********@*****.***, Bangalore. Mobile No. +91-889*******

Working with TCS as an Informatica Developer in ETL technology from November, 2015

till date.

Executed project DICoE (Data Integration Center of Excellence)for Ameriprise Financial Inc.

Industrial Experience in Power Exchange of Mainframe, ETL,TWS tools.

Proficiency in Informatica, Oracle 11g, Unix,C languages.

Project

DICoE (Data Integration Center of Excellence)

Client

Ameriprise Financial Inc, Minneapolis,USA

Period

05th NOV, 2015 to till Date

Description

DICoE (Data Integration Center of Excellence) is an Ameriprise technology bundle which provides Data Integration service to applications teams. Informatica 9.1 environment and data movements between different applications /systems are developed, maintained and supported by DICOE.

Responsibilities

My responsibility is to develop & test the data:

Develop, test and implement Informatica workflows, sessions, command tasks, mappings and transformations. Implement performance techniques and best practices in each and every component

Create Informatica mapping sheet which derives the relation between sources, look up and target systems. Validate them against business rules and data definitions

Develop and migrate Power Exchange Data maps to read COBOL files, source and target Imports from various systems.

Design and develop pre-checks like file validation, duplicate & empty file check, date& count check and post checks like post balancing, checks and balance, errors.

Work on scripts related to Unix environment.

Create Job schedule and properties document, work with IBM TWS team to implement the jobs in production, non-production environments. Design and develop late start /complete alert Incident and email notifications to support and applications teams and also to business users.

Work hand in hand with onsite team for round the clock support, have daily calls to delegate tasks and updating them about the progress/next steps of the project.

Tools/Skills Used

The following tools/debugging Skills were used in the Project:

ETL Tool : Informatica 9.X

Scheduling Tool : Tivoli WorkLoad Scheduler

Mainframe Tool : Power Exchange 9.X, Mainframe

Database : Oracle, DB2

Awarded with "On the Spot Awards" for exemplary performances in optimizing, automating so many applications.

Awarded with Certificates of Appreciation for different Project related initiatives(Informatica Version Control, Mutual Authentication)

Course

Institution

Board

Year

Percentage/CGPA

B.E. –Information Science And Engineering

New Horizon College of Engg, Bangalore

VTU, Karnataka

2015

71%

12th – Science

Cambrian Public School, Ranchi

C.B.S.E, Jharkhand

2010

63%

10th

DAV Nandraj Public

School, Ranchi

C.B.S.E, Jharkhand

2008

64%

Date of Birth : 31th December 1992

Nationality : Indian

Marital Status : Single

Language Known : English, Hindi

PLACE: Bangalore

DATE : 18th Feb 2018 (Ankita Lal)

Contact this candidate