What are the responsibilities and job description for the Integration Specialist with o9 position at ASCII Group LLC?
Job Details
TCS - Integration Specialist with o9 Experience - Richardson, TX / Onsite- 12 Months
Please find below job description and let me know if you are interested
Job Title: Integration Specialist with o9 Experience
Location: Richardson, TX/ Onsite
Duration: 12 Months
Detailed Job Description:
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, 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.
Thanks and Regards,
Rahela Banu | IT Recruiter
ASCII Group, LLC
| Direct #
38345 W 10 Mile Rd, Suite 365, Farmington, MI 48335
Website: ;/p>
