SDET Engineers - Jersey City

Photon$90K — $120K *
Information Technology
Less than 5 years of experience
Job Overview by Ladders

Qualifications

  • 5+ years of experience in software development or quality assurance.
  • Strong expertise in SQL, with the ability to write complex queries.
  • Proficiency in ETL processes and data validation techniques.
  • Experience in automation frameworks for testing data applications.
  • Solid understanding of data engineering concepts and practices.

Responsibilities

  • Write and optimize complex SQL queries for data validation.
  • Perform root cause analysis on data discrepancies.
  • Develop automated SQL scripts for data reconciliation.
  • Design comprehensive test strategies for ETL processes.
  • Test and verify data from various sources into data warehouses.
  • Implement and improve automated ETL testing frameworks.
  • Develop test scripts for validating data integrity across systems.

Benefits

  • Opportunity to work with cutting-edge data technologies.
  • Collaborative and innovative team environment.
  • Professional development and training opportunities.
  • Flexible working hours and remote work options.
  • Access to internal resources for skill enhancement.
Full Job Description
Job Description

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

About Photon

Photon Careers

Joining Photon presents an unparalleled opportunity to advance one's career with a leader in digital innovation. Photon is actively seeking talented individuals to join its diverse team of professionals, dedicated to reshaping industries through technology and creativity.

Explore Job Opportunities

Photon offers a variety of job opportunities that cater to a range of skills and interests. Each position at Photon is designed to challenge team members while providing meaningful pathways for professional and personal growth.

Experience the Culture and Benefits

Photon is committed to fostering a workplace culture that promotes diversity and inclusion. The company provides comprehensive benefits designed to support the health, well-being, and financial security of each team member. At Photon, every professional enjoys access to career development programs and diversity training, ensuring they are equipped for leadership roles in an evolving marketplace.

Engage in Professional Growth

Photon believes in the power of innovation and leadership to drive success. The company supports its team members with resources for continuous learning and growth, including advanced training sessions and leadership workshops. Networking within Photon’s industry-leading community allows for unparalleled career advancement and skill enhancement.

Internship Programs

For those beginning their professional journey, Photon offers internship programs that provide a robust foundation in digital solutions. Internships at Photon are characterized by immersive projects and hands-on learning, guided by experts in various fields. These programs are a gateway to full-time employment and a promising career path.

Join the Team

Photon is hiring! Explore open positions that match your skills and interests. Photon looks for passionate, curious, creative, and solution-driven team players. Whether you are starting your career or looking to make a significant impact in your professional journey, Photon has a place for you.

Prepare for Your Interview

Photon values a thorough selection process. Prospective team members are encouraged to prepare by understanding the company’s mission and values. Tailoring your resume to highlight relevant experience and skills will make a significant difference. Engage actively during your interview, demonstrating your knowledge and enthusiasm for the role you are applying for.

Stay Connected

Keep up to date with the latest from Photon by following the company’s career blog. Gain insights from insiders, learn about new job openings, and get tips on preparing your resume and acing your interview.

Career Development at Photon

Photon is dedicated to the professional development of its team members. The company offers various tools and resources, including career coaching and performance feedback, to help individuals reach their full potential. With Photon, career aspirations are nurtured, encouraging every team member to excel and innovate in their respective roles.

Networking and Career Opportunities

Photon encourages its team members to engage in networking within the company and the broader industry. These connections can lead to myriad opportunities, from collaborative projects to mentorship. Networking at Photon is not just about building professional relationships; it's about fostering a community of innovation and mutual growth.

Conclusion

Photon is not just a company; it is a community of driven professionals committed to making a difference. With a focus on innovation, leadership, and diversity, Photon offers a dynamic environment where ambitious individuals can thrive. Explore the possibilities and join Photon’s team of leaders, innovators, and visionaries.
Learn more about Photon

Similar Jobs

More Jobs at Photon

More Information Technology Jobs

Find similar SDET Engineers - Jersey City jobs: