Middle Data Engineer Offline

What you will do:

- Build & maintain automated test coverage using PyTest/Python to validate business goals and technical solutions for new and existing functionality as part of the certification of each ticket, within each sprint;

- Write complex SQL queries on tables with hundreds of millions of records and ensure data integrity is maintained throughout the ETL lifecycle;

- Participate in Agile ceremonies, help analyze requirements, develop testing strategies, and facilitate the Agile process within all cross-functional teams.

Must haves:

- Two or more years of experience creating automated scripts using pytest for data validation (Must);

- Bachelors in Computer Science or Data Science, or Information Systems, or Mathematics, or Statistics or equivalent years of relevant work experience;

- 5+ years of experience with agile software development testing, reviewing user stories, acceptance criteria, and other available information to develop test plans and test scenarios, both manual and automated;

- 3+ years of experience in database testing for relational databases( preferred Snowflake and MS SQL Server), ETL/ELT data solutions, and reporting and analytics tools;

- Knowledge of data warehouse concepts, such as star schemas, snowflakes, facts, and dimensional modeling;

- Experience in writing complex SQL queries, ability to determine the types of testing that must be conducted (i.e., data validation, regression, etc.), including evaluating the testability of requirements and creating a comprehensive test plan that supports the business and technological solutions being delivered;

- Experience using Jira or other bug-tracking software;

- Must be self-motivated, able to work independently, and thrive in a fast-paced, multi-tasking, high-productivity environment while maintaining excellent working relationships with people in a wide variety of functional areas;

- Excellent verbal and written communication skills.