Data Engineer- IICS, Snowflake- Senior Associate 2

Line of Service

Advisory

Industry/Sector

Not Applicable

Specialism

Data, Analytics & AI

Management Level

Senior Associate

Job Description & Summary

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

Job Title - Data Engineer- IICS, Snowflake

Exp - 4+ yrs

Required :

• Experience in IICS- Data Integration and Application Integration -Data Warehousing / Data Marts / Data Lake Projects using Informatica Cloud

• Should have expertise in extracting data from different source systems like flat files, XML sources, Big data appliances, RDBMS, etc.,

• Design, develop, and support our Data applications and infrastructure utilizing various technologies to process large volumes of data

• Strong technical experience building data integration processes by constructing mappings, tasks, task flows, schedules, and parameter files

• Provide technical assistance in identifying, evaluating, and developing systems and procedures.

• Create or update technical documentation for transition to support teams

• Develop automated data audit and validation processes.

• Good to have experience in Application Integration Platform

• Develop and deploy ETL/ELT job workflow with reliable error/exception handling and rollback.

• Manage foundational data administration tasks such as scheduling jobs, troubleshooting job errors, identifying issues with job windows, assisting with Database backups and performance tuning.

• Design, Develop, Test, Adapt ETL/ELT code & jobs to accommodate changes in source data and new business requirements.

• Proactively communicate innovative ideas, solutions, and capabilities over and above specific task requests

• Participate in design review sessions and ensure all solutions are aligned to pre-defined architectural specifications.

• Ensure data quality throughout the entire ETL/ELT process, including audits and feedback loops performing business solutions to sources of truth.

• Reviews work products (Technical design documents, ETL code, Unit testing documents etc.) and provide guidance to team members

• Collaborate with various business and technical teams to gather requirements around data quality rules and propose the optimization of these rules as applicable

• Strong SQL Skills and performance tuning capabilities

• Good to have experience / exposure in Aurora, S3, Snowflake DB, RedShift

• Good communication and presentation skills

• Good knowledge of Application DevOps tools (Git, CI/CD Frameworks) - Experience in Jenkins or Gitlab with rich experience in source code management like Code Pipeline, Code Build and Code Commit

• Good understanding of Data Modelling and Data Architecture

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

November 25, 2024