Developer In Test Ii

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 Qualifications MINIMUM QUALIFICATIONS 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 DESIRED QUALIFICATIONS 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 REPORTING STRUCTURE Team Manager Enterprise Data Analytics Additional Information Expeditors offers excellent benefits Paid Vacation Holiday Health Plan Medical Insurance Employee Stock Purchase Plan Training and Education Programs Unlimited opportunities for career advancement