- Design, develop, test, deploy and maintain ETL processes using Informatica PowerCenter to extract data from various sources such as AWS, Microsoft Azure, Snowpipe, and SQL databases.
- Collaborate with cross-functional teams to identify business requirements and design scalable data warehousing solutions on Snowflake platform.
- Develop complex queries in Python using PySpark to process large datasets for reporting purposes.
- Troubleshoot issues related to ETL pipeline failures and optimize performance by analyzing logs files.
Job Requirements :
- 8-10 years of experience in ETL development with expertise in Informatica PowerCenter or similar tools like IICS.
- Robust understanding of data warehousing concepts and hands-on experience working with Snowflake database management system.
- Proficiency in writing complex SQL queries using Python libraries like PySpark for big-data processing tasks.
- Experience with cloud-based technologies such as AWS or Microsoft Azure is an added advantage.