Developer in Test III - Core Enterprise Data and Analytics, IS Core

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. We are looking for a candidate with experience testing large amounts of data and building new test frameworks.  You will be responsible for shaping the direction and quality of our data pipelines and the frameworks used to test them.The Developer in Test designs, develops and maintains custom test automation frameworks, to test big data with complex transformations. They participate in the design and development of systems with an eye towards assuring quality and testability. They fully understand and support the role of our Quality Assurance Engineers by providing automated testing tools and generating datasets for their data pipelines.  They also perform quality assurance tasks such as test planning, test case generation and testing. They act as a driver for progress in their team. This team has a startup culture.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 SeattleFederal WayLynnwoodBellevue (Factoria)