sonsoftLivingston, NJ
Data Modeling ,
Data Modeling ,
Data Modeling ,
sonsoftLivingston, NJ
40 days ago
Computer Systems Design ServicesCustom Computer Programming ServicesOther Scientific and Technical Consulting Services
Apply for this role (opens in a new tab)Company Description:
Sonsoft, Inc. is a USA based corporation duly organized under the laws of the Commonwealth of Georgia. Sonsoft Inc. is growing at a steady pace specializing in the fields of Software Development, => Software Consultancy and Information Technology Enabled Services.
Job Description:
- Mandatory Technical SkillsHave strong experience in databases like Teradata, Netezza or Oracle etc.
- Good Experience in Unix Environment
- Good experience in Industry standard data modelling tools like Erwin.
- Have good working knowledge of Data warehousing concepts. 3+ experience is required.
- Experience in Performance tuning in DW environment.
- Experience on data modeling using Dimensional as well as ER-ModelHave working Knowledge of Industry Standard Reporting/ETL tools.
- Having good PL SQLSkillsHave good Banking and Financial Domain Knowledge is Must. Preferred/Good to have
- Worked in both OLTP and DW implementation
- Experience on Ab Initio.
Job description:
- Person needs to Interacting with Project stake holders to understand functional as well as technical requirements and documenting, publishing to Team.
- Experience in developing, validating, publishing, maintaining LOGICAL data models with exposure to or experience in developing, validating, publishing, maintaining PHYSICAL data models
- Evaluate existing data models and physical databases for variances and discrepancies
- Experience with managing meta data for data models
- To develop, publish, maintain all documentation for data models
- Work with Business Analysts, Data Architects, Software developers, DBAs to achieve project objectives - delivery dates, cost objectives, quality objectives, business customer satisfaction objectives, etc.
- Take part Data Quality, Data governance processes
- Leverage and enforce standards for data naming conventions to ensure consistency and reuse of data models
- Validate business use cases for accuracy and completeness of proposed data models.
- Ability to communicate strategies and processes around data modeling and architecture to cross functional groups and senior levels
- Good hands on knowledge on Erwin knowledge is must require. The job entails sitting as well as working at a computer for extended periods of time. Should be able to communicate by telephone, email or face to face. Travel may be required as per the job requirements.
Qualifications:
Basic Bachelor's degree or foreign equivalent required from an accredited institution. Will also consider three years of progressive experience in the specialty in lieu of every year of education. At least 2 years of experience with DW/BI and related tools At least 1 years of experience with Data Modeling related tools Understanding of Data Modeling architectural principles
Additional Information
Note:
- Only US Citizen, Green Card Holder, H4-EAD, GC-EAD & L2-EAD can apply.· No H1B & OPT-EAD. We are unable to sponsor at this time.
Summary
Type: Full-time
Function: Information Technology
Experience level: Mid-Senior Level
Industry: Information Technology And Services
Also on the board Same function, level within a rung
Level
Lead
Location
Livingston, NJ
Occupation
Data Warehousing Specialists
Industry
Computer Systems Design Services
Posted
40 days ago