Denodo Developer

Denodo Developer

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.

Qualifications

• 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.