Senior Database Architect in SQL with BI
Company Name:
Lorven technologies Inc
Our Direct Integration Client is looking for a Senior Database Architect in SQL with BI for our client in Little Rock, AR. Please find the detail description below. Kindly let me know your interest.
position
: Senior Database Architect in SQL with BI
Location: Little Rock, AR
Duration: 8
Months
Rate: $ OPEN
Required
Experience:
Should be Responsible for designing normalized databases from complex business information as well as set up Dimensional models.
Should be required to conceptualize, design and set up elaborate, maintainable, industrial strength
jobs
to move data into SQL Server databases.
Should be complete with failure alerts and set up for quick debugging in case of failures.
This is not a mature BI/Data Integration setup and will be required to advise on architecture and establish BI/Data Integration best practices and standards.
Should be very conversant with working on the Business Intelligence Development Studio/SQL Server Data Tools, especially SSIS.
Should have demonstrated skills in data processing automation in the Windows platform.
Should have excellent communication skills and be able to elicit requirements and work with non-technical Subject Matter Experts.
Responsible for producing quality reports with an eye for detail.
Produce quality documentation of processes used and train personnel of less expertise.
Environment is dynamic and unpredictable so the position must be able to adapt, multi-task and continuously strive to exceed business customer expectations.
Must be familiar with Project Management and reporting.
This is mastery of ANSI SQL in general (not to be confused with SQL SERVER/Transact SQL).
Should comprehend, debug and create complex multi-joins, star joins as well as ability to make data change SQL in complex situations.
SSIS (Business Intelligence Development Studio/SQL Server Data Tools) mastery.
SSRS (SQL Server Reporting
services
) and/or Business Objects (2 years.)
Data Modelling (Dimensional as well as relational). 4 years minimum.
Proven experience and a knack for data processing automation in the Windows platform.
ArcGIS software from ESRI, web and desktop version (1 year)
Erin (2 years).
PowerShell (1 year)
IBM DataStage
Excel macros
Skills Matrix:
Should have strong Experience SQL minimum 6 Years
Should have strong Experience ANSI SQL minimum 6 Years
Should have strong Experience SSIS minimum 5 Years
Should have strong Experience Data Modeling (plus Dimensional) minimum 4 Years
Should have strong Experience Data Processing Automation in the Windows Platform minimum 3 Years
Should have strong Experience Erin minimum 2 Years
Should have Experience PowerShell minimum 1 Years
Should have Experience IBM DataStage minimum 1 Years
Should have Experience Excel macros minimum 1 Years
Thanks & Regards
Lorven Technologies Inc,
101, Morgan Lane, Suite 209
Plainsboro, NJ-08536
Email:
Web: www.lorventech.com
Lorven Technologies, Inc. is SBE/MWBE CertifiedEstimated Salary: $20 to $28 per hour based on qualifications.
Lorven technologies Inc
Our Direct Integration Client is looking for a Senior Database Architect in SQL with BI for our client in Little Rock, AR. Please find the detail description below. Kindly let me know your interest.
position
: Senior Database Architect in SQL with BI
Location: Little Rock, AR
Duration: 8
Months
Rate: $ OPEN
Required
Experience:
Should be Responsible for designing normalized databases from complex business information as well as set up Dimensional models.
Should be required to conceptualize, design and set up elaborate, maintainable, industrial strength
jobs
to move data into SQL Server databases.
Should be complete with failure alerts and set up for quick debugging in case of failures.
This is not a mature BI/Data Integration setup and will be required to advise on architecture and establish BI/Data Integration best practices and standards.
Should be very conversant with working on the Business Intelligence Development Studio/SQL Server Data Tools, especially SSIS.
Should have demonstrated skills in data processing automation in the Windows platform.
Should have excellent communication skills and be able to elicit requirements and work with non-technical Subject Matter Experts.
Responsible for producing quality reports with an eye for detail.
Produce quality documentation of processes used and train personnel of less expertise.
Environment is dynamic and unpredictable so the position must be able to adapt, multi-task and continuously strive to exceed business customer expectations.
Must be familiar with Project Management and reporting.
This is mastery of ANSI SQL in general (not to be confused with SQL SERVER/Transact SQL).
Should comprehend, debug and create complex multi-joins, star joins as well as ability to make data change SQL in complex situations.
SSIS (Business Intelligence Development Studio/SQL Server Data Tools) mastery.
SSRS (SQL Server Reporting
services
) and/or Business Objects (2 years.)
Data Modelling (Dimensional as well as relational). 4 years minimum.
Proven experience and a knack for data processing automation in the Windows platform.
ArcGIS software from ESRI, web and desktop version (1 year)
Erin (2 years).
PowerShell (1 year)
IBM DataStage
Excel macros
Skills Matrix:
Should have strong Experience SQL minimum 6 Years
Should have strong Experience ANSI SQL minimum 6 Years
Should have strong Experience SSIS minimum 5 Years
Should have strong Experience Data Modeling (plus Dimensional) minimum 4 Years
Should have strong Experience Data Processing Automation in the Windows Platform minimum 3 Years
Should have strong Experience Erin minimum 2 Years
Should have Experience PowerShell minimum 1 Years
Should have Experience IBM DataStage minimum 1 Years
Should have Experience Excel macros minimum 1 Years
Thanks & Regards
Lorven Technologies Inc,
101, Morgan Lane, Suite 209
Plainsboro, NJ-08536
Email:
Web: www.lorventech.com
Lorven Technologies, Inc. is SBE/MWBE CertifiedEstimated Salary: $20 to $28 per hour based on qualifications.
|
|
 | |
