Sunday, August 28, 2016

Senior Software Engineer - MSBI

Senior Software Engineer - MSBI

(posted about 5 days back)

DesignationSenior Software Engineer - MSBI
Job DescriptionIt takes courage to find out how good you can be. At Optum, we're using leading-edge technology to create the health care system of tomorrow. 

When you join us as a . Net Applications Developer, you'll become part of a team focused on innovation and change. You'll work a little harder. You'll aim a little higher. 

You'll expect more from yourself and others. And at the end of the day, you'll be doing a lot of good. Through a lot of inspired individuals, we are using technology to build a health care system that works better for more people in more ways than ever. 

We are looking to reinforce our team with people who are decisive, brilliant and built for speed -- people like you. As a Developer, you will be predominantly involved in developing business solutions by creating new and modifying existing software applications. 

You will be a primary contributor in designing, coding, testing, debugging, documenting and supporting all types of applications consistent with established specifications and business requirements to deliver business value. 

This is more than a challenging development role. This is high performance technology. Are you up for the challege Join us and start doing your life's best work. 

(SM)Primary Responsibilities:

Design, implement and maintain within all phases of the Software Development Life Cycle (SDLC) Develop, test, implement and maintain application software working with established processes Communicate effectively with other engineers and QA Establish, refine and integrate development and test environment tools and software as needed Identify production and non-production application issuesIdentify opportunities to fine-tune and optimize

Desired ProfilePreferred Qualifications:- Educational Qualifications: B. Tech / MCA / Msc / MTech (Minimum 16 years of formal education, Correspondence courses are not relevant).

 - experienced developers 
Should have good experience in SQLServer. 

- Should have written stored procedures and functions. 

- Should be strong in SQL- Should be familiar with ETL concepts

- Should have good experience in SSIS and data loading using SSIS

- Exprience of developing ETL processes and troubleshooting jobs using SSIS. 

- Experience in optimizing and improving ETL processes. - Should have very strong communication skills and ability to communicate with business directly. 

Nice to Have:

Experience in US Healthcare industry. Technology Careers with Optum. Information and technology have amazing power to transform the health care industry and improve people's lives. This is where it's happening. 

This is where you'll help solve the problems that have never been solved. We're freeing information so it can be used safely and securely wherever it's needed. We're creating the very best ideas that can most easily be put into action to help our clients improve the quality of care and lower costs for millions. This is where the best and the brightest work together to make positive change a reality. 

 This is the place to do your life's best work. SMDiversity creates a healthier atmosphere: UnitedHealth Group is an Equal Employment Opportunity/ Affirmative Action employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, national origin, protected veteran status, disability status, sexual orientation, gender identity or expression, marital status, genetic information, or any other characteristic protected by law.

 UnitedHealth Group is a drug-free workplace. Candidates are required to pass a drug test before beginning employment.

 Requirements- Associate's Degree or higher level of education or equivalent experience

- 2+ years experience with relational database management systems (e. g. . Access, SQL or Oracle, FileMaker Pro 9)- 2+ years experience performing data analytics and reporting- 2+ years Advanced level of proficiency with MS Excel- Strong problem solving and analytical skills

Assets

- Experience with object-oriented programming systems- Proficiency with MySQL/ PHP- Knowledge of data release precautions and HIPAA regulations

Combine two of the fastest-growing fields on the planet with a culture of performance, collaboration and opportunity and this is what you get. Leading edge technology in an industry that's improving the lives of millions. Here, innovation isn't about another gadget, it's about making health care data available wherever and whenever people need it, safely and reliably. There's no room for error. 

Join us and start doing your life's best work. (sm)Technology Careers with Optum. Information and technology have amazing power to transform the health care industry and improve people's lives. This is where it's happening. This is where you'll help solve the problems that have never been solved. We're freeing information so it can be used safely and securely wherever it's needed. 

We're creating the very best ideas that can most easily be put into action to help our clients improve the quality of care and lower costs for millions. This is where the best and the brightest work together to make positive change a reality. This is the place to do your life's best work. 

SMDiversity creates a healthier atmosphere: 

UnitedHealth Group is an Equal Employment Opportunity/ Affirmative Action employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, national origin, protected veteran status, disability status, sexual orientation, gender identity or expression, marital status, genetic information, or any other characteristic protected by law. UnitedHealth Group is a drug-free workplace. Candidates are required to pass a drug test before beginning employment.
Experience5 - 8 Years
Industry TypePharma / Biotech / Clinical Research
RoleSoftware Developer
Functional AreaIT Software - Application Programming, Maintenance
EducationUG - B.Tech/B.E. - Any Specialization
PG - M.Sc - Any Specialization, MCA - Computers, M.Tech - Any Specialization
Doctorate - Any Doctorate - Any Specialization, Doctorate Not Required
Compensation: Not disclosed
LocationHyderabad / Secunderabad
KeywordsSenior Software Engineer - MSBI Net Applications Developer designing coding testing debuggingdocumenting Software Development Life Cycle SQL MySQL PHP
Contact
Job Posted2016-08-23 11:49:06.0
Reference672539





