Sr Snowflake Informatica Cloud Architect

Jersey City, NJ, US β€’ Posted 22 hours ago β€’ Updated 22 hours ago
Full Time
No Travel Required
On-site
Depends on Experience
Fitment

Dice Job Match Scoreβ„’

🧠 Analyzing your skills...

Job Details

Skills

  • Oracle
  • Informatica
  • ELT
  • IBM InfoSphere DataStage
  • Data Storage
  • Data Security
  • Cloud Computing
  • Amazon S3
  • Extract, Transform, Load
  • Data Migration
  • Datastage
  • RDBMS
  • RBAC
  • PySpark
  • Shell Scripting
  • SQL
  • Project Delivery
  • Teradata
  • Streaming

Summary

Skills Need:

  • Must have 12+ years of IT experience.
  • Must have 10+ years of IT experience in the US working for US companies.
  • Must have 4 years of recent experience working in a banking or Brokerage environment (With in last 8 years minimum).
  • Must have 8+ years of experience with Snowflake and Informatica.
  • Must have expertise experience with Snowflake - data modelling, ELT using Snowflake SQL, Stored Procedure, Snowpark.
  • Must have hands-on experience in AWS Glue/Pyspark Data Frame/DataStage/Matillion/Informatica and AWS data storage and management technologies such as S3.
  • Must 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.
  • Must have 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.
  • Recent Snowflake Certified Architect Certification is a ‘Big Plus’.
  • SnowPro Core Certified Certification is a ‘Big Plus’.

 

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.
  • 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.
  • 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.
Employers have access to artificial intelligence language tools (β€œAI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
  • Dice Id: 91130761
  • Position Id: 8970119
  • Posted 22 hours ago
Create job alert
Set job alertNever miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

Jersey City, New Jersey

β€’

Today

Easy Apply

Contract

Depends on Experience

New York, New York

β€’

6d ago

Easy Apply

Full-time

154000 - 180000

Jersey City, New Jersey

β€’

2d ago

Easy Apply

Full-time, Third Party

$140000 - $150000

New York, New York

β€’

Today

Full-time

USD 189,000.00 - 248,062.00 per year

Search all similar jobs