SQL Developer - Data Migration Project

Operations Leadership Data Quality Data Mapping Reconciliation Data Migration Problem Solving Data Conversion File Management Type Conversion Higher Education System Migration Business Valuation Data Transformation Full Stack Development Business Transformation SQL (Programming Language) Student Information Systems Enterprise Application Software, 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., * 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, CSV & Excel
• 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

Data Validation

• Identifying missing or invalid data
• Detecting duplicate records
• Creating reconciliation and audit queries
• Verifying record counts and data accuracy, Operations Leadership Data Quality Data Mapping Reconciliation Data Migration Problem Solving Data Conversion File Management Type Conversion Higher Education System Migration Business Valuation Data Transformation Full Stack Development Business Transformation SQL (Programming Language) Student Information Systems Enterprise Application Software +0 Login | JoinContact

SQL Development

• 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

Data Migration Experience

• 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, * 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, * Experience working with Student Information Systems (SIS)
• Higher education industry experience
• Experience supporting enterprise system implementations, * SQL Server
• Data Migration
• Data Validation
• Excel
• CSV Processing
• Data Transformation, Individual compensation offered for this position within this range will depend on many factors, including qualifications, skills, relevant experience, job knowledge, geographic location, internal equity, and other pertinent job-related factors.

We’re partners in transformation. We help clients activate ideas and solutions to take advantage of a new world of opportunity. We are a team of 80,000 strong, working with over 6,000 clients, including 80% of the Fortune 500, across North America, Europe and Asia. As an industry leader in Full-Stack Technology Services, Talent Services, and real-world application, we work with progressive leaders to drive change. That’s the power of true partnership. TEKsystems is an Allegis Group company., Were a leading provider of business and technology services. We accelerate business transformation for our customers. Our expertise in strategy, design, execution and operations unlocks business value through a range of solutions. Were a team of 80,000 strong, working with over 6,000 customers, including 80% of the Fortune 500 across North America, Europe and Asia, who partner with us for our scale, full-stack capabilities and speed. Were strategic thinkers, hands-on collaborators, helping customers capitalize on change and master the momentum of technology. Were building tomorrow by delivering business outcomes and making positive impacts in our global communities. TEKsystems and TEKsystems Global Services are Allegis Group companies. Learn more at TEKsystems.com.

The company is an equal opportunity employer and will consider all applications without regard to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.

San Francisco Fair Chance Ordinance: Pursuant to the San Francisco Fair Chance Ordinance, for all positions located in the city and county of San Francisco, we will consider for employment qualified applicants with arrest and conviction records.

Massachusetts Lie Detector: It is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this law shall be subject to criminal penalties and civil liability.

Use of Artificial Intelligence (AI): We may use Artificial Intelligence (AI) to support parts of our hiring process, including sourcing, screening, and evaluating candidates. AI helps assess applications and qualifications, but final decisions are made by our hiring team. By applying, you acknowledge and agree that your application may be reviewed using AI tools. Related Jobs