Job Description

Company Description
Global Service Center (GSC) operating from Chennai, India, is a part of CHQ - IS supporting Expeditors Information Services. GSC started with 6 employees now we are 540+ employees today delivering world class Information services globally. This Strategic Center's plays a vital role in delivering value to our people, business and customers. We will continue to deliver services as we continue to grow responsibly in the coming years.
Expeditors is a global logistics company headquartered in Seattle, Washington. As 500 company, we employ over 19,000 trained professionals in a worldwide network of over 350+ locations across six continents. Expeditors satisfies the increasingly sophisticated needs of international trade through customized solutions and seamless, integrated information systems.

SUMMARY
"The 'Velocity, Variety, and Volume' of Big Data are the driving forces behind Expeditors' global logistics operations, as we move freight across the world daily. We offer an exciting opportunity to join our Enterprise Data and Analytics (ED&A) team and play a pivotal role in ensuring the quality, integrity, and reliability of this massive data landscape. You'll be instrumental in building a robust data lake environment and supporting users by guaranteeing flawless data ingestion, analysis, and visualization. You'll collaborate with highly skilled software development engineers, working with Event-Driven Architecture, Domain-Driven Design, and Event Sourcing. If you're passionate about data quality, love digging into complex data challenges, and are excited about leveraging automation to ensure data excellence, we want to talk to you.
The ED&A team is looking for a self-motivated, driven Tester with expertise in Quality Assurance and Automation to join us. This role is critical in helping us design and deliver solutions that satisfy customer and organizational business requirements by rigorously testing our data systems. You'll ensure these systems enable the organization to achieve its future goals and explore new opportunities with confidence in our data.
The ED&A team is highly collaborative and communicative internally, within the IS department, and throughout the company as a whole. Excellent communication and customer service are always priority one."
KEY RESPONSIBILITIES

• Collaborate with the QA team and developers to define the overall testing strategy, test plans, and test cases.

• Creating and managing test data, especially for complex scenarios, to ensure thorough testing.

• Identify, report, and track defects, working closely with the development team to facilitate timely resolution.

• Conduct performance and load testing to identify bottlenecks and optimize ETL performance.

• Maintain comprehensive test documentation, including test plans, test cases, and test results.

• Reviewing test cases and scripts to ensure they are effective and meet quality standards.

• Create and inject synthetic and permutation-based test data to thoroughly test positive, negative, and error scenarios, as well as new and existing logic.

• Perform various types of testing, including standard testing, comparison testing, error handling, performance testing, end-to-end testing, and security testing.

• Develop and execute comprehensive test plans specifically for data pipelines, ETL processes, and data warehouse solutions, identifying optimal test cases for data completeness, integrity, and corner cases.

• Create comprehensive test-related documents, including data validation reports and test summaries, and effectively communicate test results, data quality issues, and other relevant information to data stakeholders and team members.

• Guide users through User Acceptance Testing (UAT) for data products and reports, ensuring they understand data validation points and how to provide valuable feedback on data accuracy.

• Review automated test results, investigate failures, identify root causes, write detailed bug reports, track defects, and drive bug triage by prioritizing issues and providing clear reproduction steps.

• Create and maintain test data for current and future regression testing.

• Collaborate with development teams to integrate automated tests into the CI/CD pipeline.

• Lead and execute data and data warehouse QA efforts, ensuring the completeness, integrity, and accuracy of data across various systems, including on-premise to cloud migrations.

• Develop and maintain automated test scripts for data validation using scripting languages and automation frameworks (e.g., Playwright) to ensure the continuous quality of data assets.

• Continuously improving test scripts and automation processes to enhance efficiency and effectiveness.

• Provide guidance and mentorship to junior members of the Testing team, sharing knowledge and best practices.

• 6-12 years of experience in ETL testing and Data Validation.
• Proven experience in establishing and executing QA processes within a development team.
• Experience in test automation using tools like Selenium, Playwright, Pytest, or similar.
• Proficiency in SQL, Scripting for data validation and test case data comparison.
• Experience with automation frameworks (e.g., Playwright) for automating data-related tests.
• Strong analytical, problem-solving and Communication skills.
• Excellent analytical skills with a keen eye for detail.

• Knowledge of Kafka, Master Data Management, Data Warehousing and Business Intelligence architecture.
• Experience in automation testing for ETL workflows.
• Understanding of CI/CD pipelines in a data context.
• Familiarity with cloud-based data storage solutions and best practices.
• Solid understanding of API testing tools and techniques.
• Relevant certifications (e.g., ISTQB, Selenium WebDriver) a plus.
• Understanding of the transportation/global logistics industry.

• Team Manager, Enterprise Data & Analytics

• Paid Vacation, Holiday
• Health Plan: Medical Insurance
• Employee Stock Purchase Plan
• Training and Education Programs
• Unlimited opportunities for career advancement