Line of Service

Advisory

Industry/Sector

TMT X-Sector

Specialism

Data and Analytics Technologies

Management Level

Associate

Job Description & Summary

A career in our Advisory Service Delivery 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.

Responsibilities

As an Associate, you’ll work as part of a team of problem solvers with extensive consulting and industry experience, helping our clients solve their complex business issues from strategy to execution. Specific responsibilities include but are not limited to:

• Proactively assist the team in various aspects of the project
• Prepare deliverables
• Contribute to the development of your own and team’s technical acumen
• Keep up to date with local and national business and economic issues
• Ensure you are adhering to compliance matters
• Work on developing internal relationships and your PwC brand

Responsibilities
1. Design, develop and implement Extract, Transformation and Load (ETL) processes, programs and scripts using structured software development method.
2. Develop data/metadata models and technical specifications using standard modeling techniques
3. Consult with analysts, data providers and business operations staff to understand and elaborate data dissemination requirements and propose technical solutions
4. Evaluate data product requirements from data providers and translate the requirements into technical specifications
5. Define technical standards; evaluate alternative protocols, tools and standards.
6. Conduct root cause analysis and resolve production problems
7. Create documentation of implemented ETL processes for knowledge sharing and hand-off
8. Develop estimates for design
Requirements
1. 3+ year of experience with informatica tool-related development work, ETL approach and technologies.
2. Strong understanding in data warehouse concepts.
3. Proficient in SQL programming. Hands-on experience in DB2 or Oracle Database is preferred.
4. Good communication skills, verbal and written in English or Japanese

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)

Desired Languages (If blank, desired languages not specified)

Travel Requirements

Up to 40%

Available for Work Visa Sponsorship?

Yes

Government Clearance Required?

No

Job Posting End Date