ETL QA developer
Previous Job
Previous
ETL QA developer
Ref No.: 17-01976
Location: Irving, Texas
Start Date: 08/24/2017
ETL Developer/ QA
Irving TX ( North of Dallas TX)
2 openings
12 months

Seeking ETL/QA Engineers with strong MDA (Modern Data Architecture), SQL/ETL skills. We are looking for candidates who come from backend development, who are interested in performing QA - writing unit tests, helping developers to debug the code, find the root cause of the issues, etc. So, Jr. SQL Database Developers, ETL Developers, PL/SQL Developers who want to work on the QA side, hand in hand with the developers would be ideal.
Here is the job description:
  • 7+ years of real time experience in writing complex SQL queries, understanding views,constraints,stored procedures and debugging the queries/stored procedure
  • Exp with MDA (modern data architecture)
  • Strong SQL Skills, Joins, minus queries, understanding of datawarehouse testing
  • 7+ years of experience in ETL,Informatica, Oracle, PL/SQL
  • Understanding of data-modeling concepts(Entity Relationship,Multi-dimensional).
  • Understanding of data-warehousing/ETL concepts.
  • Should have expertise on ETL Tools like Informatica,SSIS etc.
  • Knowledge of comparing source data against target data via (SQL Server) in source and target for both full and incremental loads
  • Development and integration which includes setting up configuration management, developing components, peer review, creating unit test plans and performing unit testing
  • Writing unit tests (software testing method)
  • This person would be responsible for creating test scripts for a backend application. Expectations are that the qualified candidate will have a development background and education, familiar with SQL/Oracle, who is open to doing automation development. They need a senior level candidate that has a background and experience testing backend applications. This resource will need to understand and have experience within ETL/SQL
  • Willingness to learn with attention to details
  • Experience in leading teams in delivering end-to-end solutions
  • Demonstrated experience in testing Java, .net and C++ applications and PEGA Smart Dispute development/testing experience
  • Develop automation scripts in Selenium, Soap UI, REST API, REST API for Web Service testing
  • Experience testing on web-based software applications in large enterprises, and familiarity with Selenium
  • Automation experience (ability to implement automation framework)
  • 5+ years' experience creating and executing test plans, and test cases/scripts from scratch
  • Worked in an Agile environment and/or on a SCRUM preferred
  • 7 years Demonstrated experience in Quality Assurance testing, writing and executing test plans; using testing tools (QTP, Selenium) plus experience in testing with Agile/Iterative development
  • Demonstrated experience with bug tracking tools such as JIRA, Bugzilla
  • Must be adequately proficient in Automation implementation, scripting, script reviews, importing automation skill to team members (QTP, Selenium, Java)
  • Develop test automation scripts in Selenium UFT along with maintaining and enhancing the automated test framework supporting a continuous integration environment with automated smoke and regression testing
  • Continuous Integration Testing with Jenkins, TestNG, and well versed with SQL queries; proficient in SQL, Oracle, SQL Server
  • Strong English communication skills, written and verbal
  • Ability to handle multiple tasks/subprojects simultaneously, organizational skills plus work with remote team; takes initiative in handling issues that arise during testing
  • Experience using XML
  • Ensure high test and code coverage with custom coding, maintainability of scripts, reliability of equipment tools, and overall robustness of testing efforts