Expeditors International
Developer in Test II - Core Enterprise Data and Analytics, IS Core
Expeditors International, Federal Way, Washington, United States, 98003
Developer in Test II - Core Enterprise Data and Analytics, IS Core
Full-time
“We’re not in the shipping business; we’re in the information business” -Peter Rose, Expeditors Founder
Global supply chain management is what we do, but at the heart of Expeditors you will find professionalism, leadership, and a friendly environment, all of which foster an innovative, customer service-based approach to logistics.
18,000 trained professionals
350+ locations worldwide across 60+ countries
Globally unified systems
The Core Enterprise Data and Analytics Group is looking for strong candidates who want to help design and expand our library of automation tools and frameworks. You will be responsible for shaping the direction and quality of our reporting data, applications and the frameworks utilized to test them.
Responsibilities:
Design test plans for Azure data engineering projects that use services like Databricks and Synapse.
Perform functional analysis and data validation.
Perform data completeness testing, duplicate data detection, and data validation rule enforcement.
Use and create design and mapping documents for transformation rules to ensure proper testing.
Collaborate with Business Analysts and Developers to define testing requirements.
Develop overall test strategy, lead testing of all impacted applications/infrastructure, and support post-production activities.
Write test scripts for inbound and outbound ETL processes and interfaces with other systems.
Conduct data quality and audit checks on source and target data.
Prepare mockup/synthetic data to test positive and negative scenarios to meet business requirements.
Create test-related documents and provide results to various client systems using Azure technology.
Test large datasets (millions of records) from diverse sources.
Conduct whitebox and blackbox testing for data transformation processes.
Verify metadata, including table and column definitions, data types, lengths, constraints, and indexes.
This position is on-site and will reside in the greater Seattle, WA. area at one of the following locations depending on availability. Candidates must be local or willing to relocate. Relocation assistance is not offered for this position.
Downtown Seattle
Lynnwood
Bellevue (Factoria)
MINIMUM QUALIFICATIONS
4+ years of experience with object-oriented languages (Python preferred) and SQL.
4+ years of experience in a technical quality assurance role.
Experience with cloud technologies (Azure preferred).
Experience working with databases.
Strong understanding of SQL and data warehousing concepts.
Experience with test automation frameworks.
Ability to generate consensus among team members.
Customer service-oriented attitude and excellent time management skills.
DESIRED QUALIFICATIONS
Familiarity with Python development.
BS in Computer Science or comparable work experience.
Strong troubleshooting and communication skills.
Ability to drive technical and process improvements.
Proficiency with automation tools and writing automation tests, test automation, automation frameworks, and testing best practices.
Proficiency with Agile methodologies.
Experience with GIT or other versioning tools, IntelliJ or other IDEs.
Experience working with Kafka.
Experience with ETL tools and data validation using Azure technologies (Databricks, Azure SQL Server/Synapse).
Experience with data validation for on-prem to cloud migration.
Experience testing large datasets from diverse sources.
Experience validating front-end data in Power BI reports and ensure it matches the database.
Strong SQL skills for data comparison and analysis.
Ability to create and manage test data for various scenarios.
Understanding of data transformation processes and validation techniques.
Experience with data profiling and quality tools.
Knowledge of data warehousing concepts.
Understanding of cloud platforms (AWS, Azure, GCP).
Familiarity with test automation frameworks like Cucumber.
Familiarity with Behavior Driven Development/Test Driven Development.
PREFERRED EXPERIENCE
Previous experience in a similar role, particularly in testing cloud-based solutions.
Experience with CI/CD pipelines and DevOps practices.
Experience with data completeness testing, duplicate data checks, and data integrity checks.
Experience with whitebox and blackbox testing for data transformation processes.
Experience with metadata testing, including verification of table and column definitions, data types, lengths, constraints, and indexes.
Ability to identify gaps in testing processes.
Applicants are required to be eligible to lawfully work in the U.S. immediately; employer will not transfer or sponsor applicants for U.S. work authorization (such as an H-1B visa) for this opportunity.
Expected base salary: $100,000 to $140,000
Expeditors offers excellent benefits:
Paid vacation
Holidays (10)
Flexible Days (2)
Paid Sick Time (accrual rate of 1 hour of sick time per 30 hours paid)
401(k) Retirement Savings Plan with employer match
Employee Stock Purchase Plan (ESPP)
Health Savings Account (HSA)
Life and Disability Insurance
Paid Parental Leave (additional eligibility criteria)
Dependent Care Flexible Spending Account (DC FSA)
Employee Assistance Program (EAP)
Training and Personnel Development Program
Educational Assistance and Reimbursement
Position is full time (40 hours per week) Monday through Friday
Business professional dress code
All your information will be kept confidential according to EEO Guidelines.
#J-18808-Ljbffr
Full-time
“We’re not in the shipping business; we’re in the information business” -Peter Rose, Expeditors Founder
Global supply chain management is what we do, but at the heart of Expeditors you will find professionalism, leadership, and a friendly environment, all of which foster an innovative, customer service-based approach to logistics.
18,000 trained professionals
350+ locations worldwide across 60+ countries
Globally unified systems
The Core Enterprise Data and Analytics Group is looking for strong candidates who want to help design and expand our library of automation tools and frameworks. You will be responsible for shaping the direction and quality of our reporting data, applications and the frameworks utilized to test them.
Responsibilities:
Design test plans for Azure data engineering projects that use services like Databricks and Synapse.
Perform functional analysis and data validation.
Perform data completeness testing, duplicate data detection, and data validation rule enforcement.
Use and create design and mapping documents for transformation rules to ensure proper testing.
Collaborate with Business Analysts and Developers to define testing requirements.
Develop overall test strategy, lead testing of all impacted applications/infrastructure, and support post-production activities.
Write test scripts for inbound and outbound ETL processes and interfaces with other systems.
Conduct data quality and audit checks on source and target data.
Prepare mockup/synthetic data to test positive and negative scenarios to meet business requirements.
Create test-related documents and provide results to various client systems using Azure technology.
Test large datasets (millions of records) from diverse sources.
Conduct whitebox and blackbox testing for data transformation processes.
Verify metadata, including table and column definitions, data types, lengths, constraints, and indexes.
This position is on-site and will reside in the greater Seattle, WA. area at one of the following locations depending on availability. Candidates must be local or willing to relocate. Relocation assistance is not offered for this position.
Downtown Seattle
Lynnwood
Bellevue (Factoria)
MINIMUM QUALIFICATIONS
4+ years of experience with object-oriented languages (Python preferred) and SQL.
4+ years of experience in a technical quality assurance role.
Experience with cloud technologies (Azure preferred).
Experience working with databases.
Strong understanding of SQL and data warehousing concepts.
Experience with test automation frameworks.
Ability to generate consensus among team members.
Customer service-oriented attitude and excellent time management skills.
DESIRED QUALIFICATIONS
Familiarity with Python development.
BS in Computer Science or comparable work experience.
Strong troubleshooting and communication skills.
Ability to drive technical and process improvements.
Proficiency with automation tools and writing automation tests, test automation, automation frameworks, and testing best practices.
Proficiency with Agile methodologies.
Experience with GIT or other versioning tools, IntelliJ or other IDEs.
Experience working with Kafka.
Experience with ETL tools and data validation using Azure technologies (Databricks, Azure SQL Server/Synapse).
Experience with data validation for on-prem to cloud migration.
Experience testing large datasets from diverse sources.
Experience validating front-end data in Power BI reports and ensure it matches the database.
Strong SQL skills for data comparison and analysis.
Ability to create and manage test data for various scenarios.
Understanding of data transformation processes and validation techniques.
Experience with data profiling and quality tools.
Knowledge of data warehousing concepts.
Understanding of cloud platforms (AWS, Azure, GCP).
Familiarity with test automation frameworks like Cucumber.
Familiarity with Behavior Driven Development/Test Driven Development.
PREFERRED EXPERIENCE
Previous experience in a similar role, particularly in testing cloud-based solutions.
Experience with CI/CD pipelines and DevOps practices.
Experience with data completeness testing, duplicate data checks, and data integrity checks.
Experience with whitebox and blackbox testing for data transformation processes.
Experience with metadata testing, including verification of table and column definitions, data types, lengths, constraints, and indexes.
Ability to identify gaps in testing processes.
Applicants are required to be eligible to lawfully work in the U.S. immediately; employer will not transfer or sponsor applicants for U.S. work authorization (such as an H-1B visa) for this opportunity.
Expected base salary: $100,000 to $140,000
Expeditors offers excellent benefits:
Paid vacation
Holidays (10)
Flexible Days (2)
Paid Sick Time (accrual rate of 1 hour of sick time per 30 hours paid)
401(k) Retirement Savings Plan with employer match
Employee Stock Purchase Plan (ESPP)
Health Savings Account (HSA)
Life and Disability Insurance
Paid Parental Leave (additional eligibility criteria)
Dependent Care Flexible Spending Account (DC FSA)
Employee Assistance Program (EAP)
Training and Personnel Development Program
Educational Assistance and Reimbursement
Position is full time (40 hours per week) Monday through Friday
Business professional dress code
All your information will be kept confidential according to EEO Guidelines.
#J-18808-Ljbffr