ETL Developer
I am Santhosh from AP, INDIA
Hands on experience with various ETL tools.
3+ years of IT experience in Design, Development, Implementation, Data Warehousing and Data Integration Solutions using Informatica PowerCenter.
Experience in ETL using Informatica PowerCenter.
Have extensively worked in developing ETL program for supporting Data Extraction, transformations and loading using Informatica Power Center
Experience with dimensional modeling using star schema.
Understand the business rules completely based on High Level document specifications and implements the data transformation methodologies.
Experience in developing mappings, workflows and sessions.
Design, Develop and ETL Mappings, Mapplets, Workflows, Worklets using Informatica PowerCenter 9.x / 10.x.
Experience in Informatica Aggregator, Sorter, Router, Filter, Join, Lookup, Union, Sequence Generator & other Transformations.
Experience in loading Various Dimension tables using SCD Type-1 & Type-2.
Work Terms
Used Informatica Power Center 10.2.0 for extraction, transformation and load (ETL) of data in the data warehouse.
Worked on Informatica Power Centre client tools like Source Analyzer, Warehouse designer, Mapping designer, mapplet designer and Transformations Developer.
Used Informatica Power Center Workflow manager to create sessions and workflows.
Developed complex mappings in Informatica to load the data from various sources.
Created various transformations such as Aggregator, Expression, Joiner, Filter, Router, Normalizer, Sequence Generator transformations.
Creating workflows and sessions.
Created mappings that involved implementation of Business Logic to load data in to staging area.
Used Informatica Reusable concepts like Reusable Transformations, Mapplets and Worklets at various levels of development
Experience in loading Various Dimension tables using SCD Type-1 & Type-2.
Experience in Extracting the data using Incremental loading.
Created Connected, Un-Connected & Dynamic lookups (Cache) .
Worked on Indirect File method.
Created Mapping parameters and variables using Informatica Parameterization.
Worked on Different tasks like Email, Command, Event-wait, Assignment tasks.
Deployed informatica code from Dev to Test Environments.
Identified performance issues in existing sources, targets and mappings by analyzing the data flow, evaluating transformations and tuned accordingly for better performance
Tested the mapping to view data got populated according to specified logics in the technical specification document.
Involved in Unit Testing.
Worked on UNIX commands.