Lead ETL Tester on W2

Title: Lead ETL Tester - Need on our W2 Only

Location: Chicago, IL (REMOTE)

Duration: 8 Months

Hourly rate: $55/hr on W2

Description:

Lead Software Testing Mandatory Skills 

§ Database: IBM DB2, TOAD DB2, Query IT 

§ ETL: Ab initio (GDE), Ab initio Technical EME, MDH (Meta Data Hub) 

§ BI Tool: Cognos 

§ Defect Tracking: IBM Clear quest, JIRA Regression Testing, Etl Testing, Testing with dimensionally modeled DB, Tdm Optional Skills Experience in Test Automation platforms like Query Surge, iceDQ etc Additional Comments As an ETL Tester, your responsibilities will include but are not limited to 

• Analyze and review business requirements (or user stories) and rules and determine the project scope, effort estimation, timeline and QA strategy. 

• Test and ensure quality delivery of end-to-end business solutions 

• Interprets business requirements and produces information objects to support those requirements. 

• Implements changes consistent with business requirements and establish time schedules. 

• Creates and maintains appropriate documentation - designs and implementation standards. 

• Develop and maintain test plans, manual and automated test scripts for Functional Testing, Black Box Testing. Data Validation - Testing Types System Testing, Integration Testing, Regression Testing for SDLC Models of Waterfall & Agile. 

• Develop Test Strategies. Test cases, SQL Test Scripts and perform Validations for ETL/Data Warehouse/Data Lake and BI Reporting applications (environment). 

• Write effective test cases from requirements and technical spec's' and edit test cases to ensure software functions as designed. 

• Review system use cases and functional specifications with the appropriate business analyst/System Analyst. 

• Conduct test cases peer review and ensure all levels of testing are conducted with adequate coverage. 

• Manage the Software Testing Life Cycle, Release Cycle, identify Quality risks, escalate issues in a timely manner and manage defects to closure. 

• Write and execute SQL queries to verify data from source to target: missing records, referential integrity or time variance. 

• Review relevant project documentation, attend sign-off meetings as needed. 

• Provide strategic direction during the implementation stages. 

• Perform defect tracking and reviews (including demos), verify test results, and document the defects. 

• Work with users to ensure user acceptance testing (UAT) criteria as well as standards have been met. 

• Utilize the following Technical Skill Set: 

§ Database: IBM DB2, TOAD DB2, Query IT 

§ ETL: Ab initio (GDE), Ab initio Technical EME, MDH (Meta Data Hub) 

§ BI Tool: Cognos 

§ Defect Tracking: IBM Clear quest, JIRA 

§ Project Management/Test Management: HP ALM, Rally 

§ Scheduling Tools: Control-M, Control-Center. 

§ Operating System: Unix AIX 

§ Applications: Service Now, MS Excel, MS Word, MS Outlook Requirements: 

• 6 - 8 yrs of ETL Testing experience with dimensionally modeled DB. 

• Experience in testing with IBM DB2, Ab initio (ETL), 

• Experience in Test Automation platforms like Query Surge, iceDQ etc. 

• Ensure adoption of industry best practices Minimum 3 to 4 Years of hands-on experience with the following: 

a. Testing Ab initio code 

b. Ability to perform root cause analysis and fix defects 

c. Create test cases based on test requirements 

d. Execute test cases 

e. Participate in Extract Transform and Load Technical reviews 

f. Strong SQL/QUERY skill is critical 

g. Demonstrated experience interacting with all levels of technical and business stakeholders to ensure requirements are clear and testable. 

h. Develop and maintain test plans, manual and automated test scripts for Functional Testing, Black Box Testing. Data Validation - Testing Types System Testing, Integration Testing, Regression Testing for SDLC Models of Waterfall & Agile. i. Must possess excellent background on Front end and backend testing, testing methodologies and processes in both an Agile and Waterfall development models. 

Required Soft Skills: 

a. Good problem-solving skills 

b. Exceptional communication skills (written and verbal) 

c. Good documentation skills 

d. Collaborate