Title : Sr Snowflake & Informatica Cloud Architect
Work Location : Jersey City NJ.
Duration : 1+years
Snowflake Architect
About the Role : Join our dynamic team as a Snowflake Architect, where you'll play a pivotal role in designing and implementing cutting-edge, scalable, and reliable data solutions using Snowflake and Informatica Cloud.
Your expertise will drive our projects to success through :
- Innovative Design : Develop scalable and reliable solutions with Snowflake and Informatica Cloud.
- Cross-Functional Collaboration : Work closely with diverse teams to gather requirements, offer technical guidance, and ensure successful project delivery.
- End-to-End Implementation : Lead comprehensive Snowflake cloud data migration from on-premises databases like SQL Server, Oracle, Teradata, etc., to Informatica.
- Data Security Leadership : Design and implement data security measures, including RBAC Policies, Dynamic Masking, and Secured Views.
- Expert Problem Solving : Address and resolve complex data pipeline challenges, taking ownership to drive solutions.
- Mentorship and Leadership : Lead architectural discussions, mentor junior team members, and stay ahead of industry trends and best practices.
Skills and Experience :
- Extensive IT Experience : 12+ years in IT, with 10+ years in the US working for US companies.
- Banking Expertise : Recent experience in a banking environment within the last 4 years, with at least 2 years of relevant experience.
- Certification Excellence : Snowflake Certified Architect and SnowPro Core Certified Professional.
- Snowflake Mastery : 8+ years of experience with Snowflake and Informatica, including data modeling, ELT using Snowflake SQL, Stored Procedure, Snowpark.
- Advanced AWS Skills : Hands-on experience with AWS Glue / Pyspark Data Frame / DataStage / Matillion / Informatica, and AWS data storage and management technologies such as S3.
- Advanced Snowflake Concepts : 4+ years of experience with resource monitors, virtual warehouse sizing, query performance tuning, Zero copy clone, time travel, Streams, and Tasks.
- Technical Proficiency : Hands-on experience with Snowflake utilities, Copy Command from S3, SnowSQL, SnowPipe, complex SQL, Unix Shell Scripting, performance tuning, and troubleshooting.
11 days ago