SQL Developer Job at Overture Rede (Chennai)

Job Description

Role- Microsoft SQL server database developer

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
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

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
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
Work Experience 5+ years