Role : Starburst Data Visualization Engineer
Location : Charlotte, NC
Duration : Full-Time
Interview : Online / Video
Must Have Technical / Functional Skills
Primary Skill : Starburst
Secondary : Data Virtualization Engineer, Dremio, Presto, SQL Performance Tuning, Shell Scripting, Autosys
Experience : Minimum 10 years
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.
- Analyze 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.