SQL Server (SQL, T-SQL, SSIS): SQL: Perform complex database programming by writing SQL procedures on large-scale databases. Proven ability to perform technical troubleshooting to diagnose, isolate and correct data and database issues.
Should be able to optimize sql scripts/jobs.
Good work exposure to Agile Methodology.
SSIS: Build end-end ETL flows for DWH application. Analyze data models.
Data quality analysis. SSAS: Should be aware of cube processing and design.
SQL Profiler usage and leveraging for optimizations.
Azure Dev Ops,CICD pipeline.
Must Have:
Minimum 6 years of application development experience in respective platform with an overall software engineering experience of 8 to 12 years.
Proven experience in the following areas a.Design codes framework b. Write efficient codes with minimal technical debt c. Write effective unit and integration tests Good communication skills & able to work with minimal supervision
Continuously resolving a minor or major of technical requests, inquiries, bug fixes and complaints
Good-to-Have :
Experience in working with large customers in enterprise application development in the specified skillsets