IdentityI am Having 9+ years of IT experience in Data Integration, Data warehousing as an ETL developer such as Extraction, Cleaning, Transformation and Loading using Informatica Powercenter and Informatica cloud data integration in Finance, Retail & Healthcare Domain.
Had experience in data modeling like Star Schema Modeling, and Snowflake modeling, FACT and Dimensions tables, physical and logical modeling.
Basic knowledge on High Level Design and Data Modelling concepts.
Good experience on Implementation and supporting the enhanced Business Information.
Involved in building a small Independent DataMart and developed Logical and Physical Data Model.
Worked with different data sources, non-relational Databases such as Flat files, and other relational sources such as Oracle, SQL Server.
Hands on experience in Oracle 11g and Informatica.
Hands on experience in writing and executing SQL queries.
Experience in database programming in PL/SQL (Stored Procedures, Triggers and Packages).
Strong Exposure in Data Warehouse concepts like star schema &Snow-flake schema.
Strong exposure in ETL process and Data warehouse lifecycle.
Experience in Performance Tuning and Debugging of mappings and sessions. Involved in designed the mapping with multiple files loading using file repository.
Extensive experience in Extraction, Transformation and Loading of data using Informatica from heterogeneous sources.
Designed various Mappings for extracting data from various sources involving relational tables and flat files.
Ability to work as a part of a team or individually & ability to pick up new skills quickly.
Extensively worked with informatica cloud (IICS) and informatica PowerCenter.
Worked on Data synchronization task, Data Replication, mapping, Mapping configuration tasks in data integration.
Experience in the full-cycle software development including requirements gathering, prototyping, and proof of concept, design, documentation, implementation, testing, and maintenance.
Good Understanding of Dimensional Modelling, Star and Snowflake Schemas.
Created Informatica mappings to load data using transformations like source qualifier, sorter, aggregator, expression, joiner, connected and unconnected lookup, filters, sequence generator, router and Update strategy.
Experienced in doing the process of extraction, transformation and loading data from multiple sources like flat files and OLTP systems into data marts using Informatica Power Centre.
Basic Hands-on Experience in Informatica BDM & Hadoop.
Good knowledge of Redshift and Hive.
Professional Skills:
Languages: Teradata SQL, Unix (Shell Script).
Tools: Teradata SQL Assistant, BTEQ, Fast Load, Multiload, Putty, PL/SQL developer.
ETL: Informatica PowerCenter V10.4, Informatica BDM.
Database: HIVE, Oracle 11g/12c, Redshift.
