Sr Snowflake Informatica Cloud Architect / Engineer

Seeking a Sr Snowflake Informatica Cloud Architect / Engineer who will be responsible for designing and implementing scalable and reliable solutions using Snowflake and Informatica Cloud. Additionally, they will be expected to:

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

Perform 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.

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.

Requirements

Skills

Required/Preferred

Years

Candidate Experience

Must have 12+ years of IT experience.

Required

12+

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

Required

10+

Must have 3 years of recent experience in a banking or Brokerage environment (With in last 6 years minimum).

Required

3+

Must have a recent Snowflake Certified Architect Certification.

Required

Must have a SnowPro Core Certified Certification.

Required

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

Required

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

Required

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.

Required

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.

Required

4+

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

Required

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

Required

Benefits

Benefit Package includes:

Paid Sick Time

Insurance for Medical, Dental, Vision and Life Available

401(k) including Employer Match

HSA, Short-term & Long-term Disability Available

We are an EEO/Veterans/Disabled employer