Technology Consultant I - ETL/SSIS
Company Name:
Genpact, Jawood Healthcare Solutions
JAWOOD is seeking a Technology Consultant I.
Description:
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.
The candidate must be a self starter and be able to work with little or no supervision. 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:
1. Write and troubleshoot SQL queries and stored procedures. (8 years)
2. Experience in SSIS and SSRS (6 Years)
3. 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 and User Acceptance Testing.
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 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
Ref#: 1000031281
Date published: 22-Aug-2014Estimated Salary: $20 to $28 per hour based on qualifications.
Genpact, Jawood Healthcare Solutions
JAWOOD is seeking a Technology Consultant I.
Description:
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.
The candidate must be a self starter and be able to work with little or no supervision. 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:
1. Write and troubleshoot SQL queries and stored procedures. (8 years)
2. Experience in SSIS and SSRS (6 Years)
3. 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 and User Acceptance Testing.
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 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
Ref#: 1000031281
Date published: 22-Aug-2014Estimated Salary: $20 to $28 per hour based on qualifications.
|
|
 | |
