ETL Tester
Core
Develop test plans and cases, reconcile source/target data, and validate data loads and transformations within data warehousing environments.
Role type
Senior ETL Tester (Data Quality)
Builds
Validated data loads and transformation rules for data warehouses
Domain
Data Warehousing / Banking and Payments
Required skills
ETL testing, Autosys, SQL (Expert), Shell scripting, Informatica IDMC, Data Warehousing concepts, Metadata management, Batch/job frameworks, Hadoop/Hive/Spark
Preferred skills
Banking and payments domain knowledge
Technologies
Informatica, IDMC, Hive, Kafka, Oracle, SQL, Snowflake, Spark, Hadoop, JIRA
Responsibilities
Analyze data mapping documents and business requirements to develop test plans and test cases. Reconcile source and target data, verify data loads, and confirm transformation rules are applied correctly. Write complex SQL validation scripts to check counts, completeness, consistency, and truncation. Identify, record, and track data defects using tools such as JIRA, Client ALM, or Octane. Automate test scripts and validate data volume, performance, and scalability. Validate HiveQL, HDFS file structures, and data processing within Hadoop clusters.