SDET focused on data reconciliation, complex SQL, and ETL testing. Build and automate test frameworks, validate ETL pipelines and data warehouses, write optimized SQL for data validation, perform root-cause analysis of discrepancies, and ensure data integrity between source and target systems.
Job Summary:
Nice to have:
We are seeking a highly skilled and detail-oriented Software Development Engineer in Test (SDET) to join our team with a focus on data reconciliation, complex SQL, and ETL testing. The ideal candidate will have a unique blend of skills in software development, quality assurance, and data engineering. You will be responsible for ensuring data accuracy, validating ETL processes, and building automation frameworks for data-related testing processes. This is a key role to ensure the integrity and quality of our data infrastructure and analytics platforms.
Key Responsibilities:- Complex SQL Queries:
- Write and optimize complex SQL queries to validate data pipelines, transformations, and reporting accuracy.
- Perform root cause analysis of data discrepancies and provide insights into data quality issues.
- Develop automated SQL scripts to streamline data validation and reconciliation processes.
- ETL Testing:
- Validate ETL processes by designing comprehensive test strategies to ensure data accuracy and completeness.
- Test and verify ETL pipelines from various data sources (structured and unstructured) into data warehouses, ensuring data conforms to business rules and logic.
- Implement automated ETL testing frameworks and continuously improve them to optimize the data validation process.
- Data Reconciliation:
- Develop, implement, and automate test scripts to validate data integrity between source and target systems.
- Identify and resolve data inconsistencies, mismatches, and errors in large datasets.
- Design and execute reconciliation processes to ensure accurate data migration and transformation.
Nice to have:
- Experience with HiveQL for Hive Database
- Experience with Python as a scripting language
Similar Jobs
Information Technology
Sell CDW Security services and products across the full sales lifecycle. Develop strategic account plans, build relationships with enterprise clients and partners, manage pipeline and forecasts in Salesforce, coordinate cross-functional resources, mentor junior sellers, represent CDW at events, and achieve bookings, revenue, and profit targets while tracking market trends and driving customer security program adoption.
Top Skills:
AICloud SecurityData PrivacyEmerging Security TechnologiesIdentity And Access ManagementPhysical SecuritySalesforceSecure InfrastructureThird-Party Risk ManagementThreat And Vulnerability Management
Information Technology
Sell CDW Security services and products, manage full sales lifecycle, develop strategic account plans, build and grow client and partner relationships, coordinate internal resources, maintain Salesforce pipeline and forecasts, mentor junior sellers, represent CDW at industry events, and meet bookings, revenue, and profit targets.
Top Skills:
AICloud SecurityCyber Workforce DevelopmentEmerging Security TechnologiesIdentity And Access ManagementPhysical SecurityPrivacyRisk And ComplianceSalesforceSecure InfrastructureThird-Party Risk ManagementThreat And Vulnerability Management
Information Technology
Sell CDW Security services and products through full sales lifecycle management: strategic account planning, opportunity qualification, relationship building, partnering with services and OEMs, pipeline forecasting, and closing. Mentor junior team members, engage partners and marketing, maintain Salesforce, represent CDW at industry events, and drive revenue, bookings, and gross profit targets.
Top Skills:
Salesforce
What you need to know about the Seattle Tech Scene
Home to tech titans like Microsoft and Amazon, Seattle punches far above its weight in innovation. But its surrounding mountains, sprinkled with world-famous hiking trails and climbing routes, make the city a destination for outdoorsy types as well. Established as a logging town before shifting to shipbuilding and logistics, the Emerald City is now known for its contributions to aerospace, software, biotech and cloud computing. And its status as a thriving tech ecosystem is attracting out-of-town companies looking to establish new tech and engineering hubs.
Key Facts About Seattle Tech
- Number of Tech Workers: 287,000; 13% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Amazon, Microsoft, Meta, Google
- Key Industries: Artificial intelligence, cloud computing, software, biotechnology, game development
- Funding Landscape: $3.1 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Madrona, Fuse, Tola, Maveron
- Research Centers and Universities: University of Washington, Seattle University, Seattle Pacific University, Allen Institute for Brain Science, Bill & Melinda Gates Foundation, Seattle Children’s Research Institute
