HVR/Fivetran Implementation Consultant

HVR/Fivetran Implementation Consultant

Posted 7 days ago by 1752562791

Apply
Negotiable
Outside
Remote
USA
Apply
Azure Databricks BigQuery Change Data Capture (CDC) Cloud Computing Cloud Technology Databricks Data Capture (SQL) Data Flow Diagram Data Integration Data Warehousing File Servers Google Cloud Google Cloud Platform (GCP) Microsoft Azure Microsoft SQL Servers MySQL Operational Efficiency PostgreSQL Python (Programming Language) SAP Applications SAP HANA Scripting Snowflake (Data Warehouse) SQL (Programming Language)

Summary: The HVR/Fivetran Implementation Consultant role involves managing the installation, configuration, and optimization of HVR software for data replication across various databases and cloud platforms. The consultant will also be responsible for establishing data source connections, ensuring operational health, and implementing high-volume Change Data Capture strategies. Strong expertise in HVR/Fivetran, database technologies, and cloud data integration is essential for success in this position. The role is fully remote and classified as outside IR35.

Key Responsibilities:

  • Install, configure, and upgrade HVR software across source and target systems.
  • Establish and manage data source connections for diverse databases and cloud platforms.
  • Configure replication channels and set up data transformations.
  • Optimize HVR configurations for maximum data replication performance.
  • Develop strategies for high-volume data replication and efficient log-based Change Data Capture.
  • Ensure HVR agents maintain reliable connectivity to all endpoints.

Key Skills:

  • Minimum of 5 years of hands-on experience with HVR (or Fivetran HVR).
  • Strong command of various database technologies and their CDC mechanisms.
  • Proven experience with major cloud platforms and cloud data warehouses.
  • Solid understanding of data warehousing concepts and ETL/ELT processes.
  • Excellent analytical and problem-solving abilities.
  • Strong communication and collaboration skills.
  • Scripting proficiency for automating tasks.
  • Fundamental knowledge of network configurations and security principles.

Salary (Rate): undetermined

City: undetermined

Country: USA

Working Arrangements: remote

IR35 Status: outside IR35

Seniority Level: undetermined

Industry: IT

Detailed Description From Employer:

HVR Implementation Remote Project

Platform Management: Install, configure, and upgrade HVR (now Fivetran HVR) software, including the Hub, agents (HVAs), and associated components, across source and target systems.
Connection & Replication Setup: Establish and manage data source connections for diverse databases (e.g., Oracle, SQL Server, SAP HANA, PostgreSQL, MySQL) and cloud platforms (e.g., Snowflake, Databricks, BigQuery, Redshift). Configure robust replication channels, defining source/target locations, selecting tables, and setting up data transformations.
Performance Optimization: Fine-tune HVR configurations to maximize data replication performance, including adjusting batch sizes, parallelization, and network settings. Proactively identify and address system capacity bottlenecks (e.g., storage, CPU, memory, network bandwidth) by recommending improvements.
High-Volume CDC Implementation: Develop and execute strategies for high-volume data replication and efficient log-based Change Data Capture (CDC).
Operational Health: Ensure HVR agents are running optimally and maintaining reliable connectivity to all source and target endpoints.
Key Skills & Qualifications


HVR/Fivetran Expertise: Minimum of 5 years of hands-on experience with HVR (or Fivetran HVR) administration, configuration, and advanced troubleshooting.
Database Proficiency: Strong command of various database technologies (e.g., Oracle, SQL Server, SAP HANA, PostgreSQL, MySQL) and their respective Change Data Capture (CDC) mechanisms.
Cloud Data Integration: Proven experience with major cloud platforms (AWS, Azure, Google Cloud Platform) and cloud data warehouses (Snowflake, BigQuery, Redshift).
Data Concepts: Solid understanding of data warehousing concepts, ETL/ELT processes, and common data integration patterns.
Problem-Solving: Excellent analytical and problem-solving abilities to diagnose and resolve complex data flow issues.
Communication: Strong communication and collaboration skills to work effectively with diverse technical and business teams.
Automation: Scripting proficiency (e.g., Shell scripting, Python) for automating tasks and enhancing operational efficiency.
Networking & Security: Fundamental knowledge of network configurations and security principles as they apply to data replication.

Thanks & Regards,

Srikrishna P

Phone:

Email:

Apply
Similar Jobs
Loading data...