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

Rare Diamond Marketing

Door-to-Door Fiber Sales Representative Job at Rare Diamond Marketing

 ...Door-to-Door Fiber Sales Representative Location: Lakeland, FL Join One of the Fastest-Growing Fiber Sales Teams in Central Florida! Rare Diamond Marketing is expanding throughout Lakeland and the surrounding Central Florida communities , and we're looking... 

MCI Careers

Outbound Call Center Sales Representative Job at MCI Careers

MCI Careers seeks an Outbound Call Center Sales Representative to join our performance-driven Sales & Business Development team. In this fast-paced customer service and sales role, you will make high-volume outbound calls to engage prospects, present solutions, overcome...

Delta Healthcare Providers

Travel Occupational Therapist (OT) - $2,326 per week in Show Low, AZ Job at Delta Healthcare Providers

 ...Occupational Therapist Location: Show Low, AZ Agency: Delta Healthcare Providers Pay: $2,326 per week Shift Information: Days Start Date: ASAP About the Position Overview Setting: Acute Care Compensation: $1,984 - $2,326 estimated... 

Tooele Motor Company

New Car Sales Specialist Job at Tooele Motor Company

 ...New Car Sales Specialist**$1,000 Sign-On Bonus**Location: Rhinelander, Wisconsin Pay Range: $50,000 $150,000 annuallyAbout the RoleRhinelander Auto Group is seeking motivated and driven sales professionals to join our Chevrolet, GMC, Cadillac, and Toyota dealerships.... 

Columbia Sportswear

Sales Director, Bass Pro Shops and Family Footwear Job at Columbia Sportswear

 ...marketplace. This role leads the team and process.As the Director, Strategic Accounts, you will focus on Columbia Sportswear's Bass Pro Shop/Cabela's, Famous Footwear, and Shoe Carnival accounts. This role is responsible for developing and executing plans based on company...