We are storming the marketplace with the highly skilled, experienced, and certified professionals that businesses need.

Find your perfect job.

ETL Test Engineer / SQA Tester (Closed)

SkillStorm is seeking an ETL Test Engineer / SQA Tester for our client in Charlotte, NC OR Jersey City, NJ. Candidates must be able to work on SkillStorm's W2; not a C2C position. EOE, including disability/vets.

Job Description:

  • This role is for a Senior ETL Test Engineer. Java and Selenium nice to have and Pega a plus. Candidate must be a self -motivated go getter with good data analysis and testing skills to dissect and pick apart data requirements, data integration and controls and data designs.
  • 7+ years testing ETL processes, jobs and data transport/movement, source to target mappings, materialized views, etc.
  • Excellent communication skills and ability to validate data models and identify issues.
  • Experience in working in a global delivery model
  • Knowledge of varied QA processes/methodologies, good Business acumen in technical development organization
  • Experience in using one or more Agile tools – Rally, JIRA
  • Ability to manage competing priorities on an ongoing basis.
  • Ability to be self-directed to complete assigned activities.
  • Strong problem-solving skills with the ability to analyze and debug issues.
  • Application development background will be an added advantage
  • Able to assist Management and work with partner teams in development of testing approach and strategy(ies). Create test plans, scripts and artifacts for all phases of testing. Identify, document, and resolve data quality/data integrity issues. Analyze and test ETL mappings, workflows/sessions and other DW jobs/processes.  Ensures adherence to locally defined standards.  Work with Development and other internal QA teams to build, implement and improve test solution frameworks. Assist with improving quality testing productivity and effectiveness. Ability to identify potential risks and steps to minimize the impact of risks across area of responsibility. Provide input to project estimations. Extensive experience in data warehouse and middleware testing environments to include testing of ETLs and Webservices, senior-level SQL knowledge and thorough understanding of middleware APIs.      
  • knowledge/experience with testing ETLs and Webservices; SQL knowledge and understanding of middleware APIs desirable

Required Skills:

  • Experience writing complex queries which include multiple joins and conditional statements, updating existing queries for streamlining and correctness; Create SQL scripts with test cases
  • Understanding existing code in Stored procedures / DB Views
  • Should know how to work with batch logic like soft deletes / timestamps / current record vs historical records, how to use foreign keys and surrogate keys
  • Ability to understand data mappings in mapping documents and ask questions if there are any
  • Candidate should have worked on batch feeds / Data warehouse updates.
  • Ability to use Informatica or SSIS or Wherescape or any other tool will be an added advantage
  • Understand look ups, transformation logic provided in the design documents and ask questions if there are any
  • Ability to engage and discuss with data architects / data developers, ask questions and get the information required
  • Candidate should be a quick learner and ready to take new challenges.
  • Excellent communication skills (verbal and written)
  • Excellent collaboration skills, building relationships with the business and development team
  • Excellent analytical skills, must be able to dig deep and understand stand the strategy
  • Coordinate / collaborate automation solutions

Desired Skills:

  • Previous experience in implementing test automation development efforts in an Agile SCRUM development environment
  • Experience in version control tools like SVN, Perforce, Git.
  • Java and ETL test automation development frameworks a plus.
  • Working experience in Banking and AML or regulatory domain preferred

#LI-DNI

Similar Jobs

Quality Assurance Consultant V

Contract job in Charlotte

Business Event Analyst

Contract job in Charlotte