Currently Open - Microsoft SSIS Developer

KPI Partners provides strategic guidance and technology systems for clients wishing to enable big data applications for both operations and analytics. We empower businesses with the ability to derive deep insights for fact-based decisions that can increase competitive advantage, create process efficiencies, monetize data, and increase revenue.

KPI is a Microsoft Partner and global provider of consulting, mentoring and training services for Microsoft Data Management, Business Intelligence and Analytics.

Title: Microsoft SSIS Developer

Locations: Hyderabad and Bengaluru (India)

Experience: 5-7 years

Education/Qualification: Bachelor’s degree in Computer Science or related field, or equivalent education and experience

What we are looking for...

The developer should have a good grasp of SSIS and should be able to provide application design guidance and consultation with a thorough understanding of applicable technologies, tools and existing design. Their responsibilities would include solution design, development and may include ongoing operational support of the code-line.

Requirements:

  • 7+ years of overall development experience
  • 5+ years of development experience in SSIS
  • Experience in developing projects with large data sets
  • Experience in designing reusable components within integration and reporting layer
  • Experience in building tools to manage and process large sets of data using Microsoft technologies
  • Experience in integrating data captured from heterogeneous platforms
  • Experience in providing automation solutions
  • Experience in developing end-to-end test cases/execution
  • Demonstrated deployments of enterprise software systems using industry standard environments including NDM, File Systems, .NET, XML
  • Proficient in data access to MS SQL Server 2012/2014
  • Experience in custom SQL Scripts, Stored Procedures for SQL Server
  • Organized and detail-oriented with strong problem solving and communication skills
  • Strong understanding of software development life cycle and release management
  • Experience in integrating Oracle and Microsoft SQL Server
  • Strong analytical and problem solving skills
  • Self-motivated, independent, team-player

Job Summary:

  • Design, develop and unit test ETL using SSIS
  • Design and develop highly complex store procedures and functions using SQL Server
  • Design and develop data processing processes using SSIS
  • Conduct design and code walk-throughs
  • Drive consistent quality practices through all work and in major new functionalities
  • Design reusable integration components using Microsoft technologies
  • Design solution using various Microsoft technologies keeping scale, reusable and system performance in mind
  • Maintain system and programming guidelines by adhering to the software development lifecycle
  • Develop technical design documents detailing the designs used to maintain systems
  • Experience in MS SQL Server as a developer
  • Provide reference documentation by writing and maintaining technical specifications

Skills:

  • SSIS
  • SSRS
  • SQL Server