About the role
Role-Microsoft SQL server database developer
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.
- 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.
- Maintain and improve already existing processes