Hello Partners - we've an immediate need on BI Data Analyst in Detroit. Candidates should be locals to MI who can do 100% onsite interview after phone screening. If you've any qualified resources who has hands on experience in TOP 3 skills send them to- raj@ksourceinc.com including availability, rate, visa and location.
BI Data Analyst
Location: Detroit, MI
Duration: Long term
Hiring: phone + onsite- F2f.
Technology Consultant supporting and enhancing using SSIS
This project is for a healthcare Insurance provider utilizing BI tools from Microsoft.
The analyst joining this position will be part of a big team consisting of developers, testers and support using Microsoft tools to build and support a data mart.
The position will be more aligned with Production support role. Desired candidate will coordinate functional activities of system integration testers participating on cross-functional teams for specific product development efforts.
On a day to day routine the analyst would be required to monitor data processed by various ETLs (SSIS packages) in Production. Based on the analysis/pre-defined procedures would have to report business stakeholders. In case of any issues, they would find the root cause and provide possible solutions. The Analyst would also be required to do performance tuning of such queries that take long time (these queries are utilized in data validations). The Analyst would also actively participate in design sessions for production.
As this position requires a lot of interaction with data, ideal candidate would have perspective to understand and derive conclusions from the data while supporting ETLs and data generated out of it. The position will also include working with business and technical resources to analyze problems encountered in testing and determining changes required to correct problems.
Top 3 Skills/Experience:
Required Skills/Experience:
Preferred Skills/Experience
Educational Requirements
--
-- BI Data Analyst
Location: Detroit, MI
Duration: Long term
Hiring: phone + onsite- F2f.
Technology Consultant supporting and enhancing using SSIS
This project is for a healthcare Insurance provider utilizing BI tools from Microsoft.
The analyst joining this position will be part of a big team consisting of developers, testers and support using Microsoft tools to build and support a data mart.
The position will be more aligned with Production support role. Desired candidate will coordinate functional activities of system integration testers participating on cross-functional teams for specific product development efforts.
On a day to day routine the analyst would be required to monitor data processed by various ETLs (SSIS packages) in Production. Based on the analysis/pre-defined procedures would have to report business stakeholders. In case of any issues, they would find the root cause and provide possible solutions. The Analyst would also be required to do performance tuning of such queries that take long time (these queries are utilized in data validations). The Analyst would also actively participate in design sessions for production.
As this position requires a lot of interaction with data, ideal candidate would have perspective to understand and derive conclusions from the data while supporting ETLs and data generated out of it. The position will also include working with business and technical resources to analyze problems encountered in testing and determining changes required to correct problems.
Top 3 Skills/Experience:
- Write and troubleshoot SQL queries and stored procedures. (8 years)
- Experience in SSIS and SSRS (6 Years)
- Experience in ETL and Data ware house testing (7+ Years)
Required Skills/Experience:
- Extensive experience in leading complex projects with division or company wide scope.
- Strong skills required in communications, leadership, presentations to senior management, problem-solving, project management, team development and organization.
- 10+ years of experience specifically with leading System Integration (SIT) and User Acceptance Testing (UAT).
- Extensive experience in SQL server 2008 platform.
- Experience in Data centric testing. Should be able to verify data loaded in tables as per the algorithms
- Must be able to understand Data transformation rules, and able to validate principal totals.
- Experience in testing data warehousing applications.
- Expertise in Data analysis, Data modeling, Database design, Data migration, and Business intelligence solutions.
- Solid understanding of relational database concepts, SQL and procedural SQL in Teradata
- Expertise in processing data available in Message Queues, Flat Files and Relational Databases
- Create processes to ensure the data quality of the information collected.
- Extensive hands-on experience on writing Excel macros.
- Extracting data from tables and formatting and dumping in files for validation
- 6 + years experience is a must.
Preferred Skills/Experience
- Prior Health Care industry experience is a plus.
- Understanding of concepts of Performance testing and Load Testing
Educational Requirements
- Bachelor's degree in computer science, information systems, computer engineering, systems analysis, or related field required. Master's degree in computer science, information systems, computer engineering, systems analysis, or related field preferred.
--
Raj Coduru
K- Source Inc | raj@ksourceinc.comYou received this message because you are subscribed to the Google Groups "Jobs for USA consultants (Citizen G.C and H1B)" group.
To unsubscribe from this group and stop receiving emails from it, send an email to jobs-for-usa-consultants-citizen-gc-and-h1b+unsubscribe@googlegroups.com.
To post to this group, send email to jobs-for-usa-consultants-citizen-gc-and-h1b@googlegroups.com.
Visit this group at http://groups.google.com/group/jobs-for-usa-consultants-citizen-gc-and-h1b.
For more options, visit https://groups.google.com/d/optout.
0 comments:
Post a Comment