Line of Service

Advisory

Industry/Sector

Not Applicable

Specialism

Data, Analytics & AI

Management Level

Senior Associate

Job Description & Summary

At PwC, our people in data and analytics focus on leveraging data to drive insights and make informed business decisions. They utilise advanced analytics techniques to help clients optimise their operations and achieve their strategic goals.

In business intelligence at PwC, you will focus on leveraging data and analytics to provide strategic insights and drive informed decision-making for clients. You will develop and implement innovative solutions to optimise business performance and enhance competitive advantage.

*Why PWC

At PwC, you will be part of a vibrant community of solvers that leads with trust and creates distinctive outcomes for our clients and communities. This purpose-led and values-driven work, powered by technology in an environment that drives innovation, will enable you to make a tangible impact in the real world. We reward your contributions, support your wellbeing, and offer inclusive benefits, flexibility programmes and mentorship that will help you thrive in work and life. Together, we grow, learn, care, collaborate, and create a future of infinite experiences for each other. Learn more about us.

At PwC, we believe in providing equal employment opportunities, without any discrimination on the grounds of gender, ethnic background, age, disability, marital status, sexual orientation, pregnancy, gender identity or expression, religion or other beliefs, perceived differences and status protected by law. We strive to create an environment where each one of our people can bring their true selves and contribute to their personal growth and the firm’s growth. To enable this, we have zero tolerance for any discrimination and harassment based on the above considerations. "

Job Description & Summary: We are seeking a hands-on Data Engineer with 5-8 years of experience specializing in on-premises database migration to cloud. The ideal candidate will have a strong background in cloud migration whether on-premises to Azure cloud, or cloud to Azure cloud.

Responsibilities:

Should have experience of database migration strategy and related technologies.

Experience of Microsoft SQL DB migration from on-prem to cloud platform.

Experience of any other cloud (e.g. AWS or GCP) to Azure cloud platform.

Review Database migration plans, provide recommendation and liaise with Customer and Migration Factory for successful migrations.

Ability to identify and resolve performance issues post-migration

Required Skills:

Knowledge in using tools like Azure Data Studio, Azure DMA, Azure DMS, Azure SQL/MI

Familiarity with migrating SSIS packages using ADF. SSMA Migration Tool, Database migration using SSIS Packages

In-depth knowledge of SQL, TSQL and programming experience with stored procedures, triggers, functions, etc.

Stronger performance tuning (partitioning, exec plans, indexing etc.), data modeling experience and dacpac deployment experience, Stored Procedures Optimization

Extensive experience with Azure Data Services, including Azure Data Factory, Azure SQL Data Warehouse, and Synapse Analytics.

Strong understanding of database architecture principles and best practices.

Preferred Qualifications:

Azure Solutions Architect Expert certification.

Knowledge of SQL Clustering/Always on Availability Groups, Azure SQL, SQL MI

Experience of CTS/Migration technologies. (Rehost/Clean Deployments)

Should have exp on Azure project and GitHib as Code Repo

Knowledge of setting up High Availability & Disaster Recovery configuration.

Experience in setting up Always ON Availability Groups & Zone Redundant Storage

Familiarity with Azure DevOps (ADO) for (CI/CD) pipelines, Infrastructure as Code (IaC) tools like Terraform for deploying container apps and associated services

Knowledge of security best practices and compliance requirements for cloud-based applications

Backup/recovery, Security related activities, Audit tracking and reporting

Maintaining and supporting, monitoring production and test environments

Implementing of High Availability such as Clustering, Database Mirroring, Log Shipping, and Replication

Mandatory skill sets:

Azure Data Studio, Azure DMA, Azure DMS, Azure SQL/MI, Migration of SSIS Packages using ADF. SSMA Migration tool, Database migration using SSIS Package, Knowledge of SQL, TSQL, Stored Procs, Exp in Azure Data Factory, Azure SQL Datawarehouse, Synapse Analytics. Understanding of database architecture principles. 

Preferred skill sets:

Knowledge of SQL Clustering/Always on Availability Groups, Azure SQL, SQL MI. Experience of CTS/Migration technologies. (Rehost/Clean Deployments)

Years of experience required:

5 to 8 years

Education qualification:

Graduate Engineer or Management Graduate

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

Degrees/Field of Study required: Bachelor of Engineering

Degrees/Field of Study preferred:

Certifications (if blank, certifications not specified)

Required Skills

Microsoft Azure

Optional Skills

Accepting Feedback, Accepting Feedback, Active Listening, Analytical Thinking, Business Case Development, Business Data Analytics, Business Intelligence and Reporting Tools (BIRT), Business Intelligence Development Studio, Communication, Competitive Advantage, Continuous Process Improvement, Creativity, Data Analysis and Interpretation, Database Management System (DBMS), Data Collection, Data Pipeline, Data Quality, Data Science, Data Visualization, Embracing Change, Emotional Regulation, Empathy, Inclusion, Industry Trend Analysis, Intellectual Curiosity {+ 11 more}

Desired Languages (If blank, desired languages not specified)

Travel Requirements

Available for Work Visa Sponsorship?

Government Clearance Required?

Job Posting End Date

IN-Senior Associate_Azure Cloud Migration Engineer_Data & Analytics_Advisory_Bangalore

PWC

Job Description

About Company

Services you might be interested in

One-Shot Campaign