$100,000–$120,000 Per Year
Analysis Skills, Apache Hadoop, Apache Spark, Apiary/Beekeeping, Atlassian JIRA, Banking Services, Bug Tracking/Defect Management, CA Workload Automation AE (AutoSys Edition), Communication Skills, Data Analysis, Data Mapping, Data Processing, Data Quality, Data Warehousing, Database Extract Transform and Load (ETL), HDFS (Hadoop Distributed File System), Hewlett-Packard Product Family, Identify Issues, Informatica, Metadata, Oracle Database, Oracle PL-SQL, Reconciliation, SQL (Structured Query Language), Scripting (Scripting Languages), Snowflake Schema, Star Schema, Test Automation, Test Case, Test Design, Test Scripts, Testing, Unix Shell Programming
ETL Tester
Must Have Technical/Functional Skills
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
Tools & Skills:
IDMC, Informatica Power center, Hive, Kafka Knowledge
SQL, Oracle, PL/SQL
Domain: Banking knowledge, Payments knowledge preferred.
Concept: Data Warehousing, Data Transformation, ETL/ELT, Data Quality.
Salary Range- $100,000-$120,000 a year
T
Tata Consultancy Services Ltd