Key Skills: IICS, Snowflake, ETL, data migration, SQL, data modeling, web services, cloud integration, problem-solving, project management, communication, security, data warehousing.
Roles & Responsibilities:
- Implement ETL solutions with a focus on IICS (Informatica Intelligent Cloud Services) and Snowflake.
- Develop ETL processes using IICS, including CDI, CAI, and Mass Ingestion.
- Utilize various connectors for different source/file formats and databases.
- Integrate web services into ETL processes for data exchange.
- Administer IICS to ensure smooth operational environment and system performance.
- Design and implement data models within the Snowflake environment.
- Develop ETL processes using Snowflake features and SQL.
- Ensure security best practices and access control within Snowflake.
- Manage data migration to Snowflake from other platforms.
- Troubleshoot, analyze, and resolve critical issues during the development process.
- Collaborate effectively with the team and communicate status updates with customers.
Experience Requirement:
- 5-8 years of experience in implementing ETL solutions with a strong focus on IICS and Snowflake.
- Proven hands-on development experience in IICS, including CDI, CAI, and Mass Ingestion.
- Strong proficiency in developing ETL processes using Snowflake features and SQL.
- Familiarity with data integration and data warehousing concepts.
- Experience with data migration to Snowflake from other platforms is a plus.
- Excellent problem-solving skills with the ability to analyze and resolve issues.
- Strong organizational, project management, and prioritization skills.
- Proven ability to work in a client-facing role with a focus on delivering high-quality work.
Education: Any Graduation