Rohit Nath Kapila

4+ years of prominent experience as an ETL Developer in Analysis, Design, Development, and Implementation of Client Server Application and Data warehousing ETL (Extract, Transform and Load) in Informatica Power Center 9.x/10.x

1. Health Insurance Exchange

Client: Anthem

Anthem, Inc., is a provider of health insurance in the United States.

Role : Informatica Developer

Responsibilities:

• Interaction with the Customer business user to understand business requirements and understanding their existing business model and their customer requirements.
• Understanding the mapping specifications and requirements.
• Used Source Analyzer and Warehouse Designer to import the source and target database schemas, and the mapping designer to map source to the target.
• Designed various mappings for extracting data from various sources involving flat files and relational tables. Development of the Informatica mappings to load the data from files/oracle to target Oracle database.
• Created Mappings using various transformations like Filter, Router, Sorter, Joiner, Aggregator, Expression, Update Strategy, Lookup and Union.
• Developed mapping to load the data in slowly changing dimensions SCD Type -1 and Type-2.
• Documented & Performed Unit testing and Integration testing of Informatica mappings.
• Implemented various Performance Tuning techniques.

2. Sales Analysis System

Client: Best Buy Inc., USA

Best Buy Inc. is the largest electronic retailer in USA for consumer electronics, home office equipment, Entertainment software and applications.

Role : Informatica Developer

Responsibilities:

• Extraction of Data from Oracle data base by using Source Analyzer.
• Used Various Transform components such as Filter, Router, Sorter, Expression, Aggregator, Union, Sequence Generator, Lookup and Joiner.
• Have created ETL mapping, sessions and workflows as per the requirement.
• Working on the aggregator for calculating the aggregate values.
• Performance tuning of the Informatica mappings using various components like Parameter files,Variables and Dynamic Cache.
• Running the Jobs/Workflow for ETL process.
• Verifying the data in target database after ETL process.
• Verified column mapping between source and target tables.
• Ability to interface and communicate effectively with team members and provide the guidance in the development activity.
• Worked closely with the onsite team to understand the business requirements and applying the business rules to make them up to the DW.

Environment : Informatica PowerCenter 9.4, Oracle 11g and Informatica Scheduler.

• Data Warehousing Tools : INFORMATICA POWER CENTER 9.x/10.x
• Languages : SQL
• Scheduling Tools : Informatica Scheduler
• Operating Systems : Windows 10/11, Unix
• RDBMS : Oracle10g/11g/12c
• Third Party Tools : WinSCP & PUTTY

• Successfully completed and received certificate in "Financial Markets" module with an aggregate of 73% from National Stock Exchange.
• Enthusiastic, Knowledge-hungry learner, ready to meet challenges.
• Able to work together with other employees and individuals to solve and define the developmental problems.
• Strong counseling & convincing skills. Relationship-builder with unsurpassed interpersonal skills. Self-Motivated and Determined.
• Fluent English, Communication skills certification from VETA.
• Received " Performer of the Month " Certificate and Client appreciation during my service at Tech Mahindra.
• Received " ACE " Award for the year 2020-21 as a Consistent Performer at Tech Mahindra.

• Full Name : Rohit Nath Kapila
• Date of Birth : 02 March 1994
• Gender : Male
• Notice Period : Immediate Joiner