• Snapboard
  • Activity
  • Reports
  • Campaign
Welcome ,

Chat with the recruiter

...Minimize

Hey I'm Online! Leave me a message.
Let me know if you have any questions.

Power BI Developer

In United States

Save this job

Power BI Developer   

Click on the below icons to share this job to Linkedin, Twitter!

JOB TITLE:

Power BI Developer

JOB TYPE:

JOB SKILLS:

JOB LOCATION:

Remote United States

JOB DESCRIPTION:

Position : Programmer Analyst 6 - Data Migration Location : Lansing, MI    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)   Job description   The Data Migration Specialist is responsible for migrating data from various data sources to an AMANDA database. The ideal candidate would have participated inlarge 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 other's scripts to ensure consistency · Test data migration processes andvalid data was migrated correctly · Manage data migration scripts by versioning them via source control · Constantly work to fine tunedata migration scripts to improve performance · Collaborate with the QA team on data migration activities · Coordinate with Data Architect for various technical documentation   Client Skill Matrix · 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

Position Details

POSTED:

Nov 26, 2022

EMPLOYMENT:

INDUSTRY:

SNAPRECRUIT ID:

S1655308827846837

LOCATION:

United States

CITY:

Remote

Job Origin:

OORWIN_ORGANIC_FEED

A job sourcing event
In Dallas Fort Worth
Aug 19, 2017 9am-6pm
All job seekers welcome!

Power BI Developer    Apply

Click on the below icons to share this job to Linkedin, Twitter!

Position : Programmer Analyst 6 - Data Migration Location : Lansing, MI    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)   Job description   The Data Migration Specialist is responsible for migrating data from various data sources to an AMANDA database. The ideal candidate would have participated inlarge 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 other's scripts to ensure consistency · Test data migration processes andvalid data was migrated correctly · Manage data migration scripts by versioning them via source control · Constantly work to fine tunedata migration scripts to improve performance · Collaborate with the QA team on data migration activities · Coordinate with Data Architect for various technical documentation   Client Skill Matrix · 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


Please wait..!!