USM Business Systems Logo

USM Business Systems

ETL / SQL QA (Datastage preferred but not required/just ETL skills)----------Need GC and USC

Reposted 2 Months Ago
In-Office
Downers Grove, IL, USA
Mid level
In-Office
Downers Grove, IL, USA
Mid level
The Quality Assurance Analyst II develops and executes test plans and test cases, ensures software quality, and manages defects in a regulated environment.
The summary above was generated by AI
Company Description

Businesses face challenges every day building responsive and agile IT capabilities to grow and stay ahead. Since everyone has access to the same tools, your competitive advantage directly depends on how you apply technology – on the people leading, supporting and optimizing your IT initiatives. USM Business Systems, established in 1999, is an industry-leading private talent management firm, specializing in providing unique IT turnkey solutions, IT staffing solutions, and Talent management insights, enabling you to sustain a truly competitive advantage in this fast-moving environment. USM has offices throughout the US and offshore delivery centers in India. USM is a certified Minority Business Enterprise and is a CMMi Level 3 Organization.

USM is recognized as one of the fastest growing IT Temporary Staffing firms in the US and most recently was ranked #3 on the list of the Top Temporary Staffing firms in the DC Metro Area – Washington Business Journal (2016).

Job Description

ETL / SQL QA (Datastage preferred but not required/just ETL skills)

Location: Downers Grove, IL

Duration: 6 month increments – ongoing – up to 3 years

Need GC and USC

MUST HAVE SKILLS:

GENERAL JOB DETAIL

Position Overview:

The position of a Quality Assurance Analyst II is responsible for developing test plans, developing and executing formal test cases to ensure the delivery of quality software application. Design, write and edit test cases to ensure software functions as designed. Review system use cases and functional specifications with the appropriate business analyst. Conduct test cases peer review. Ensure all levels of testing are conducted with adequate coverage. Identify potential problems, omissions and open issues, attend walkthroughs and signoff meetings. Manage the release cycle, identify Quality risks, escalate issues in a timely manner and manage defects to closure.

Position Scope:

Scope:

Must participate in and possess experience performing the following tasks.

• Requirements Analysis and Decomposition

• Prioritization of Test-related Tasks

• Test Design and Test Plan Development

• Writing and Executing Test Cases

• Test Data Acquisition

• Manual Test Execution

• Data Validation

• Defect Tracking (Logging and Reporting)

• Test Status & Metrics Reporting

Job Complexity:

A highly regulated environment with complex technical environments that may require flexibility working during the downtime, reprioritizing due to delayed builds, etc.

Interaction:

Must be able to efficiently interact with the client and project team, and with the internal QA team members.

Supervision:

• This role does not require supervisory activities.

Required Skills:

Technical Skills:

• Functional testing of web applications

• Ability to create and execute complex SQL queries for database testing (e.g. joins, conditional select statements)

• Test management/defect tracking tools and processes

• Environment – Unix

QA & Testing Skills:

• Testing Methods

o Functional Testing

o Black Box Testing

o Data Validation

• Testing Types

o System Testing

o Integration Testing

o Regression Testing

• SDLC Models

o Waterfall

Other Skills:

• Good communication skills and a positive attitude are required to work in a fast-paced environment with changing priorities.

• Excellent decision maker

• Self-directed; self-sufficient

• Strong time management ability

• Excellent analytical skills

Additional Information

If you are interested in the below position please forward your profile to preethib@usmsystems(dot)com or call me on 703 468 0398

Similar Jobs

4 Minutes Ago
Easy Apply
Hybrid
Chicago, IL, USA
Easy Apply
21-23 Hourly
Mid level
21-23 Hourly
Mid level
Fintech • Information Technology • Machine Learning • Software • Analytics • Financial Services
Mentor and coach outbound collections representatives, monitor performance and quality metrics, review customer and error reports, identify trends, recommend improvements, support engagement initiatives, and assist with projects. The role requires contact center and lending or loan operations experience, leadership, problem-solving, and data-informed decision-making skills.
9 Minutes Ago
In-Office or Remote
2 Locations
124K-207K Annually
Senior level
124K-207K Annually
Senior level
Artificial Intelligence • Healthtech • Machine Learning • Natural Language Processing • Biotech • Pharmaceutical
Leads chargeback, pricing, and gross-to-net analytics for Pfizer’s U.S. hospital injectable and biosimilar portfolio. The role models contracting, rebate, government pricing, and commercial impacts on revenue, margins, and profitability; supports forecasting, accruals, reconciliations, and financial reporting; manages pricing data repositories; and advances automation, dashboards, and AI-enabled analytics. Partners extensively with Commercial, Finance, Controllership, Government Pricing, and Accounting while ensuring compliance with accounting and pricing governance requirements.
Top Skills: Ai-Enabled AnalyticsErpFlexExcelModel NOraclePower BIRevitasSAPTableau
9 Minutes Ago
In-Office or Remote
2 Locations
147K-272K Annually
Senior level
147K-272K Annually
Senior level
Artificial Intelligence • Healthtech • Machine Learning • Natural Language Processing • Biotech • Pharmaceutical
Leads learning measurement and impact strategy across Pfizer’s commercial learning portfolio. Defines evaluation standards, metrics, and success measures; oversees behavior- and business-level studies; validates relationships between learning, competency, and business outcomes; presents evidence and recommendations to senior leaders; and builds the organization’s measurement practice and analytical capabilities.
Top Skills: Learning PlatformsStatistical ModelsTesting Methodologies

What you need to know about the Chicago Tech Scene

With vibrant neighborhoods, great food and more affordable housing than either coast, Chicago might be the most liveable major tech hub. It is the birthplace of modern commodities and futures trading, a national hub for logistics and commerce, and home to the American Medical Association and the American Bar Association. This diverse blend of industry influences has helped Chicago emerge as a major player in verticals like fintech, biotechnology, legal tech, e-commerce and logistics technology. It’s also a major hiring center for tech companies on both coasts.

Key Facts About Chicago Tech

  • Number of Tech Workers: 245,800; 5.2% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: McDonald’s, John Deere, Boeing, Morningstar
  • Key Industries: Artificial intelligence, biotechnology, fintech, software, logistics technology
  • Funding Landscape: $2.5 billion in venture capital funding in 2024 (Pitchbook)
  • Notable Investors: Pritzker Group Venture Capital, Arch Venture Partners, MATH Venture Partners, Jump Capital, Hyde Park Venture Partners
  • Research Centers and Universities: Northwestern University, University of Chicago, University of Illinois Urbana-Champaign, Illinois Institute of Technology, Argonne National Laboratory, Fermi National Accelerator Laboratory

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account