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
Digital Media • Information Technology • News + Entertainment
Field-based enterprise seller responsible for developing territory strategy, prospecting and closing mid-market and enterprise multi-location accounts. Delivers face-to-face presentations, builds partner relationships, positions Comcast Business solutions, ensures customer retention, and meets/exceeds financial targets while coordinating with internal teams.
Top Skills:
23)Business ContinuityCustomer Premise Equipment (Cpe)CybersecurityDisaster RecoveryEthernetLanMan (Metropolitan Area Network)Network SecurityNetworking Protocols (Layers 1Sd-WanVoipVpnWanWdm
Digital Media • Information Technology • News + Entertainment
Design, develop, and deploy microservices and ETL applications for a SaaS cybersecurity platform. Collaborate with product, UX, DevOps, and architects to implement features, support production deployments, triage customer issues, and build reusable components while applying DevSecOps practices and production incident mitigation tools.
Top Skills:
Apache IcebergContent Management SystemsData LakeDevsecopsDockerETLGitGoJIRAMicroservicesPythonSaaSUnit Test Frameworks
Digital Media • Information Technology • News + Entertainment
Lead and scale a national Inside Enterprise Account Management organization to drive expansion, retention, and multi-product adoption for enterprise customers under $3,500 monthly telco spend. Set strategy, coverage models, quotas, and operating rhythms; coach managers and account teams; partner cross-functionally to remove barriers; and own performance versus revenue, retention, and customer experience goals.
Top Skills:
Advanced VoiceBroadbandCybersecurityManaged ServicesMetro EthernetSecurity
What you need to know about the Charlotte Tech Scene
Ranked among the hottest tech cities in 2024 by CompTIA, Charlotte is quickly cementing its place as a major U.S. tech hub. Home to more than 90,000 tech workers, the city’s ecosystem is primed for continued growth, fueled by billions in annual funding from heavyweights like Microsoft and RevTech Labs, which has created thousands of fintech jobs and made the city a go-to for tech pros looking for their next big opportunity.
Key Facts About Charlotte Tech
- Number of Tech Workers: 90,859; 6.5% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Lowe’s, Bank of America, TIAA, Microsoft, Honeywell
- Key Industries: Fintech, artificial intelligence, cybersecurity, cloud computing, e-commerce
- Funding Landscape: $3.1 billion in venture capital funding in 2024 (CED)
- Notable Investors: Microsoft, Google, Falfurrias Management Partners, RevTech Labs Foundation
- Research Centers and Universities: University of North Carolina at Charlotte, Northeastern University, North Carolina Research Campus
