Dear Associates,
Kindly Share your Suitable Consultants Profile to vathani@empowercsi.com and Our Payment Terms Net 45 Days.
Job Description:
A. Position
Description
1. A self-starting Senior SQL Server Data Warehouse developer with full development responsibility for a multi-billion dollar Global real estate management firm’s Data Warehouse
B. Principal Accountabilities
1. Create, administer, and maintain the SQL Server objects required to support the Data Warehouse
2. Assist ETL team in developing source to target mapping.
3. Assist Cognos Lead in mapping report requirements to data model.
4. Source System of Record data analysis and source to target design.
5. Assist in Data Quality research and UAT.
6. Work with Informatica ETL developers for ETL & DBA for Physical DDL creation &
7. Work with Cognos Report Developers in Report development, Report Metadata, etc.
8. Troubleshoot and optimize the performance of Cognos reports, Informatica ETL packages
9. Troubleshoot and optimize the performance of SQL Server objects including SSIS, stored procedures, triggers, views, etc.
C. Required Skills
1. Extensive experience with SQL Server and ETL, including Integration Services.
2. Excellent knowledge of databases, data warehouse/modeling concepts and understanding of business intelligence.
3. Extensive experience with Stored Procedures, Triggers, Views, and Functions.
4. Query performance analysis and tuning.
5. Excellent problem solving and critical thinking skills.
6. Excellent analytical skills, documentation, and ability to work in teams and/or independently.
7. Fast learner.
8. ETL development using a variety of tools to meet all technical specifications and business requirements according to the established designs
D. Required Experience
1. 5+ years SQL Server development including triggers, stored procedures, SSIS, views
2. Expertise with Microsoft SQL Server 2012 or higher database technologies and structures
E. Desired Experience
1. Informatica ETL
2. Cognos report development
3. SSIS, SSAS, SSRS, Microsoft BI
4. Mixed on-shore and off-shore development
1. A self-starting Senior SQL Server Data Warehouse developer with full development responsibility for a multi-billion dollar Global real estate management firm’s Data Warehouse
B. Principal Accountabilities
1. Create, administer, and maintain the SQL Server objects required to support the Data Warehouse
2. Assist ETL team in developing source to target mapping.
3. Assist Cognos Lead in mapping report requirements to data model.
4. Source System of Record data analysis and source to target design.
5. Assist in Data Quality research and UAT.
6. Work with Informatica ETL developers for ETL & DBA for Physical DDL creation &
7. Work with Cognos Report Developers in Report development, Report Metadata, etc.
8. Troubleshoot and optimize the performance of Cognos reports, Informatica ETL packages
9. Troubleshoot and optimize the performance of SQL Server objects including SSIS, stored procedures, triggers, views, etc.
C. Required Skills
1. Extensive experience with SQL Server and ETL, including Integration Services.
2. Excellent knowledge of databases, data warehouse/modeling concepts and understanding of business intelligence.
3. Extensive experience with Stored Procedures, Triggers, Views, and Functions.
4. Query performance analysis and tuning.
5. Excellent problem solving and critical thinking skills.
6. Excellent analytical skills, documentation, and ability to work in teams and/or independently.
7. Fast learner.
8. ETL development using a variety of tools to meet all technical specifications and business requirements according to the established designs
D. Required Experience
1. 5+ years SQL Server development including triggers, stored procedures, SSIS, views
2. Expertise with Microsoft SQL Server 2012 or higher database technologies and structures
E. Desired Experience
1. Informatica ETL
2. Cognos report development
3. SSIS, SSAS, SSRS, Microsoft BI
4. Mixed on-shore and off-shore development
Note :
Our Payment terms - Monthly Net 45 Days
Thanks and Best Regards,
Vathani
Ramachandra
Empower Consultancy Services Inc.,
USA | UK | India|Sweden
Direct: 510-995-7780 | Office: (510) 335-1190
Ext. 109 I Fax : 510-740-3549
Gtalk – vinformax.vathani |Skype –
vinformax.vathani
510-512-8069(W)
No comments:
Post a Comment