IN-Manager GCP+SSIS -- Data and Analytics Advisory Kolkata

Line of Service

Advisory

Industry/Sector

Not Applicable

Specialism

Data, Analytics & AI

Management Level

Manager

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: A career within PWC

Responsibilities:

Role: SQL Server Integration Service - Architect

· Team leading: Need to lead the delivery track, coordinate with client Architect, Present architectural solutions to client stakeholders. Guide the team members, review the code, establish the technology best practices.

· Designing and Developing SSIS Packages: Creating and modifying SSIS packages to move and transform data between different systems, including databases, files, and other sources. 

· ETL Processes: Implementing ETL workflows to extract data from various sources, transform it according to business rules, and load it into data warehouses or other target systems. 

· SQL Development: Writing and optimizing stored procedures, functions, views, and triggers in SQL Server to support the SSIS packages and data transformations. 

· Data Warehousing: Working with data warehouse concepts like schemas, facts, and dimensions, and designing ETL solutions for data warehousing. 

· Reporting: Potentially developing reports using SSRS (SQL Server Reporting Services) or other reporting tools to visualize and analyze data processed by SSIS. 

· Testing and Quality Assurance: Ensuring the accuracy and efficiency of ETL processes through unit testing, system testing, and other quality assurance activities. 

· Troubleshooting and Support: Identifying and resolving issues with SSIS packages and ETL processes, providing support to users, and maintaining documentation. 

· Performance Optimization: Tuning SSIS packages and SQL code to optimize performance and ensure efficient data loading. 

· Data Quality: Building processes to validate and cleanse data during the ETL process, ensuring high-quality data for reporting and analysis. 

· Documentation: Creating and maintaining documentation for SSIS packages, ETL processes, and related configurations. 

Team leading: Need to lead the delivery track, coordinate with client Architect , Present architectural solutions to client stakeholders. Guide the team members ,review the code , establish the technology best practices.

Skill and Experience:

· Microsoft SQL Server: Strong understanding of SQL Server database concepts, T-SQL, stored procedures, functions, and performance tuning.  Nede more than 10+ years of experience.

· SSIS: Proficiency in designing, developing, and deploying SSIS packages. 

· ETL Processes: Experience with ETL methodologies and best practices. 

· Data Warehousing: Knowledge of data warehouse concepts, schemas, and dimensional modeling. 

· Troubleshooting and Problem Solving: Ability to diagnose and resolve issues related to SSIS packages and ETL processes. 

· Communication: Strong communication and collaboration skills to work with business users and other IT teams. 

Mandatory skill sets:

GCP+SSIS

Preferred skill sets:

GCP+SSIS

Years of experience required:

8-16 years

Education qualification:

BE/BTECH, ME/MTECH, MBA, MCA

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

Degrees/Field of Study required: Master of Engineering, Master of Business Administration, Bachelor of Engineering, Bachelor of Technology, Chartered Accountant Diploma

Degrees/Field of Study preferred:

Certifications (if blank, certifications not specified)

Required Skills

ICH GCP Guidelines

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, Coaching and Feedback, Communication, Competitive Advantage, Continuous Process Improvement, Creativity, Data Analysis and Interpretation, Data Architecture, Database Management System (DBMS), Data Collection, Data Pipeline, Data Quality, Data Science, Data Visualization, Embracing Change, Emotional Regulation, Empathy, Inclusion {+ 21 more}

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