Denodo Developer – Data Integration & Virtualization

Mriti InfoSystems Inc.; Dallas (TX); On-site; USD 95,000 - 125,000; Full time

Job summary

Mriti InfoSystems Inc. is seeking a Denodo Developer to design and optimize virtual data integration solutions. You will develop Denodo views, optimize long-running queries, and build monitoring dashboards while collaborating with cross-functional teams.

Strong SQL, data modeling, and Denodo experience are required, with Python and REST/SOAP API data service knowledge as a plus. You will also document data solutions and contribute to ETL tooling familiarity within agile environments, leveraging

Qualifications

• 4+ years of SQL experience across OLTP, DW, and Big Data databases.
• 4+ years in Data Analyst/Data Engineer/SQL Developer roles.
• 2+ years writing medium to complex SQL queries and stored procedures.
• 2+ years with Denodo and data integration tooling.
• Experience with query optimization techniques.
• Experience developing REST and SOAP API data services.
• Agile team experience; Jira and GitLab usage.
• Strong data modeling and data integrity fundamentals.
• Prior exposure to ETL tools and cloud data environments is a plus.

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 optimize long-running queries with cross-functional teams.
• Develop and implement new monitoring views and dashboards for the Denodo platform.
• Collaborate with functional teams to develop new virtual data integration solutions.
• Create functional and technical documentation for Denodo data solutions.

Skills

SQL

Data modeling

Python

REST API data services

SOAP API data services

Agile teams

Query optimization

Tools

Denodo

Jira

GitLab

Informatica

Ab Initio

Hadoop

MongoDB

Postgres

Cloud

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.

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.
• Self-motivated.
• Works well in a team environment.
• Exposure to ETL tools like Informatica and Ab Initio is a plus.
• Previous experience with Python development is a plus.
• Previous experience with Master Data Management tools is a plus.
• Big Data experience is a plus (Hadoop, MongoDB).
• Postgres and Cloud experience is a plus.