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