Gather functional and technical requirements from project stakeholders and document them for the team.
Develop, validate, publish, and maintain logical data models, with exposure to physical data models.
Assess existing data models and physical databases for discrepancies and manage model metadata and documentation.
Collaborate with analysts, architects, developers, and DBAs to support project objectives.
Summarised from the posting by AI and can be wrong. The full description is the source.
Requirements
Experience
Strong experience with databases such as Teradata, Netezza, or Oracle
Good experience in a Unix environment
Hands-on experience with Erwin
3+ years of experience with data warehousing concepts
Experience with performance tuning in a data warehousing environment
Experience in dimensional and ER data modeling
Banking and financial domain knowledge
At least 2 years of experience with DW/BI and related tools
At least 1 year of experience with data modeling-related tools
Experience with both OLTP and data warehouse implementations (preferred)
Experience with Ab Initio (preferred)
Education
Bachelor’s degree or foreign equivalent from an accredited institution, or three years of progressive specialty experience in lieu of each year of education
Skills
Working knowledge of industry-standard reporting or ETL tools
Good PL/SQL skills
Understanding of data modeling architectural principles
Other requirements
U.S. citizen, Green Card holder, TN visa holder, GC-EAD, H4-EAD, or L2-EAD; OPT-EAD and H1B consultants are not eligible
Your match
Sign in and add your resume to see which of this job's requirements it shows.
Saved to your account, encrypted. The AI that reads it doesn't keep it or train on it.
Full job description
From Sonsoft Inc’s careers site
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 Skills
Show full descriptionShow less
Have 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-Model
Have working Knowledge of Industry Standard Reporting/ETL tools.
Having good PL SQL Skills
Have 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.
Qualifications
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
** U.S. citizens and those authorized to work in the U.S. are encouraged to apply. We are unable to sponsor at this time.
Note:-
This is a Full-Time Permanent job opportunity for you.
Only US Citizen, Green Card Holder, TN Visa, GC-EAD, H4-EAD & L2-EAD can apply.
No OPT-EAD & H1B Consultants please.
Please mention your Visa Status in your email or resume.