Home       |     Overview      |     Candidate Login      |     Post Resume       |     Contact us
 
  
     
     
Search Jobs
     
Keywords,Title,Skills,Company  Location,City,State,Zip  
  Advanced Search
     
SSIS T-SQL GIT Azure DevOps Agile Methodologies Analyst
(Jobs in Lansing, MI)
 
Requirement id 134406
Job title Analyst
Job location in Lansing, MI
Skills required SSIS, SQL Server DBA, T-SQL, GIT Azure DevOps Agile Methodologies
Open Date 09-Jun-2022
Close Date
Job type Contract
Duration 12 Months
Compensation DOE
Status requirement ---
Job interview type ---
   Email Recruiter: coolsoft
Job Description Analyst: SSIS, SQL Server DBA, T-SQL, GIT Azure DevOps Agile Methodologies

start date:6/27/2022
End date:06/30/2023

submission deadline:6/16 at 10am EST

client info : DIFS

Note:

* Interview Process: MS Teams Video using integrated audio. Camera MUST be on.

* Duration: 1 year

* Remote or On-site? Local preferred - remote work allowed. (May NOT need to relocate)

Description:

The Data Migration Specialist is responsible for migrating data from various data sources to an AMANDA database. The ideal candidate would have participated in large data migration projects and have experience migrating data to an AMANDA database. AMANDA is a solution from Granicus (formerly Calytera).

Responsibilities:

• Adhereto 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 as well as identify gaps between requirements and data in existing databases
• Map existing databases fields to new AMANDA database fields
• Document and validate data mapping with Project team
• Develop and document the data migration plan in collaboration with Data Architect.

• Use Microsoft SSIS package for data migration
• Execute data migration plan by migrating data from the source databases to 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 design in AMANDA for mapping the data from source to Amanda database structure
• Collaborate with other Data Migration Specialists and review each others scripts to ensure consistency
• Test data migration processes and valid 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

Skills:

• Experience with Microsoft SSIS
• Experience with Microsoft SQL Server
• Knowledge of T-SQL
• Ability to write complex SQL statements
• Ability to tune SQL queries for better performance
• Experience writing stored procedures and functions
• Ability to develop various jobs using a job scheduler
• Experience using version management tools (Git is a plus)
• Experience with Azure DevOps
• Experience with Agile Methodology (Kanban is a plus)

Highly Desired Skills:

• Experience with AMANDA solution from Granicus (formerly Calytera)

• Knowledge of AMANDA database structure and table relationships

• Knowledge of various AMANDA database objects related to Folders and People.
 
Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 134406 while calling.
 
Other jobs in MI: Ann Arbor (5), Detroit (2), Dimondale (1), Lansing (29), Pontiac (1), Southfield (1), TROY (1), Warren (1),
SSIS job openings in Lansing, MI
Jobs List

QOL - Programmer Analyst 4 (646634)
Create date: 02-Mar-2021
Start Date :03/08/2021
End Date :06/30/2021
Submission Deadline :03/08/2021

Client Info : DEQ, DNR, MDARD

Note :

* Agency Interview Type : Webcam Interview Only

Description :

Years of Experience: 12-15 years of experience in the field or in a related area..... (This job is for - SSIS Triggers Jobs in MI Lansing Analyst - (in Lansing, MI))

MDOS - Database Administrator 3 (589207)
Create date: 01-Mar-2019
Start Date :3/18/2019
End Date :09/30/2019
Submission Deadline :3/7/2019
Client Info :MDOS

Position Description:

This position is for one Database Administrator to support current MDOS DBA work.

This DBA is responsible for the logical design and physical implementation o.... (This job is for - SSIS SSRS Jobs in MI Lansing Administrator - (in Lansing, MI))

Programmer Analyst 5 - 457519
Create date: 19-May-2016
Description:


The Programmer Analyst will perform analytical programming assignments pertaining to the development, enhancement and maintenance of reports and integration packages and procedures in a CRM Dynamic environment. The position also involves the utilization of project management and systems design in a technical developme.... (This job is for - SSRS SSIS Jobs in MI Lansing Analyst - (in Lansing, MI))
 
 SSIS job openings in other states
Jobs List

