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 NCDEQ - Data Analyst /Architect-Xpert (746252) Create date: 05-Sep-2024 No of Submissions : 2 Start date : 09/16/2024 End Date : 08/18/2025 Submission deadline : 09/11/2024 Client Info : NCDEQ-ITS Note: * Agency Interview Type : Either Webcam Interview or In Person * Remote * Equipment can be shipped to the candidate. De.... (This job is for - SSIS Jobs in NC Raleigh Architect - (in Raleigh, NC)) NCDEQ - Data Project Manager (740337) Create date: 24-Jun-2024 * Remote No of Submissions : 2 Start date :06/17/2024 End Date :06/15/2025 Submission deadline :06/28/2024 Client Info :NCDEQ-ITS Note: * Either Webcam Interview or In Person * Equipment can be shipped to the candidate. Description : Curre.... (This job is for - SSIS Jobs in NC Raleigh Manager - (in Raleigh, NC)) NCDEQ - Data Analyst /Architect-Xpert (740356) Create date: 24-Jun-2024 * Remote No of Submissions : 2 Start date :06/24/2024 End Date :06/24/2025 Submission deadline :06/28/2024 Client Info :NCDEQ-ITS Note: * Either Webcam Interview or In Person * Equipment can be shipped to the candidate. Description : Curren.... (This job is for - SSIS Technology Jobs in NC Raleigh Architect - (in Raleigh, NC)) Database Architect III - 130607 Create date: 20-May-2024 Bid Limit Per Vendor : 1 Start date : 07/01/2024 End Date : 06/30/2025 Submission deadline :5/22 at 4:00 PM CST. Client Info : DCF Note : INTERVIEW NOTES: • Phone and web based interviews will be acceptable. • However, an in--person interview may be required. .... (This job is for - SSIS CDC Jobs in WI Madison Architect - (in Madison, WI)) 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))    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)

Featured Jobs Developer (Jobs in Atlanta, Georgia) Data Architect ETL Specialist (Jobs in Raleigh, North Carolina) SQL Architect (Jobs in Richmond, Virginia) Business Analyst Financial Analyst (Jobs in Fredericksburg, Virginia) Cyber Architect (Jobs in Columbia, South Carolina) VxRails Consultant (Jobs in Boise, Idaho) Project Manager Microsoft Manager (Jobs in Raleigh, North Carolina) Agile Jira UAT Manager (Jobs in Atlanta, Georgia) - - Analyst (Jobs in Portland, Oregon) HTMLCSSJavaScript Developer (Jobs in Lincoln, Nebraska)