SARAVANAN R

ulk loading from the external stage (AWS S3), internal stage to snowflake cloud using the COPY command.

• Loading data into snowflake tables from the internal stage using snowsql.
• Used COPY, LIST, PUT and GET commands for validating the internal stage files.
• Used import and Export from the internal stage (snowflake) from the external stage (AWS S3).
• Writing complex snowsql scripts in snowflake cloud data warehouse to business analysis and reporting.
• Used SNOW PIPE for continuous data ingestion from the S3 bucket.
• Developed snowflake procedures for executing branching and looping
• Created clone objects to maintain zero-copy cloning.
• Performed data quality issue analysis using Snow SQL by building analytical warehouses on Snowflake
• Cloned Production data for code modifications and testing

• Handling the project individually in offshore
• Prepare the test cases and test queries from informatica mapping and compare it with mapping document.
• Worked in executing the test cases in JIRA, executing test scripts in TERADATA and reporting defects to Dev Team
• Hands on experience in TERADATA, ORACLE, SQL SERVER and Informatica workflow, Monitor and Mapping, Salesforce, SAP(Webi), GitLab
• Worked on Validation of DDL, Data, null, Duplicate Check Scenarios.
• Expertise in BTEQ query tools
• Analyzing test results on database impacts, errors or bugs, and usability.
• Develop test cases and prioritize testing activities.
• Worked on Automation in Java framework script to compare data validation in ETL.