Epicareer Might not Working Properly
Learn More
Z

SQL Server & BI Developer

Salary undisclosed

Apply on

Availability Status

This job is expected to be in high demand and may close soon. We’ll remove this job ad once it's closed.


Original
Simplified
Role: SQL Server & BI Developer Location: Columbia, SC (Hybrid)
Experience in Data Warehousing and Business Intelligence applications design, development, Maintenance of Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analytical Services (SSAS) and MS SQL Developer in Support and development of Database Design and Development in SQL Server 2018\2016\2014\2012\2008R2\2008 system in OLTP and OLAP Environment. Experienced in logical and physical database design and development, normalization, data modeling and SQL Server Enterprise Manager/SQL Server Management Studio. Experience on performing Data loads to Dimension, Fact tables, Data warehouse, Data marts, and OLAP cubes. Expertise in MDX to create Named Sets, Named Members, Calculated Members, and other calculations. Extensive ETL experience using DTS/SSIS for data extraction, transformation and loading from OLTP systems to ODS and OLAP systems. Responsible for all backup, recovery, and upgrading of all the PostgreSQL databases. ETL and Data Warehouse design experience, Excellent knowledge to do UAT testing and working on defects using JIRA and Quality Center and Application Lifecycle Management ALM software. Utilizing NumPy and Pandas to perform data manipulation tasks, such as data cleaning, transformation, and aggregation. Experience in Extraction of data from heterogeneous data sources like Excel, MS Access, Oracle, and DB2 to MS SQL Server by using Import Export Wizard, DTS, SSIS, BCP and Bulk Insert utilities. Experience in providing Logging, Error handling by using Event Handler and Custom Logging for SSIS Packages. Expert in scheduling jobs for SSIS Packages and sending Alerts using SQL Mail. Adept in designing Stylish Report layout and have extensive experience in generating Drill down and Drill through as well as Slice and Dice reports with Drop down menu option, sorting the data, Sub reports defining subtotals in SSRS 2005/2008/2008R2. Integrating Azure Data Factory with other Azure services, such as Azure Databricks, Azure Synapse Analytics, and Azure SQL Database, to build end-to-end data processing pipelines. Integrating Azure Data Factory with other Azure services, such as Azure Databricks, Azure Synapse Analytics, and Azure SQL Database, to build end-to-end data processing pipelines.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
Report this job
Similar Jobs

1d ago

Server
Flix Entertainment | Flix Brewhouse | Cinema Breweries

Full Time, onsite, onsite

Salary undisclosed