- 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 productive project management.