Sr . Associate - Software Engineer - Hyderabad @ Sutherland Global

• This technical position will be responsible for development and on-going support of an enterprise data warehouse, data marts and supporting systems/applications.
  
• Role will be part of a team which will be responsible for using business and technical requirements and architecting solutions based on what is needed from a delivery standpoint.
  
• Build and maintain modular ETL applications which enable the flow of data between data sources
  
• Develop database schemas, database procedures and functions, ETL, data loads and data extracts
  
• Interact with Business Systems Analysts, users and business leads to understand Business needs.
  
• Understand source data components and how they integrate with each other and existing EDW structures
  
• Review and approve the technical specifications provided by the Business Systems Analysts.
  
• Design and implement ETL architectures based on the business, data and functional requirements
  
• Deliver the ETL high level design document for program and development team to review.
  
• Deployment and integration testing of developed components in
• Development and Test environments.
  
• Support QA (resolve issues and release fixes) UAT and production support when required.
  
• Develop, maintain and document SSIS packages and solutions.
  Partner directly with other ETL developers, data architects, clients, other technical data warehouse team members and database administrators to design and develop high performing ETL and maintain consistent development functions.
  
• Ensure solution designs address performance requirements, reusability, availability, integrity, security challenges, and business functional requirements.
  
• Develop and maintain T-SQL code (stored procedure, functions, etc ) as needed.
  
• Converted PL/SQL logic used currently into SSIS Packages and Solutions.
  
• Performance tune SSIS packages and solutions to improve the overall execution time.
  
• Provide estimates of work to be done.

Key competencies: