Search jobs > Nampa, ID > Data engineer

Data Warehouse Migration Engineer

Stellar IT Solutions LLC
Nampa, Idaho, USA
Full-time

Job Title : Data Warehouse Migration Engineer

Job Location : Remote

Interview : Virtual

Job Duration : 6 Months

Key Responsibilities :

Migration Planning : Partner with the clients internal team to develop a detailed migration plan from WhereScape to Microsoft Synapse.

This includes defining timelines allocating resources and identifying potential risks with mitigation strategies.

  • Data Mart Migration : Oversee the migration of data marts from the current onpremise data warehouse to Microsoft Synapse ensuring high levels of data integrity accuracy and security throughout the process.
  • Performance Optimization : Apply best practices for optimizing the performance of the Synapse data warehouse including techniques like data partitioning indexing and query performance tuning.
  • Technical Consulting : Offer expert advice on utilizing Microsoft Synapse features such as data integration analytics and business intelligence tools to fully leverage the platforms capabilities.
  • Documentation & Training : Produce comprehensive documentation of the migration process and deliver training sessions to the clients team to ensure a seamless transition and effective ongoing management of the new data warehouse.

Required Qualifications :

  • A minimum of 5 years of experience in data warehouse migrations particularly transitioning from onpremise environments to cloudbased platforms.
  • Proven expertise in Microsoft Synapse including architecture design implementation and performance optimization.
  • Handson experience planning and executing data warehouse migrations especially from WhereScape or similar platforms to Microsoft Synapse.

Technical Skills :

  • Proficient in SQL ETL processes data modeling and cloud data warehousing technologies.
  • Experience migrating data marts into Microsoft Synapse.
  • Familiarity with Data Factory / ETL data flows into Azure Data Lake.
  • Strong understanding of Azure storage tier options specifically for data marts with sentiment layers (e.g. timebased layers).
  • Ability to craft a comprehensive migration strategy to Microsoft Synapse.
  • Familiarity with GitHub for version control and collaborative development.
  • Excellent communication and interpersonal skills to collaborate effectively with both technical and nontechnical stakeholders.
  • 18 days ago
Related jobs
Promoted
Stellar IT Solutions LLC
Nampa, Idaho

Oversee the migration of data marts from the current onpremise data warehouse to Microsoft Synapse ensuring high levels of data integrity accuracy and security throughout the process. Data Warehouse Migration Engineer. Apply best practices for optimizing the performance of the Synapse data warehouse...

Stellar IT Solutions LLC
Nampa, Idaho

Oversee themigration of data marts from the current onpremise data warehouseto Microsoft Synapse ensuring high levels of data integrityaccuracy and security throughout theprocess. Data Warehouse MigrationEngineer. Apply bestpractices for optimizing the performance of the Synapse datawarehouse includ...

Promoted
Idaho State Job Bank
ID, United States

As an IT Solution Architect at Micron representing one or more service domains, you will participate in the ongoing partnership and communication with the various Enterprise Architecture (EA) teams, Site IT, Solution Managers, Project Managers, and with project teams to develop and implement systems...

Promoted
Christeyns
Meridian, Idaho

Dit omvat het optimaliseren van de databasestructuren om duurzaamheidsdata nauwkeurig te verzamelen en het implementeren van geavanceerde data pipelines. Dit vergt complexe en kwalitatieve dataverzameling en dataverwerking waarvoor de groep op zoek is naar een extra. Ervaring met het verwerken en an...

Promoted
Attijariwafabank
Meridian, Idaho

Reviewing all the operation works, leading operators to complete all duties in the data center. Ensure that Data Center operations duties are carried out on a timely basis ensuring the provision of best service to BBE users. Liaise with the Data Center manager on all operations-related issues. Parti...

Promoted
Page Mechanical Group, Inc.
Meridian, Idaho

Leverages deep expertise in one of the programming languages for data processes (Python, Scala) and expertise in building data lakes. Provides best practices of ETL/ELT design methodologies, architecture, strategy, and tactics for complex ETL solution. Technical leadership of data engineering pipeli...

Promoted
ICTerGezocht
Meridian, Idaho

Collaborate with other data engineers, data analysts, and business stakeholders to identify and define use cases, formulate hypotheses, and design solutions for stakeholders. Are you passionate about data analysis and visualization? We're excited to have you join our team! Dive into a role where you...

Promoted
Fides Info Sys, Inc
Meridian, Idaho

The Databricks Data Engineer is responsible for designing, building, and maintaining scalable data pipelines and infrastructure. The successful candidate will have a solid foundation in data engineering principles, substantial experience with Databricks, and a proven track record of implementing rob...

Promoted
Fontainbleau
Meridian, Idaho

Identify, collect, consolidate, and analyze data from various source systems and data warehouse encompassing the company’s operations, including, financial data, customer data, sales data, and other relevant metrics. The Senior Analyst of Data Analytics role will be responsible for aiding the cleans...

Promoted
Kenya
Meridian, Idaho

Data Analyst Certification Course in Delhi, 110032. Learn from eminent IIT/NIT faculty and become a globally certified Data Analyst. Get a great career path to a career in Data analytics by Structured Learning Assistance. In the Data Analytics program, you’ll learn a high in-demand skill set that wi...