Data Modeling Analyst develops data models to meet the needs of the organization's information systems. Manages the flow of information between departments through the use of relational databases. Being a Data Modeling Analyst maintains data integrity by working to eliminate redundancy. Stays informed of the ways the organization uses its data. Additionally, Data Modeling Analyst requires a bachelor's degree. Typically reports to a manager. The Data Modeling Analyst gains exposure to some of the complex tasks within the job function. Occasionally directed in several aspects of the work. To be a Data Modeling Analyst typically requires 2 to 4 years of related experience. (Copyright 2024 Salary.com)
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.
Mandatory Technical Skills
• 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.
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
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.