Logo
Tech Tammina

Snowflake Data Architect

Tech Tammina, Jersey City, New Jersey, United States, 07390


Title: Sr Snowflake Informatica Cloud Architect / Engineer.

Work Location:

525 Washington Blvd, #600

Jersey City NJ.

Duration:

1+years

NOTE:

3 months on site

then a remote option can be offered.

• Must have a recent Snowflake Certified Architect Certification.

• Must be SnowPro Core Certified Professional.

PRESENT CERTS WITH RESUME

The Job: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.