SQL Sybase Developer

HCLTech is looking for a highly talented and self- motivated SQL Developer with strong database migration and data processing expertise to support a large-scale Sybase to SQL Server migration program.

Job Title: SQL Developer

Job ID: 158215

Position Type: Full-time

Location: Remote

Job Summary:

We are seeking a SQL Developer with strong database migration and data processing expertise to support a large-scale Sybase to SQL Server migration program. The role will focus on schema conversion, stored procedure remediation, query optimization, and data validation to ensure a secure, accurate, and high-performance migration.

Key Responsibilities

Analyze and convert database objects (schemas, tables, stored procedures, triggers) from Sybase to SQL Server

Refactor and optimize existing SQL logic to align with SQL Server (T-SQL)

Develop and enhance complex SQL queries, stored procedures, and views

Perform query tuning and performance optimization using indexing and execution plan analysis

Design and execute data validation and reconciliation scripts to ensure data accuracy and integrity

Support large-scale data migration activities, including data extraction, transformation, and loading validation

Collaborate with ETL teams (Informatica) and application teams for seamless data flow and DB integration

Assist in testing phases (SIT, UAT, E2E) including defect analysis and resolution

Troubleshoot and resolve data, performance, and migration-related issues during cutover and post-go-live

Document database changes, migration logic, and dependencies in line with audit and compliance requirements

Skill Requirements:

1. Strong Proficiency In Sql Server, Including Database Design, Development, And Optimization Techniques.
2. In-Depth Understanding Of Sql Query Writing, Performance Tuning, And Troubleshooting Complex Database Issues.
3. Solid Knowledge Of Data Modeling, Etl Processes, And Implementing Best Practices In Database Management.
4. Familiarity With Agile Methodologies And Project Management Frameworks.

Other Requirements

Good to have:

Experience in database migration / modernization projects

Experience with Informatica ETL tools

Knowledge of Power BI / reporting queries optimization

Financial services domain experience

Pay and Benefits

Pay Range Minimum: $95000 per year

Pay Range Maximum: $151000 per year

HCLTech is an equal opportunity employer, committed to providing equal employment opportunities to all applicants and employees regardless of race, religion, sex, color, age, national origin, pregnancy, sexual orientation, physical disability or genetic information, military or veteran status, or any other protected classification, in accordance with federal, state, and/or local law. Should any applicant have concerns about discrimination in the hiring process, they should provide a detailed report of those concerns to secure@hcltech.com for investigation.

Compensation and Benefits

A candidate’s pay within the range will depend on their work location, skills, experience, education, and other factors permitted by law. This role may also be eligible for performance-based bonuses subject to company policies. In addition, this role is eligible for the following benefits subject to company policies: medical, dental, vision, pharmacy, life, accidental death & dismemberment, and disability insurance; employee assistance program; 401(k) retirement plan; 10 days of paid time off per year (some positions are eligible for need-based leave with no designated number of leave days per year); and 10 paid holidays per year.