Senior Analyst - JDA (Blue Yonder), Informatica

Work Your Magic with us! 

Ready to explore, break barriers, and discover more? We know you’ve got big plans – so do we! Our colleagues across the globe love innovating with science and technology to enrich people’s lives with our solutions in Healthcare, Life Science, and Electronics. Together, we dream big and are passionate about caring for our rich mix of people, customers, patients, and planet. That`s why we are always looking for curious minds that see themselves imagining the unimageable with us.

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 Years

Location: Bangalore

Key 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

What we offer: We are curious minds that come from a broad range of backgrounds, perspectives, and life experiences. We celebrate all dimensions of diversity and believe that it drives excellence and innovation, strengthening our ability to lead in science and technology. We are committed to creating access and opportunities for all to develop and grow at your own pace. Join us in building a culture of inclusion and belonging that impacts millions and empowers everyone to work their magic and champion human progress!

Apply now and become a part of our diverse team!