Denodo Developer

Nava Software Solutions LLC

Dallas, TX, United States

8 days ago

Apply on www.careerjet.com

Prepare application

Role details

Contract type

Temporary to permanent

Employment type

Full-time (> 32 hours)

Experience level

Expert

Experience required

2 years minimum

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

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., * 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

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., * 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.