Starburst Data Virtualization Engineer, SQL Performance Tuning, Shell Scripting, Autosys Job at ClifyX, Charlotte, NC

TzFtcWFFWFI0S3Z0VTNSaExSSGZjMjBZcWc9PQ==
  • ClifyX
  • Charlotte, NC

Job Description

Roles & Responsibilities
Key Responsibilities:
• Demonstrated expertise in Starburst Data Virtualization, including designing and implementing data virtualization solutions, optimizing query performance across distributed data sources, and integrating Starburst with enterprise data architectures.
• nalyze 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 Client ALM or Octane.
• utomate 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.
Tools & Skills:
Starburst, IDMC, Informatica Power center, Hive, Kafka Knowledge
SQL, Oracle, PL/SQL
Domain: Banking knowledge, Payments knowledge preferred.
Concept: Data Virtualization, Data Warehousing, Data Transformation, ETL/ELT, Data Quality.

Job Tags

Similar Jobs

Raytheon Technologies

Mechanical Assembler II - Grinder - 2nd Shift Job at Raytheon Technologies

 ...required. Maintain materials, equipment, and work area in a clean and orderly condition. Comply with all rules and regulations of Raytheon Technologies, including, but not limited to: Environmental Health and Safety, Complete assigned tasks, not specifically listed,... 

Radiology Partners

Interventional , Interventional Radiologist - No Call, No Weekends, No Holidays | Philadelp... Job at Radiology Partners

 ...EST to 5 pm EST ~ NO CALL, NO EVENINGS, NO OVERNIGHTS, NO WEEKENDS & NO HOLIDAYS ~210 shifts per year ~8 Weeks of PTO in...  ...program with exceptional flexibility, enabling radiologists to work remotely from home as much or as little as they choose. LOCAL... 

UnitedHealthcare

Remote Credentialing Specialist - Provider Network Job at UnitedHealthcare

 ...A leading healthcare organization is seeking a skilled individual for a role focused on provider credentialing and network management. This position allows for telecommuting with 25% travel in Miami. Candidates should have at least 3 years of experience in Medicaid and... 

USASJB

Remote Data Entry Clerk - Work at Home Job at USASJB

 ...Earn at Home by Taking Polls - Data Entry Clerk - Customer Service Rep - Work at Home & Part Time We are looking for people nationwide to participate in polls - Apply ASAP! We offer you the opportunity to earn extra income from home (teleworking) and also to decide... 

Vertex Education

Regional Food Service Specialist Job at Vertex Education

 ...changing lives through education. As a purpose-led education services provider, our mission is destined to benefit many and yet it starts...  ...capable and confident in serving their students every day, ultimately driving high satisfaction and strong, lasting partnerships....