SSIS Lead

Wipro Ltd

Bangalore, India

Salary : 15,500 - 19000

Job details 

Key Responsibilities:

  1. SQL Server Database Development:
  • Design, develop, and maintain SQL Server databases.
  • Create and optimize stored procedures, functions, views, and triggers.
  • Ensure database performance, security, and reliability.
  • Perform data modeling and database schema design.
  1. SSIS Development:
  • Design and develop ETL (Extract, Transform, Load) processes using SSIS.
  • Build data transformations, including importing data from various sources and moving data between databases.
  • Debug and optimize SSIS packages to ensure efficient data movement.
  • Implement and maintain database objects and security.
  1. SSRS Development:
  • Design, develop, and maintain reports using SSRS.
  • Create complex reports, including dashboards and scorecards, to meet business requirements.
  • Ensure reports are optimized for performance and accuracy.
  • Collaborate with business users to gather reporting requirements and provide technical solutions.
  1. General Responsibilities:
  • Work closely with business analysts, stakeholders, and other team members to understand data requirements.
  • Provide technical guidance and support to other developers.
  • Participate in code reviews and ensure adherence to best practices.
  • Stay updated with the latest industry trends and technologies related to SQL Server, SSIS, and SSRS.

Qualifications:

  • Bachelor's degree .
  • Proven experience as a SQL Server Database Developer, SSIS Developer, and SSRS Developer.
  • Strong knowledge of T-SQL, data modeling, and database design.
  • Proficiency in developing and optimizing SSIS packages and SSRS reports.
  • Excellent problem-solving skills and attention to detail.
  • Ability to work independently and manage multiple tasks effectively.

Note :-   Candidate should have hands on experience on the highlighted column .