ETL Automation Test Engineer

at Apex Systems Inc

location Blue Ash, Ohio

Updated on Nov 16, 2018

Contract Position
15 month(s)

  • Referral Bonus


  • Signing Bonus



Pay Rate $42.00 per hour

Experience 7-12 Years

Eligibility Green Card, US citizen


Information Technology Services


Not Specified

Job ID


Working Remotely Allowed



Required Skills :Automation Testing, Jira, Informatica, SQL, Quality Center, ALM

Additional Skills :Prefer candidates with recent experience working on Informatica IDQ

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.
Identify obstacles and roadblocks; and offer suggestions to work around obstacles
Help drive and improve QA process within the team you are assigned

Similar Jobs


Earn money by referring your friends to their next dream job, or find a job for yourself and the Referral Bonus becomes a Signing Bonus. Full time or Contract.

  • Make Money

    We’ll give you between several hundred and several thousand dollars for every successful referral.

  • Help Your

    Job applications with personal recommendations are twice as likely to get hired.

  • 100% Free

    Absolutely zero sign up and subscription fees. We want to pay YOU!

  • Signing Bonuses

    All jobs on iEndorseU come with a Signing Bonus if you find a job for yourself

  • No credit card needed

    We pay you directly through Paypal, so keep your personal information…personal.

  • Sponsor others

    Get others to download our app and we will pay you $100 whenever they next get a job through our platform.

All the ways to make money from us