ETL Tester

1 month ago

Jersey City, United States Photon Full time

ETL Tester with SQL

Jersey City, NJ

No. Of positions: 5

Fulltime in Photon


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 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.

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.

  • ETL Tester

    4 weeks ago

    Jersey City, New Jersey, United States Expedite Technology Solutions LLC Full time

    The Role:As a seasoned ETL Tester, you will leverage your expertise in creating test plans, building and executing test cases through SQL and Unix scripts. You will apply testing standards, guidelines, and methodologies to meet project testing objectives. Your responsibilities will include consolidating testing results, identifying and flagging defects or...

  • Data Warehouse ETL Tester

    4 weeks ago

    Jersey City, New Jersey, United States Expedite Technology Solutions LLC Full time

    Job Summary:The Expedite Technology Solutions LLC is seeking a highly skilled Data Warehouse ETL Tester to join our team. As an ETL Tester, you will be responsible for creating test plans, building and executing test cases through SQL and UNIX scripts. You will apply testing standards, guidelines, and testing methodology to meet project testing objectives....

  • ETL Automation Specialist

    4 weeks ago

    Jersey City, New Jersey, United States Photon Full time

    ETL Tester Job DescriptionAbout the Role:We are seeking an experienced ETL Tester to join our team at Photon. As an ETL Tester, you will be responsible for testing and validating the integration of data from various sources into our systems.Key Responsibilities:Design and execute automated test scripts using Selenium, RestAssured, and PACT.IO Java...

  • SDET Engineer

    4 weeks ago

    Jersey City, New Jersey, United States Photon Full time

    We are seeking a highly skilled and detail-oriented Software Development Engineer in Test (SDET) to join our Digital Engineering team at Photon. The ideal candidate will have a unique blend of skills in software development, quality assurance, and data engineering.Key Responsibilities:Complex SQL Queries:Write and optimize complex SQL queries to validate...

  • Data Integration Specialist

    4 weeks ago

    Jersey City, New Jersey, United States Hays Recruitment Full time

    Job Title: ETL TesterWe are seeking a skilled ETL Tester to join our team at Hays Recruitment. As an ETL Tester, you will be responsible for testing and validating the extraction, transformation, and loading of data into our systems.Key Responsibilities:Test and validate ETL processes to ensure data accuracy and integrityDevelop and maintain test scripts and...

  • ETL Tester

    1 month ago

    Jersey City, United States Photon Full time

    Description for Internal Candidates •Must have experience in UI and API automation testing•Creating automated test scripts with Selenium/restAssured/PACT.IO Java libraries•Must have experience in XML and JSON request and response parsing, integrating databases like MongoDB•Experience in testing platform services applications which are consumed by...

  • ETL Tester

    1 month ago

    jersey city, United States Photon Full time

    Description for Internal Candidates •Must have experience in UI and API automation testing•Creating automated test scripts with Selenium/restAssured/PACT.IO Java libraries•Must have experience in XML and JSON request and response parsing, integrating databases like MongoDB•Experience in testing platform services applications which are consumed by...