Data Engineer-

At PwC, our people in managed services focus on a variety of outsourced solutions and support clients across numerous functions. These individuals help organisations streamline their operations, reduce costs, and improve efficiency by managing key processes and functions on their behalf. They are skilled in project management, technology, and process optimization to deliver high-quality services to clients. Those in managed service management and strategy at PwC will focus on transitioning and running services, along with managing delivery teams, programmes, commercials, performance and delivery risk. Your work will involve the process of continuous improvement and optimising of the managed services process, tools and services.

KEY SKILLS - Mainframe, Teradata Datastage

Mainframe and Teradata DataStage Associate

Summary:.

Minimum Degree Required: Bachelor's degree in computer science/IT or relevant field

Degree Preferred: Master's degree in computer science/IT or relevant field

Minimum Years of Experience: 6 - 8 year(s)

Certifications Required: NA

Required Knowledge/Skills: (character count limit 5000) *PLEASE ONLY USE THIS FIELD IF THIS IS A MUST HAVE SKILL FOR APPLICANT*

Job Summary

We are seeking a skilled and experienced IT professional to join our team as a Mainframe and Teradata DataStage Associate. The successful candidate will be responsible for developing, maintaining, and optimizing ETL processes using IBM DataStage, as well as managing and supporting data operations on Mainframe and Teradata platforms.

Key Responsibilities
• Design, develop, and implement ETL processes using IBM DataStage to support data integration and transformation requirements.
• Manage and maintain data on Mainframe and Teradata systems, ensuring data integrity and performance optimization.
• Collaborate with business analysts and stakeholders to understand data requirements and translate them into technical specifications.
• Troubleshoot and resolve issues related to ETL processes and data management on Mainframe and Teradata platforms.
• Monitor and tune the performance of ETL jobs and database queries to ensure optimal performance.
• Develop and maintain documentation related to ETL processes, data flows, and system configurations.
• Participate in code reviews and ensure adherence to best practices and coding standards.
• Provide support for data migration and integration projects, ensuring timely and accurate data delivery.
• Stay updated with the latest developments in Mainframe, Teradata, and DataStage technologies and recommend improvements.

Qualifications

Job Summary -

A career in our Managed Services team will provide you with an opportunity to collaborate with a wide array of teams to help our clients implement and operate new capabilities, achieve operational efficiencies, and harness the power of technology. Our Data, Testing & Analytics as a Service team brings a unique combination of industry expertise, technology, data management and managed services experience to create sustained outcomes for our clients and improve business performance. We empower companies to transform their approach to analytics and insights while building your skills in exciting new directions. Have a voice at our table to help design, build and operate the next generation of software and services that manage interactions across all aspects of the value chain.

Minimum Degree Required (BQ) *:

Bachelor's degree

Degree Preferred

Required Field(s) of Study (BQ):

Preferred Field(s) Of Study

Computer and Information Science, Management Information Systems

Minimum Year(s) of Experience (BQ) *: US

Certification(s) Preferred

Minimum of 1 year of experience

Preferred Skills (PQs)

Position Requirements:

Datasphere

Required Skills:
• More than 2 years of hands-on experience in SAP Datasphere / DWC at least 1 full life cycle project implementation.
• Work on development/maintenance of DWC Models, CDS Views, SQL Scripts SAC Stories
• Should have experience in building complex models in SAP Datasphere/ DWC
• Developing SAP Datasphere end-to-end Dataflows Design, build data flows, and develop chains to load and monitor Data Loading.
• Knowledge in setting up the connections to Datasphere and from Datasphere.
• Knowledge in handling the delta in Datasphere.
• Unit testing the dataflows and reconciling the data to Source Systems.
• Good exposure in troubleshooting data issues and provide workarounds in cases where there are product limitations.
• Good exposure with Datasphere security setup, currency conversion.
• Good knowledge in writing CDS Analytical Queries and S4HANA Embedded Analytics.
• Good exposure in performance tuning of the models in the datasphere.
• Good knowledge on Datasphere and Data Lake integration.
• Good Knowledge on using the Database explorer and SAP Hana Cockpit through Datasphere.

Nice To Have
• Good knowledge in either BW Modeling or HANA Modeling.
• BW/4HANA And/or Native HANA (or HANA Cloud) modeling, including SQL Scripting, Graphical View-Modelling, SDA extraction.