IN-Associate_IICS Data Enginer_Data & Analaytics_Advisory_Gurgram

Line of Service

Industry/Sector

Specialism

Management Level

Job Description & Summary

*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 Data and Analytics services will provide you with the opportunity to help organisations uncover enterprise insights and drive business results using smarter data analytics. We focus on a collection of organisational technology capabilities, including business intelligence, data management, and data assurance that help our clients drive innovation, growth, and change within their organisations in order to keep up with the changing nature of customers and technology. We make impactful decisions by mixing mind and machine to leverage data, understand and navigate risk, and help our clients gain a competitive edge. 

Responsibilities:

• IICS (Informatica Intelligent Cloud Services)/Informatica ETL Developer experienced in designing, implementing, and maintaining data pipelines and ETL processes.
• Key Responsibilities:
• · Extensive experience in developing solutions with IICS Data Integration and Application Integration.
• · Design, develop, and maintain ETL workflows and mappings using IICS/Informatica PowerCenter.
• · Extract, transform, and load data from various source systems into data warehouses or other target systems.
• · Design data mapping strategies between source systems, and Salesforce Service Cloud.
• · Assist in mapping source data to target fields within Salesforce.
• · Work on integrating data from multiple sources, ensuring data quality and consistency.
• · Create reusable components, mappings, mapplets and workflows.
• · Proven experience in resolving data integration issues, ETL performance tuning, troubleshooting and optimization.
• Required Skills and Qualifications:
• · Bachelor’s degree in computer science, Engineering, or related field.
• · 4 to 7 years of hands-on experience as a Data Engineer, focusing on IICS/ Informatica PowerCenter.
• · Experience with SQL and database platforms (e.g., Oracle, SQL Server, MySQL).
• · Familiarity with cloud platforms (e.g., AWS, Azure, GCP) is a plus.
• · Good to know Database Ingestion / Mass Ingestion.
• · Design and develop ETL workflows using IICS to extract, transform, and load data into Salesforce Service Cloud
• · Knowledge of APIs and RESTful services for Data as well as Application integration
• · Worked on Rest V2 Connectors, Swager file.
• · Conduct various types of testing, including Unit testing, and User Acceptance Testing (UAT), to ensure data accuracy and integrity.
• · Experience with scripting languages (e.g., Python, Shell scripting) is a plus.
• · Create mappings/tasks /taskflows using Cloud Data Integration (CDI).
• · Create Processes/Connectors etc. using Cloud Application Integration (CAI)
• · Strong understanding of data warehousing concepts, star/snowflake schema, and dimensional modelling.
• · Knowledge of data governance, data quality, and security principles.
• Good to Have:
• · Experience in Data Migration
• · Experience in SOQL
• · Experience in Snowflake DB.

Mandatory skill sets:

IICS, ETL, Power Center

Preferred skill sets:

IICS, ETL, Power Center

Years of experience required:

3 - 4

Education qualification:

B.Tech / M.Tech / MBA / MCA

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

Certifications (if blank, certifications not specified)

Required Skills

Optional Skills

Desired Languages (If blank, desired languages not specified)

Travel Requirements

Available for Work Visa Sponsorship?

Government Clearance Required?

Job Posting End Date