Senior SQL Developer

Candidate Must Have:
- 6+ years experience in core database design, development, performance tuning, and optimization
- Strong experience with SQL Server 2016/Azure databases
- ETL (Extraction, Transformation and Loading) Design & Development (Microsoft SSIS/ADF & T-SQL)

Preferred Skills:

- Knowledge of Data Marts / Data Warehouse Solution Design, Dimensional Modeling (Kimball Methodology)

Primary responsibilities:

• Understanding of database architecture, security, and deployment strategies
• Demonstrate good knowledge and skills in designing and implementing Data Marts, Data Warehouse, BI and Dashboard solutions
• Exhibit hands-on skills in data modelling
• Data components development using SQL Server T-SQL, SQL stored procedures, triggers, views, and SQL Agent Jobs
• ETL Design & Development using Microsoft SSIS / Azure Data Factory (Optional)
• Connect to multiple datasets to bring all the relevant data together in one place
• Uploading of Power BI reports to Power BI online service, implement security and audit # scheduling of Power BI data sets in online version and knowledge of viewing dashboards in Power BI mobile version
• Designing, developing and testing data transformations for reporting and interfaces between systems
• Ability to develop systematic testing plans for unit testing

Soft Skills:

• Ability to read, analyze, and interpret general business documentation, technical specifications, and project management documentation
• Data gathering, research, and analytical abilities to develop insightful conclusions and generate solutions to address user needs
• Good analytical, logical reasoning, and problem-solving skills
• Good interpersonal, written, and oral communication skills
• Self-motivated and directed, with keen attention to detail
• Able to prioritize and execute tasks in a high-pressure environment # Experience working in a team-oriented, collaborative environment

Requirements

BE/BTECH in Information Technology, Computer Science, or related field

Additional information

All your information will be kept confidential according to EEO guidelines.