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/ DBeaver/ tablePlus like SQL Server, MySQL etc

Very Good in SQL query writing skills for Data Validations among multiple data sources

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