TEAM LEAD
Cognizant Technology Solutions
Total years of experience :16 years, 11 Months
As per business requirements the data that needs to be provided to end user should be segregated by date
period for clear and easy access to data views. The COAMGR (COLLECTION OPERATION ANALYTICS
MANAGER) data load is driven via Oracle Stored Procedures and ETL jobs which pull data from various
sources of Infoprod and load in to the corresponding tables of Busprod (Target Database).So basic is
to understand the complex STORED PROCEDURES and to convert them in to ETL Mappings using
INFORMATICA.
Role: Associate Project
As a Team member, was responsible for
● Understanding the business rules completely and implementing the data Transformation methodology.
● Documenting all the Business rules and taking care that they were deployed as code at its best.
● Converting all the Corresponding Complex Stored Procedures to ETL Mappings to pull the data from Source
DB and to load in Target DB.
● Extracted, transformed, cleansed, and loaded data from Legacy systems to Oracle and other Targets through
several Maps developed for all OLTP Modules.
● Mappings are tuned to optimize the load performance.
Role:
As a Team member, was responsible for
● Understanding the business rules completely and implementing the data Transformation methodology.
● Documenting all the Business rules and taking care that they were deployed as code at its best.
● Publishing Good Scenarios with best possible solutions.
● Extracted, transformed, cleansed, and loaded data from Legacy systems to Oracle and other Targets through
several Maps developed for all OLTP Modules involved in OSRH.
● Mappings are tuned to optimize the load performance.