SQL Developer
$1,300,000–$1,300,000 year
On-siteChennai, Tamil Nadu, India
Chennai, Tamil Nadu, IndiaOn-siteFull Time$1,300,000–$1,300,000 yearSmall
Full TimeSmall
Job Summary
Write T-SQL queries using joins and subqueries to extract, transform, and load data from Excel flat files into MS SQL Server. Create primary objects including tables, views, and indexes while designing conceptual, logical, and physical data models for operational data stores and data marts. Generate reports by querying databases and maintain existing processes through customer support for environmental issues and maintenance. Oversee data architecture expansion, optimize query performance via index maintenance, and ensure data conversions across different sources.
Required Qualifications
- 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
Hiring someone like this?
Get your role in front of qualified candidates on Sorce.