> Markdown version of [/jobs/ext/4472329-o9-technical-integration-lead](https://www.wearedevelopers.com/jobs/ext/4472329-o9-technical-integration-lead). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# O9 Technical Integration Lead

- **Company:** K Anand Corporation
- **Location:** Hanover, NJ, United States
- **Experience:** Expert
- **Contract:** Contract
- **Skills:** Microsoft Access, Databases, Data Integrity, Extract Transform Load (ETL), Data Mining, Relational Databases, Microsoft SQL Server, Performance Tuning, Systems Development Life Cycle, User Defined Functions, SQL Stored Procedures, SQL Server Reporting Services, Systems Integration, Transact-SQL, Information Technology
- **Published:** October 26, 2026
- **Apply:** https://www.dice.com/job-detail/b531ca18-b7a6-47f0-98df-a1acd0f05fba

## About the Role

About the Project: The project is seeking a highly skilled Integration Specialist with extensive

experience in o9 solutions. The ideal candidate will have a strong background in ETL processes,

SQL Server Reporting Services (SSRS), and T-SQL coding, along with a deep understanding of

database management and performance tuning., * Proven experience in Data Extraction, Transformation, and Loading (ETL).

 * Expertise in writing parameterized queries and generating reports using SSRS 2005.

 * Strong experience in stored procedure/T-SQL coding and performance tuning.

 * Proficiency in T-SQL for developing complex stored procedures, triggers, tables, user

defined functions, and relational database models.

 * Excellent knowledge of RDBMS, including T-SQL & MS SQL Server 2000/2005, and MS

Access databases.

 * Strong understanding of SDLC principles.

 * Expertise in database creation, maintenance, monitoring, backups, and recoveries.

 * Experience with o9 solutions is highly desirable.

 * Strong analytical and problem-solving skills.

 * Excellent communication and teamwork abilities.

Preferred Qualifications:

 * Bachelor's degree in computer science or related field.

 * Certification in database management or related fields.

## Description

* Perform Data Extraction, Transformation, and Loading (ETL) to integrate various data

sources into the o9 platform.

 * Develop and maintain parameterized queries for generating tabular and sub-reports using

SSRS 2005.

 * Utilize global variables, expressions, and functions to sort data, define data sources, and

calculate subtotals in reports.

 * Write and optimize complex stored procedures, triggers, tables, and user-defined functions

using T-SQL.

 * Design, maintain, and tune relational database models to ensure data integrity and optimal

performance.

 * Manage database creation, maintenance, monitoring, backups, and recovery processes.

 * Collaborate with cross-functional teams to understand business requirements and

translate them into technical solutions.

 * Ensure adherence to SDLC principles throughout the development lifecycle.