Merck KGaA

Senior Analyst - JDA (Blue Yonder), Informatica

Posted On

Dec. 23, 2024

Location

Bangalore, Karnataka

Experience Level

D - Professional (4-9 years)

Job Type

Full-time

Apply By

Jan. 28, 2025

Job Description

Job Description: We are looking for a talented Informatica PowerCenter or IDMC Developer with 5 to 7 years of experience, proficient in Oracle SQL and PL/SQL or other any other database systems, to join our dynamic team. The ideal candidate should possess a deep understanding of ETL processes, database concepts, data modeling, and data warehousing principles. Experience Level: 5-7 YearsLocation: BangaloreKey Responsibilities:Minimum of 5-7 years of experience in designing, developing, and deploying ETL workflows using Informatica PowerCenter to integrate data from multiple sources into data warehouses.Work experience in Oracle SQL, PL/SQL, and database systems.Proficient in developing ETL workflows and mappings to ensure seamless data integration and transformation.Skilled in utilizing various transformations such as Filter, Expression, Lookup, Sequence Generator, Update Strategy, Joiner, Router, and Aggregator.Experienced in creating and managing Mappings, Mapplets, Transformations, Sessions, Workflows, and Worklets within Informatica PowerCenter.Capable of implementing Slowly Changing Dimensions (SCD1 and SCD2) using Informatica.Expertise in developing incremental load processes using Informatica PowerCenter or other ETL tools.Proficient in creating and managing workflows, sessions, tasks, and worklets using Workflow Manager.Ability to develop tasks such as Session, Email, Command, Decision, Assignment Variable, Event Wait, and Event Raise.Experience in performance tuning of ETL processes and optimizing workflows for maximum efficiency.Proven experience collaborating with international teams, including European teams.Expertise in Oracle Database concepts, including creating tables, indexes, views, sequences, and triggers.Skilled in creating complex SQL queries and analytical queries.Proficient in PL/SQL concepts, including packages, procedures, functions, variables, cursors, and dynamic SQL.Experience in Oracle SQL and PL/SQL performance tuning.Hands-on programming experience and familiarity with the software development life cycle.Fluent in English, both written and spoken.Strong teamwork and communication skills with stakeholders and software providers

Jobs at Bangalore

Capgemini

Cost Accounting with SAP S/4HANA Co…

Experienced Professionals

Bangalore, Karnataka

Senior Analyst - JDA (Blue Yonder), Informatica Apply Now

Job Description

Jobs at Bangalore

More Jobs at Merck KGaA

Actively Recruiting Companies at Bangalore, Karnataka

Senior Analyst - JDA (Blue Yonder), Informatica