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
Artificial Intelligence • Cloud • Computer Vision • Hardware • Internet of Things • Software
Own and optimize Samsaras identity infrastructure (Okta, Google Workspace, Workato). Design and support integrations/automations, lead IAM initiatives, ensure StateRAMP/FedRAMP compliance, provide Tier 3 escalation, document runbooks, and partner with Security and GRC to strengthen identity security.
Top Skills:
GCPGemini EnterpriseGoogle Apps Manager (Gam)Google WorkspaceIgaOktaOkta WorkflowsOwl-ItPamPythonRest ApisSaviyntScimSplunkTerraformVertex AiWorkatoWorkato Connector SdkWorkato One
.png)
Artificial Intelligence • Blockchain • Fintech • Financial Services • Cryptocurrency • NFT • Web3
Design, build, and operate backend systems for prediction markets, including order management, trade matching, settlement, and market resolution. Architect distributed, low-latency systems with strict financial correctness, lead multi-quarter technical projects, mentor engineers, and collaborate with Product, Compliance, and Risk to meet regulatory requirements.
Top Skills:
Generative AiGoJava
Artificial Intelligence • Blockchain • Fintech • Financial Services • Cryptocurrency • NFT • Web3
Lead end-to-end design for Coinbase's CX products (Help Center, Chatbot, Voicebot, in-app Concierge). Define AI-powered support UX, build reusable pattern libraries, drive MVPs and future-state concepts, partner with product/engineering/operations, translate Concierge revenue goals into experience, and generate insights from customers and agents to improve automation and satisfaction.
Top Skills:
ChatbotConversational UiDesign SystemFigmaGenerative AiPrototyping ToolsVoicebot
What you need to know about the Boston Tech Scene
Boston is a powerhouse for technology innovation thanks to world-class research universities like MIT and Harvard and a robust pipeline of venture capital investment. Host to the first telephone call and one of the first general-purpose computers ever put into use, Boston is now a hub for biotechnology, robotics and artificial intelligence — though it’s also home to several B2B software giants. So it’s no surprise that the city consistently ranks among the greatest startup ecosystems in the world.
Key Facts About Boston Tech
- Number of Tech Workers: 269,000; 9.4% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Thermo Fisher Scientific, Toast, Klaviyo, HubSpot, DraftKings
- Key Industries: Artificial intelligence, biotechnology, robotics, software, aerospace
- Funding Landscape: $15.7 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Summit Partners, Volition Capital, Bain Capital Ventures, MassVentures, Highland Capital Partners
- Research Centers and Universities: MIT, Harvard University, Boston College, Tufts University, Boston University, Northeastern University, Smithsonian Astrophysical Observatory, National Bureau of Economic Research, Broad Institute, Lowell Center for Space Science & Technology, National Emerging Infectious Diseases Laboratories
