Requirements: At least 3-9 years of data integration (sourcing, staging, mapping, loading,) experience in SQL-Server, SSIS, T-SQLExperience in SQL Server cloud instances is a must.Monitor and address database server performance issues, including running SQL profiler, identifying long-running SQL, advising development teams to improve performance, optimizing performance using techniques including indexing and schema normalization/denormalization, capacity planning, and server resource usageCreate and maintain SQL for use in in-house BI applications and dashboardsDevelopment of SQL Server Integration packages for importing, exporting and processing dataDesign and develop SQL Server stored procedures, functions, views and triggers to be used during the ETL processDesigning and developing SSIS / SQL, ETL solutions to acquire and prepare data from numerous upstream systems for processing by QRMBuilds data transformations with SSIS including importing data from files, moving data from one database platform to anotherDebug and tune SSIS or other ETL processes to ensure accurate and efficient movement of dataDesign, implement and maintain database objects (tables, views, indexes,) and database securityAnalyze and develop strategies and approaches to import and transfer data between source, staging, and ODS/Data Warehouse destinationsTest and prepare ETL processes for deployment to production and non-production environmentsSupport system and acceptance testing including the development or refinement of test plansExperienced in SQL Server / SSIS migration from On-Prem to Cloud environment.
Benefits:Provident Fund Performance based Bonuses Health Insurance Bi-annual Increments Paid LeavesCertification ReimbursementGYM Membership