Amit Verma

• Having around 3.6 years’ experience in design and development of Extraction Transformation Loading (ETL) methodology for supporting data transformations and processing in a corporate wide ETL Solutions using Informatica Power Center.
• Apart from that I have worked as a Sr. Process Associate Executive for first 4 years in my early days.
• Experience in Informatica PowerCenter 10.x for extraction, transformation and load (ETL) of data in the data warehouse.
• Experience in extraction, transformation and loading of data directly from different source systems like Oracle, flat files
  Experience in designing and developing complex mappings using various transformations like Unconnected and connected lookups, Router, Filter, Expression, Aggregator, Joiner, Sorter, Union, and Update Strategy.
• Experience in developing mappings using designer, creating tasks, workflows using workflow Manager, monitoring the session execution using workflow monitor.
• Experience in Created Mapplets and Re-Usable Sessions.
  Experience in Implementation of SCD Type-1 and Type-2 to load the data into various dimension tables
• .Extensively worked on Mapping Variables, Mapping Parameters.
  Determine source, target or mappings bottle necks for slow mappings and optimized the mappings using Informatica performance tuning techniques.
• Experience in Informatica mapping specification documentation, tuning mappings to increase performance.
• Intermediate communication skills, self-motivated, Keen learner, positive attitude and team player.
• Involved in knowledge sharing and knowledge transfer to the new members of the project & Preparation of knowledge transfer documents

• Certified Informatica Power Center Software from Raj Informatica Bangalore, Karnataka
• Oracle 10g Certified from CMC ltd Noida, Uttar Pradesh

Project#2 Client : Takeda Pharmaceutical Company, Japan

Technologies:

Project#1

Project Name : HAE DW

Client : Hyundai AutoEver America

Duration : Oct 2021- till date

Environment : Informatica 10.x, Oracle 11g, Windows 10

Roles and Responsibility:

• Worked on Power Center client tools like Source Analyzer, Mapping Designer, Mapplet Designer and Transformations Developer.
• 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.
• Extraction of data from various sources using Informatica.
• 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.
• Used Transformation Developer to create the filters, joiner, update strategy, lookups and
• Aggregation transformations, which are used in mappings.
• Created various tasks like sessions and workflows in the workflow manager during development.
• To keep track of historical data slowly changing dimensions are implemented.
• Developed mapping to load the data in slowly changing dimensions SCD Type -1 and Type-2.
• Created Connected, Un-Connected & Dynamic lookups (Cache)
• Identified performance issues in existing sources, targets and mappings by analyzing the data flow, evaluating transformations and tuned accordingly for better performance
• Created and Monitored Batches and Sessions using Informatica Power Centre.
• Developed all the mappings according to the design document and mapping specs provided and performed unit testing.
• Checked the output according to the specifications.
• Configured and ran the Debugger from within the Mapping Designer to troubleshoot the mapping before the normal run of the workflow.
• Prepared documentation for business data flow from source to target and also for the changes made to the mappings/sessions existing to eliminate the errors.

Project Name : Takeda DW

Duration : Apr 2019– Sep-2021 Environment : Informatica 9.6.1, Oracle 11g

• Created ETL mappings using Informatica Power Center to move Data from multiple sources like Flat files, Oracle into a common target area such as Staging, Data Warehouse and Data Marts.
• Extracted Data from Oracle data base by using Source Analyzer..
• Used Various Transform components such as Filter, router, Sorter, Expression, Aggregator, Union, Seq Gen, 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 Variables and Dynamic Cache.
• Created the Staging Area and loading raw data to cleanse it over there.
• Running the Jobs/Workflow for ETL process.
• Verify the both runs and records on daily basis.
• Verifying the data in target database after ETL process.
• Performed column data mapping between source & target database.
• Prepared SQL Queries
• 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
• Involved in performance tuning by optimizing the sources, targets, mappings and sessions.
• Used SQL tools to run SQL queries and validate the data loaded into the target tables