ETL Tester

Posted 2 Days Ago
Be an Early Applicant
India
Junior
Professional Services
The Role
As an ETL Tester, you will ensure the quality of data processed through ETL systems by designing test cases, collaborating with stakeholders, performing data validation, and monitoring ETL jobs for discrepancies. You'll be responsible for maintaining documentation and conducting regression testing to uphold data integrity and compliance standards.
Summary Generated by Built In

Description

We are seeking a dedicated and detail-oriented ETL Tester to join our dynamic team. As an ETL Tester, you will play a crucial role in ensuring the quality and integrity of data processed through our extraction, transformation, and loading (ETL) systems. Your expertise will contribute to the successful implementation and maintenance of data warehousing solutions, empowering our organization to make data-driven decisions effectively. The ideal candidate is someone with a strong background in ETL testing methodologies and an understanding of data integration processes. You will be responsible for collaborating closely with data engineers, business analysts, and other stakeholders to validate data flows, perform data quality checks, and verify the accuracy of reports generated from our data warehouses. In this role, you will utilize your analytical skills and attention to detail to identify discrepancies, troubleshoot issues, and ensure compliance with data governance standards. We value individuals who are proactive, possess excellent communication skills, and have a strong problem-solving mindset. If you are passionate about working with data and ensuring its accuracy and reliability, we encourage you to apply for this exciting opportunity to make a significant impact in our organization.

Responsibilities:

  • Design and execute test cases for ETL processes to ensure data accuracy and completeness.
  • Collaborate with data engineers and business analysts to understand data requirements and specifications.
  • Perform data profiling and validation to check data quality across various sources.
  • Identify, report, and track defects or issues in the ETL processes and data outputs.
  • Conduct regression testing to ensure existing functionalities remain intact after updates or changes.
  • Monitor ETL jobs and analyze logs to detect failures or anomalies in data processing.
  • Prepare and maintain test documentation, including test plans, test cases, and defect reports.
Requirements
  • Bachelore's in Degree in Computer Science, Information Technology, or a related field.
  • Proven experience as an ETL Tester or similar role in data testing.
  • Strong understanding of ETL processes and data warehousing concepts.
  • Proficiency in SQL for data manipulation and validation.
  • Must have hands-On experience backend /front end enterprise applications.
  • Must have SQL or PL/SQL knowledge using Oracle.
  • Must have Agile life cycle experience.
  • Must have knowledge on Web UI testing and workflows.
  • Must have Power BI/Report testing experience.
  • Must have financial reports knowledge
  • Automation knowledge will be an advantage.
  • Good to have experience using Hadoop (Hive/Impala)/Spark SQL.
  • Good to have hands on experience with writing complex Spark queries for HDFS/Parquet files validation
  • Data bricks/synapse hands knowledge will be an advantage.

Top Skills

Hadoop
Pl/Sql
Spark Sql
SQL
The Company
Atlanta, GA
409 Employees
On-site Workplace
Year Founded: 2006

What We Do

ProArch was founded on the belief that a future where change is ‘business as usual’ is fundamentally more exciting than one where it is not.

We accelerate value and increase resilience for our clients with consulting and technology - enabled by cloud, guided by data, fueled by apps, and secured by design

Similar Jobs

Cisco Meraki Logo Cisco Meraki

Senior Wireless Driver Engineer - 6+yrs - C/C++ programming, WiFi drivers/SDK

Hardware • Information Technology • Security • Software • Cybersecurity • Conversational AI
Easy Apply
Remote
Bengaluru, Karnataka, IND
3000 Employees

Atlassian Logo Atlassian

Senior Software Engineer, Anti Abuse

Cloud • Information Technology • Productivity • Security • Software • App development • Automation
Remote
Bengaluru, Karnataka, IND
11000 Employees

Roblox Logo Roblox

Sr Manager, Data Engineering

Computer Vision • Gaming • Software • Virtual Reality • Web3 • Metaverse
Remote
India
2500 Employees

Magna International Logo Magna International

SW Sr Engineer-Functions - GPU, ISP and Algo

Automotive • Hardware • Robotics • Software • Transportation • Manufacturing
Hybrid
Bangalore, Bengaluru, Karnataka, IND
171000 Employees

Similar Companies Hiring

ABN AMRO Clearing USA LLC Thumbnail
Professional Services • Information Technology • Financial Services
Chicago, IL
215 Employees
Energy CX Thumbnail
Utilities • Professional Services • Greentech • Financial Services • Energy • Consulting • Business Intelligence
Chicago, IL
55 Employees
Jobba Trade Technologies, Inc. Thumbnail
Software • Professional Services • Productivity • Information Technology • Cloud
Chicago, IL
45 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account