SQL Developer

TEKsystems • New York, NY

2d • $45 - $60 • Hybrid

About The Position

We are seeking an experienced SQL Developer to support a large-scale data migration project. The ideal candidate will help transform, validate, and prepare data from a legacy SQL database for import into a new enterprise system. This role will work closely with business and technical teams to develop SQL views, implement data mapping requirements, create validation queries, and support testing throughout the migration process.

Requirements

• Strong SQL and SQL Server experience
• Complex joins, CTEs, and subqueries
• CASE statements and data transformations
• Data cleansing and troubleshooting
• Data type conversions and handling NULL values
• Aggregations and duplicate identification
• Source-to-target data mapping
• Data conversion and transformation
• Crosswalk and lookup mapping rules
• Exception reporting and data quality validation
• Experience supporting system migration projects
• Exporting data from SQL queries and views
• Creating and validating CSV files
• Working with Excel for data review and analysis
• Formatting data according to import specifications
• Identifying missing or invalid data
• Detecting duplicate records
• Creating reconciliation and audit queries
• Verifying record counts and data accuracy
• 2-6 years of SQL development experience
• Experience with SQL Server
• Previous data conversion, migration, or integration experience
• Strong Excel and CSV file management skills
• Excellent analytical and problem-solving abilities

Nice To Haves

• Experience working with Student Information Systems (SIS)
• Higher education industry experience
• Experience supporting enterprise system implementations

Responsibilities

• Review and enhance existing SQL views and migration logic
• Develop new SQL views and data transformation queries
• Implement business mapping and conversion requirements
• Create validation and data quality checks
• Generate datasets and CSV files for review and import
• Investigate and resolve data issues and rejected records
• Support testing and data reconciliation activities
• Document data mappings, transformations, and validation processes

Benefits

• Medical, dental & vision
• Critical Illness, Accident, and Hospital
• 401(k) Retirement Plan
• Pre-tax and Roth post-tax contributions available
• Life Insurance (Voluntary Life & AD&D for the employee and dependents)
• Short and long-term disability
• Health Spending Account (HSA)
• Transportation benefits
• Employee Assistance Program
• Time Off/Leave (PTO, Vacation or Sick Leave)

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed