10+ Years of programming experience in Oracle PL/SQL and Snowflake in Analysis, Design and Implementation of Business Intelligence
Strong experience in Data warehouse concepts. Implemented various ETL strategies for non-oracle systems using ADF (Automated Data Flow) and Basis IICS knowledge.
Experience in leading end to end project implementations and support both offshore and onsite.
Extensive domain knowledge in banking from International Banks and Financial Institutions.
Coordinated with the Bank MIS (Management Information System) team to provide necessary reports and dashboards.
Experience in working with core Banking systems like FINACLE, FLEXCUBE, T24.
Experienced in Agile methodologies.
Hands on experience on DWH , ETL and Snowflake.
Sub Queries and Correlated Sub Queries to retrieve the data from Database.
Performance Tuning, Partitioning, Bulk collect and Bulk Insert.
Implementation of Procedures, Functions at database level.
Developing Stored Procedure, user defined functions, application of cursors and runtime handling of errors using exceptions.
Unit Testing, constraints check validation, DDL Scripts, Procedures.
Hands on experience in analysing the development requirement, Design, Querying, Coding, Testing and Implementation
Snowflake Migration - RISE to be brought to AWS S3 and AWS S3 load SNOWFLAKE DL using Store Procedure copy command.
Snowflake Migration - Some user data to be brought to SNOWFLAKE DL through Upload Tool and AWS S3 (IICS).