Developer Manager

Lijo K Abraham

Contact No: +91-818******* Email Id:*******.****@*******.***

Informatica Developer

OBJECTIVE

To extend my career in a well established competitive, challenging environment,

where my knowledge can be shared and enriched, contributing to the company’s growth

and in turn ensuring personal growth within the organization.

SUMMARY

Having 2 years of experience working in the phases of Datawarehousing & Database life

cycle including Development & Implementation.

Experience working with various source systems/files like RDBMS, Flat Files etc.

Proficient in databases including Oracle10g (SQL), MS Excel.

Proficient in using tools like Microsoft Office (Excel, Word, PowerPoint).

Experienced working on Ralph Kimball & Inmon Approach.

Extensive experience in handling ETL using Informatica Power Center 9.x.

Extensively worked on Informatica Designer Components - Source Analyzer,

Transformation Developer, Mapplet and Mapping Designer.

Experience in using Workflow Manager Tools - Task Developer, Workflow Designer.

Strong experience in developing mappings using various transformations like

Unconnected and Connected lookups, Router, Aggregator, Sorter, Rank, Joiner,

Stored Procedure, Update Strategy etc and Re-usable transformations.

Experience in developing Workflows, sessions and tasks to effectively manage the Load.

Ability to prioritize multiple tasks.

Self-motivated and able to work independently and as a member of a team.

Excellent communication, interpersonal and analytical skills.

SKILL SET

ETL TOOLS : Informatica Power Center 9.1

OPERATING SYSTEM : Windows 9X/2003/XP/2007

RDBMS : Oracle 10g, MS Excel

DATABASE TOOLS : SQL*PLUS, SQL DEVELOPER

PROFESSIONAL EXPERIENCE

Bank of Mandiri, Jakarta, IN Feb 2014 – Nov

2014

Informatica Developer

Responsibilities:

Analyzed Business identified the source data and transformation logic needs and

review of final mapping documents. Also, participated in the review meetings/

project check in and user requirement gathering meetings.

Handled slowly changing dimensions of Type I, Type II to populate current and

historical data to Dimensions tables in the data warehouse.

Understanding the business model and customer requirements.

Involved in Performance Tuning of Source,Target and Mappings Level.

Extensively used ETL to load data from Flat files which involved both fixed width as

well as Delimited files and also from the relational database, which was Oracle

10g.

Worked on Source Analyzer, Warehouse Designer, Mapping Designer and

Transformations.

Used Filter, Router, Aggregator, Lookup, Expression Update Strategy etc.

transformations whenever required in the mapping.

Knowledge in creation of sessions and scheduling of sessions.

Environment: Oracle10g, Informatica Power center 9.1, SQL *Plus, Windows 2007.

NATIONAL ENTERPRISES, IND Oct 12 to Jan- 14

Database Developer (Internship)

Responsibilities:

Project Planning and Planning for project timelines, documentation for support team.

Requirement Gathering from clients and Design and Development.

Experience in Creation of Data base Design Tables, Joins, Sub-Queries, Views, and

Constraints.

Understand the Business requirements and estimate the effort for the new

requirements.

With Technical and functional expertise of the system helping other teams to

understand and develop new systems that would make the business more

productive and efficient.

Major ASSIGNMENTS:

Assignment Name: Development of Offline Database named as “Employees

Management”

Assignment Duration: Feb-2012 to July-2012

Team size 6

My Role:

Content Development.

Database Development

PERSONAL INFORMATION:

Date of Birth : Oct-16-1990.

Gender : Male.

Marital Status : Single.

Languages Known : English, Hindi

Declaration: I hereby declare that the information furnished above is true to the best of

my knowledge.

Current Loc: Hyderabad (LIJO K ABRAHAM)

Contact this candidate