Stored ProceduresTriggersTablesViewsIndexUser Defined FunctionsData integrityvariablescursorCTEjoins
Work Authorization
US Citizen
Green Card
EAD (OPT/CPT/GC/H4)
H1B Work Permit
Preferred Employment
Corp-Corp
W2-Permanent
W2-Contract
Contract to Hire
Employment Type
Consulting/Contract
education qualification
UG :- - Not Required
PG :- - Not Required
Other Information
No of position :- ( 1 )
Post :- 25th Jan 2024
JOB DETAIL
Create and maintain stored procedures for data transfer between apps and databases.
Create complex SQL queries for different ad-hoc reporting and for integration with reporting tools.
Extensively use SSIS transformations such as Lookup, Derived column, conversion, task, etc. have Hands on experience in developing and deploying SSIS and SSRS in different environment.
Should have experience in data warehousing including business intelligence tools-SQL, SSIS and SSRS.
Should have used T-SQL objects like Stored Procedures, Triggers, Tables, Views, Index, User Defined Functions, Data integrity, variables, cursor, CTE, joins etc.
Experience in Performance tuning of Queries and indexing to improve Performance.
Ensure policies for handling sensitive date (PCI, PII) ethically within the application.
Should have used T-SQL objects like Stored Procedures, Triggers, Tables, Views, Index, User Defined Functions, Data integrity, variables, cursor, CTE, joins etc.
Experience in Performance tuning of Queries and indexing to improve Performance. Experience on Table Partitioning , Backup and Recovery.
Proficiency in creating a database from the group up for a brand-new application.
Ability to design tables and organize data in a manner that maximizes performance, incorporating use of suitable indexes and partitions.
Knowledge: Understanding of Cloud database services. (AWS preferred) Deep Knowledge of MSSQL ,PostgreSQL Basic understanding of No-SQL Databases Manage the data archives.
Understanding of the User Interfaces .
Ensure database / licenses are always up to date. Knowledge of MSBI, ETL and Tableau reporting Agile methodologies Jira Soft Skills:
Good verbal and written communication skills Good on client interaction, project management and co-ordination with team.
Team player and self-starter with good communication and documentation skills, ability to work independently or as part of a team and capable of picking up new skills quickly.