| Lead Data Modeling Engineer at Menands,New York at York, New York, USA |
| Email: [email protected] |
| From: Ashok Reddy, Sligo Software Solutions Inc. [email protected] Reply to: [email protected] Greetings from Sligo Software Solutions, Inc. !! SLIGO is a Software Development & IT Consulting company. We have around 100+ IT associates working with our esteemed clients across several domains such as IT, Banking, Healthcare, and Government. We have an urgent requirement for Lead Data Modeling Engineer position with our client. Role: Lead Data Modeling Engineer Location: Menands, New York Duration: 24 Months Client: NY State Client Job ID#: NYST-156 Duties Working closely with business subject matter experts (SMEs) and Business Analysts through the process of detailed business functional requirements elicitation. Analysing detailed business requirements and business needs to create long-term data strategies. Analysing the current CIS relational database schema. Designing and maintaining conceptual, logical, and physical relational database models. Creating and implementing Master Data Management strategies to eliminate redundant data related to Employer and Claimant entities. Leading all data integration, migration and conversion activities including a team of data developers who will be responsible for moving and cleansing data from the current CIS system databases to the new databases. This role involves assessing existing legacy databases, developing migration and conversion plans, and executing the data transfer process using data integration (ETL/ELT) tools such as Informatica. Skills in SQL, data profiling, source-to-target data mapping, and scripting are crucial. Reviewing and making recommendations to improve existing data quality program. Perform data profiling and reviewing outcomes with technical and business subject matter experts. Assisting with and providing support for teams responsible for data warehouses/marts, replication of the OLTP databases, delivery and ETL systems by determining structural requirements; developing data system schematics. Developing complete database solutions by designing logical models; defining database physical structure and functional capabilities, security, and recovery specifications. Creating and maintaining a data dictionary, including element-level technical and business definitions and metadata. Mandatory Requirements Experience ( 12+ Years) Requirements This is an 50% Onsite A minimum of a bachelors degree. An equivalent combination of advanced education, training, and experience will be considered. A minimum of eight (8) years of relational database modeling, including conceptual, logical, and physical, in support of the development and successful implementation of at least two (2) major application development modernization projects in the role of the Lead Data Modeling Engineer. A minimum of four (4) years leading, designing, and executing data migration and conversion solutions using ETL tools such as Informatica, including data profiling activities. A minimum of four (2) years implementing information management strategies, including master data management solutions. Ashok Reddy Akkala Sligo Software Solutions, Inc. NYS and NYC MBE Certified Company. Email:[email protected] www.sligosoft.com 12 Metro Park Rd, Suite 112 Albany, NY 12205 LinkedIn:https://www.linkedin.com/in/ashok-reddy-a88b471b7/ Keywords: information technology Idaho New York |
| [email protected] View all |
| Thu Feb 15 20:06:00 UTC 2024 |