Chesterfield County Data Warehouse Architect 4 (730461)
Create date: 29-Feb-2024
Hybrid

Start date :03/18/2024

End Date : 10/14/2025

Submission deadline : 3/5/2024

Client Info : Chesterfield County

Description :
------------------------------------------------------
*Local Richmond area candidates or those willing to relocate to the Richmond area during this engag.... (This job is for - SSIS Sql Server 2000 Jobs in VA Chesterfield Architect - (in Chesterfield, VA))

Database Administrator 3 -123972
Create date: 31-Oct-2023
Start date : 11/20/2023

End date : 04/26/2024

Submission deadline : November 6, 2023, 10 AM CST.

Client info :DESE

Note:

* Interview Process: Remote/WebEx interviews will be scheduled.

* Duration of the Contract: 7 months, with potential to extend.

* Onsite or Remote? .... (This job is for - SQL SSIS ETL Jobs in MO JeffersonCity Administrator - (in Jefferson City, MO))

Programmer/Developer - 61750
Create date: 31-Oct-2023
Start date : 12/04/2023

End date :06/30/2024

Submission deadline :11/10/2023

Client info : TN DOH

Note:

* Position Location: Hybrid

Description :

SQL Developer

Position Description: The Tennessee Department of.... (This job is for - SSIS Jobs in TN Nashville Developer - (in Nashville, TN))

IA-DOM-DoED-TS3-.NET SQL Developer (721499)
Create date: 05-Oct-2023
Remote

start date :10/30/2023

End date :10/30/2024

submission deadline :10/10/2023

client info :ED: Education Department

Description :

The Iowa Department of Education needs a technical and functional development specialist to support .... (This job is for - SSIS JQuery Jobs in IA DesMoines Developer - (in Des Moines, IA))

Data Warehouse Developer III - 119696 - SP
Create date: 03-Jul-2023
start date : 07/31/2023

End date : 06/30/2024

submission deadline : 7/12/2023 4:00PM CST.

client info : DPI

Note :

* Interview Process: Microsoft Team, 1 round, with audio and video on, also be prepared to share your screen.

* Duration: Until June 30, 2024 with possibility of ext.... (This job is for - SSIS Agile Jobs in WI Madison Developer - (in Madison, WI))
 
 SSIS job openings in MI
Jobs List

Software Developer - 299
Create date: 11-Apr-2018
Start Date : 04/30/2018
Submission Dead Line : 04/20/2018
Client Info : OAKLAND COUNTY
Department of Information Technology

Description :

Software Developer. Develops custom programs in a variety of languages designed to enhance user functi.... (This job is for - MS SQL Server SSIS T SQL Jobs in MI Pontiac Developer - (in Pontiac, MI))

Software Developer - 289
Create date: 01-Feb-2018
Start Date :02/26/2018
Submission Deadline :02/09/2018
Description :

This requisition will close on 02/09/2018.
Software Developer. Completes programming functions on highly complex .Net programs for highly available public safety applications. Includes the design and development of new automated systems f.... (This job is for - T SQL SSIS Jobs in MI Pontiac Developer - (in Pontiac, MI))

Software Developer - 284
Create date: 23-Jan-2018
Start Date : 02/26/2018
Submission Dead Line : 02/06/2018
Description :

Software Developer. Completes programming functions on highly complex .Net programs, including the design and development of new automated systems from their inception to implementation to enhance user fu.... (This job is for - SSIS SSRS Jobs in MI Pontiac Developer - (in Pontiac, MI))

SQL Server DBA
Create date: 19-Apr-2016
Start Date :04/29/2016
Submission Deadline :04/25/2016
Description:

Senior SQL Server Database Administrator

Must be a US Citizen Document/ProjectWise/ Business Systems Senior SQL Server Database Administrator. Minimum of 7 years of experience working as a SQL Server database administrator in a productio.... (This job is for - SSRS SSIS Jobs in MI Pontiac Administrator - (in Pontiac, MI))
(Analyst: SSIS, SQL Server DBA, T-SQL, GIT Azure DevOps Agile Methodologies in Lansing, MI)
     
Search Jobs
     
Keywords,Title,Skills,Company  Location,City,State,Zip  
  Advanced Search
     

    About Us     Services    Privacy policy    Legal     Contact us