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.Skills Required
snowflake , Informatica Intelligent Cloud Services, Data Definition Language, Aws