Jobs

Interviews
Job Alerts
Tools

Upskill and Grow with AI

Mock Interview Practice interviews in realistic simulations

Coding Practice Improve your coding skills with challenges

Certification Earn certifications to validate your skills

AI Learning Get trained with AI expert sessions

Career Path AI insights for smarter career decisions

AI Job Match Score AI-Powered Job Match Against Your Resume and Optimize Your Resume

Career Tools and Resources

Resume Builder Build Professional Resume with Ease

ATS Friendliness Check Check Resume Friendliness for Applicant Tracking Systems

Auto Apply Apply to hundreds of jobs on any platform effortlessly

Co-Pilot (Chrome Extension) Your AI Assistant for Seamless Browsing Efficiency

Interview Questions Streamline interviews with ready-to-use questions

Salaries Discover market-driven salary insights across skillsets and geographies

Companies Explore leading companies actively hiring talent
For Employers

Home
>
Jobs in chennai
>
Photon
>
SDET Engineer

SDET Engineer

Photon

2 - 6 years

8 - 12 Lacs

chennai bengaluru

Posted:-1 days ago| Platform:

Apply

Skills Required

python hive software development data pipelines business rules building automation data migration data engineering root cause analysis sql analytics data quality etl pipelines automation testing frameworks quality assurance etl

Work Mode

Work from Office

Job Type

Full Time

Job Description

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

More Jobs at Photon

Backend Java Developer

Chennai, Bengaluru, Hyderabad

8 - 12 yrs

INR 8 - 17 Lacs

Java Developer + Angular

Chennai, Bengaluru

4 - 9 yrs

INR 0 - 0 Lacs

Full Stack Developer

Chennai, Bengaluru

6 - 10 yrs

INR 16 - 19 Lacs

SDET Engineer

Chennai

7 - 12 yrs

INR 11 - 12 Lacs

Delivery Manger/Delivery Head

Chennai

14 - 24 yrs

INR 27 - 42 Lacs

Mock Interview

Practice Video Interview with JobPe AI

Start Python Interview

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.