USM Business Systems Logo

USM Business Systems

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

Reposted 16 Days Ago
Be an Early Applicant
In-Office
Downers Grove, IL
Mid level
In-Office
Downers Grove, IL
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

Top Skills

Datastage
ETL
SQL
Unix

Similar Jobs

An Hour Ago
Hybrid
Peoria, IL, USA
113K-183K Annually
Mid level
113K-183K Annually
Mid level
Artificial Intelligence • Cloud • Internet of Things • Software • Cybersecurity • Industrial
Develop and manage digital tools and reporting systems for Condition Monitoring, focusing on user interface design, business analysis, and technical support for customers and internal teams.
Top Skills: MacroPower BIProgrammingTableau
An Hour Ago
Hybrid
Chicago, IL, USA
126K-205K Annually
Senior level
126K-205K Annually
Senior level
Artificial Intelligence • Cloud • Internet of Things • Software • Cybersecurity • Industrial
Lead the development and implementation of UI architecture for web applications, collaborating across teams and managing complex programming tasks.
Top Skills: Aws LambdaGen Ai ToolsGithub CopilotGrafanaPostmanReactReduxRestful ApisSwaggerTypescript
An Hour Ago
Hybrid
Chicago, IL, USA
148K-240K Annually
Senior level
148K-240K Annually
Senior level
Artificial Intelligence • Cloud • Internet of Things • Software • Cybersecurity • Industrial
The Principal Digital Architect will design functional architectures, lead new technology evaluation, and collaborate on CRM solutions across various platforms.
Top Skills: AWSFabricGoogleSalesforce Marketing CloudSnowflake

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