Icon hamburger
US
What job do you want?
Apply to this job.
Think you're the perfect candidate?
Apply Now
Thumsup

You’re being taken to an external site to apply.

Enter your email below to receive job recommendations for similar positions.
Default3

SQL Power BI

Flexasoft Redmond Full-Time
Apply Now








  • Around 5 years of IT experience which includes System Analysis and Design, Development, Deployment & Support of Client/Server, Business Intelligence (BI) database applications using MS SQL Servers 2012/2010/2008R2/2008 SSIS, Reporting & Analysis Services.

  • Strong experience in installing, configuring, managing, upgrading and migrating, Backup/Restore, monitoring and troubleshooting SQL Server 2012/2010/ 2008 R2/2005

  • Extensive experience with different phases of project (project initiation, project requirement and specification gathering, designing system, coding, testing and debugging new and existing client-server based applications).

  • Strong experience with T-SQL(DDL & DML) in Implementing & Developing Complex Stored Procedures, appropriate Triggers, Joins, Cursors, Views, User Defined Functions, Indexes, User Profiles, Relational Database Models, Creating & Updating tables and checking the database consistency by executing DBCC Commands.

  • Strong Experience in Creating, Configuring, Deploying and Testing SSIS Packages.

  • Experience in Extraction, Transformation and Loading (ETL) data from different sources including Data Secured layers (DSL), Web Services and SSAS Multi-dimensional cubes, Access, Excel, Flat Files and XML using DTS and SQL Server Integration Services (SSIS).

  • Expertise in building and migration of various DTS packages.

  • Skilled in performing various SSIS data transformation tasks like Look-ups, Fuzzy Look-ups, Conditional Splits, Event Handlers and Error Handlers.

  • Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS).

  • Created and Configured Data Source & Data Source Views, Dimensions, Cubes, Measures, Partitions, KPI’s & MDX Queries using SQL Server 2008 Analysis Services(SSAS).

  • Excellent knowledge of creating and Scheduling SQL Agent jobs, Operators and Alerts using       SQL Server Agent.

  • Hands on Experience in writing MDX (Multi-Dimensional Expression) queries and creating and customizing Cubes using SQL Server Analysis Services (SSAS) 2008/2005.

  • Extensive experience in developing Custom Reports and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) using Business intelligence development studio (BIDS).

  • Hands on experience on Integrating SSRS Reports using various web parts into SharePoint (MOSS 2007) and various delivery mechanisms.

  • Expertise in database optimization using tools like Index Tuning Wizard, SQL profiler, File groups, DBCC utilities and Windows Performance Monitor for monitoring and tuning MS SQL Server performance.

  • Working knowledge of Source Control tools like Team Foundation Server (TFS),Visual Studio  and Visual Source Safe (VSS).

  • Broad experience in Query Optimization and Performance Tuning of stored procedures, functions.

  • Flexible, enthusiastic and project oriented team player with excellent written, verbal communication to develop creative solutions for challenging client needs.

  • Self-motivated, diligent with the ability to quickly adapt to new environments and changes. 


• MUST: At least a Bachelor degree in Computers or a closely related field from a reputed university/college



Recommended skills

User Defined Functions
Ssas 2008
Sql Server Reporting Services
Sql Server Analysis Services
Performance Monitor
Sql Server Integration Services

Location

CareerBuilder Estimated Salary

Based on Job Title, Location and Skills
$130K
Below Avg. Average Above Avg.
Apply to this job.
Think you're the perfect candidate?
Apply Now

Help us improve CareerBuilder by providing feedback about this job: Report this job

Report this Job

Once a job has been reported, we will investigate it further. If you require a response, submit your question or concern to our Trust and Site Security Team

CAREERBUILDER TIP

For your privacy and protection, when applying to a job online, never give your social security number to a prospective employer, provide credit card or bank account information, or perform any sort of monetary transaction. Learn more.

By applying to a job using CareerBuilder you are agreeing to comply with and be subject to the CareerBuilder Terms and Conditions for use of our website. To use our website, you must agree with the Terms and Conditions and both meet and comply with their provisions.