Worked as data warehousing Architect

.worked as datawarehouse consultant

Worked as data analysts for one of the telecom project going on between IBM India and bharti Airtel

.Strong experience in Data Warehousing and ETL using Informatica Power Center 8.6/9.1  Creation of ETL frame work and review of high level design document  Created/Implemented the Architecture for Informatica Power Exchange CDC processes using (Oracle, MySQL, and SQL Server) feeding a queue that would be consumed by Cognos  Architected/Developed Informatica Batch/Real-time(CDC) processes to feed the Informatica MDM (Master Database Management) serving as a single access of customer data between applications  Extensively worked on data extraction, Transformation and loading data from various sources like Oracle, SQL Server and Flat files.  Responsible for ETL process includes data extraction, cleansing, aggregation, reorganization, transformation, calculation, and loading assay data. Responsibilities included data modeling using TOAD to implement star schema data warehouse and data marts for experimental data using Oracle. Created search capabilities to drill up data from the data mart to the data warehouse. Created dynamic pivot for data mart was very efficient since the source data was run in multiple threads to process the data efficiently and made it scalable.  Strong skills in Data Analysis, Data Requirement Analysis and Data Mapping for ETL processes.  Hands on experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.  Had experience in data modeling using Erwin, Star Schema Modeling, and Snowflake modeling, FACT and Dimensions tables, physical and logical modeling.  Experience in database programming in PL/SQL (Stored Procedures, Triggers and Packages), SQL queries, unions and multiple table joins and experience with Views.  Responsible for all activities related to the development, implementation and support of ETL processes for large scale data warehouses using Informatica Power Center.

Architected data warehouse from requirements gathering to conceptualization to creation of data marts.