Line of Service
Advisory
Industry/Sector
Not Applicable
Specialism
Product Innovation
Management Level
Senior Associate
Job Description & Summary
A career in our Platform and Integration Architecture practice will provide you with the opportunity to bring our clients a competitive advantage through delivering architecture solutions, governance and alignment during the delivery process, and ensure alignment to the overall project objectives and technology strategy.
As part of our Cloud Architecture team, you'll focus on the architecture of data centers, including the design and implementation of network architecture and information storage to optimize innovation and program delivery for our clients.
To really stand out and make us fit for the future in a constantly changing world, each and every one of us at PwC needs to be an authentic and inclusive leader, at all grades/levels and in all lines of service. To help us achieve this we have the PwC Professional; our global leadership development framework. It gives us a single set of expectations across our lines, geographies and career paths, and provides transparency on the skills we need as individuals to be successful and progress in our careers, now and in the future.
As a Senior Associate, you'll work as part of a team of problem solvers, helping to solve complex business issues from strategy to execution. PwC Professional skills and responsibilities for this management level include but are not limited to:
- Use feedback and reflection to develop self awareness, personal strengths and address development areas.
- Delegate to others to provide stretch opportunities and coach to help deliver results.
- Develop new ideas and propose innovative solutions to problems.
- Use a broad range of tools and techniques to extract insights from from current trends in business area.
- Review your work and that of others for quality, accuracy and relevance.
- Share relevant thought leadership.
- Use straightforward communication, in a structured way, when influencing others.
- Able to read situations and modify behavior to build quality, diverse relationships.
- Uphold the firm's code of ethics and business conduct.
JOB DESCRIPTION β ETL Testing
REQUIRED EXPERIENCE:
MUST HAVE
- 3-5 years of experience in ETL and Data Warehouse testing on GCP platform
- Knowledge of any automated testing tool is preferred
- Proficient in writing SQL Queries to extract data as per the test cases and perform data comparison
- Create SIT test cases/test data and perform Test execution
- Knowledge of dimensional modeling and data warehouse concepts, such as star schemas, snowflakes, dimensions and facts
- Review Data Models, Data Mappings, Architectural Documentation to create/execute effective SIT Test Plans and SIT test cases
- Analyzes and troubleshoots erroneous results, determines the root cause of defects, logs the defects in HP Quality Center/ALM/Jira or other Test Management tool and enables defect management, including working with the development team on the resolution of Software related defects
- Works closely with software development team (Business Analysts, Developers & other testers) to ensure timely and effective testing effort
- Ensure all sign offs on deliverables (overall test strategy, test plan, test cases, ) and that testing meets governance requirements
- Solid understanding of databases and systems and the ability to communicate effectively across groups
- Self-Starter, with strong confidence level
- Flexible in thought and creative in approach to testing
- Experienced in an Onshore/Offshore model, ability to work independently and with a team.
- Excellent Communication, Analytical and Problem-solving skills
PREFERRED / GOOD TO HAVE
- Knowledge of ETL automation tool such as Query surge
- Basic understanding of big data technologies
- Cloud technology knowledge/experience β Azure, AWS, GCP
- Experience in various databases β Oracle, Teradata, Snowflake etc.
ROLES / RESPONSIBILITIES:
- Design, implement, and continuously expand data pipelines by performing extraction, transformation, and loading activities
- Gather requirements and business process knowledge to transform the data in a way thatβs geared towards the needs of end users
- Maintain and improve already existing processes
- Ensure that the data architecture is scalable and maintainable
- Work with the business in designing and delivering correct, high-quality data
- Investigate data to identify potential issues within ETL pipelines, notify end-users and propose adequate solutions
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
January 22, 2025