Position: O9 Technical Integration Lead with o9 Experience
Location: Hanover, NJ(Onsite)
Contract
Job 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 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.
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, 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.
Thanks & Regards,
Hemant Chauhan
Sr Associate – Talent Acquisition
KAnand Corporation
Email:
