Description

You will focus on the design, development, and support of data warehousing and integration solutions.

Responsibilities

• Design and implement data integration solutions using Informatica PowerCenter, PowerExchange, and Informatica Cloud Services (IICS).
• Execute migrations from Informatica 10.2 to IICS and migrate data to Snowflake Cloud databases.
• Develop complex database objects, including queries, views, and materialized views, using SQL and PL/SQL.
• Build reusable transformations, Mapplets, and Mappings to implement business rules across XML, JSON, and relational formats.
• Perform ETL/DWH testing and manage slowly changing dimensions (CDC) within star and snowflake schemas.

Required Skills

• 5+ years of relevant industry experience.
• Proficiency with Informatica PowerCenter tools including Designer, Workflow Manager, Workflow Monitor, and Repository Manager.
• Hands-on experience with Informatica Cloud Services (IICS).
• Strong SQL and PL/SQL skills for developing database objects.
• Experience with Oracle, Teradata, SQL Server, and DB2 databases.
• Working knowledge of Windows and Unix environments.
• Expertise in data warehousing concepts such as star schema, snowflake schema, dimensions, and fact tables.
• Technical proficiency with XML and JSON file formats.
• Experience with Snowflake and DB2.

Education

• Bachelor's degree in Technology, Computer Science, or a related field.

Key Skills

Education

Bachelor's degree