Snowflake Tester with Matillion and DBT
Position: Snowflake Tester with Matillion and DBTLocation: Oakland, CA - OnsiteDuration: Long Term projectInterview Virtual InterviewRelocation allowed8+ profiles
We are looking for a skilled Snowflake & Matillion Engineer to join our team.In this role, you’ll leverage your expertise in Snowflake and Matillion to design, optimize, and maintain cloud-based data solutions.If you have experience with data migration, ELT processes, and troubleshooting, we’d love to hear from you!
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 verify modify 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 application project
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"
Job Types: Full-time, Contract
Pay: $60.00 - $70.00 per hour
Schedule:
Monday to Friday
Work Location: In person
