ETL Developer
EXL Service
Total years of experience :8 years, 10 Months
• Extensively involved in Data Extraction, Transformation and Loading (ETL) from Source to Target Systems using Informatica Power Center.
• Developed mappings by using Informatica Transformations like Expression, Filter, Aggregator, Source Qualifier, Lookup, Joiner, Router, Update Strategy etc.
• Worked with various developer modules like profiling, standardization and matching.
• Designed various mappings and mapplets using different transformations such as key generator, match, labeler, case converter, standardize, parser and lookup.
• Incorporated the DQ mapplets into PC Mappings.
• Implemented PC DQ mappings to test the standardized and cleansed new data.
• Populated the data into target tables in an efficient manner.
• Involved in Unit testing and identifying the bottlenecks and tuning to improve the performance.
Used workflow manager to create workflows and sessions
Daman started its business in 2006, currently operated over 12 branches in UAE and Daman is UAE’s
first exclusive health insurance provider. Daman is a public joint-stock company which is 80% owned by
the Abu Dhabi Government with the remaining 20% owned by Munich Re. Munich Re is one of the
world’s leading reinsurers.
Atlas is the core data warehouse of Daman. It combines data from all major operational systems:
MedNext, Oracle Finance, Rule Engine and Documentum, plus custom groupings (CSV)
Atlas has a high business impact as well as visibility throughout the whole company
.
Responsibilities:
• Extensively involved in Data Extraction, Transformation and Loading (ETL) from Source to Target Systems using Informatica Power Center.
• Developed mappings by using Informatica Transformations like Expression, Filter, Aggregator, Source Qualifier, Lookup, Joiner, Router, Update Strategy etc.
• Implemented Slowly Changing Dimensions. Used Type 2 Dimension to keep the history changes.
• Worked with various developer modules like profiling, standardization and matching.
• Designed various mappings and mapplets using different transformations such as key generator, match, labeler, case converter, standardize, parser and lookup.
• Incorporated the DQ mapplets into PC Mappings.
• Implemented PC DQ mappings to test the standardized and cleansed new data.
• Involved in Unit testing and identifying the bottlenecks and tuning to improve the performance.
• Used workflow manager to create workflows and sessions
International, Inc., is an American manufacturer of consumer electronics that specializes in
connectivity devices. It sells various consumer and commercial product. Linksys is a company selling data
networking hardware products mainly to home users and small businesses. It is currently owned by Belkin, who
bought it from Cisco Systems.
Belkin Vendor Drop Shipments Data Ware Housing project is required for the end-to-end management
of Vendor Drop Ship and Consolidate Direct Shipments through 3PLs and load data into VDS DW for building a
BO Universe upon the created VDS tables. The objective of this project is to create VDS Data mart and automate
the process of loading/updating VDS related data sets from various sources (Flat files from Users, Third parties,
Vendors and the Oracle Tables of ERP) using Informatica Mappings.
Responsibilities:
Analyzing the requirements.
Extensively involved in Data Extraction, Transformation and Loading (ETL) from Source to Target systems
QUALIFICATION:
