ADF+ ADB+ DW (Python) - Manager

☞ PwC

View: 101

Update day: 30-05-2024

Location: Bengaluru / Bangalore Karnataka

Category: Printing / Publishing

Industry: Financial Services

Loading ...

Job content

Line of Service

Advisory

Industry/Sector

Not Applicable

Specialism

Microsoft

Management Level

Manager

Job Description & Summary

A career in our Advisory Acceleration Centre is the natural extension of PwC’s leading class global delivery capabilities. We provide premium, cost effective, high quality services that support process quality and delivery capability in support for client engagements.
Should have a total Experience of 10 to 14 years- Managers.

Microsoft Azure Platform - Mandatory
  • Demonstrated experience in end-to-end deployment of MS Azure BI solution
  • Hands on experience in developing solutions using Azure data factory
  • Hands on experience in building data lake from multiple data sources with ingestion, data governance and auditing capabilities
  • Should have exposure to Microsoft Azure platform, including Azure Data Factory (ADF), Azure Cosmos DB, Azure Storage, Azure Data Warehouse (SQLDW), Event Hubs, Data Lake Store, Data Lake Analytics, U-SQL, HD Insights, PowerShell

SQL Server - Mandatory
  • Expert in designing and implementing relational database and Dimensional model
  • In-depth knowledge of Transact-SQL (DDL, DML)- creating indexes, Views, complex Stored Procedures, user defined functions, cursors, derived tables, common table expressions (CTEs) and Triggers to facilitate efficient data manipulation and data consistency.

SQL Server Integration Services (SSIS) - (Desirable)
  • Proficient in implementing all transformations available on the SSIS toolbox.
  • Excellent knowledge of using variables and expressions in packages.
  • Experienced in creating master and child packages, package configurations and logging.
  • Experienced in SSIS package Auditing.
  • Experienced in SSIS package deployment and Scheduling

Power BI (Desirable)
  • Experience in creating Microsoft Power BI dashboards, modeling, reports with a focus on usability, performance, flexibility, testability, and standardization
  • Experience in Data Gateway for data refreshing, contents packs, publishing reports to app.powerbi.com
  • Exposure to custom visuals, embedding Power BI reports, SSRS integration with Power BI
  • Exposure to Power Pivot, T-SQL, MDX, VBA, DAX, Power queries
Key Responsibilities:
  • Work with business users and other stakeholders to understand business processes.
  • Ability to design and implement Dimensional and Fact tables
  • Determine testing needed to assure the functionality and integrity of the reporting solutions, create test plans, and evaluate testing results taking corrective action as necessary
  • Should have a mind-set to challenge status-quo with out-of-box solutions.
  • Able to translate functional and technical requirements into detail design.
  • Able to implement and follow industry best practices in relevant technologies.
  • Good troubleshooting and application performance tuning experience.
  • Prepare and produce releases of software components

Education(if blank, degree and/or field of study not specified)

Degrees/Field of Study required: Degrees/Field of Study preferred:

Certifications(if blank, certifications not specified)

Required Skills

Optional Skills

Desired Languages(If blank, desired languages not specified)

Travel Requirements

Not Specified

Available for Work Visa Sponsorship?

No

Government Clearance Required?

No

Job Posting End Date

November 30, 2021
Loading ...
Loading ...

Deadline: 14-07-2024

Click to apply for free candidate

Apply

Report job
Loading ...
Loading ...

SIMILAR JOBS

Loading ...
Loading ...