Software Development Engineer in Test (SDET) – ETL - #19504149

CSAA Insurance Group

Date: Dec 26, 2020
City: Glendale, AZ
Contract type: Full time
CSAA Insurance Group

Job Title

Software Development Engineer in Test (SDET) – ETL

Requisition Number

R4194 Software Development Engineer in Test (SDET) – ETL (Open)


Glendale, Arizona

Additional Locations

Job Information

We are actively hiring for a Software Development Engineer in Testing - ETL! Join us and support CSAA Insurance Group, a AAA insurer, in achieving our goals.

We are looking for motivated, innovative individuals, who think big and move fast with a passion for service excellence.

Essential Responsibilities

  • Lead efforts in building an automation framework for ETL and Oracle UI

  • Works with Scrum/Agile team to establish and support the execution of automated tests on the Continuous Integration Environment for Functional and Regression Testing

  • Creates, modifies and executes automated tests, test scripts and test suites including functional and regression tests to extract, transform and load data that is transmitted between systems.

  • Executes both manual and automated tests. Analyzes execution results to determine the reason for test failures

  • Ensures clear and prompt reporting on a build/release status for all stakeholders based on test run execution results

  • Develops expertise in the Insurance Application Hub applications and maintains a solid knowledge with respect to automated testing tools and techniques that support ETL/Data Integration testing

  • · Contributes to the review and development of QA standards, policies and procedures

What would make us excited about you?

Required Skills/Experience

  • Bachelor's degree in related area or an equivalent combination of education and experience

  • 5+ years of testing/quality assurance experience on ETL/Data Integration/Data Warehousing projects of which at least 3 years as a senior test engineer on ETL projects

  • 5+ years of relational database experience covering writing queries, manipulating test data through efficient SQL queries and stored procedures

  • 5+ years of defining, writing and executing detailed test cases covering all the functionalities of an ETL solution

  • 1 year of verifiable hands-on experience on Python and Cloud data integrations Informatica DVO or equivalent testing tool

  • Experience working in Agile delivery methodology and using testing/quality assurance tools such as JIRA

Preferred Skills / Experience

  • Informatica ETL

  • An understanding of processing transactional data in financial systems

  • Web-application automation tools (Selenium)

  • Testing framework (JUnit, TestNG)

  • Insurance experience

Why join us?

Make a difference. We don't just go to work. We're a team of employees committed to AAA members, our communities and each other.

Recognition. We offer a total compensation package that includes: performance bonus, 401(k) with a company match, volunteer time off, and more.

Lifestyle. We drive strategy through innovation. We do honorable work, and we live our core beliefs.

Read about our benefits and more on our career site:

Be part of a community that works

Headquartered in Walnut Creek, California, our community also works in Arizona, Colorado, Nevada, New Jersey and Oklahoma. Our differences, visible and invisible, make every individual at CSAA Insurance Group unique and valuable. We foster a culture where all employees feel a sense of belonging and can leverage their differences to influence, innovate, problem-solve and thrive. Ultimately, our differences allow us to better serve our members. We place great importance on inclusion and belonging because it enriches our environment, leads to improved leadership effectiveness, a more fulfilling employee experience, greater member satisfaction and improved business performance.

Let's work together

Submit your application to be considered. We communicate via email, so please check your inbox to ensure you don't miss important updates from us.

If reasonable accommodation is needed to participate in the job application or interview process please contact

Must have authorization to work indefinitely in the US.



  • LI-SB1

How to apply

To apply for this job you need to authorize on our website. If you don't have an account yet, please register.

Post a resume