RS0016-IICS Architect

RS0016-IICS Architect - Spearwin-RS

Date Posted: Sep 27, 2023

Email to Friend Add to Favourite Report Abuse

Design, develop and maintain Informatica cloud data integration processes using the appropriate data load technique, including Push-Down Optimization for performance optimization
Analyzes the impact of changes on existing ETL/ELT processes and systems. Assesses the compatibility with goals in all areas. Analyzes cost effectiveness and feasibility
Debug and tune data integration processes; analyze data warehouse architecture, normalized/de-normalized, star schemas and snowflakes, slowly changing dimensions, dimensional surrogate key handling, exception data processing, troubleshoot and recommend improvements and alternate methodologies
Design, develop and maintain Snowflake database objects (tables, views, stored procedures, etc.) and SQL scripts.
Should have experience in create APIs using IICS & integrate IICS with other internal & external applications .
Data Quality management
Maintenance of business rules associated with data integration
Participate in the fulfillment of ad-hoc data requests from internal business owners
Participate in design reviews and provide input to the design recommendations; provide input to information/data flow, understand and comply with Project Life Cycle Methodology in all planning steps
Should have experience in doing basic administration of IICS.