ETL Tester

About the employer:

Our Client ranks at the top of the leading companies providing services at the highest level, allowing us to build modern and efficient businesses. The client's objective is to change business operational and technological models and adapt them to a rapidly changing world.

Responsibilities:

• interpret business and data requirements to create robust ETL testing strategies and plans,
• design and run test cases to verify the correctness of data extraction, transformation, and loading workflows,
• perform thorough source-to-target validation to confirm data consistency, accuracy, and completeness,
• validate transformation rules by analyzing discrepancies between expected and actual outcomes in staging and target environments,
• work closely with data engineers, developers, and analysts to clarify specifications and address any data-related issues,
• carry out data quality assessments to detect anomalies, missing records, or duplicates,
• utilize scripting languages or ETL testing tools to automate repetitive testing tasks,
• document and track defects using tools such as JIRA, HP ALM, or TestRail,
• maintain clear and detailed records of test plans, cases, and outcomes for reporting and compliance,
• conduct performance and scalability testing to evaluate how ETL processes manage large volumes of data,
• ensure that all testing practices align with established data governance and security protocols,
• contribute to CI/CD efforts by embedding ETL tests within automated deployment pipelines.

Requirements:

• strong SQL skills to craft complex queries for validating data across source, staging, and target systems,
• hands-on experience with ETL tools such as Informatica or IDMC,
• solid understanding of data warehousing principles and dimensional modeling, including star and snowflake schemas,
• familiarity with scripting languages like Python, Shell, or PowerShell for automation and data handling,
• experience using data profiling and quality tools to maintain accuracy, completeness, and consistency,
• ability to interpret and validate transformation logic and business rules across data pipelines,
• proficiency with test management platforms such as JIRA, HP ALM, TestRail, or Zephyr,
• knowledge of data comparison tools like QuerySurge or Datagaps for automated validations,
• basic knowledge of Azure cloud services, especially related to data,
• experience performing performance and volume testing on high-volume ETL processes,
• familiarity with CI/CD practices and integrating ETL testing within automated workflows,
• understanding of data governance principles and compliance frameworks such as GDPR or HIPAA,
• Nice to Have:
• hands-on experience with Azure data services,
• 3-5 years of experience in ETL testing or data quality assurance,
• certifications in ETL tools or cloud platforms,
• exposure to big data technologies such as Hadoop or Spark.

Our client offers:

• contract of employment or a B2B contract,
• for the contract of employment: extensive benefits package - Multisport Card, Lux Med medical healthcare including dental care, life insurance, cafeteria benefits,
• hybrid work model,
• training and continuous learning and certification opportunities.