Sahil K.

Sahil K.

Experienced Technical Architect

New Delhi , India

Experience: 20 Years

Sahil

New Delhi , India

Experienced Technical Architect

56051.5 USD / Year

  • Notice Period: Days

20 Years

Now you can Instantly Chat with Sahil!

About Me

Experienced Technical Architect with a demonstrated history of working in the information technology and services industry for more than 15 years. Strong program and project management professional with a Master of Computer Applications focused in Co...

Show More

Portfolio Projects

Description

Worked as data warehousing Architect

Show More Show Less

Description

.worked as datawarehouse consultant

Show More Show Less

Description

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

Show More Show Less

Description

.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.

Show More Show Less

Description

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

Show More Show Less