Data Architect with Data modeler and snowflake

Must have 5+ years strong experience in Data modelling.Able to understand,analyze and design enterprise data model, and have expertise on some data modelling tool.Experience in designing the Canonical logical and physical data model using the data modeler tool.Have expertise on SQL PL/SQL) programming and one the languages like Java/JavascriptHas built processes supporting data transformation, data structures, metadata, dependency and workload managementHas experience on analyzing source data, transforming data, creating mapping document, build design documents, and data dictionary etc.Good experience in end to end Data warehousing, ETL, and BI projects.Hands on experience on anyof the ETL tools like InformticaHands-on experience on at least one CDC tool: Oracle Goldengate, Qlik etc.Has Led or involved on data migration projects end to endProficient in Oracle database, complex PL/SQL, Unix Shell Scripting, performance tuning and troubleshootProficient in Snowflake(Certified SnowPro (Desirable)) DatawarehouseExperience in Snowflake Data warehouse - data modeling, ELT using Snowflake SQL,implementing complex stored Procedures and standard DWH and ETL conceptsHave created flexible and scalable snowflake modelExperience with data security and data access controls and designProvide resolution to an extensive range of complicated data pipeline related problems, proactively and as issues surfaceGood to have:Experience with Snowflake utilities, SnowSQL, SnowPipe and Big Data modeltechniques using Python have experience at least two end-to-end implementation of Snowflake cloud data warehouse.Snowflake advanced concepts like setting up resource monitors, RBAC controls, virtual warehouse sizing, query performance tuning, Zero copy clone, time travel and understand how to use these featuresShould have good understanding of 3NF and Star schemaPreferred to have expertise in any one programming language Python/Java/ScalaAble to develop and maintain documentation of the data architecture, data flow and data models of the data warehouse appropriate for various audiences.Provide direction on adoption of Cloud technologies Apply tot his job Apply tot his job Apply To this Job