ETL Testers
Role details
Job location
Tech stack
Requirements
Primary Skill: ETL testing
Secondary: ETL Testing, Autosys, SQL, Shell Scripting, Exposure to IDMC/Informatica
Experience: Minimum 10 years
Roles & Responsibilities
*Analyze data mapping documents and business requirements to design comprehensive test plans and cases.
*Perform source-to-target data reconciliation, check data loading, and ensure transformation rules are applied correctly.
*Write complex SQL scripts for validation (count, data completeness, data consistency, data truncation).
*Identify, log, and track data defects using tools like JIRA or HP ALM or Octane.
*Automate test scripts and validate data volume, performance, and scalability.
*Expert-level knowledge of SQL for data analysis.
*Experience with tools such as Informatica and IDMC.
*Understanding of data warehouse concepts and architectures (e.g., star/snowflake schema).
*Familiarity with Hadoop or Spark is often preferred.
*Validate HiveQL, HDFS file structures, and data processing within the Hadoop cluster.
*Strong analytical and troubleshooting skills.
*Excellent communication for collaborating with developers and stakeholders.
*Knowledge in Metadata dependent ETL process and batch/job framework
