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

The Sherwin-Williams Company

3rd Shift CTS Maintenance Technician Bonus Eligible Job at The Sherwin-Williams Company

 ...The Sherwin-Williams Company is seeking a CTS Maintenance Technician to maintain the safe operating condition of our CTS trailer fleet. You will perform preventative maintenance, operate shop tools, and make repairs with limited supervision.This 3rd shift role runs Sunday... 

Amerifleet Transportation, Inc.

Full-Service Vehicle Delivery Driver Job at Amerifleet Transportation, Inc.

 ...is a field-based driving position. The position requires regular long-distance travel (up to a 150-mile radius), outdoor work in all weather conditions, and daily use of a company-issued smartphone. Drivers must be comfortable operating a variety of vehicle types and... 

YO AI Labs

Locum Tenens Hospitalist Remote Job at YO AI Labs

 ...Role Title: Locum Tenens Hospitalist Role Type: Contractor Location: United States Remote We are seeking experienced Locum Tenens Hospitalists to review adult inpatient medical records and clinical documentation for an AI training project ensuring clinical accuracy... 

Ibility

Organizational Change Management Demo Analyst Job at Ibility

Founded in early 2021, Ibility is a Service-Disabled Veteran-Owned Small Business and a Woman-Owned Small Business, headquartered in Gaithersburg, MD. Ibility is a small but mighty company that is positioned for rapid growth. Simply put, we help government leaders to achieve...

Auto-Chlor System

Equipment Installer Job at Auto-Chlor System

 ...Equipment InstallerAuto-Chlor System is immediately hiring for an Equipment Installer for our Memphis, TN location. Come be a part of a growing organization with a strong brand reputation that thrives off reliable customer service and exceptional products for over 80 years...