What are the responsibilities and job description for the ETL QA Tester position at R Systems, Inc.?
Job Details
Position: ETL QA Tester
Location: Jersey City, NJ- Onsite: 2 days per week (Hybrid)
Duration: 12 Months (Starting April 1st)
About R Systems:
R Systems is a leading digital product engineering company that designs and develops chip-to-cloud software products, platforms, and digital experiences that empower its clients to achieve higher revenues and operational efficiency. Our product mindset and engineering capabilities in Cloud, Data, AI, and CX enable us to serve key players in the high-tech industry, including ISVs, SaaS, and Internet companies, as well as product companies in telecom, media, finance, manufacturing, and health verticals.
We Are Great Place to Work Certified in 10 countries with a full-time workforce [India, USA, Canada, Poland, Romania, Moldova, Indonesia, Singapore, Malaysia & Thailand]!
We are recognized as one of the Best Tech Brands 2024 by the Times Group and India's Top 500 Value Creators 2023 by Dun & Bradstreet.
Company Link:
Job Requirement:
Job Summary:
We are seeking a meticulous ETL QA Tester with strong SQL skills and experience in Data warehouse ETL testing to ensure data integrity, accuracy, and completeness throughout our data transformation processes.
Key Responsibilities:
Design, develop, and execute ETL test cases to validate data extraction, transformation, and loading processes.
Write and execute complex SQL queries to perform data validation and back-end testing.
Identify, report, and track defects systematically.
Participate in project meetings and collaborate with developers to resolve the issues
Clarify requirements when necessary and ensure comprehensive coverage of all requirements in the testing process.
Required Skills & Qualifications:
Must-have: Strong SQL skills with hands-on experience in writing and optimizing complex queries.
Experience in ETL Testing: Understanding of data extraction, transformation, and loading (ETL) processes.
Knowledge of Agile Methodologies and Defect Tracking Tools: Familiarity with Agile development processes and proficiency in using defect tracking tools like JIRA.
Data Validation & Reconciliation: Ability to compare large datasets between sources and targets.
Experience with SQL DBMS Tools: Knowledge of database management systems such as Oracle, Azure Databricks, Denodo.
Familiarity with data warehouses and data lake is required.
Strong analytical and problem-solving skills with attention to detail.
Excellent communication skills with the ability to work in a collaborative and fast-paced environment.
Nice to Have:
Knowledge of Python is an advantage.
Knowledge of Azure Databricks is a great plus.
Familiarity with cloud platforms (AWS, Azure, Google Cloud Platform) and their data services is a plus.
Why Join R Systems?
If you are passionate and excited about working in a fast-paced, innovative environment, we would love to hear from you!
R Systems is an equal opportunity employer that does not discriminate against any employee or job applicant because of race, color, religion, national origin, sex, physical or mental disability, age, or any other characteristic protected by law. We strive to build a team that reflects the diverse communities we serve, and we actively encourage applications from individuals of all backgrounds and experiences. Our commitment to equal opportunity extends to all aspects of employment, including recruitment, hiring, training, promotion, and benefits.
#LI-RC1
Location: Jersey City, NJ- Onsite: 2 days per week (Hybrid)
Duration: 12 Months (Starting April 1st)
About R Systems:
R Systems is a leading digital product engineering company that designs and develops chip-to-cloud software products, platforms, and digital experiences that empower its clients to achieve higher revenues and operational efficiency. Our product mindset and engineering capabilities in Cloud, Data, AI, and CX enable us to serve key players in the high-tech industry, including ISVs, SaaS, and Internet companies, as well as product companies in telecom, media, finance, manufacturing, and health verticals.
We Are Great Place to Work Certified in 10 countries with a full-time workforce [India, USA, Canada, Poland, Romania, Moldova, Indonesia, Singapore, Malaysia & Thailand]!
We are recognized as one of the Best Tech Brands 2024 by the Times Group and India's Top 500 Value Creators 2023 by Dun & Bradstreet.
Company Link:
Job Requirement:
Job Summary:
We are seeking a meticulous ETL QA Tester with strong SQL skills and experience in Data warehouse ETL testing to ensure data integrity, accuracy, and completeness throughout our data transformation processes.
Key Responsibilities:
Design, develop, and execute ETL test cases to validate data extraction, transformation, and loading processes.
Write and execute complex SQL queries to perform data validation and back-end testing.
Identify, report, and track defects systematically.
Participate in project meetings and collaborate with developers to resolve the issues
Clarify requirements when necessary and ensure comprehensive coverage of all requirements in the testing process.
Required Skills & Qualifications:
Must-have: Strong SQL skills with hands-on experience in writing and optimizing complex queries.
Experience in ETL Testing: Understanding of data extraction, transformation, and loading (ETL) processes.
Knowledge of Agile Methodologies and Defect Tracking Tools: Familiarity with Agile development processes and proficiency in using defect tracking tools like JIRA.
Data Validation & Reconciliation: Ability to compare large datasets between sources and targets.
Experience with SQL DBMS Tools: Knowledge of database management systems such as Oracle, Azure Databricks, Denodo.
Familiarity with data warehouses and data lake is required.
Strong analytical and problem-solving skills with attention to detail.
Excellent communication skills with the ability to work in a collaborative and fast-paced environment.
Nice to Have:
Knowledge of Python is an advantage.
Knowledge of Azure Databricks is a great plus.
Familiarity with cloud platforms (AWS, Azure, Google Cloud Platform) and their data services is a plus.
Why Join R Systems?
- Frequent Internal Hackathons: Engage in dynamic competitions with exciting prizes to keep your skills sharp.
- Cultural Celebrations: Strengthen our familial bonds through shared celebrations, fostering a sense of community.
- Diverse Project Exposure: Work on a variety of projects across sectors like Healthcare, Banking, e-commerce, and Retail, collaborating with leading global brands.
- Centre of Excellence (COE): Benefit from technical guidance and upskilling opportunities provided by our team of technology experts, helping you navigate your career path.
- E-Learning Platform: Gain access to comprehensive e-learning platforms coupled with a robust mentorship program to enhance your skills.
- Open Door Policy: Embrace a culture of mutual support, respect, and open dialogue, promoting a collaborative work environment.
If you are passionate and excited about working in a fast-paced, innovative environment, we would love to hear from you!
R Systems is an equal opportunity employer that does not discriminate against any employee or job applicant because of race, color, religion, national origin, sex, physical or mental disability, age, or any other characteristic protected by law. We strive to build a team that reflects the diverse communities we serve, and we actively encourage applications from individuals of all backgrounds and experiences. Our commitment to equal opportunity extends to all aspects of employment, including recruitment, hiring, training, promotion, and benefits.
#LI-RC1
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
