Informatica/ ETL Architect (IICS)

  • Dallas, TX
  • Posted 27 days ago | Updated 2 hours ago

Overview

On Site
Hybrid
USD110000.0/ANNUAL - USD125000.0/ANNUAL
Full Time

Skills

IICS
snowflake
ETL Architecture
Informatica
Data Modeling

Job Details

Roel Informatica/ ETL Architect (IICS)

Location : Dallas, TX (Hybrid)

Full Time

Required Experience: 12 - 16 Years

Skills : IICS, snowflake, ETL Architecture, Data Modeling

Primary Skills:

  • bold; font-size: 14px;">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.

  • bold; font-size: 14px;">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.

  • bold; font-size: 14px;">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.

  • bold; font-size: 14px;">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:

  • bold; font-size: 14px;">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.

  • bold; font-size: 14px;">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.

  • bold; font-size: 14px;">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.