To pursue a long-term career that nurtures my technical knowledge and to provide your esteemed organization with the best of my talent and convert all problems into solutions. An ambitious and motivated professional with good development, and performance engineering skills.
Having around 2.3 years of experience in Snowflake, ETL, Oracle , SQL Server, AWS S3, IICS and DB2. Involved in all phases of STLC / SDLC with timely delivery against aggressive deadlines. Strong experience on ETL/ Snowflake Database Warehouse. Involved with Business Analyst to understand the data integration requirements given by stakeholders. Good knowledge on Data warehouse concepts like Star schema, snow-flake schema, fact table, dimension table. Experience on Oracle database, Snowflake and DB2. Involved in snow pipe creation to integrate the data between the AWS cloud to the snowflake Database. Have done sequences to generate the data sequence number for the primary key serial of data. Performed Clone technique in snowflake database to take the backup of the data whenever needed. Involved creation of the snow stream object to create the audit table data backup of the data whenever the DML is happening on base tables. Hands on experience in writing SQL queries for the transformations logic based on the business requirement. Proficient in SDLC and STLC. Proficient in Windows OS and UNIX.
Analyzed Requirement Specification Document and mapping document to find the test scenarios.
Created UnitTest Plan document and executed on time as per the planning document to avoid risks.
Created SQL Queries as Test scripts to execute the test cases using Group function, Analytical function, Joins and Set operators.
Validated record counts, missing data validation and metadata validation from source and target environment.
Defect list and Test reports will be documented and validated.
Snowflake SQL
IICS
SSIS
JIRA
Oracle SQL developer
AWS
Putty
WINSCP
Informatica
Oracle 19c
SQL Server
DB2
Snowflake
SQL
UNIX
Python
Windows
Linux