With the reference to your CV posted in Job portal. We are looking out for SQL Server professionals.Job type: "Permanent"
Job Locations: Chennai
Kindly share the profile ONLY IF you are Interested & ONLY IF you can join within 30 Days
Job Description:
SQL Server Database
• Table Design Principles
• Create and alter tables using T-SQL
• Design, Create and alter views
• Query data by using SELECT statements
• Implement sub-queries
• Implement aggregate queries
• Query and manage XML data
• Create, alter and tune stored procedures
• Create and alter functions
• Modify data by using INSERT, UPDATE and DELETE statements
• Combine datasets using UNION , UNION all, MERGE statements
• Optimize SQL queries
• Implement error handling
• Cursors Usage and Issues
• Database Backup Strategies & Tuning
• Database Restore and Recovery Options
• ETL Concepts
• Troubleshooting - manual approaches, using troubleshooting tools like SQL Profiler
• Managing SSDT Projects in Visual Studio TFS (Source Control System)
SSRS
• Designing reports using tools like BIDS, Report Builder
• apply conditional formatting using expressions
• implement headers and footers;
• implement matrices, table, chart, images, list, indicators, maps and groupings in reports
• Configure authentication and authorization for a reporting solution
• Implement interactivity in a report - drilldown reports, drillthrough reports
• Configure report data sources and datasets
• Using Parameters in reports
• Troubleshoot reporting services issues
• Managing SSRS Projects in Visual Studio TFS
SSAS (Good to have)
• Datawarehouse Concepts - Kimball and Inman Models
• Design dimensions and measures - Given a requirement, identify the dimension/measure group relationship that should be selected
• Implement and configure dimensions in a cube
• Design a schema to support cube architecture
• Create and configure measures
• Implement a cube
• Troubleshooting Cube Processing Issues
• Managing SSAS Projects in Visual Studio TFS
Please fill in the details below if interested.
Highest Qualification:
Total Exp:
Relevant Exp:
Current CTC:
Expected CTC:
Current Company:
Current Location:
Pref. Location:
Notice Period: 30 /60 /90:
No comments:
Post a Comment