Senior Associate - QA (etl/dwh Tester)

GALE is a Business Agency that brings its insights to brand storytelling and activates it across every channel. With expertise in business strategy, media, CRM, brand communications, performance marketing and technology, GALE creates integrated marketing systems and communications that grow businesses. Founded in 2014, the agency has since been named Ad Age Data and Analytics Agency of the Year and Adweek’s Breakthrough Media Agency of the Year.   We work with Chipotle, Hard Rock, MilkPEP, H&R Block, Dropbox, Hertz and more. If you’re driven by a passion to build something great, a desire to innovate, and a commitment to achieve excellence in your craft, GALE is a great place for you!   GALE has nine offices around the world, including New York, Toronto, Los Angeles, Austin, Denver, Kansas City, London, Bengaluru and Singapore. GALE embraces a hybrid, flexible workplace with employees asked to attend the office three days per week. 

As a global agency, we are currently hiring across multiple locations within North America, please apply today to learn more. You can check our office locations here.

Job Description

Title: Senior Associate

About us GALE helps brands solve complex challenges through our integrated consultancy and agency offering. Headquartered in New York with offices in Toronto, Singapore and Bangalore, our teams are connected by a set of core values that inform everything we do, from how we hire to how we work together: values like Everyone Matters, No Silos, and Masters of Our Craft. If you’re driven by a passion to build something great, a desire to innovate, and a commitment to achieve excellence in your craft, GALE is a great place for you. 

Experience:

4-6 years of experience in functional testing, with expertise in ETL processes and SQL Working knowledge of any RDBMS like SQL Server, Oracle, MySQL etc Good query writing skills, ability to write SQL queries with joins

Technical Skills: Proficient in functional testing methodologies and tools. Good understanding and experience on requirement gathering and documentation Strong command of ETL processes and their validation. Advanced SQL skills for data querying and validation. Hands-on experience with dataframes for data processing and analytics. Ability to participate in the business requirements and software development life cycles as they relate to testing activities Knowledge and hands-on experience on Data visualization Ability to write programs to calculate data using Pandas Hands on experience on python programming to design test suite for data validation Nice to have knowledge of Gherkin to design test cases to be automated Ability to handle API requests and data validation of json response against database Identifying, documenting, and tracking defects and issues found during testing, and verifying their resolution Using SQL to set up and manage test data, perform data validation, and troubleshoot issues related to database connectivity or data integrity