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

Herman N Logistics

CDL-A Local Water Delivery Driver - Competitive Pay Job at Herman N Logistics

 ...CDL-A Local Dry Van Driver Good Pay | Home Daily Join a dedicated local account hauling palletized water with average weekly pay of $1,300 , home daily, and two consecutive days off each week. Pay Details Average Weekly Pay: $1,300 Average Annual Pay... 

Clean Harbors

Class A HAZMAT Truck Driver / Equipment Operator Job at Clean Harbors

 ...Description Clean Harbors in Bartow, FL is seeking a Class A CDL Driver to operate a variety of heavy and light duty trucks/work...  ...Maintain daily logs, time sheets, and various reports Follow all local, state (provincial) and federal compliance regulations and... 

Sargento

Graphic Design Intern Job at Sargento

 ...You love to develop, design, and execute creative materials that will reflect our brand...  ...relocation and housing ~5 unpaid days off for interns and 10 unpaid days off for co-ops ~401...  ..., Shopper marketing, email, video production webpages, internal communications,... 

H&H Recruiting

RECENT GRADUATES AMD EXPERIENCED CLASS A CDL DRIVERS IN JOHNSTOWN NY AREA NEEDED Job at H&H Recruiting

Job Description Job Description We are looking for recent graduates and experienced Class A CDL drivers in the Johnstown, NY area for a regional lane. Drivers home every three weeks, hauling no-touch loads. Drivers on these accounts can earn up to $1600 weekly and...

Choctaw Professional Staffing Group

Psychology Assistant Job at Choctaw Professional Staffing Group

 ...Overview Job Summary: Provide non-clinical internal clinical behavioral health, leader support and training to commanders and Soldiers...  ...and respect from all stakeholdersCommitment to the USAREC Psychology Services missionConfidence and ability to negotiate challenging...