Job Description
Assistant Manager- SQL developer
Key skills T-SQL, MS SQL Server, SSIS. Database Developer
Required Skills: SQL(Expert)& Excel (Intermediate)
Location- Hyderabad (Return to office)
We are seeking a Data Analyst for Hyderabad locationExperience: 5+ years
Role that involves client interaction
Responsibilities
- Writing T-SQL Queries using joins and Sub queries in MS SQL Server.
- T-SQL development skills to write complex queries involving multiple tables, Joins.
- Creating & modifying of tables, fields, constraints in MS SQL Server
- Strong hands-on experience in optimizing data base performance and Query performance
- Must have good experience in testing and troubleshooting database issues
- Advance functions
- Creating / modifying stored procedures in MS SQL Server.
- Scheduling / modifying Jobs to automate in MS SQL Server.
- Knowledge on creating Views / Triggers / Functions
- Analytical mindset and sound knowledge of MS-Excel, MS-Access is Preferred
- Knowledge on designing Data model (Star / Snowflake Schema).
You will work on SQL server and engaged in writing complex queries, creating/amending procedures, packages, triggers, Indexes, Functions, and transactions.
Responsible for designing Complex SQL queries, Stored Procedures, cursors, triggers, ETL etc.
- Need to Import/Export data on SQL Server
- Data analysis, data verification and problem-solving abilities.
- Should know how to build functions, procedures, triggers, indexes, cursor etc.
- Very good command over SQL and write complex queries.
- Good technical knowledge in data mining, reporting tools.
- Good knowledge of databases and data warehouse structures
Qualifications we seek in you.
Minimum qualifications
- BE/B- Tech, BCA, MCA, MBA, BSc/MSc
Job Classification
Industry: IT Services & Consulting
Functional Area / Department: Data Science & Analytics
Role Category: Business Intelligence & Analytics
Role: Business Intelligence & Analytics - Other
Employement Type: Full time
Contact Details:
Company: Genpact
Location(s): Hyderabad
Keyskills:
SQL Server
SSIS
data warehouse
SSRS
SQL