1. Choose your Affinity Group

* Equal Opportunity / Affirmative Action

We serve Equal Opportunity Employers and are an Equal Opportunity Employer. The Professional Diversity Network has separate professional networking sites for different affinities, and in selecting the groups you identify with, you will be joined with those networks.

Note: Providing this information is strictly voluntary - you will not be penalized or subjected to adverse treatment. If you choose not to provide this information, simply select "Choose not to identify."

2. Choose Method
Sign in with LinkedIn
Sign in with Facebook

Tell us about yourself

ETL Development and Testing
at Ascendum Solutions
Cincinnati, OH

ETL Development and Testing
at Ascendum Solutions
Cincinnati, OH

Save or bookmark jobs as you go and access them anytime later with your account.



Job Description

The tester supports quality assurance programs and processes in alignment with QA strategy.  

The tester is responsible for providing feedback on artifacts developed during requirements and analysis phase within client projects; authoring test cases; and performing test execution for both project and support related activities. The tester will be predominately performing manual testing in the first few months but will heavily participate in establishing our test automation approach and automation testing thereafter.

Position/Project Specific Requirements:

  • 5+ years of relevant experience in software quality assurance
  • 3+ years SQL utilizing complex queries and writing stored procedures
  • 2+ years testing data/data transformation/data movement (ETL)
  • Firm understanding of data architecture and ETL workflows
  • 1+ years of experience with Netezza and AMPP
  • 1+ years of using Informatica IDQ or other tools to automate ETL tests
  • 1+ years of Agile methodology experience
  • 2+ years of using Quality Center/ALM for test case management
  • 1+ years of using Jira for defect tracking


Position/Project Specific Preferences/Desires:

  • Prefer ETL experience to be on most recent project
  • Prefer Informatica IDQ experience to be on most recent project
  • Prefer Netezza/AMPP experience to be on most recent project
  • Prefer Agile methodology being utilized in the current/most recent project Prefer experience in the SAFe Agile approach


Essential Job Functions:

  • Work within an Agile methodology
  • Validate data from the data sources through each step of the extract and transformation process including final load in the data warehouse
  • Develop and review test plans and test scripts
  • Automate test efforts using Kroger ETL automation tools
  • Conduct some manual or automated web service testing when needs arise
  • Ensure accurate data and reporting, in terms of content and infrastructure by researching and identifying source of errors
  • Understand the data model and ETL flow. 
  • Write SQL scripts to extract data from various databases and systems and compare against data warehouse
  • Perform root cause and trend analysis to identify recurring patterns of errors
  • Ensure data standards/integrity are maintained in order to deliver the highest quality products
  • Participate in SAFe Agile ceremonies (PI Planning, Sprint Planning, Scrum, Retrospectives, Showcases, etc).
  • Document defects and evaluate priority of defect based on overall application functionality
  • Coordinate test script reviews with stakeholders as appropriate.
  • Adhere to requirement review, defect writing & test script writing guidelines
  • Keep QA Lead/Coach and management informed of current state of quality
  • Ensure completion of all deliverables within schedule, budget and quality constraints.
  • Participate in Root Cause Analysis sessions
  • Ensure that projects follow prescribed software development life cycle standards.
  • Develop and maintain good relationships with project team.
  • Multi-task to meet assignment deadlines
  • Accurately estimate work assignments
  • Show assertiveness
  • Have obtained a bachelor’s degree in Information Systems or have related and equivalent work experience
  • Identify obstacles and roadblocks; and offer suggestions to work around obstacles
  • Help drive and improve QA process within the team you are assigned


Company Description

About Ascendum:

We are a global IT services company leveraging technology to solve business problems. Our clients include small, medium, and large firms with small, medium, and large problems. Ascendum's approach is built on the success of using the right combination of strategy, people, processes, technology, and infrastructure for each client situation, to meet specific business needs/challenges and deliver expected results.

High levels of technical expertise, commitment to exceeding customer expectations, a dedicated and highly motivated global workforce, coupled with a seamless onsite/offshore delivery model and a state-of-the-art worldwide infrastructure, gives us the competitive edge to provide comprehensive, end-to-end IT solutions to our diverse clientele.

Headquartered in the heartland of America (Cincinnati, OH) Ascendum has delivery, sales, and support offices worldwide including its offshore development center in Bangalore, and a BPO Center in Ahmedabad, India.

We welcome inquiries from applicants only (We will not accept third parties or agencies for this opportunity). Candidates must be authorized to work permanently in the United States. Due to the volume of resumes that we receive, only those candidates selected for review will be contacted. Ascendum is an equal opportunity employer.

Similar Jobs

See All »

Other Jobs at Ascendum Solutions

See All »