Digvijay Vilas Bhosale.
ETL INFORMATICA DEVELOPER
Cell phone: +91-997*******
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.
• 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.
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
● 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
BE Computer from Pune University with First Class.
• Cognos 8.4 BI Report Author
• Teradata 12 Certified Professional certificate
Project # 1
Title : 20th century Fox
Client name : 20th century Fox
Role : ETL Developer
Period : July 2010 – Nov 2010
Team Size : 4
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.
• 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
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
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.
• 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
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,