IICS Snowflake Developer

Mandatory Skills:

• IICS ETL Tool:
• 3+ years of experience in pipeline development using Informatica Intelligent Cloud Services (IICS).
• Hands-on experience with data quality checks using IICS.
• SQL:
• 3+ years of experience with SQL, including writing and optimizing queries.
• AWS S3 Integration:
• Experience pulling data from AWS S3 buckets, specifically converting CSV files into tables.
• Snowflake:
• 2+ years of experience working with Snowflake for data storage and processing.
• DDL Scripts:
• Proficiency in creating Data Definition Language (DDL) scripts.

Preferred Skills:

• Experience with JIRA for project tracking and task management.

Key Responsibilities:

• Develop and maintain ETL pipelines using IICS to extract, transform, and load data.
• Integrate data from AWS S3 and other sources into Snowflake tables.
• Create and execute DDL scripts to set up and manage database structures.
• Perform data quality checks to ensure accuracy and reliability of datasets.
• Collaborate with cross-functional teams to meet project deadlines and goals.
• Utilize JIRA for task tracking and efficient project management.