Senior IICS (Informatica) ETL Architect

Job Title: Senior Technical Architect IICS

Remote

Contract & Full Time

• Mandatory skillset: IBM I Series DB2 CDC and Informatica IICS
• Good to have skillset: Snowflake and PowerBI The person should be able to lead a data engagement and interact effectively with clients. He should be strong in Snowflake and has broader knowledge base in other areas like Databricks, Cloud etc. He should be good in Python
  
  

Top skills to look for is IISC, informatica and IBM i5.

Primary Skills

• ETL Architecture and Data Modeling: Designing and implementing efficient ETL architectures to extract, transform, and load data from diverse sources into target systems. Proficiency in data modeling techniques to ensure optimal database structures for analytics and reporting.
• Change Data Capture (CDC): Experience with CDC methodologies and tools for capturing and propagating data changes in real-time or near real-time, enabling timely updates to downstream systems and analytics.
• Informatica Intelligent Cloud Services (IICS): Expertise in leveraging IICS for cloud-based data integration, data quality, and master data management solutions. Ability to design and deploy scalable and robust data pipelines using IICS components.
• Snowflake: In-depth knowledge of Snowflake cloud data platform, including architecture, features, and best practices. Experience in designing and implementing Snowflake data warehouses, data lakes, and data sharing solutions to meet business requirements.
  
  

Secondary Skill

• Power BI: Familiarity with Microsoft Power BI for data visualization, reporting, and dashboarding. Ability to design and develop Power BI reports and dashboards to provide insights into organizational data.
• Strong Communication Skills: Excellent communication skills to effectively collaborate with stakeholders, articulate technical concepts to non-technical audiences, and lead discussions on architectural design and implementation strategies.
  
  

This role requires a seasoned technical architect who can provide leadership and guidance in designing and implementing scalable, reliable, and performant data solutions. The ideal candidate should have a strong foundation in ETL architecture and data modeling, with hands-on experience in CDC, IICS, and Snowflake. Additionally, proficiency in Power BI and excellent communication skills are essential for successful collaboration and stakeholder engagement.