• US Citizen

• Green Card

• EAD (OPT/CPT/GC/H4)

• H1B Work Permit

• Corp-Corp

• W2-Permanent

• W2-Contract

• Contract to Hire

• Consulting/Contract

• UG :- - Not Required

• PG :- - Not Required

• No of position :- ( 1 )

• Post :- 4th Jun 2024

·       As a Snowflake Architect, the consultants will be responsible for:

·       Designing and implementing scalable and reliable solutions using Snowflake and Informatica Cloud.

·       Collaborating with cross-functional teams to gather requirements, provide technical guidance, and ensure successful project delivery.

·       Perfom end-to-end implementation of Snowflake cloud data migration from on-premises preferably from any RDBMS like SQL Server, Oracle, Teradata etc to Informatica.

·       Perform data security and data access controls and design, RBAC Policies, Dynamic Masking, Secured Views etc.

·       Experience with Snowflake and Snowflake utilities.

·       Provide resolution to an extensive range of complicated data pipeline related problems, proactively helping the team and take the ownership for closer.

·       Lead architectural discussions, mentor junior team members, and stay updated with the latest industry trends and best practices.

Skills Need:

·       Must have 12+ years of IT experience.

·       Must have 10+ year of IT experience in the US working for US companies.

·       Must have recent experience in a banking environment (With in last 4 years and minimum 2 years of experience).

·       Must have a recent Snowflake Certified Architect Certification.

·       Must be SnowPro Core Certified Professional.

·       Must have 8+ years of experience with Snowflake and Informatica.

·       Expertise experience with Snowflake - data modelling, ELT using Snowflake SQL, Stored Procedure, Snowpark.

·       Should have recent hands-on experience in AWS Glue/Pyspark Data Frame/DataStage/Matillion/Informatica and AWS data storage and management technologies such as S3.

·       Should have 4 plus years of Snowflake advanced concepts like setting up resource monitors, virtual warehouse sizing, query performance tuning, Zero copy clone, time travel, Streams and Tasks.

·       Hands-on experience with Snowflake utilities, Copy Command from S3, SnowSQL, SnowPipe.

·       Must be proficient in complex SQL, Unix Shell Scripting, performance tuning and troubleshooting.