SSIS SQL
- Hexaware Technologies
- 6 - 9 years
- Pune
- 2 months ago
- Email to a friend
- Report this job
Job Description
Hi
Experience : 6-9yrs
Work location : Pune/Chennai/Bangalore
Notice Period: Imm - 30 days
Skills and Experience 5-6 years of experience with relational databases (Strong in SQL Server 2016). 5-6 years of experience with SSIS 2016 and SSRS 2016.
Strong communication skills.
Sharing JD for your reference :
The ETL developer/application engineer will work as part of the project team. Will be primarily responsible for implementing ETL processes using SSIS, to populate variety of source data into the Marketing database(s).The candidate will have a deep understanding of both OLTP and star schemas, with all associated ETL constructs to effectively manage facts and dimensions. The resulting ETL processes should be scalable, efficient, audited and as re-usable as possible. This role should also be able to assess data quality and auditability of the overall flow.
Primary Responsibilities Develop, design, tune and maintain 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. Write scripts for automated testing of data in the target facts and dimensions. Capture audit information during all phases of the ETL process. Write and maintain documentation of the ETL processes via process flow diagrams. Collaborate with business users, support team members, and other developers throughout the organization to help everyone understand issues that affect the data warehouse.
Secondary Responsibilities Design, build and deploy reports in SQL Server Reporting Services (SSRS). Deploy reports in Native as well as share-point mode
Job Classification
Industry: IT Services & ConsultingFunctional Area / Department: Data Science & Analytics,
Role Category: Business Intelligence & Analytics
Role: BI Developer
Employement Type: Full time
Contact Details:
Company: Hexaware TechnologiesLocation(s): Pune
Similar positions
Hexaware Technologies
Hexaware BPS is a unit of Hexaware Technologies Ltd. We are currently staffed at 2000+ people across Navi Mumbai (Mahape) Chennai, Nagpur and US. Ranked 15th in the NASSCOM Top 20 IT Software & Services Exporters from India, we also rank among the Top 20 Best IT employers in India by DQ-IDC fo...
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in