Senior ETL Developer/ EBI-Integration Team Lead Resume

SUMMARY

Experience in Data warehousing involving various phases such as Data Extraction, Data Transformation and Data Loading.
Experience in Development of mappings using needed Transformations in Informatica tool
Experience in various scheduling tools such as $Universe, Tivoli Workload Scheduler and Autosys.
Preparing the Documentation for the mappings according to the Business Requirements.
Good Knowledge in Data Warehousing concepts
Good knowledge in Shell Scripting
Optimizing Informatica Mappings and Sessions to improve the performance.
Extensively used Informatica client tools - Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Informatica Repository Manager and Informatica Workflow Manager.
Worked on SSAS, SSRS, BOBJ, Cognos, Tabular cubes as part of EBI support for a shorter period.
Excellent problem-solving skills with strong technical background and good interpersonal skills. Quick learner and excellent team player, ability to meet deadlines and work under pressure
Worked on Conversion of Cognos ETL Jobs to Informatica Jobs as part of Cognos decommission project.
Retail Domain Certified.
Informatica Certified PowerCenter Data Integration 9.x - Developer Specialist
Worked as EBI Team Lead at offshore
Knowledge in IICS - Informatica Intelligent Cloud Services
Learning Azure Data Factory and Data integration to cloud data warehouse.

PROFESSIONAL EXPERIENCE

Confidential

Senior ETL Developer/ EBI-Integration Team Lead

Responsibilities:

Worked on multiple BI Stacks including Informatica, Cognos etc.
Responsible for Data Loading using Informatica Power Center 9.x to load Data from the source system of one application to another
Integrating data between multiple applications by applying suitable transformations based on the requirements
Working with different Source/Target systems such as Message Queues, Flat File, XML, Data Base etc.
Scheduling / Managing the jobs using different schedulers such as Tivoli, Autosys etc.
Transitioned into the role of EBI Application support resource as part of Dev Ops plan.
Provided timely support in reporting area such as SSRS, SSAS, Cognos, BOBJ reports.
Worked in conversion of Cognos ETL Jobs to Informatica workflows as part of cogon decommission.
Worked on Data Center migration and handled EBI related activities
Worked on ODS/DWH Consolidation project
Worked on performance tuning of ETL flows.
Working with the client to gather the requirements
Creating functional and design documents for the new requirements.
Involved in peer code review and unit testing.
Conducted technical knowledge transition with the new joiner and the support team.
Leading the offshore EBI development team

Confidential

ETL Developer

Responsibilities:

Responsible for Data Loading using Informatica Power Center to move Data from XML sources common target area as flat files.
Designed the Mapping Technical Specifications on the basis of Functional Requirements
Worked with Informatica client Tools.
Worked with different mappings by using different Transformations like Aggregator, Expression, Joiner, Router, Sequence generator etc to load the data as part of new change request.
Worked with the scheduling tool $universe Scheduler to monitor and manage the sessions and UPROCS scheduled.
Taken part in Performance tuning of existing code
Involved in unit testing

Confidential

System Engineer

Responsibilities: