Req: DB Architect/ETL, Remote
Role: DB Architect/ETL (2 positions)
Location: Remote
Duration: 12+ Months
Description:
· 15+ years of "Hands On" experience in Software Development life cycle (SDLC) and in Data integration, analysis, design, data replication, data lineage, modeling and implementation of business logic including Data warehousing and Business Intelligence technologies.
· At least 1 Large scale SQL to NoSQL (Preferably Oracle to Cassandra) migrations/implementation experience
· Extensive experience in creating packages, stored procedures, Functions, Triggers, Views and other database objects using SQL, PL/SQL programming.
· Knowledge in oracle PLSQL constructs nested tables, associative arrays, records, arrays and dynamic SQL and analytical functions, Hierarchical queries, Bulk Binding.
· Good Hands On experience in PL/SQL including Packages, procedures/functions, database triggers, EXPLAIN PLAN, Hints, PL/SQL Collections, Ref cursors, Performance Tuning, co-related queries, complex joins for existing and new programs.
· Very good working knowledge in of the following types of DBs – SQL DBs, NoSQL (Cassandra Required)
· Minimum 5+ years of extensive experience in working with Cassandra DB, creating Db Schemas, DB Mappings etc.
· Working knowledge in the following types of DBs & Caching will be preferred - In-Memory DBs (Memcached etc), Document DBs ( CosmosDB, MongoDB etc), Time Series DBs (Prometheus, InfluxDB, eXtremeDB, Druid etc) & Redis
· Strong understanding/knowledge of Data Modeling (Physical, Logical, Conceptual), Dimensional modeling in Data warehouse environment such as star schema and snow flake schema.
· Good knowledge of utilizing metadata management tools for business, technical and operational metadata (ASG, Informatica, Collabra, Erwin, Oracle etc.)
· Demonstrated experience and competency in Data Warehouse and ETL concepts and Working knowledge of ETL
· Experience in Performance tuning, writing complex SQL queries and Partitioning.
You received this message because you are subscribed to the Google Groups "HimanshuDailyRequirements" group.
To unsubscribe from this group and stop receiving emails from it, send an email to himanshudailyrequirements+unsubscribe@googlegroups.com.
To post to this group, send email to himanshudailyrequirements@googlegroups.com.
To view this discussion on the web, visit https://groups.google.com/d/msgid/himanshudailyrequirements/CAHwffbJnm8_j8S2jG938zh-HrdDrQ_MOeoP3X07P00KghJKVvg%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.
Comments
Post a Comment
Thanks