ETL Tester Job at AceStack LLC, Charlotte, NC

  • AceStack LLC
  • Charlotte, NC

Job Description

ETL TesterLocation: Charlotte, NC/Plano, TXExperience: Minimum 10 yearsRoles and 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 & SkillsIDMC, Informatica Power center, Hive, Kafka KnowledgeSQL, Oracle, PL/SQLDomainBanking knowledge, Payment’s knowledge preferred.ConceptData Warehousing, Data Transformation, ETL/ELT, Data Quality.

Job Tags

Similar Jobs

Dairy Queen

Restaurant Cook - Restaurant Crew Member Job at Dairy Queen

 ...Queen - Weimar is looking for a Restaurant Cook to join our team in Weimar, TX. This position is full time or part time. The restaurant cook is responsible for food preparation that meets or exceeds hospitality and service standards and must be able to prepare all foods... 

Hutco, Inc - Marine and Shipyard Staffing

Blaster Painter Job at Hutco, Inc - Marine and Shipyard Staffing

1st Class Blaster/PainterPainters have the responsibility to perform blasting and painting utilizing marine coating to specified contract requirements. Understanding of blasting and painting specifications, including but not limited to blast profiles, mileage requirements...

100KCrossing

Director OF Government Relations Job at 100KCrossing

 ...Executive Order 15-09) Fines and penalties apply to untimely filings.The conditions of employment listed here are incorporated and related to any of the job duties as listed in the job description.About the Agency is deeply committed to the welfare and protection of... 

NKC Dental

Dental receptionist / admin Job at NKC Dental

 ...to do * Are comfortable with technology and learn new systems quickly * Understand that hospitality matters just as much in healthcare as it does in a five-star hotel * Want to be part of an organization that's constantly improving Dental experience is a **big... 

Synergy Care, Inc.

Physical Therapist Assistant (Licensed Therapist) Jackson, LA Job at Synergy Care, Inc.

 ...Job Description Job Description Physical Therapist Assistant Veterans Home (Jackson, LA) Company: Synergy Care Synergy Care is seeking a dedicated and compassionate Physical Therapist Assistant to join our team at a Veterans Home in Jackson, Louisiana. This...