Find The RightJob.
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-$130,000 a year
Location
Charlotte, NC
Job Function
TECHNOLOGY
Role
Analyst
Job Id
416714
Desired Skills
Automation Testing
Salary Range
$100,000-$130,000 a year
Similar jobs
No similar jobs found
© 2026 Qureos. All rights reserved.