Writing TSQL Queries using joins and Sub queries in MS SQL Server.
TSQL development skills to write complex queries involving multiple tables Joins.
Experience in Extracting Transforming and Loading (ETL) data from Excel Flat file to MS SQL Server.
Creating primary objects (tables views indexes)
Generating various reports by querying from database as per need.
Customer support for environmental issues and maintenance
Data conversions from different sources
ADDITIONAL RESPONSIBILITY:
SQL knowledge (query performance tuning index maintenance etc.) as well as an understanding of database structure
Knowledge of data modelling principles
Design implement and continuously expand data pipelines by performing extraction transformation and loading activities
Be responsible for the development of the conceptual logical and physical data models the implementation of RDBMS operational data store (ODS) data marts and data lakes on target platforms (SQL).
Oversee and govern the expansion of existing data architecture and the optimization of data query performance via best practices. The candidate must be able to work independently and collaboratively.
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.