USM Business Systems Logo

USM Business Systems

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

Reposted One Month 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

36 Seconds Ago
Remote or Hybrid
USA
140K-195K Annually
Senior level
140K-195K Annually
Senior level
Cloud • Computer Vision • Information Technology • Sales • Security • Cybersecurity
Leads CrowdStrike’s Red Team, overseeing penetration testing and adversary emulation engagements, operations, reporting, metrics, vendor relationships, and customer coordination. Manages and mentors team members, supports security program improvements, scopes engagements with Sales, guides crisis response, and communicates findings to executive and technical audiences. The role requires advanced security assessment, networking, operating system, vulnerability testing, automation, scripting, and tool-development expertise, with occasional travel.
Top Skills: Adversary EmulationArtificial IntelligenceAutomationBurp SuiteCobalt StrikeFirewallsLinuxLoad BalancersmacOSMail ServersMetasploitNessusNetworkingNmapPenetration TestingProxiesRoutersScriptingSwitchesUnixVulnerability TestingWeb ServersWindowsWireless Access Points
39 Seconds Ago
Remote or Hybrid
USA
95K-140K Annually
Junior
95K-140K Annually
Junior
Cloud • Computer Vision • Information Technology • Sales • Security • Cybersecurity
Manage 30–40 concurrent cybersecurity platform implementation projects, maintaining schedules, documentation, status reports, risks, dependencies, and delivery standards. Coordinate with customers, technical teams, sales, and stakeholders; manage project queues and provide timely updates. The role requires strong organization, communication, multitasking, problem-solving, cybersecurity awareness, and effective use of AI technologies to improve workflows and outcomes.
Top Skills: Ai TechnologiesCrowdstrikeCybersecurity SolutionsIbm QradarProject Management ToolsSplunk
41 Seconds Ago
Remote or Hybrid
2 Locations
140K-195K Annually
Senior level
140K-195K Annually
Senior level
Cloud • Computer Vision • Information Technology • Sales • Security • Cybersecurity
Leads and grows a team of resident cybersecurity consultants delivering CrowdStrike Falcon platform services. Oversees presales scoping, customer engagements, deployments, project delivery, optimization, support, and customer communications. Partners cross-functionally to improve services, automation, security posture, and time-to-value. Mentors employees, manages customer project portfolios, supports sales initiatives, and translates customer needs into product feedback. Requires substantial security professional services experience, team leadership, technical deployment management, and practical use of AI technologies.
Top Skills: Ai TechnologiesArcsightAWSBashCrowdstrike FalconCrowdstrike Falcon LogscaleExabeam Data LakeGCPLogrhythmAzureNext-Gen SiemPythonQradarSplunk

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