IN Senior Associate Informatica Developer Data & Analytics Advisory Kolkata

Line of Service

Advisory

Industry/Sector

Not Applicable

Specialism

Data, Analytics & AI

Management Level

Senior Associate

Job Description & Summary

A career within…. 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.

*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. "

 

Responsibilities:

• 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.

Mandatory skill sets:

Informatica, ETL

Preferred skill sets:

Informatica, ETL

Years of experience required:

4 - 8

Education qualification:

B.Tech / M.Tech / MBA / MCA

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

Degrees/Field of Study required: Master of Business Administration, Bachelor of Engineering, Master of Engineering

Degrees/Field of Study preferred:

Certifications (if blank, certifications not specified)

Required Skills

ETL (Informatica), Informatica ETL

Optional Skills

Accepting Feedback, Accepting Feedback, Active Listening, Analytical Thinking, Business Case Development, Business Data Analytics, Business Intelligence and Reporting Tools (BIRT), Business Intelligence Development Studio, Communication, Competitive Advantage, Continuous Process Improvement, Creativity, Data Analysis and Interpretation, Data Architecture, Database Management System (DBMS), Data Collection, Data Pipeline, Data Quality, Data Science, Data Visualization, Embracing Change, Emotional Regulation, Empathy, Inclusion, Industry Trend Analysis {+ 12 more}

Desired Languages (If blank, desired languages not specified)

Travel Requirements

Available for Work Visa Sponsorship?

Government Clearance Required?

Job Posting End Date