Sr Snowflake Informatica Cloud Architect / Engineer Job at ePATHUSA Inc, Jersey City, NJ

WHdKMTFKaEFoUUpHbmY5TnpOUWpZUG9H
  • ePATHUSA Inc
  • Jersey City, NJ

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

Cambridge Health Alliance

Phlebotomist - PACE Elder Care Services Job at Cambridge Health Alliance

 ...supportive environment. Position Overview We are currently seeking a dedicated and skilled Phlebotomist to join our care team at CHA PACE. In this unique role, you will travel to PACE participants homes in order to perform a variety of phlebotomy procedures, ... 

Truckee Meadows Community College

Political Science Part-Time Faculty Job at Truckee Meadows Community College

 ...Part-Time Faculty Positions Truckee Meadows Community College (TMCC) is recruiting Part-Time Faculty to teach courses in political science for the Department of History, Political Science and Law. The college welcomes qualified applicants from all backgrounds for temporary... 

Dodd Creative Group

Art Director Job at Dodd Creative Group

 ...Dodd Creative Group is looking for an experienced and versatile Art Director to bring high-level visual execution and design excellence to our fast-paced studio. This is a roll-up-your-sleeves role for a creative who thrives on developing original logo designs, signage... 

Figma

Email Marketing Manager Job at Figma

 ...world. If you're excited to shape the future of design and collaboration, join us! Figma's Global Marketing team is looking for an experienced and proactive Email Marketer to help us scale personalized communications across our user base. This person will work on... 

Britt Medical Search

Physician / Surgery - Orthopedics-Hand / Kentucky / Permanent / Orthopedic Hand Surgeon opening in Bowling Green, KY - Faculty position Job Job at Britt Medical Search

 ...Seeking a full-time BC/BE Orthopedic Hand Surgeon to teach students and residents, as well as provide care for patients in Bowling Green,...  ...critically evaluating outcomes as related to orthopaedic hand surgery patients and will serve on applicable University and College...