Job Title: Informatica IICS Developer

Location – Remote Role

Contract -12+ months(Possibility of extension)

 Client: ARTECH/IBM

End Client: Not Yet Revealed

Job Description-

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


• Participate in code reviews and ensure that all solutions are aligned to pre-defined architectural and requirement specifications


• May prepare or review product documentation, written instructions or technical literature for accuracy and completeness


• 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