Required Skills

SQL Server Developer

Work Authorization

  • US Citizen

  • Green Card

Preferred Employment

  • Corp-Corp

Employment Type

  • Consulting/Contract

education qualification

  • UG :- - Not Required

  • PG :- - Not Required

Other Information

  • No of position :- ( 1 )

  • Post :- 9th Jun 2022

JOB DETAIL

 

Supporting the backend of a Sales Enablement Application. Power Sizer Tool- Engineering Team- Responsible for PowerEdge Severs.

·         7 plus years of experience as MS SQL Developer, worked on Database Design and Development in SQL Server system.

·         Main skill required: Developed multi-dimensional objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS).

·         Software Development Life cycle (SDLC), Agile Methodology with Extensive experience in Microsoft Database Technologies that includes Database Design and Development of SQL Server

·         Experience in strategically implementing indexes such as Clustered index, Non-clustered index, implement index appropriately to achieve faster data retrieval.

·         Experience working with SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS) for high performance Data Integration, Data Migration, and report generation.

·         Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.

·         Review the designs, code, and test plans of other developers and provide recommendations for improvement or optimizations

·         Extensively used SSIS to move data from text files to SQL Server.

·         Some Data Warehousing experience.

·         Designed and developed the ETL data flow to populate the CER Cube Analysis Database using the SSIS packages (SQL Server Integration Services). Scheduled and automated the packages to populate the data in the cube daily up to date for business reporting.

 

Company Information