No more applications are being accepted for this job

Data Architect - Cranbury, United States - Blue Ocean Ventures

Blue Ocean Ventures Cranbury, United States

1 month ago

Technology / Internet

Must have :

Total 10+ yrs in Data warehouse, ETL and 2+ years' experience working on end to end implementation in native cloud based DWH.

5+ years of experience working as a Data Architect / Data Modeler for insurance programs

Good understanding of concepts like Micro-partitions, Warehouse, Clone, Stages(external, internal), Time travel, Cluster keys.

Expertise in ETL using SQL, writing complex stored procedures.

Experience with AWS & services like AWS RDS (PostgreSQL), API Gateway, VPC, IAM, CloudWatch, CloudTrail etc.

Experience in ingesting data into Lakes / Warehouse from S3, SharePoint , APIs.

Experience in scheduling the ingestion pipelines using Tasks, pipe, Airflow etc.

Expertise in advanced concepts like setting up resource monitors, RBAC controls, virtual warehouse sizing, query performance tuning.

Good hands on skills in SQL, PLSQL, Unix shell scripting.

Good communication skills.

Nice to have :

Experience with Informatica (ETL) and SnapLogic would be an added plus.

Has understanding/working knowledge of Big data technologies like Hadoop, Hive, Impala.

Has experience in handling technical issues on visualization tools like Power Bi / Tableau.