Technical Lead, IT​/Tech, Data Engineer

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