Job Description

Hello Professionals,
We are looking for candidates, requires strong experience in data modelling, advanced SQL development, data quality troubleshooting, erwin Data Modeler, Azure Data Factory ELT/ETL processes, and source control tools like Git and Azure DevOps. Ideal candidates have a proven history of working in complex database environments and delivering high-quality technical solutions.
Details:
Title : IT Specialist - Expert
Location : Albany, NY, 12226
Duration : 24 Months
Client : Government Agencies
Rate : $65/ Hourly
:
The position is required to provide data management expertise supporting the continued development and maintenance of WCB systems. Working as part of a DevOps environment, the position will be responsible for the development and maintenance of ETL/ELT pipelines in Azure ADF and/or data migration processes, T-SQL and SQL scripts. In addition, the resource will review business requirements documents, analyze and profile source data, maintain scripts in source control repository, performance tune scripts, review and troubleshoot data quality alerts, prepare source to target mapping documents and execute data manipulation language (DML) scripts. The duties will be performed against both cloud-based and on-premises databases.
Requirements:

• 84 months experience developing logical and physical relational data models for OLTP databases.
• 60 months experience using erwin Data Modeler to create and maintain logical and physical data models.
• 84 months experience in complex T-SQL and SQL development against SQL Server.
• 60 months experience identifying and troubleshooting data quality issues.
• 48 Months experience developing and managing Azure Data Factory ELT/ETL processes.
• 48 months experience using source control and release technologies such as Git and Azure DevOps.

Best Regards,
Meba Laitstep
IT Recruiter || NYC IT Inc.
M/WBE Certified
? Email: recruiter@nycitinc.com
? LinkedIn:

Skills Required