Informatica Developer

Requirement is as follows: • Design and implement scalable data storage solutions using Snowflake • Writing SQL queries against Snowflake, developing scripts to do Extract, Load, and Transform data. • Write, optimize, and troubleshoot complex SQL queries within Snowflake • Hands-on experience with Snowflake utilities such as SnowSQL, SnowPipe, Tasks, Streams, Time travel, Cloning, Optimizer, Metadata Manager, data sharing, stored procedures and UDFs. • Develop and maintain ETL processes using Informatica PowerCenter • Integrate Snowflake with various data sources and third-party applications • Experience in Data Lineage Analysis, Data Profiling, ETL Design and development, Unit Testing, Production batch support and UAT support. • Involve SQL performance tuning, Root causing failures and bifurcating them into different technical issues and resolving them. • In-depth understanding of Data Warehouse, ETL concepts and Data Modelling. • Experience in requirement gathering, analysis, designing, development, and deployment. • Good working knowledge of any ETL tool (preferably Informatica powercenter, DBT) • Should have proficiency in SQL. • Have experience in client facing projects. • Have experience on Snowflake Best Practices. • Should have experience working on Unix shell scripting. • Good to have working experience in python Expected skillset: Should have 6 8 years of IT experience. Minimum 4+ years of experience in designing and implementing a fully operational solution on Snowflake Data Warehouse. Proven experience as a Snowflake and Informatica developer Strong expertise in Snowflake architecture, design, and implementation. Proficient in SQL, ETL tools, and data modelling concepts. Excellent leadership, communication, and problem-solving skills. Certifications in Snowflake and relevant cloud platforms are desirable.