• Us Citizen

• Green Card

• EAD (OPT/CPT/GC/H4)

• H1B Work Permit

• Corp-Corp

• Consulting/Contract

• UG :- - Not Required

• PG :- - Not Required

• No of position :- ( 1 )

• Post :- 26th Jan 2021

Must have around 8-10 years of experience in Oracle & Big data technologies

Create logical and physical data models using Embarcadero ER/Studio(or other tool), employing IDEF1X specification and 3rd Normal Form for OLAP and OLTP systems.

Provide and enforce best practices and governance standards, normalization, data classification, and normalization in the delivery of high-quality data solutions for Enterprise Data Warehouse, business group focused

BI platforms (Data Marts), metadata reporting applications, and OLTP systems.

Conduct modeling sessions with project teams across all business groups, gather and define data requirements for Enterprise Data Model.

Lead discussion with stakeholders designed to transform subscriber data requirements into a robust, canonical logical model and data dictionary, with clearly-written business definitions for logical entities and attributes that describe enterprise data in a way that is consumable by a wide business audience.

Experience with Cloud BI Platform - Snowflake

Strong experience of building report using Power BI/Tableau

Experience in reporting tools, including SQL Database, Power BI / Tableau and Data warehouse.

Experience in Oracle SQL Scripting & PL/SQL, Oracle database, TD, Snowflake

Enforce architectural standards and train Developers, Technical Leads, Project Managers, and Systems Analysts regarding best practices for Enterprise Data Warehouse Design.

Identify repeatable processes and develop automation macros using VBScript and Er/Studio’s OLE Automation Interface to increase efficiency, productivity, and accuracy of modeling processes.

Perform light Data Analysis and Data Profiling as needed.

Good hands-on experience on batch processing and streaming data/reporting

Develope visualization dashboards like ranking, data distribution spread

Shilpa Baisla

Email-Shilpa.b@idctechnologies.com

Desk:4084579399 Ext-3294

Mobile : 669-241-7092

https://www.linkedin.com/in/shilpa-baisla-603ba6149/