Now you can Instantly Chat with Sahil!
Professional Experience in all phases of the Software Development Life Cycle, including requirements gathering, Impact analysis, solution design, integration, testing and production rollouts with decent knowledge on maintenance and support of Ente...Show More
Data & Analytics
Networking & Security
.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
ToolsCognos Informatica Oracle Database