ETL+API Testing

Key Responsibilities:

ETL Testing:

• Validate end-to-end ETL workflows, including data extraction, transformation, and loading processes

• Write complex SQL queries to verify data integrity, accuracy, and quality across multiple stages

• Perform data validation between source and target systems (e.g., flat files, databases, data lakes)

• Collaborate with data engineers to understand transformation logic and business rules

• Conduct regression, smoke, and functional testing on data pipelines

• Perform root cause analysis for data discrepancies and anomalies

API Testing:

• Test RESTful APIs for functionality, reliability, performance, and security

• Validate API request/response formats (JSON, XML), HTTP methods, and status codes

• Develop and execute automated API test scripts using tools like Postman, SoapUI, Rest Assured, or Karate

• Integrate API tests into CI/CD pipelines for continuous validation

• Collaborate with developers and product teams to define test strategies and acceptance criteria