> Markdown version of [/jobs/ext/974900-etl-tester](https://www.wearedevelopers.com/jobs/ext/974900-etl-tester). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# ETL Tester

- **Company:** Stanley David and Associates
- **Location:** Charlotte, NC, United States
- **Experience:** Expert
- **Contract:** Permanent contract
- **Skills:** Data Analysis, CA Workload Automation Ae, Extract Transform Load (ETL), Data Transformation, Data Warehousing, Apache Hadoop, Hadoop Distributed File System, Apache Hive, Metadata, Oracle (Applications), Shell Script, PL-SQL, SQL Databases, Data Processing, Apache Spark, Test Scripts, Hp Alm, Apache Kafka
- **Published:** June 9, 2026
- **Apply:** https://www.dice.com/job-detail/bb2f946a-737d-404c-9d74-27939fce133c

## About the Role

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.



## Related Videos

- [A Data Mesh needs Open Metadata](https://www.wearedevelopers.com/videos/505-a-data-mesh-needs-open-metadata)
- [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering)
- [Crafting Custom Frameworks with Rust: A Deep Dive into Procedural Macros](https://www.wearedevelopers.com/videos/849-crafting-custom-frameworks-with-rust-a-deep-dive-into-procedural-macros)
- [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt)
- [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works)
- [Bringing Clarity to Event Streams: Enabling Analytics and AI Through Rich Metadata](https://www.wearedevelopers.com/videos/1616-bringing-clarity-to-event-streams-enabling-analytics-and-ai-through-rich-metadata)

## Related Articles

- [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know)
- [The 8 Best Code Testing Tools](https://www.wearedevelopers.com/magazine/402-the-8-best-code-testing-tools)
- [Integration And E2E Testing: Are They Complementary or Interchangeable?](https://www.wearedevelopers.com/magazine/86-integration-and-e2e-testing-are-they-complementary-or-interchangeable)
- [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story)
- [Benefits of Using JMeter For Performance Testing](https://www.wearedevelopers.com/magazine/96-benefits-of-using-jmeter-for-performance-testing)
- [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers)