ETL Testing, SQL

Job Description

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 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 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.,

Keyskills :
testcasecreation testplancreation qatesting sqlqueries webtesting dataquality testingtools testanalysis testscenarios qualityassurance defectmanagement functionaltesting etframework