ETL- The responsibilities include understanding the requirements, design, and development, and implementing the solution.- Development of Ab Initio graphs (as per the business requirement).- Worked on Data profiler component, to creating profiling report for business.- Worked on Multifile system components such as partition by key and sort, partition by round robin etc.- Created a customized Mapping with several Transformations such as Expression, Filter, Sort, Reformat, Joins, Rollup and Look up - Involved in fixing Data Lineage issues- Monitored and resolved the issues encountered during ETL jobs- Preparation of Unit test cases and documents. - Worked on creating plans and psets.- Create packages and tags to migrate code to higher environment.- Creation and execution of Autosys jobs in DEV/SIT/UAT/PROD environmentScripting- Developed script for archival and cleanup process of daily input files- Created a script to scan through the objects in lookup file and provide the count of the objects BRE- Developed business transformation using Business Rule Environment(BRE)- Developed complicated business transformation rule sets - Developed workflow and mapping for different scenarios in Ab Initio- Tested and resolved various cases in case of errors by performing Unit Testing for workflows

ROLE/RESPONSIBILITIESETL is done using Ab Initio and reporting using tools like Rational tool manager. Databases used are DB2.Developed mappings, workflows in Ab Initio.Developed business transformation by using Business Rule Environment(BRE)Responsible for the Designing ETL strategy, Bulk loads and Normal loads.Created an customized Mappings with several Transformations such as Expression, Filter, Sorter, Normalizer, Reformat, Joins, Rollup, Look up Created Workflows and linked the Mappings and tested with various errors and resolved them.Performed Unit testing for workflows.Contribution as Ab INITIO & BRE DeveloperDesigned ETL workflows, Mappings and Data modeling.Developed complicated business transformation rulesets. Worked and troubleshoot many Workflows.Monitored and resolved the issues encountered during ETL jobs.