Denodo Developer

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.