Job Search
ETL AQA Engineer IRC246692
Job: | IRC246692 |
Location: | Ukraine - Kyiv, Lviv |
Designation: | Software Engineer |
Experience: | 3-5 years |
Function: | Engineering |
Skills: | BigQuery, Pipeline Execution/ETL, QA Automation, Snowflake |
Work Model: | Remote |
Description:
We have an exciting opportunity for an experienced and passionate ETL AQA Engineer to join our growing technology team within the WPP division, focusing on building technology products for some of the world’s leading media agencies. The successful candidate will work alongside developers and other members of the scrum teams of the WPP division.
About the division:
We like to say that we play with giants. That’s huge data sets, influential partners, and even bigger ambitions. But only because we’re here to make a difference. As WPP’s division, our mission is to create products that make advertising work better for people. With expertise in data science, audience insights, simulations, and automation, our 350-person strong team designs and builds software products that shape the global media ecosystem. With a partnership philosophy at the heart of everything we do, we team up with the world’s leading media and technology organizations — including Adobe, Amazon, Baidu, The Trade Desk, Google — to develop innovative solutions and bring a unique competitive advantage to our portfolio of clients.
WPP and all its affiliates embrace and celebrate diversity, inclusivity, and equal opportunity. We are committed to building a team that represents a variety of backgrounds, perspectives, and skills. We are a worldwide media agency network that represents global clients. The more inclusive we are, the more great work we can create together.
Requirements:
3-4+ years AQA experience.
Experience with testing Data pipeline projects (process in which raw data is ingested from various data sources, transformed and then ported to a data store, such as a data lake or data warehouse, for analysis)
GCP BigQuery or Snowflake.
Experience with any RDBMS.
Hands-on experience working with SQL queries and SQL aggregations.
Experience working with APIs directly (Postman, etc).
Experience with Behave testing.
Experience with Scrum methodology.
Adverity, dbt (Data build tool), Airflow, Microsoft Power BI would be a plus.
Experience with creating and implementing an effective test strategy from scratch would be a plus.
Self-motivated, eager to learn, and loves challenges.
Job Responsibilities:
Working as a part of the distributed multicultural team and keeping communication at the high level.
Using tools like dbt/Airflow to implement tests as part of the data pipelines.
Learn new technologies and tools with the team that is starting working on the new project.
AQA of the database-related tasks as well as various stages of the Data pipeline.
Work with different RDBMS/DWH (Microsoft SQL Server, Google BigQuery), that store terabytes of data.
Working with SQL queries (joins, filtering, updating, creating, etc.) and SQL aggregations.
Calling APIs directly and understanding on a high level the technical structure of the project and be able to trouble shoot basic technical issues.
Basic managing of the test environment (validate that DBs are up and running, validate the data presence, etc.).
Managing schema objects, such as tables and views.
Proactively monitoring the database’s health.
What We Offer
Empowering Projects: With 500+ clients spanning diverse industries and domains, we provide an exciting opportunity to contribute to groundbreaking projects that leverage cutting-edge technologies. As a team, we engineer digital products that positively impact people’s lives.
Empowering Growth: We foster a culture of continuous learning and professional development. Our dedication is to provide timely and comprehensive assistance for every consultant through our dedicated Learning & Development team, ensuring their continuous growth and success.
DE&I Matters: At GlobalLogic, we deeply value and embrace diversity. We are dedicated to providing equal opportunities for all individuals, fostering an inclusive and empowering work environment.
Career Development: Our corporate culture places a strong emphasis on career development, offering abundant opportunities for growth. Regular interactions with our teams ensure their engagement, motivation, and recognition. We empower our team members to pursue their career goals with confidence and enthusiasm.
Comprehensive Benefits: In addition to equitable compensation, we provide a comprehensive benefits package that prioritizes the overall well-being of our consultants. We genuinely care about their health and strive to create a positive work environment.
Flexible Opportunities: At GlobalLogic, we prioritize work-life balance by offering flexible opportunities tailored to your lifestyle. Explore relocation and rotation options for diverse cultural and professional experiences in different countries with our company.