Description:

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.
Robust 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.
Robust 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
🏢 SRS Infoway
📍 Pune