Question: Need to make a script for interview based on these responsibilties. assume it is heathcare domain. Thanks in advance Role: Data Engineer Responsibilities: Design and
Need to make a script for interview based on these responsibilties. assume it is heathcare domain. Thanks in advance
Role: Data Engineer
Responsibilities:
- Design and implement end-to-end data solutions (storage, integration, processing, visualization) in Azure.
- Architect and implement ETL and data movement solutions using Azure Data Factory, SSIS
- Develop dashboards and visualizations to help business users analyze data as well as providing data insight to upper management with a focus on Microsoft products like SQL Server Reporting Services (SSRS) and Power BI.
- Engage with business users to gather requirements, design visualizations and provide training to use self-service BI tools.
- Developed and maintained multiple Power BI dashboards/reports and content packs.
- Created POWER BI Visualizations and Dashboards as per the requirements
- Used various sources to pull data into Power BI such as SQL Server, Excel, Oracle, SQL Azure etc.
- Propose architectures considering cost/spend in Azure and develop recommendations to right-size data infrastructure.
- Design and implement database solutions in Azure SQL Data Warehouse, Azure SQL
- Migrate data from traditional database systems to Azure SQL databases
- Implement ad-hoc analysis solutions using Azure Data Lake Analytics/Store, HDInsight
- Design and implement streaming solutions using Azure Stream Analytics
- Design and develop data visualizations in Power BI.
- Prepare documentation and architectural designs.
- Propose architectures that consider cost/spend in Azure and develop recommendations to right-size Azure data infrastructure.
- Work with similar Microsoft on-prem data platforms, specifically SQL Server and related technologies such as SSIS, SSRS.
- Migrate data from traditional database systems to Azure databases.
- Recreating existing application logic and functionality in the Azure Data Lake, Data Factory, SQL Database and SQL data warehouse environment. experience in DWH/BI project implementation using Azure DF.
- Interacts with Business Analysts, Users, and SMEs on requirements
- Designs Logical and Physical Data Model for Staging, DWH and Data Mart layer.
- Recommend, Design and construct policies and standards that impact infrastructure operations and services but also improve overall business performance. (Strategic)
- Develop dashboards and visualizations to help business users analyze data as well as providing data insight to upper management with a focus on Microsoft products like SQL Server Reporting Services (SSRS) and Power BI.
- Engage with business users to gather requirements, design visualizations and provide training to use self-service BI tools.
- Developed and maintained multiple Power BI dashboards/reports and content packs.
- Created POWER BI Visualizations and Dashboards as per the requirements
- Used various sources to pull data into Power BI such as SQL Server, Excel, Oracle, SQL Azure etc.
- Propose architectures considering cost/spend in Azure and develop recommendations to right-size data infrastructure.
- Experience managing Azure Data Lakes (ADLS) and Data Lake Analytics and an understanding of how to integrate with other Azure Services. Knowledge of USQL and how it can be used for data transformation as part of a cloud data integration strategy.
- Participating in Technical Architecture Documents, Project Design, and Implementation Discussions.
- Worked on SQL Server Integration Services (SSIS), SSRS, T-SQL skills, stored procedures, triggers.
Environment: MS SQL Server Stack, SSRS, Power BI, Tableau, Query Analyzer, Visual Studio, HTML, Script, System Monitor/Performance Monitor, Event Viewer, SQL Profiler, SQL Clustering, Index Tuning, SDLC, Azure Data Factory, and PowerBI, Data Warehousing, Azure Databricks, FHIR
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
