Hi, Hope you are doing good.
*Role: Data Modeler* *Location: NJ (Remote)* *Duration: 6 to 12 Months* *Share profiles with Insurance domain experience only * *Responsibilities:* · Professional experience working as a Data Modeler/Data Architect with diverse industry verticals like Insurance and REInsurance service domains. · Be responsible for the development of the conceptual, logical, and physical data models, the implementation of RDBMS, operational data store (ODS), data marts, and data lakes on target platforms (SQL/NoSQL). · Oversee and govern the expansion of existing data architecture and the optimization of data query performance via best practices. The candidate must be able to work independently and collaboratively · Extensive experience in developing logical and physical data models for both transaction as well as analytical systems. · Proficient in Enterprise Data Warehouse. Worked extensively in several projects in both Forward Engineering as well as Reverse Engineering using data modeling tools. · Experience with Business Process Modeling, Process Flow Modeling, Data flow modeling. · Experience in analyzing the business requirements and creating Business Requirement Document (BRD). Expertise in interacting with stakeholders, gathering requirements through interviews, workshops, and existing system documentation or procedures, defining business processes, identifying and analyzing risks using appropriate templates and analysis tools. · Proficient in requirement gathering, Organizing JAD sessions, one to one interviews, and focus groups. · Well versed in Kimball/Inmon data warehouse Philosophies. Experienced in Normalization/De-normalization techniques for optimum performance in OLTP and OLAP environments. · Knowledge on integrating JSON structures within relational tables · Experience in multiple modeling techniques (normalize, Data Vault, Star Schema, etc.) · Expertise in Data Modeling using tools like ERwin, ER Studio and Power Designer. · Experience with Oracle and SQLserver database commands and worked extensively on XML Schema designs. · Exposure working in a Microsoft Azure Data Platform environment; · Exposure working with Azure Data Factory, Azure Storage (Blob or Data Lake), Databricks, SQL Azure DB, SQL Azure DW and Azure DevOps – CI/CD · Hands-on experience with modeling using ERwin in developing Entity-Relationship, modeling Transactional Databases and Data Warehousing, Dimensional Data Modeling for Data Marts and Fact & Dimensional Tables. · Hands-on knowledge of enterprise repository tools, data modeling tools, data mapping and data profiling tools. · Extensive Experience working on SQL Queries along with good experience in development of T-SQL, Oracle PL/SQL Scripts, Stored Procedures and Triggers for business logic implementation. · Good Understanding and Knowledge with Agile and Waterfall Environments. · Involved in performance optimization of DWH solutions, both on ETL as well as Database side. · Experience in preparing project cutover plan, test plan with test cases for unit test, regression test and User Acceptance Testing (UAT). · *P&C Insurance background* Regards, *Md.Khazababu* Recruiter 3*S* Business Corporation Inc(*3SBC*) P: 281-823-9222 Ext 518 | F: 281-823-9225 Email: md.kh...@3sbc.com| <md.kh...@3sbc.com> www.3sbc.com Hangouts – khaza3...@gmail.com *3S Business Corporation Inc. 11271 Richmond Ave, Suite # H107, # H108 Houston, Texas. 77082* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/excel-macros/CAKPjPOS6bZPQ4_kOEA6zd-AG3nR6OVBap3WA28%2BriKJkjZkRhA%40mail.gmail.com.
