Job Description :
ETL tester with AWS(F2F Locals only)/Remote work
6-12 months
Oroville ,CA

Required:
Data Quality Assurance Engineer/ ETL- Data Integration Tester

Position Summary:
Client Data Lake team is in search of a Data geek who will have responsibility for testing the data which is brought in from source applications into the Enterprise Data Lake & then provisioned to research data marts. Working closely with our Data Lake and application teams and assists in the development of testing strategies, automating regression test plans for reusability. This position is great for a Developer with a testing mind set who strives for data accuracy or for someone who has played this role on several projects. ETL tools will be used to perform data integration and all data staged and sourced through to relational data stores.

Key Responsibilities:
Create, document and conduct detailed test plans & test cases for multiple data projects
Create test scripts to validate data primarily using SQL and scripting
Analyze requirements, develop & execute test plans, determine effort estimates and timelines for data testing needs related to new project efforts
Automate test cases by using scripts or advanced tools like Alteryx
Conduct comprehensive source to target data testing, identifying issues with data accuracy, hygiene, and data characteristic logic
Actively monitor and proactively identify data quality issues
Build and enhance existing BI data quality dashboards to report current data quality levels (Preferred JasperReports, AWS Quicksight or similar tools experience desired.
Develop and integrate enhanced monitoring and alerting related to identified KPIs
Understand and test complex database structures using SQL
Run Bug Triage meetings to raise issues with Development teams and raise unresolved issues to leadership

Job Requirements:
Bachelor*s degree or higher in technology related field
3+ years of experience in Oracle or MS SQL
Experience performing work as a virtual resource.

Intermediate to advanced SQL skills
Experience with drafting test cases to check data quality
Clear & Concise communication of bugs / issues in written & verbal
Strict attention to detail must be demonstrated
Solid understanding of data lake, data warehouse, data marts, ETL & BI Concepts
Experience with Agile development