Brillio - Senior Data Specialist - Informatica Intelligent Cloud Services (8-11 yrs)

Immediate Joiner needed - who can join max in 30 days.

Job Overview :

We are seeking a skilled and experienced Senior Data Specialist with hands-on expertise in data management and ETL technologies. The ideal candidate will have strong proficiency in Informatica PowerCenter, IICS, and Snowflake, along with advanced SQL knowledge and scripting abilities. You will play a critical role in optimizing ETL jobs, troubleshooting errors, and contributing to a high-performance data environment.

Key Responsibilities :

- Work extensively with Informatica PowerCenter and Informatica Intelligent Cloud Services (IICS) to manage and optimize ETL processes.

- Apply strong knowledge of data models and data warehousing principles in designing and managing data workflows.

- Utilize ETL job optimization techniques, especially Pushdown optimization, to enhance performance.

- Troubleshoot and resolve ETL errors effectively, ensuring smooth data pipeline operations.

- Develop and maintain Shell scripts to support data processing and automation tasks.

- Work with Snowflake for cloud-based data storage and management.

- Write and execute complex SQL/Advanced SQL queries for data extraction, manipulation, and reporting.

- Collaborate with team members as a proactive team player/lead, and demonstrate a quick learning ability for new technologies.

- Python knowledge is a plus, providing an advantage in automation and data manipulation tasks.

Technical Skills :

- Informatica PowerCenter

- Informatica Intelligent Cloud Services (IICS)

- Snowflake

- Advanced SQL

- Shell Scripting

- Python (Added advantage)