Developer in Test III – Core Enterprise Data and Analytics – IS Core
| Company | Expeditors |
|---|---|
| Location | Seattle, WA, USA |
| Salary | $Not Provided – $Not Provided |
| Type | Full-Time |
| Degrees | |
| Experience Level | Mid Level, Senior |
Requirements
- 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.
- Proficiency in reading and writing code in programming languages such as Python, Java, or JavaScript (Python preferred).
- 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.
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.
Preferred 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.