Data Modeling ,
sonsoftLivingston (NJ)
About the role
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
Before you apply
Applying takes about a minute. These four things decide how fast it moves after that.
Your profile is current
It's what we read first. Occupations, seniority and locations matter more than a long history.
Two examples you can talk through
Not a portfolio — just two pieces of work where you can explain the decisions and what you'd change.
A number in mind
What you're on now and what would make you move. We negotiate better when we know both.
Your notice period
Employers plan around it, and it's the question that stalls offers most often.
Once you apply, someone reads it and calls you before anything reaches the employer — usually within two working days.