PROFESSIONAL SUMMARY:

• Young, energetic and result oriented professional with over 13 years of experience as a Senior ETL Developer in Medicaid Data warehouse, Investment Banking, ERP and Product Development domains.
• Have extensive experience in ETL tools - Oracle warehouse Builder 11.2.0.4 (OWB), Informatica 8.6x - 9.6x, Oracle Data Integrator 12.1.0 (ODI), SSIS - Oracle & Sql server Database, Sql/Pl Sql & T-Sql.
• Designed the ETL Architectural using layered approach which simplifies the data load process in Medicaid Data Warehouse (MDW).
• Good understanding and experience in Data warehouse concepts and principles, Star schema, Snowflake schema, SCD 1-2-3, Surrogate keys, Normalization/Denormalization.
• Designed the strategy for Error Handling and Recovery, Change Data Capture (CDC ) and Data Lineage.
• Good exposure in all phases of ETL life cycle including Planning, Analysis, Design, Development, Implementation and Maintenance (Archive policies) for ETL Data warehouse and Data Marts.
• Designed and implemented Buffer pool cache (KEEP pool can cache objects for super-fast access at RAM speeds) utility to improve performance Intraday & Rollover Batch process.
• Experience in reading the query with explain plan, Tuning & optimized the code for better Performance using various type of ORACLE HINTS, query rewrite, using cache persistent lookup approach in Informatica maps.
• Extensively used all standard tools in ETL such as Topology Manager, Repository Manager, Mapping Designer, Operator, Work Flow Manager, Work Flow Monitor, Source Analyzer, Transformation Developer, Mapplet Designer, Task Developer, Worklet Designer, Task View, Re-usable Transformations, Shortcuts, Performance Tuning and ETL Best Practices.
• Good conceptual knowledge and experience in creating ODI scenarios and scheduled using agents at regular intervals. ODI jobs monitoring, debugging any failed jobs and production support using ODI’s Operator.
• Strong Knowledge in using various ODI knowledge modules and customizing knowledge modules.
• Expertise in writing complex SQL queries using oracle analytic functions, database packages, stored procedures, functions, triggers, synonyms, cursors, exception handlers, dynamic cursor programs, native dynamic SQL and data collections using advanced Sql and PL/SQL with 12c inbuilt functions.
• Have in-depth knowledge of Oracle architecture, data loading tools like external table, UTL FILE, SQL loader and various other oracle features like exchange partition, table partitioning, interval partitioning, table redefinition, data compression, Archive policy, Materialized views etc.
• Good experience in Data Analysis, Data Profiling, Data Management, Troubleshooting and Performance tuning in various level of ETL Process.
• Performed Data modeling of Data Warehouse and ER Relationship models with data modelers.
• Implemented various Fact and Dimension Tables Conceptual, Logical and Physical Data Modeling using ERWIN and ETL development standards and procedures.
• Involved in the Requirements Gathering with business teams positioned across multiple countries, Analysis, Design, Development and involvement in Unit testing, System testing, UAT & regression testing of SDLC life cycle.
• Scheduled multiple brain storming sessions with DBAs and production support team to discuss long running ETL jobs by providing them the bad plan for those maps and identify the root cause.
• Worked on many migration projects .
• Developed short-term projects using the Agile Methodology using spring using scrum type open office concept.
• Coordinated with QA team in design and execution of Unit Tests. Using JIRA for tracking defects during SIT & UAT so that trend of defect can be tracked.

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• Have extensive experience in ETL tools - Oracle warehouse Builder 11.2.0.4 (OWB), Informatica 8.6x - 9.6x, Oracle Data Integrator 12.1.0 (ODI), SSIS - Oracle & Sql server Database, Sql/Pl Sql & T-Sql.
• Designed the ETL Architectural using layered approach which simplifies the data load process in Medicaid Data Warehouse (MDW).
• Good understanding and experience in Data warehouse concepts and principles, Star schema, Snowflake schema, SCD 1-2-3, Surrogate keys, Normalization/Denormalization.
• Designed the strategy for Error Handling and Recovery, Change Data Capture (CDC ) and Data Lineage.
• Good exposure in all phases of ETL life cycle including Planning, Analysis, Design, Development, Implementation and Maintenance (Archive policies) for ETL Data warehouse and Data Marts.
• Designed and implemented Buffer pool cache (KEEP pool can cache objects for super-fast access at RAM speeds) utility to improve performance Intraday & Rollover Batch process.
• Experience in reading the query with explain plan, Tuning & optimized the code for better Performance using various type of ORACLE HINTS, query rewrite, using cache persistent lookup approach in Informatica maps.
• Extensively used all standard tools in ETL such as Topology Manager, Repository Manager, Mapping Designer, Operator, Work Flow Manager, Work Flow Monitor, Source Analyzer, Transformation Developer, Mapplet Designer, Task Developer, Worklet Designer, Task View, Re-usable Transformations, Shortcuts, Performance Tuning and ETL Best Practices.
• Good conceptual knowledge and experience in creating ODI scenarios and scheduled using agents at regular intervals. ODI jobs monitoring, debugging any failed jobs and production support using ODI’s Operator.
• Strong Knowledge in using various ODI knowledge modules and customizing knowledge modules.
• Expertise in writing complex SQL queries using oracle analytic functions, database packages, stored procedures, functions, triggers, synonyms, cursors, exception handlers, dynamic cursor programs, native dynamic SQL and data collections using advanced Sql and PL/SQL with 12c inbuilt functions.
• Have in-depth knowledge of Oracle architecture, data loading tools like external table, UTL FILE, SQL loader and various other oracle features like exchange partition, table partitioning, interval partitioning, table redefinition, data compression, Archive policy, Materialized views etc.
• Good experience in Data Analysis, Data Profiling, Data Management, Troubleshooting and Performance tuning in various level of ETL Process.
• Performed Data modeling of Data Warehouse and ER Relationship models with data modelers.
• Implemented various Fact and Dimension Tables Conceptual, Logical and Physical Data Modeling using ERWIN and ETL development standards and procedures.
• Involved in the Requirements Gathering with business teams positioned across multiple countries, Analysis, Design, Development and involvement in Unit testing, System testing, UAT & regression testing of SDLC life cycle.