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

Monster

Sr Data Analyst Job at Monster

 ...communication skills, with ability to work onsite with business stakeholders Proficiency in Microsoft Excel and BI tools like Power BI, Tableau, or SAP Analytics Cloud Preferred Qualifications: Familiarity with Finance Accounting Transformation and Finance data migration.... 

Athenahealth

Facilities Technician (Mon-Fri 3:30PM-12AM) Job at Athenahealth

 ...support Perform office moves when necessary Assist in onboarding and termination operations Assist in office equipment installations and furniture moves Other tasks as assigned by the Office Services Manager Typical Qualifications ~ High School (or equivalent... 

What Like You

Data Entry Clerk - Work at Home Job at What Like You

 ...About the job Data Entry Clerk - Work at Home We are looking for people who are motivated to work from home and participate in...  ...spot while we still have spots. Compensation Take surveys to earn money from home. There are many payment options, including... 

Brian T Boyd CPA PC

Senior Tax Staff Accountant Job at Brian T Boyd CPA PC

 ...Job Description Job Description We are looking for a Senior Tax Staff Accountant to join our team! You will be responsible for preparing and analyzing financial records and preparing and reviewing tax returns for our clients. Responsibilities: Prepare and examine... 

RIT Solutions

UI/UX Researcher Job at RIT Solutions

 ...Ui/Ux Researcher Location: Grand Rapids, MI Submittal Requirements: 3-5 Must Haves: 3-5 years of UX Research experience Strong experience with wireframes is required Must provide a link to their online portfolio Proven experience with HTML, CSS, and...