ZipRecruiter

Log In

Client Server Software Solutions

60 Client Server Software Solutions Jobs Hiring in Michigan

FastTek

Software Engineer

Dearborn, MI

... for user-centric software solutions * Solve complex problems by designing, developing, and ... Develop and maintain back-end applications like APIs and microservices using server-side languages

InterSources

Sr. Full Stack Engineer

Troy, MI

... and Client/Server applications. The candidate will be working very closely with the internal ... and Software solutions. We have been recipients of Various Awards under "Fastest Growing ...

Denso

Software Developer 1

Battle Creek, MI

... solutions. This role will be responsible for building scalable, high-quality applications that ... Work with Microsoft development tools such as Visual Studio , Azure DevOps , SQL Server , Git, and ...

Denso

Software Developer 1

Battle Creek, MI · On-site

... solutions. This role will be responsible for building scalable, high-quality applications that ... Work with Microsoft development tools such as Visual Studio , Azure DevOps , SQL Server , Git, and ...

previous page

Showing results 41-60

All JobsClient Server Software Solutions JobsJobs at Client Server Software Solutions in Michigan

SQL Server BI Developer / Data Migration Specialist

NAVA Software Solutions

Lansing, MI • On-site

Full-time

Re-posted 20 days ago

Job description

NAVA Software solutions is looking for a SQL Server BI Developer / Data Migration Specialist
Details:
SQL Server BI Developer / Data Migration Specialist
Duration: 12 months
Location: Remote - onsite visits may be required at key points in the project.
The main responsibilities are:
  • The Data Migration Specialist is responsible for migrating data from various data sources to an AMANDA database.
  • The Data Migration Specialist is responsible for migrating data from Oracle to MS SQL Server database.
  • The ideal candidate would have participated in large data migration projects, and have experience migrating data to MS SQL Server.
  • Adhere to data standards and scripting standards set at the project level
  • Analyze existing Oracle and MS Access databases
  • Work with Business Analysts to understand the requirements and identify gaps between requirements and data in existing databases.
  • Map existing databases fields to new AMANDA database fields
  • Document and validate data mapping with the Project team.
  • Develop and document the data migration plan in collaboration with Data Architect.
  • Execute data migration plan by migrating data from the source databases to the AMANDA database.
  • Apply the data governance rules as well as data retention policies to data migration
  • Support efforts to cleanse source data via scripts and/or reports identifying data requiring manual cleansing
  • Review AMANDA table structure based on the design in AMANDA for mapping the data from source to Amanda database structure
  • Collaborate with other Data Migration Specialists and review each other's scripts to ensure consistency
  • Test data migration processes and validate data was migrated correctly.
  • Manage data migration scripts by versioning them via source control
  • Constantly work to fine-tune data migration scripts to improve performance.
  • Collaborate with the QA team on data migration activities
  • Coordinate with Data Architect for various technical documentation

Required Skills
  • Minimum 5 years' experience with Microsoft SQL Server
  • Ability to write complex SQL statements to query data in MS SQL server and Oracle
  • Experience writing SQL stored procedures and functions
  • Ability to tune SQL queries for better performance
  • Experience with Microsoft SSIS
  • Knowledge of T-SQL
  • Ability to write complex SQL statements
  • Experience using version management tools (Git is a plus)
  • Experience with Azure DevOps
  • Experience with Agile Methodology (Kanban is a plus)
  • Knowledge of AMANDA database structure and table relationships
  • Experience with AMANDA solution from Granicus (formerly Calytera) is a plus.
  • Experience with MS SQL Server and Oracle databases (Highly Desired)
NAVA Software Solutions logo

About NAVA Software Solutions

Sourced by ZipRecruiter

NAVA is a strategic partner for companies seeking to develop or customize software and products. Our team of experts leverages cutting-edge technology and deep industry knowledge to provide customized solutions that drive business success. Whether you're looking to improve your operations, increase efficiency, or bring a new product to market, NAVA has the expertise and resources to help you achieve your goals. Trust us to be your partner in software and product development.

Industry

It services

Company size

51 - 200 Employees

Headquarters location

Rocky Hill, CT, US

Social media

Facebook

View All NAVA Software Solutions Jobs

Apply