Data Modeler (OLTP / Erwin)

Trigyn's direct government client has an immediate need for a Data Modeler in Albany, NY.

Description:
The consultant will serve Data Modeler and developer in the .NET Developer Team implementing
? Analyzing and translating business needs into long-term solution data models.
? Evaluating existing data systems.
? Working with the development team to create conceptual data models and data flows.
? Developing best practices for data coding to ensure consistency within the system.
? Reviewing modifications of existing systems for cross-compatibility.
? Implementing data strategies and developing physical data models.
? Updating and optimizing local and metadata models.
? Evaluating implemented data systems for variances, discrepancies, and efficiency.
? Troubleshooting and optimizing data systems.
? Generate and publish data definition language (DDL) from physical data model to Oracle and SQL Server databases.
? Design and develop ELT/ETL processes for the migration of data.
? Develop and execute complex queries and procedures using T-SQL and SQL.
? Manage and maintain scripts and code in source control repository.
? Document data models, data migration and data quality requirements and solutions.
? Provide knowledge transfer to other data management team members.
? Assistance in development of software/hardware requirements for Development, User Acceptance Testing (UAT), and Production environment.

Mandatory Qualification:
? Works in the field of Information Technology, experienced in the usage and support of a collection of development platforms, technical architectures or business applications and products that run on those platforms - beyond that of a Programmer.
? Candidate is able to provide guidance to large teams and/or has extensive industry experience and is considered at the top of his/her field.

? 84 months experience developing logical and physical relational data models for OLTP databases.
? 60 months experience using Erwin OR toad Data Modeler to create and maintain logical and physical data models.
? 84 months experience in complex PL\SQL, T-SQL and SQL development against SQL Server.
? 60 months experience identifying and troubleshooting data quality issues.
? 12 months experience developing and managing ELT/ETL processes.
? 36 months of experience in development using Agile/Scrum
? 36 months experience using source control and release technologies such as Git and Azure DevOps.
? Masters Degree in computer related field.

For Immediate Response call , or send your resume to
For Immediate Response call , or send your resume to

TRIGYN TECHNOLOGIES, INC. is an EQUAL OPPORTUNITY EMPLOYER and has been in business for 35 years. TRIGYN is an ISO 9001:2015, ISO 27001:2013 (ISMS),ISO 20000:2018 and CMMI Level 5 certified company.