ETL Automation Engineer

Tekstrom - Dallas, TX

Full-time - Mid Level

Dallas, TX

Professional, Scientific, and Technical Services

About the position

The ETL Automation Engineer is responsible for leading technical test teams with hands-on experience in ETL and Java. This role involves managing the testing of ETL, Batch, and Big Data applications in an agile environment, driving innovation in testability, and ensuring high-quality solutions through automation. The engineer will establish quality assurance standards and best practices for test automation, while collaborating with QA engineers and developers to develop test strategies and maintain quality standards.

Responsibilities

• Review requirements and design specifications with an emphasis on product testability.
• Develop test strategies with QA engineers, developers, and team members.
• Design and code unit, component, integration, service/API, and system automated testing for new or enhanced IT systems.
• Maintain an expert level awareness of relevant software design techniques, automation tools, and processes.
• Develop supporting structures for all test automation including mocks, stubs, and test harnesses.
• Design, extend, and optimize the test automation framework.
• Automate test data management and identify, implement, manage, and report appropriate metrics.
• Work with the Quality Assurance organization to ensure established procedures, standards, and processes are utilized consistently.
• Maintain quality standards for own work and be detail-oriented.
• Develop and sustain positive relationships with peers.
• Provide technical support and coaching to team members regarding automated testing.

Requirements

• Minimum seven years of SDLC experience in ETL and Java on large software systems (10+ years preferred).
• Experience working in an agile development environment, preferably Scrum.
• Proficient in object-oriented design and design patterns.
• Experience in ETL and Data Warehouse concepts.
• Experience with DataStage, Hadoop Ecosystem, and Scheduling tool Control-M.
• Experience with unit testing tools such as JUnit and TestNG.
• Strong understanding of Java, JEE, JavaScript, O/R Mapping, SQL, PL/SQL, UNIX scripting, UML, Eclipse, and various frameworks.
• Expert knowledge of multi-threading, SOAP/REST, and MVC.
• Well-versed in RDBMS technology: Oracle and SQL Server.
• Bachelor's degree in Computer Science or Engineering.

Nice-to-haves

• Experience with Test Driven Development.
• Experience with Continuous Delivery.
• Experience with one or more test automation tools such as SOAPUI Pro, Selenium, Ranorex, SeeTest, or QTP.
• Experience with Jenkins, Hudson, Nolio, SONAR, Fisheye, or Crucible.
• Domain background in Banking or Credit Card industry.
• Experience with TSYS.