SQL Server Developer
Desired Candidate Profile
Primary Area: IT Metrics System
Technical Proficiencies: SQL Server T/SQL, ANSI SQL, SQL Server Integration Services (SSIS)
Technical Familiarity: SQL Server Administration, SQL Server Analysis Services (SSAS)
Concepts/Subject Matter: Data Warehousing concepts and best practices, Extract, Transfer and Load (ETL)
Major KT Activities: QSDP, IT Support Systems/Tools, ITSDW architecture and flows, QGEM architecture and flows
Details:
Proficiency in writing and optimizing T-SQL code and stored procedures
Proficiency in DDL, DML, DCL & TCL statements, different types of operators, conditions, expressions, functions, Triggers, Cursors, how to query from tables using joins and other advanced sub-queries. Must know to create and manage database objects such as tables, views, indexes, identity etc.
Proficiency in "Control Flow" and "Data Flow" as well as know what "Log providers", "Connection Managers", "Property Expressions" (For SSIS)
Good understanding of SQL Server administration activities (creating database/objects/users; working with permissions; backup / restore activities)
Job Description
Primary Area: IT Metrics System
Technical Proficiencies: SQL Server T/SQL, ANSI SQL, SQL Server Integration Services (SSIS)
Technical Familiarity: SQL Server Administration, SQL Server Analysis Services (SSAS)
Concepts/Subject Matter: Data Warehousing concepts and best practices, Extract, Transfer and Load (ETL)
Major KT Activities: QSDP, IT Support Systems/Tools, ITSDW architecture and flows, QGEM architecture and flows
Details:
Proficiency in writing and optimizing T-SQL code and stored procedures
Proficiency in DDL, DML, DCL & TCL statements, different types of operators, conditions, expressions, functions, Triggers, Cursors, how to query from tables using joins and other advanced sub-queries. Must know to create and manage database objects such as tables, views, indexes, identity etc.
Proficiency in "Control Flow" and "Data Flow" as well as know what "Log providers", "Connection Managers", "Property Expressions" (For SSIS)
Good understanding of SQL Server administration activities (creating database/objects/users; working with permissions; backup / restore activities)
Keywords: SQL
Experience: 4 - 6 Years
Location: Noida
Education: UG - Any Graduate - Any Specialization
PG - Any PG Course - Any Specialization
Industry Type: IT-Software/ Software Services
Role: Software Developer
Functional Area: System Programming
Contact Details
Artech Infosystems Pvt. Ltd.
Website: http://www.artechinfo.com
Executive Name: Sandeep Prasad
Email Address: sprasad@artechinfo.in