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

SEARHC Ethel Lund Medical Center - Juneau

Radiology - Diagnostic Job at SEARHC Ethel Lund Medical Center - Juneau

 ...SEARHC Ethel Lund Medical Center - Juneau Job Type Permanent Offering Physician Profession Radiology Specialty Diagnostic Job ID 15769543 Shift Details Shift Full Time Days Scheduled Hours... 

Career Land Center, LLC

Diagnostic Radiologist - Emergency Radiology Job at Career Land Center, LLC

 ...organization in the Bronx, New York, is seeking a Board-Certified or Board-Eligible Diagnostic Radiologist to join its Emergency Radiology division as an academic faculty member. The Emergency Radiology team includes six radiologists and provides comprehensive imaging... 

Wysocki Family Farms

Agronomist Job at Wysocki Family Farms

 ...As an Agronomist , youll be at the core of our farm operations, supporting every stage of the crop lifecyclefrom strategic planning, implementing and overseeing all agronomic activities across assigned fields to maximize crop yield, quality and operational efficiency... 

Highbrow

QA Engineer - ETL/BI/DW Data Testing (Remote to Start) Job at Highbrow

 ...A prominent technology company is seeking a QA Engineer with a focus on ETL/BI/DW testing processes. The ideal candidate will have over 5 years of experience in relevant testing and strong skills in SQL, as well as familiarity with Agile methodology. This role involves... 

AC Foods

Farm Manager Job at AC Foods

 ...Description Job Description Description: Position Summary The Farm Manager leads and oversees farming operations, with...  ...federal requirements, including OSHA, EPA, USDA, food safety, and agricultural regulations. Requirements: Skills and Abilities Strong...