NAME
youremail@gmail.com
Ph: +91-your phone
number
PROFESSIONAL SUMMARY:
Having 3+ years of technical experience in Analysis, Design, Development,
Testing and Implementation of Client Server Application and Data
warehousing ETL (Extract, Transform and Load) in Informatica Power Center
10.x
Main areas of expertise are Developing and Testing the data warehousing
projects with data quality standards.
Extensive experience in Extraction, Transformation and Loading of data
directly from heterogeneous source systems like flat files, Oracle by using
Informatica power center.
Tuned several mappings for the better performance and involved in
Performance Testing.
Experience on all important General transformations.
Customized SQL override queries where ever possible to minimize the use of
Joiner, Aggregator and Lookup Transformations.
Developed all the mappings according to the design document and mapping
specs provided and performed unit testing.
Experience in Creating SCD Type-1 and Type-2 mapping technique to load
the data into various dimension tables.
Used Parameterization for Mapping, Workflows and sessions.
Error handling & issue analysis during the testing and maintenance.
Hands on dynamic parameter file creation.
Identifying the bottlenecks and implement the Performance tuning &
Optimization techniques in power center.
Experience in creating mapping parameters and variables to load the stage
and Data warehouse incrementally.
Worked on Versioning Concepts on Informatica Powercenter.
Created Mapplet and Re-usable Transformations for applying few logics.
Created UNIX Shell scripts to run the Informatica Workflows & controlling
the ETL flow.
Experience in Creating, Scheduling and configuring workflows, worklets and
sessions using Informatica workflow manager.
Good Knowledge on Data Warehousing concepts like Star Schema,
Dimensions and Fact tables.
Excellent problem-solving skills with strong technical background and good
interpersonal skills.
Work Experience:
Working as a software Engineer for <Company name> Bangalore from Aug
2017 to till date.
Skills/Technologies:
ETL Tools : Informatica Power Center 10.x
Database : Oracle 11g, 12g,SQL Server2008
Operating Systems : Windows XP/ 2000, UNIX
Programming Skills : SQL
Application Utilities : Putty ,Toad,SQL+ and WinScp
Educational Qualification:
M.SC Computers from <your University>, <Location>.
Project Profile:
#Project 1
Project : Sanofi Pharma
Client : Sanofi Inc
Role : ETL Developer
Environment : Windows, SQL, Oracle 10g, Informatica Power Center 10.2
Project Description:
Sanofi is a pharmaceutical company, which provides new and
improved biotech drugs for various diseases and their symptoms. The objective of
the project is to extract data stored in different databases and load into oracle
system which is the staging area and the business logic is applied to transform
the tables in the required way. The data warehouse is fed by marketing data,
sample data, market (competitor) data, prescription data and others.
Responsibilities:
Understanding existing business model and customer requirements.
Understanding the mapping specifications and requirements.
Managing priorities of tasks, scheduling and tracking progress.
Extraction of data from various sources using Informatica.
Designed various mappings for extracting data from various sources
involving flat files and relational tables.
Used Source Analyzer and Warehouse Designer to import the source and
target database schemas, and the mapping designer to map source to the
target.
Used Transformation Developer to create the filters, joiner, update strategy,
lookups and
Aggregation transformations, which are used in mappings.
Created various tasks like sessions, worklets, and workflows in the workflow
manager to test the mapping during development.
To keep track of historical data slowly changing dimensions are
implemented.
Worked with Mapping Variables and Mapping Parameters.
Developed all the mappings according to the design document and mapping
specs provided and performed unit testing.
Developed mapping to load the data in slowly changing dimensions SCD
Type -1 and Type-2
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.
Tuned several mappings for the better performance and involved in
Performance Testing.
Documenting test cases and Informatica mappings
Provide weekly status report to the Project Manager and discuss issues
related to quality and deadlines.
#PROJECT :2
Project : America National
Client : America National
Environment : Informatica 10.x, Oracle 11g, Windows NT,Unix
Role : ETL Developer.
Description:
Amearica National is one of the fastest growing Auto/Property/ Life Insurance
Company. It serves its customers by offering a range of innovative products to
individuals and group customers at more than 600 locations through its company-
owned offices.
The primary objective of this project is to capture different Customers, Policies,
Claims Agents, Products and financial related data from multiple OLTP Systems
and Flat files. Extracted Transformed Loaded data in to data warehouse using
Informatica PowerCenter and generated various reports on a daily, weekly
monthly and yearly basis. These reports give details of the various products of
Allstate Insurance products that are sold.
Responsibilities:
Extracted Data from Oracle data base by using Source Analyzer.
Primarily responsible for designing and developing Extraction,
Transformation and loading process using ETL tool Informatica.
Designed and developed Informatica Mappings and Sessions based on user
requirements and ETL rules to load data from source Flat files to target
tables
Used Various Transform components such as Sorted, Lookup, Joiner and
Aggregator.
Analysis of the specifications provided by the clients.
Developing new mappings for Planning Phase.
Designing mapping for the target tables.
Working on the aggregator for calculating the aggregate values.
Created reusable mapplets/transformations embedding business logic.
Contributed in Unit testing for developed mapping using sample data.
Tuned and monitored in Informatica workflows using Informatica workflow
manager and workflow monitor tools.
Created mappings for Flat file targets.
Created several Workflows for the maintenance of Informatica using Event
Wait for file, Command task, and other sessions in workflow.
Worked closely with the onsite team to understand the business
requirements and applying the business rules to make them up to the DW
Personal Strength:
Quick learning capabilities.
Hard working and Positive thinking.
Active Team Player.
Good Interpersonal & Presentation Skills.
