ETL QA

The key job responsibilities include the following:

• Responsible for planning, developing and coordinating testing activities including

Test Plan creation, Test Case creation, debugging, execution, test analysis.

• Responsible for the execution of test scenarios in support of the test team.
• Familiarize themselves with the business functionality and technology used for

assigned applications (under test).

• Utilize ESG QA testing tools, methodologies, and processes.
• Work closely with on-site team towards successful test phases.
• Encourage collaborative efforts and camaraderie with other Release Stream

team areas.

• Ensure the quality and low bug rates of code released into production.
• Responsible for successful execution and alerting team leads and managers of

obstacles, issues and risks.

• Able discuss status of all open issues facing the test team and describes actions

taken to mitigate such issues

• Responsible for coordinating/engaging build movements to the QA environment

as directed by Team Lead.

The key skills required

Test and QA Skills:

• Demonstrates a working understanding of planning, developing and coordinating

testing activities including Test Plan creation, Test Case creation, debugging,

execution, test analysis.

• Demonstarte an understanding on the estimation techaniques and QA plan
• Demonstrates analytical skills in assessing user, functional and technical requirements
• Demonstrates a working understanding of functional testing techniques and

strategies.

• Demonstrates a strong understanding of web testing techniques and web testing

strategies.

• Demonstrates a working understanding of Cloud(Azure) based services
• Demonstrates a working understanding of test analysis and design.
• Demonstrates a working understanding of analyzing test results and the creation

of appropriate test metrics.

• Demonstrates a working understanding of the defect management process.
• Demonstrates a working understanding of quality assurance and/or software

development processes and methodologies, with the ability to share that

knowledge with peers, and project team members

• Identifies ways of working smarter”, through elimination of unnecessary steps

or duplication

Tools/Technology Skills:

• Demonstrates an understanding and working experience on SQL databases and ETL testing. Should be able to write queries to validate the table mappings and structures
• Should be able to perform schema validations
• Good understanding of SCD types
• Strong knowledge of database methodology
• In-depth understanding of Data Warehousing/Business intelligence concepts
• Working experience on cloud(Azure) based services
• Working experience in testing BI reports
• Should be able to write queries to validate the data quality during migration projects
• Demonstrates an understanding of any of the peripheral technologies utilized in SDC, including Peoplesoft, SAP and Aderant.
• Demonstrates a working understanding of tools like UFT and TFS
• Experience with Microsoft tools is highly desired
• Understands enterprise wide networks and software implementations.
• Must have previous experience in creating complex SQL queries for data validation.
• Must have testing experience in Enterprise Data Warehouse (EDW)

Project Skills:

• Strong communication skills regarding technical topics and remote collaboration

skills are critical to this role.

• Demonstrates an ability to provide accurate project estimates and timelines.
• Demonstrates an ability to deliver on project commitments.
• Produces work that consistently meets quality standards.

Leadership Skills:

• Demonstrates the ability to operate as the primary resource on a project
• Demonstrates the ability to work with peers on project assignments.
• Demonstrates a working ability to foster a cooperative environment with the

entire project team. This resource is viewed as a “team player”, who understands

the culture and how to be effective in it.