ETL Tester Job at United IT, Charlotte, NC

  • United IT
  • Charlotte, NC

Job Description

ETL TesterCharlotte, NC – OnsiteMust Have Technical/Functional SkillsPrimary Skill: ETL testingSecondary: ETL Testing, Autosys, SQL, Shell Scripting, Exposure to IDMC/InformaticaExperience: Minimum 10 yearsRoles & ResponsibilitiesAnalyze 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 frameworkTools & Skills:IDMC, Informatica Power center, Hive, Kafka KnowledgeSQL, Oracle, PL/SQLDomain: Banking knowledge, Payments knowledge preferred.Concept: Data Warehousing, Data Transformation, ETL/ELT, Data Quality.

Job Tags

Similar Jobs

Rendevor Dialysis

Dialysis Technician, CCHT Job at Rendevor Dialysis

 ...Job Description Job Description Who is Rendevor Dialysis? We are a family-owned and operated company founded over 30 years ago...  ...giveaways What Youll Do As a Certified Clinical Hemodialysis Technician (CCHT) , you will be utilizing your technical, and critical... 

Tremco

Stucco Professionals Job at Tremco

 ...by the Lead Tech, Foreman, or Supervisor. Skills & Qualifications: Minimum 3+ years of commercial caulking and waterproofing experience Commercial facade restoration experience Knowledge of EIFS systems, plastering techniques, and waterproofing... 

Alaka`ina Foundation Family of Companies

Security Escort Job at Alaka`ina Foundation Family of Companies

 ...Security Escort Location VA - Charlottesville Job Code 14494 Salary Range of openings 1 Apply Now ( Bering-Alaka`ina Holdings, LLC has a potential need for a Security Escort to provide support for our government customer in Charlottesville, VA. DESCRIPTION... 

Akron Children's Hospital

Risk Management Specialist Job at Akron Children's Hospital

 ...Full-Time 40 Hrs. Week Monday - Friday 8:00am- 4:30pm Hybrid Summary: The Risk Management Specialist supports the health system's risk management efforts by identifying, investigating, evaluating, and mitigating clinical and operational risks that... 

AmericanSitters.com

Looking for a mothers helper. Job at AmericanSitters.com

Looking for a Mothers HelperWe are looking for a reliable, caring, and helpful Mothers Helper to assist with everyday household tasks and make life a little easier for mom. The main focus is providing an extra set of hands around the house and helping things run smoothly...