O9 Integration consultant

About the Project:

The project is seeking a highly skilled Integration Specialist with extensive experience in o9 solutions. The ideal candidate will have a robust background in ETL processes, SQL Server Reporting Services (SSRS), and T-SQL coding, along with a deep understanding of database management and performance tuning.

Key Responsibilities:

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

Required Skills and Qualifications:

- 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, userdefined 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:

- Bachelors degree in computer science or related field.

- Certification in database management or related fields.

📌 Integration consultant (Pune)
🏢 Vidushi Infotech
📍 Pune