Senior Software Development Engineer in Test
Senior Software Development Engineer in Test (SDET) (employer: Bizrate Insights Inc.; job location: Los Angeles, CA) Build infrastructure required for testing optimal extraction, transformation, & loading (ETL) of data from wide variety of data sources using SQL & big data technology. Dsgn data quality & data integration framework. Work with stakeholders include Product, Data & Design teams to assist with data-related technical issues. Conduct performance & scalability testing efforts. Take technical ownership of software testing infrastructure & improving product quality. Anticipate problems & take appropriate actions to mitigate negative impacts. Implement processes & systems to monitor data quality, ensuring production data is always accurate & available for key stakeholders & business processes that depend on it. Perform data analysis required to troubleshoot data related issues & assist in resolution of data issues. Mentor & share big data testing practices with Scrum & SDET teams.
Requires: Bachelor's degree in Computer Science or Computer Engineering & 5 years of post-bach progressive experience in position offered or as a Software/Test Engineer. At least 3 years of required experience must have included writing test data scripts based on ETL mapping artifacts; using Python & PysPark to apply, design & develop automated testing strategies & build automated testing frameworks; using Data Warehouse & Data Lake concepts to execute formal test plans for delivery of data related projects; & using database validation & querying tools including Amazon Athena, Amazon Aurora & Spark SQL to investigate & debug software & data issues.