TSQL Developer
Location: 100% Remote
Budget: 40 50K / month
Experience : 25 years
Time zone: IST
Contract Duration: 6 months ( extendable)
Must Have:
- Experience: 25 years in the design and development of endtoend BI & Analytics projects in a global enterprise environment.
- Technical Skills: Strong TSQL experience including defect triaging building TSQL procedures TVF Views Ragged hierarchy Cursors Loops working with local/global parameters reports and ETL load issues.
- Performance & Tuning: Ability to review and optimize TSQL code identify bottlenecks and improve performance.
- Database Knowledge: Strong understanding of database performance tuning troubleshooting and query optimization.
- Data Warehousing: Proficiency in data warehouse design and BI application development.
- SQL Expertise: Deep understanding of writing SQL code.
-
Nice to Have:
- BI & Cloud Tools: Experience in Power BI SSAS tabular modeling Azure Data Factory and DAX on the Azure platform.
- Cloud Platforms: Knowledge of Azure technologies like Azure Analysis Services.
- CRM Systems: Experience in CRM platforms like Salesforce.
- Data Handling: Experience in dataset ingestion data model creation reports and dashboards.
- Reporting Tools: Familiarity with other reporting tools.
- Version Control & CI/CD: Ability to use GIT Jenkins and other change management tools.
- Additional Database Knowledge: Good knowledge of database performance tuning troubleshooting and query optimization.
CLOUD TOOLS , AZURE DATA FACTORY , DEFECT TRIAGING , T-SQL , POWER BI , CI/CD , SQL CODE