Job Description

Job Description

Job Description

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
  

Job Tags

Temporary work,

Similar Jobs