Software Engineer in Test

Hi Associate,

Greetings for the day,

We have a position for an SDET Engineer in Jersey City, NJ. Please find the job description below for this position.

Role: SDET Engineer

Locations: Jersey City, NJ

Duration: Fulltime

Job Summary:

We are seeking a highly skilled and detail-oriented Software Development Engineer in Test (SDET) to join our team with a focus on data reconciliationcomplex SQL, and ETL testing. The ideal candidate will have a unique blend of skills in software developmentquality 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

Thanks & Regards

Seerla Raju Reddy

Assistant Manager -HR

Photon Infotech Inc.

Mobile no: +1-573-539-0386

Desk No: +1-469-501-1067 Ext: 303

seerla.raju@photon.com