UNICOM TECHNOLOGIES INC is hiring: Lead ETL Tester on W2 in Norfolk

Overview

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

Responsibilities

• 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:

Technical 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
• 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.
• 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.

Soft Skills

• a. Good problem-solving skills
• b. Exceptional communication skills (written and verbal)
• c. Good documentation skills
• d. Collaborate