Job Title: Manual Testing with Snowflake, Matillion and DBT
Location: Torrance, CA onsite
Job Description:
- Manual Testing in Snowflake Matillion and DBT
- Strong in Snowflake SQL DWH ETL
- Good understanding work experience of Data warehouse kind of project
- Plus, other nice to have Snowflake, Redshift, AWS, Azure etc
- Design and develop UNIX commands as part of the ETL process automate the process of loading pulling the data
- Manage departmental inventory and troubleshoot testing reporting and inventory issues
- Automate the functionality using QTP
- Test the target data in Teradata database
- Used JIRA to track and report on defects
- Generate the report from COGNOS report tool and compare with EDW database
- Execute SQL queries to perform backend database testing and verifymodify user data
- Perform technical testing and analysis using SQL and automate testing tool QTP
- Involve with extraction routines to verify all the required data load into target systems
- Used JIRA for storing maintaining the test repository bug tracking and reporting
- Execute the test scripts against Teradata source and validate the rules according to mapping documentation
- Work in multiple source data extraction and data transition from existing production system to test environment
- Participate in documenting defects resolve defects and coordinate with UAT team to get signoff for the applicationproject
- Impart and organize training to newcomers in the team regarding different technologies like SQL PLSQL and different processes
- Involve in developing selenium automation framework using TestNG”
From:
Sona Chhabra,
SMART IT FRAME
sona@smartitframe.com
Reply to: sona@smartitframe.com