ETL Tester
Charlotte, NC
Fulltime
Face to face is must
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.
...have been telling their family stories for centuries, connect researchers and data partners with people seeking answers to family history... ...in North Carolina, South Carolina, or Georgia, and is a remote opportunity. American Ancestors offers outstanding benefits...
...mornings or afternoons (7a-12p or 12-5p etc) Reliable transportation and driver's license At least 18 years of age and have a High School Diploma or GED Comfortable working in homes with dogs and/or cats Working Conditions and Requirements: Work environment...
...and Basecamp (preferred).* The availability to work 40 hours per week from 9:00 am to 6:00 pm PST.* The ability to adapt in a diverse... ..._California, New York, Washington, and Colorado: starting base pay for this position ranges between $15 - $35 per hour. Compensation...
...care that utilizes medication management, TMS and ketamine therapy in a supportive, patient focused environment. The Role: Psychiatric Nurse Practitioner (PMHNP) | Lakewood, CO At Serenity Healthcare, we provide a broad variety of treatment options, amazing clinical...
The J.R. Simplot Company is a diverse, privately held global food and agriculture company headquartered in Boise, Idaho. We are a true farm-to-table company with an integrated portfolio including food processing and food brands, phosphate mining, fertilizer manufacturing...