Project Role :Data Architect Project Role Description :Define the data requirements and structure for the application. Model and design the application data structure, storage and integration. Must have skills :Microsoft SQL Server Integration Services (SSIS) Good to have skills :NA Minimum 5 year(s) of experience is required Educational Qualification :15 years full time educationKey ResponsibilitiesDefine migration strategy & roadmap:Establish timelines, downtime windows, rollback plans, and communication with stakeholders.Assess compatibility & risks:Use migration assessment tool (SQL Server Management Studio 22) to identify deprecated features and breaking changes.Infrastructure readiness:Coordinate with client/system admins to provision SQL Server 2025 servers (hardware/VMs, storage, networking).Design & validate migration scripts:Create and review T-SQL and PowerShell scripts for schema migration, data movement.Oversee testing & validation:Define unit test scenarios, ensure data integrity, and validate application connectivity.Co-ordinate in deployment/cutover activitiesRequired SkillsSQL Server administration (installation, configuration, migration methods).Hands on experience with Microsoft SQL server (version 2016 and above) and SQL Server Management Studio (SSMS)Strong SQL development knowledge, T-SQL & scripting for automation. PowerShell Scripting is added advantage.Basic Infrastructure knowledge (Windows Server, storage, networking).Project management & leadership.Troubleshooting & root cause analysis. Additional Information:
The candidate should have minimum 5 years of experience in Microsoft SQL Server Integration Services (SSIS).
This position is based at our Hyderabad office.
A 15 years full time education is required. Qualification15 years full time education
Job Classification
Industry: IT Services & ConsultingFunctional Area / Department: Engineering - Software & QARole Category: DBA / Data warehousingRole: Data warehouse Architect / ConsultantEmployement Type: Full time