ETL Test Analyst

Job Title:

Experience:

Location:

Seasoned Software Test Analyst

ETL Testing, Data Warehousing, SQL, Unix

Python scripting

Key Responsibilities

• Perform ETL and data validation testing across multiple databases and platforms.
• Write, review, and execute complex SQL queries to validate data transformations and migrations.
• Conduct backend and web automation using open-source tools such as Playwright, Pytest, Selenium, Rest Assured, Requests, Numpy, and Pandas.
• Execute API testing to ensure seamless integration and data consistency.
• Validate data flow and integrity in Data Warehouse environments (Oracle, Snowflake).
• Utilize Unix scripting for automation and data extraction processes.
• Work within cloud environments (AWS, Azure, or Snowflake) for validation and testing activities.
• Collaborate with development and QA teams to ensure end-to-end data quality.
• Implement and maintain test automation pipelines using CI/CD tools (e.g., Jenkins).
  

Preferred Skills

• Experience in Finance/Investment domain.
• Exposure to Java or JavaScript for automation scripting.
• Familiarity with modern testing frameworks and automation best practices.
  

Key Attributes

• Strong analytical and problem-solving ability.
• Excellent communication and documentation skills.
• Ability to work independently and manage priorities effectively.
  

Must Have Skills

• ETL Testing – Minimum 4 years of hands-on experience
• Data Warehouse Concepts – Strong practical understanding
• SQL – Ability to write and optimize complex queries
• Unix – Command-line and scripting knowledge
• Python – Minimum 1 year of hands-on experience