Hi
This is regarding to a position of an ETL QA
Title: ETL QA
Location: Austin, TX (2 days onsite)
Client is Texas State - ERS Department
Must be in Austin and should be a Texas state resident ( 2 days hybrid )
candidate must be strong in SQL and MSSQL ( 7+ years exp ) 10-15 mins internal round and Then client round Interview.
PURPOSE
The Quality Assurance (QA) will help develop and implement appropriate functional, regression test plans for Extract, Transform, Load (ETL) and Data migration projects. In addition, this position will utilize appropriate test tools, process and practices as defined by the Director of QA and the QA Lead for functional, systems-integration, performance testing, as well as building in quality standards throughout the SDLC to avoid defects and minimize rework and waste.
ESSENTIAL DUTIES, RESPONSIBILITIES & OUTCOMES
· Develop and implement appropriate functional, regression, volume test plans for Extract, Transform and Load (ETL) and Data migration projects
· Participate in sprint planning, user story grooming, defining acceptance criteria’s, design walkthroughs so QA can inject quality early in the development life cycle
· Closely collaborate with other scrum team members (Product owners, Systems Analysts, Developers) to ensure business and technical requirements are fully understood
· Ensure that business requirements are fully met before each release; certify releases for quality and completeness of functionality
· Assist in triaging, debugging, and resolving complex ETL and data migration defects by applying critical thinking and problem solving skills
· Able to load data using given API Payloads and validate Data Completeness, Accuracy and duplicate data in Test Environments
· Proactively understand business reporting requirements, write test plans to identify any data related defectss
WHAT WE EXPECT FROM YOU:
· Bachelor’s Degree, Computer Science, Engineering or related preferred
· 7+years of hands-on experience testing Extract, Transform and Load (ETL) Process, writing complex SQL queries, data migration and backend database validations
· 3+ years of Quality Assurance/engineering testing experience in a web application environment Testing User Interfaces, backend databases, Batch/ETL application components
· 1+ years of experience working with complex JSON files, JSON arrays, Jsonb operators, JSON functions and Object Relational databases
· Prior experience comparing data in multiple tables, datasets, data sources
· Prior experience testing business intelligence reports such as Tableau, QuickSight, Power BI or similar reporting tools
KNOWLEDGE OF
· Understanding of the industry, specific Client’s business model, and unique characteristics of the Company.
· Detailed understanding of Quality Assurance tools, practices and success measures.
· Agile development methodologies.
· Common business practices and software product design and development.
· Building collaborative relationships.
SKILLS AND ABILITIES IN
· Verbal and written communication skills
· Problem-solving
· Relationship building both within the organization and with external sources
· Presentation and facilitation skills
· Analytical and Critical thinking
· Deductive and inductive reasoning
· Technical Expertise
Job Type: Contract
Pay: $50.00 - $51.00 per hour
Schedule:
Work Location: In person