Full-Time

Data Migration Analyst

US Tech Solutions

US Tech Solutions

1,001-5,000 employees

Global diversity-focused IT staffing partner

No salary listed

Sunnyvale, CA, USA

In Person

Category
Data & Analytics (2)
,
Required Skills
SQL
ETL
Oracle
Data Analysis
Requirements
  • At least 5 years of information technology related experience.
  • 3-5 years working with databases with demonstrated expertise in SQL, PL/SQL, Oracle 11, ETL tools, Data conversion, Data De-duplication, Data Cleansing methodologies.
  • Be able to build SQL data queries.
  • Demonstrated experience in analyzing data sets and effective at understanding a problem and developing one or many approaches to solving the problem.
  • Assist in designing, planning and managing the data migration process.
  • Work with subject matter experts and project team to identify, define, collate, document and communicate the data migration requirements.
  • Experience in data migration methodologies.
  • Highly effective working in a team, as well as working independently.
  • Perform source system data analysis in order to manage source to target data mapping.
  • Perform migration and testing of static data and transaction data from one core system to another.
  • Perform data migration audit, reconciliation and exception reporting.
  • Assist with the identification of trends or patterns in complex data sets
  • Filter and “clean” data, and review reports, printouts, and performance indicators
  • Create Test Plans and Test Cases for all scenario types and execute. (i.e. positive, negative testing, boundary)
  • Verify requirement traceability from System Requirements through test cases and defects
  • Ensure that testing activities will allow applications to meet business requirements and systems goals, fulfil end-user requirements, and identify and resolve systems issues
  • Work with the developers to understand the technical requirement/design being built in a project
  • Validate Test Preparation of environments and verify all teams are aligned with what needs to occur to build/prepare the test environments
  • Coordinate, track and report regularly on execution of system testing
  • Verify defects are effectively recorded, communicated and understood
  • Analyze and ensure test results and changes/defect are reflected in the test case and test cases are updated appropriately based on resolution
  • Identify and recommend process improvements as necessary
  • Excellent written and oral communication skills
  • Excellent listening and interpersonal skills (includes but not limited to peers, managers, and the business)
  • Excellent organizational skills to manage a wide array of testing information
  • Strong knowledge of system testing and software quality assurance best practices and methodologies
Responsibilities
  • Create Test Plans and Test Cases for all scenario types and execute. (i.e. positive, negative testing, boundary)
  • Verify requirement traceability from System Requirements through test cases and defects
  • Ensure that testing activities will allow applications to meet business requirements and systems goals, fulfil end-user requirements, and identify and resolve systems issues
  • Work with the developers to understand the technical requirement/design being built in a project
  • Validate Test Preparation of environments and verify all teams are aligned with what needs to occur to build/prepare the test environments
  • Coordinate, track and report regularly on execution of system testing
  • Verify defects are effectively recorded, communicated and understood
  • Analyze and ensure test results and changes/defect are reflected in the test case and test cases are updated appropriately based on resolution
  • Identify and recommend process improvements as necessary

US Tech Solutions helps large enterprises and MSPs build diverse, flexible workforces through a combination of curated talent pools, workforce management services, IT resourcing, and IC (independent contractor) compliance. Its core offering relies on AI-powered Talent platforms that connect organizations with top talent and smoothly integrate new hires into existing programs. The company positions itself as the largest privately owned diversity supplier in the US, emphasizing inclusion and unlocking hidden potential by inverting the traditional hiring pyramid. It partners with Fortune 500 customers and major MSPs, leveraging in-house platform solutions and a close computing industry background to enable faster innovation. The goal is to help organizations achieve digital leadership and faster innovation by aligning talent with business needs while maintaining a strong focus on diversity and inclusion.

Company Size

1,001-5,000

Company Stage

N/A

Total Funding

N/A

Headquarters

Toronto, Canada

Founded

2000

Simplify Jobs

Simplify's Take

What believers are saying

  • $1.4 billion revenue reflects robust IT consulting and talent management growth.
  • 11-year Cushman & Wakefield partnership drives workplace expansions like 10 Exchange Place.
  • Neurodiversity hiring commitments via [email protected] boost inclusive talent pools.

What critics are saying

  • 9,692 sq ft lease stagnates expansion amid Jersey City rents over $60/sq ft.
  • Low-wage Jersey City postings fail to attract developers versus Infosys' higher rates.
  • AI platforms like Upwork displace 40% of routine IT staffing within 24-36 months.

What makes US Tech Solutions unique

  • US Tech Solutions supplies diverse talent to Fortune 500 firms across 10+ US locations.
  • Global HQs in Jersey City, Noida, and Hyderabad enable worldwide skilled professional access.
  • Serves aerospace, healthcare, and financial sectors as trusted MSP partner since 2000.

Help us improve and share your feedback! Did you find this helpful?

Benefits

Flexible Work Hours

Phone/Internet Stipend

Remote Work Options

Paid Vacation

401(k) Retirement Plan

401(k) Company Match

Wellness Program

Mental Health Support

Hybrid Work Options

Stock Options

Company Equity

Conferences Attendance Budget

Family Planning Benefits

Fertility Treatment Support

Adoption Assistance

Childcare Support

Phone/Internet Stipend

Home Office Stipend

Company News

TradingView
May 15th, 2025
KellyOCG Honors Top-Performing Suppliers for Delivering Exceptional Workforce Solutions

One supplier, US Tech Solutions, also received the Innovative Partner Award.

ROI-NJ
Oct 26th, 2022
It Firm Signs Lease At 10 Exchange Place, Jersey City

An information technology consulting and talent management firm has signed a lease in Jersey City, according to Cushman & Wakefield. The real estate services firm said in a news release that US Tech Solutions took 9,692 square feet at 10 Exchange Place’s 17th floor