Msbi/ Power BI Developer - Ssas/ Ssis/ SQL Server

Msbi/ Power BI Developer - Ssas/ Ssis/ SQL Server

Job Description


Send me Jobs like this
- Power BI Desktop - for Data model preparation and Visuals

- SSAS Tabular Model - Mandatory

- SSIS - would be an added advantage

- Row Level Security Implementation - Mandatory

- SQL Server 2016 - Model Data Refresh/Schedules/Jobs setup etc

- ANSI SQL - Mandatory for data validation

Please reply with billow details :

Location :
CTC :
ECTC :
Notice Period :
Reason for job change :
Skype ID

Desired Candidate Profile

Education-

UG:Any Graduate - Any Specialization
PG:Any Postgraduate - Any Specialization, Post Graduation Not Required
Doctorate:Doctorate Not Required

Company Profile:
Readmind Info Services

Leading client of Readmind Info Services 

Tuesday, August 16, 2016

SSRS Interview Question

  1. What programming language would you use to create embedded functions in SSRS?
    visual Basic .Net used to create  embedded code in SSRS
  2. What is the purpose of query parameter in ssrs?
Query parameter is used to filter the data in data source

3. What is the main difference between a Matrix report item and a Table report item? 
              both report items are just templates for the Tablix data region.            tabular report is the most basic type of report. Each column corresponds to a column selected from the database. A matrix (cross-product) report is a cross-tabulation of four groups of data: a. One group of data is displayed across the page

4.      What is the benefit of embedded code in the ssrs  reports?
Once we write the code in reports we can use the code in any expression in that report.

5.      How to display the amount in currency format and for that which property do you use?
For currency format in ssrs reports select the report item and then set the format property to  C.

6.      Can you use stored procedures in ssrs reports to get the data?
Yes, we can use stored procedures in ssrs reports and it should return only a single result.
7.      By which  we can use to generate reports in ssrs?
Reports can be developed by using tables,cubes,textfiles etc.,
8.      What is .rdl file?
Every report saved with .rdl extension in reporting services. RDL means Report Definition  Language.
9.      How many types os parameters in ssrs reports?
Single value parameters, multi value parameters, cascading parameters
10  what are the different stages in ssrs report processing
     Compile, process,render and export


Monday, August 15, 2016

SQL Server real time question


I have one doubt of SQL SERVER DBA
I am settings in backup every Sunday 12 am fullback up.
And  for every 6 hours differential backup.
And for every 15 mints  log back up.

 If my server crashes at Thursday 4.30 pm...How to recovery and restore the backup.

Saturday, January 24, 2015

SQL SEVER INTERVIEW QUESTION


1. What is  the default "SORT" order for SQL SEVER?


2. select adresses which are between  " 1/1/2015" and "1/04/2015" ?

3.why should you use CTE rather than using simple views?


Wednesday, January 14, 2015

sql server to day question

CREATE TABLE mytable ( id INT, name VARCHAR(10) );
 GO
 INSERT mytable ( id, name )
 VALUES 
 ( 1, 'S' ), 
 ( 2 , 'P'),
 ( NULL, 'Q' ), 
 ( 4, 'T' ), 
 ( NULL, 'M' ), 
 ( 6, 'N' ); 

 SELECT COUNT(*) FROM mytable;


ANSWER: 
1) 2

2) 4

3) 6

4) NULL


post the right answer


Tuesday, November 20, 2012

SSIS Real Time Question

How do I access Microsoft Excel 2007 from SSIS 2005 version. I am unable to access the files from SSIS

ANS:
Use ACE connector for Excel.
ACE OLEDB 12.0:

TYPE OLE DB ProviderUSAGE Provider=Microsoft.ACE.OLEDB.12.0MANUFACTURER Microsoft 


Xlsx files

This one is for connecting to Excel 2007 files with the Xlsx file extension. That is the Office Open XML format with macros disabled.
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\myFolder\myExcel2007file.xlsx;
Extended Properties="Excel 12.0 Xml;HDR=YES";
"HDR=Yes;" indicates that the first row contains columnnames, not data. "HDR=No;" indicates the opposite.