Lead ETL/o9 Platform
- TekisHub Consulting Services
7 Days Ago
NA
NA
Atlanta-GA, Richardson-TX, Seattle-WA
8-12 Years
Required Skills: ETl, o9 platform, SSRS 2005, T-SQL, SDLC, RDBMS
Job Description
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:
- Bachelor’s degree in computer science or related field.
- Certification in database management or related fields.
