Mandatory Skills:
Pipeline Development:
3+ years of hands-on experience using Informatica Intelligent Cloud Services (IICS) for ETL pipeline development.
SQL:
3+ years of experience in SQL, including writing, optimizing, and managing queries.
AWS S3 Integration:
Proven experience in pulling data from AWS S3 buckets, including converting CSV files to database tables.
Snowflake:
Extensive experience working with Snowflake for data warehousing and processing.
DDL Script Creation:
Proficiency in creating and managing Data Definition Language (DDL) scripts.
Data Quality Checks:
Robust knowledge of performing data quality checks using IICS tools.
Preferred Skills:
Experience using JIRA for task tracking and project management (nice to have).