Denodo Developer

Techgene Solutions LLC

Tampa, FL, United States

1 day ago

Apply on www.careerjet.com

Prepare application

Role details

Contract type

Temporary to permanent

Employment type

Full-time (> 32 hours)

Experience level

Experienced

Experience required

2 years minimum

Compensation

$104,000.0 - $112,320.0

Working hours

Regular working hours

Job source

www.careerjet.com

Tech stack

Big Data Cloud Computing Databases Data as a Services Data Integration Data Integrity Extract Transform Load (ETL) Data Transformation Data Systems Data Warehousing Dimensional Modeling Apache Hadoop

+14 more

Python (Programming Language) PostgreSQL MongoDB Online Transaction Processing Performance Tuning Query Optimization SQL Stored Procedures SQL Databases Web Services Freeform SQL Ab Initio Gitlab Data Management Software Version Control

Job description

Must haves: Denodo, traditional ETL tools, SQL, Big Data and Python (a plus) The primary responsibilities of the Denodo Developer role include developing virtual data integration solutions, analyzing and optimizing existing integration queries/views, and developing new Denodo platform monitoring processes. The candidate will collaborate with cross-functional teams to proactively optimize long-running queries and provide thorough functional documentation. The ideal candidate brings over four years of advanced SQL querying experience, a solid grasp of data modeling, and expertise in troubleshooting performance issues. Prior experience with Denodo, traditional ETL tools, and Python is highly advantageous. Responsibilities

Create base views, derived views, integration views, and summary views.
Write queries using SQL and VQL, including data transformations and data integration queries.
Proactively work with teams who have long-running queries to help optimize these.
Actively develop and implement new monitoring views and dashboards for the Denodo platform.
Work with functional teams to develop new virtual data integration solutions.
Create functional and technical documentation for Denodo data solutions.

Requirements

4+ years of SQL experience working with OLTP, Data Warehouse and Big Data databases.
4+ years in a Data Analyst/Data Engineer/SQL Developer role.
2+ years writing medium to complex SQL queries/stored procedures.
2+ years of experience with Denodo.
Experience with query optimization techniques.
Experience developing and supporting REST and SOAP API data services.
Experience in troubleshooting data quality and performance issues.
Experience working in agile teams.
Experience working with ticketing tools like Jira.
Experience working with code versioning tools like GitLab.
Strong understanding of data modeling, including dimensional modeling concepts.
Strong understanding of data integrity concepts.
Good communication skills.
Self-motivated.
Works well in team environment.
Exposure to ETL tools like Informatica like ETL and Ab Initio a plus.
Previous experience with Python development a plus.
Previous experience with Master Data Management tools a plus.
Big Data Experience a plus (Hadoop, MongoDB).
Postgres and Cloud Experience a plus.