Developer Data

Digvijay Vilas Bhosale.

ETL INFORMATICA DEVELOPER

Cell phone: +91-997*******

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

CAREER OBJECTIVE:

Looking forward to a career in ETL tool Informatica Power Center where my analytical and technical skills would be utilized and I would add as an asset to the organization.

SUMMARY:

• 2 years of experience as a BI/DW (ETL and Reporting) Developer using Informatica, Cognos and BO.

• Good understanding of Data Warehousing and Business Intelligence concepts. Expertise in understanding functional & technical requirement of clients based on reports to accomplish the decided targets.

• Good experience in understanding business applications, business dataflow and data relation.

• Experience in the Report design, Data Warehousing using Data Conversion, Data Extraction, Data Transformation and Data Loading.

• Good team player with excellent interpersonal and communications skills.

PROFESSIONAL EXPERIENCE:

Organization : Ascent Techno systems Pvt Ltd.

Designation : Software Engineer (Developer).

Experience : 2 years, since July-2010 till date

Technologies worked on : Informatica Power center 8.6.1/9.0.1,SQL,OWB

TECHNICAL SKILLS:

● ETL Tools : Informatica Power Center 8.6.1/9.0.1,Teradata,OWB

● Reporting Tool : Cognos 8.4, BO

● Data bases : Oracle 9i/10g/11g.

● Languages : SQL

ACADEMIC QUALIFICATION:

BE Computer from Pune University with First Class.

CERTIFICATION:

• Cognos 8.4 BI Report Author

• Teradata 12 Certified Professional certificate

PROJECT UNDERTAKEN:

Project # 1

Title : 20th century Fox

Client name : 20th century Fox

Role : ETL Developer

Period : July 2010 – Nov 2010

Team Size : 4

Description

Data related to Title are spread across different system in Fox, in order to provide one single version of truth for Product/Title Informatica MDM is being used. Data into MDM hub will be ported from different source systems like WPR, Prophet, CopDoc, Rovi international, Air date etc.

Key Responsibilities

• Analyze the mapping specification to understand the business logic.

• Mainly involved in ETL development and testing.

• Created the mappings using almost all the transformations like Source qualifier, Expression, Filter, Aggregator, Joiner, lookup, Router transformations etc. to load the data into DWH according to business logic

• Developed ETL mappings, Transformations and Loading using Informatica Power

Center 8.6.1.

Environment: Informatica Power Center 8.6.1, Oracle 10g and windows XP

Project # 2

Title : OWB to Informatica Conversion

Client name : Beach Body

Role : ETL Developer

Period : Dec 2010 – Till Date

Team Size : 6

Description

BEACHBODY is Health based product selling company in US and because of excessive data volume and Changing of target database, it migrating already created OWB mappings into the INFORMATICA mappings.

Key Responsibilities

• Analyze the OWB mappings to understand the business logic.

• Created the mappings using various the transformations like Source qualifier, Expression, Filter, Aggregator, Joiner, lookup to load the data into Staging and DWH according to business logic specified in OWB mapping.

• Mainly involved in ETL development and Unit testing.

• Made the Unit Test Plan.

• Performance tuning related task.

Environment: Informatica Power Center 9.0.1, OWB 10.2.0.3.0, Oracle 10g/11g, Win Server2003/XP

PERSONAL INFORMATION:

Date of birth: 4th Nov 1988

Language proficiency: English, Hindi, Marathi

Interests: Reading, Photography, Travelling

Address: Flat No: 7, Laxmisadan Appt, Lane No: 2, Shahu Colony, Karvenagar,

411052.

Contact this candidate