What are the responsibilities and job description for the ETL / Data Test Engineer – Automotive & Connected Vehicle position at Bizoforce - The Innovation Platform Accelerating Digital Solutions for Enterprises?
Job Title - ETL / Data Test Engineer – Automotive & Connected Vehicle
Hiring: Automotive Data Test Engineer – Connected Vehicles & Telematics
Location: Lewisville, TX Onsite
Experience: 4–8 Years
Domain: Automotive | Connected Vehicles | Telematics
We are looking for an experienced Automotive Data Test Engineer with strong expertise in ETL/ELT testing, data pipeline validation, SQL, Python, API testing, and cloud-based data platforms. The ideal candidate will have hands-on experience validating high-volume data flows within automotive, connected vehicle, or telematics environments.
The role involves ensuring the accuracy, completeness, reliability, and performance of vehicle-to-cloud data pipelines across ingestion, processing, storage, and consumption layers.
Key Responsibilities
- Validate end-to-end vehicle-to-cloud data pipelines across ingestion, processing, storage, and consumption layers.
- Perform source-to-target validation of ETL/ELT workflows, data mappings, transformation rules, reconciliation, and exception handling.
- Test batch and near-real-time data processing for accuracy, completeness, sequencing, duplication, latency, and data loss.
- Validate automotive datasets, including vehicle health, GPS/location, fuel consumption, driver behavior, diagnostic trouble codes (DTCs), powertrain, EV battery, and over-the-air (OTA) campaign data.
- Test REST APIs, microservices, and integrations across vehicle systems, telematics platforms, cloud services, enterprise applications, and analytics solutions.
- Validate Kafka topics, producers, consumers, connectors, and event-streaming workflows.
- Develop and maintain reusable data-validation scripts and automated testing utilities using Python, SQL, and PyTest.
- Execute functional, integration, regression, database, data migration, and production-readiness testing.
- Prepare test strategies, test plans, test cases, test data, traceability matrices, defect reports, and test completion reports.
- Collaborate with engineering, data, cloud, and product teams in Agile/Scrum and DevOps environments.
- Perform defect triage, root-cause analysis, and continuous quality improvement.
Required Skills & Experience
- 4–8 years of experience in Data Testing, ETL Testing, Data Engineering Testing, or Quality Engineering.
- Strong hands-on SQL skills, including complex queries, joins, reconciliation, and database validation.
- Experience testing ETL/ELT pipelines, data warehouses, data lakes, and high-volume data platforms.
- Working knowledge of Python and test automation frameworks such as PyTest.
- Hands-on experience with REST API testing using Postman or equivalent tools.
- Knowledge of Apache Kafka or comparable event-streaming platforms.
- Experience with relational databases such as PostgreSQL, SQL Server, or MySQL.
- Exposure to AWS, Microsoft Azure, or Google Cloud Platform (GCP).
- Strong understanding of data-quality dimensions, including accuracy, completeness, consistency, uniqueness, validity, and timeliness.
- Understanding of Agile/Scrum methodologies and DevOps delivery practices.
Automotive & Connected Vehicle Domain Knowledge
Candidates should have knowledge or experience in the following areas:
- Connected vehicle and telematics platforms.
- Vehicle-to-cloud data flows and vehicle signal data.
- Vehicle diagnostics and Diagnostic Trouble Codes (DTCs).
- Over-the-Air (OTA) software and firmware updates.
- CAN/CAN-FD and UDS diagnostics.
- Fleet management and commercial or passenger vehicle platforms.
- Software-Defined Vehicle (SDV) concepts.
Good-to-Have Technical Skills
- Snowflake and Databricks.
- AWS S3, Lambda, Glue, and IAM.
- Azure Data Factory or equivalent data integration tools.
- GitHub, GitHub Actions, CI/CD, and DevOps tooling.
- MongoDB or other NoSQL databases.
- Power BI or Tableau data validation.
- Performance testing of data pipelines.
- Exposure to Digital Twin technologies and AI/ML data validation.
Preferred Qualifications
- Bachelor's degree in Computer Science, Information Technology, Data Engineering, Electronics, Automotive Engineering, or a related discipline.
- ISTQB certification preferred.
- AWS, Azure, GCP, Snowflake, or Databricks certifications are an advantage.
- Experience with automotive OEMs, Tier-1 suppliers, or commercial vehicle organizations is desirable.
- Awareness of ISO/SAE 21434, UNECE R155, and UNECE R156 is an added advantage.
Key Competencies
- Strong analytical thinking and structured problem-solving skills.
- Excellent attention to detail and a data-quality mindset.
- Effective debugging, defect triage, and root-cause analysis capabilities.
- Ownership of testing deliverables and quality outcomes.
- Strong communication and cross-functional collaboration skills.
Interested candidates: Please share your updated resume along with your total experience, relevant data-testing experience, automotive/connected vehicle domain experience, current location, notice period, and contact details.
If you have the right combination of Data Testing SQL/Python Automotive/Connected Vehicle expertise, we would love to hear from you!