Gebbs Healthcare Solutions Pvt. Ltd.
Location
Navi Mumbai | India
Job description
Designation : Lead-Data WarehouseDepartment : SoftwareLocation : Airoli, Navi MumbaiOffice Time : 11am - 8pmWork Mode : WFOKey skill : T-SQL, Azure Data Factory (ADF), SQL Server Integration Service (SSIS), Datawarehouse concepts Job Description :Duties & Responsibilities : - 6-9 years of experience- Develop, design, tune and maintain ADF/SSIS packages to perform the ETL process.- Design and develop SQL Server stored procedures, functions, views and triggers to be used during the ETL process.- Design and develop ETL solutions using data integration tools for interfacing between source application and the Enterprise Data Warehouse.- Develops ETL technical specifications, designs, develops, tests, implements, and supports optimal data solutions.- Integrates ETL development with existing projects to maximize object reuse.- Creates, executes, and documents unit test plans for ETL and data integration processes and programs.- Perform problem assessment, resolution and documentation in existing ETL packages, mapping and workflows in production.- Troubleshoot data issues and defects to determine root cause.- Performance tuning of the ETL process and SQL queries and recommend and implement ETL and query tuning techniques.- Develop and create transformation queries, views, and stored procedures for ETL processes, and process automations.- Team handling, task distribution and task estimates. (ref:hirist.tech)
Job tags
Salary
