As an Informatica (IICS) consultant on this team, you will be responsible for designing, developing, and supporting cloud-based data integration and data warehouse solutions using Informatica Intelligent Cloud Services (IICS). You will work closely with business and technical stakeholders to understand data requirements, translate them into scalable data models, and build reliable ETL/ELT pipelines.
This role requires strong experience in dimensional modeling and enterprise data warehousing concepts, along with hands-on expertise in Informatica IICS tools. You will produce technical design documentation, implement solutions following best practices, perform unit testing, and support end-to-end data flows with a comprehensive business context in mind.
Minimum Qualifications
Experience in data integration and data warehousing solutions.
Hands-on experience with Informatica Intelligent Cloud Services (IICS), including Cloud Data Integration and related services.
Strong expertise in dimensional modeling (star and snowflake schemas) and enterprise data warehouse design.
Proven experience designing and developing ETL/ELT pipelines to support analytics and reporting use cases.
Experience working with multiple source systems (e.g., transactional systems, SaaS applications, flat files) and loading curated data into a data warehouse or analytics platform.
Familiarity with data quality, data validation, error handling, and performance optimization best practices.