From: Maseeullah K <maseek@usmsystems.com>
Date: Tue, Aug 25, 2015 at 2:31 PM
Subject: Urgent Need: Sr./Lead Data Warehouse (ETL) Architect
To: Maseeullah K <maseek@usmsystems.com>
Dear Folks.
Please have an eye on my job description and revert back to me with your consultant updated resume Asap. Thanks
Role :Sr./Lead Data Warehouse (ETL) Architect
Location: Washington, DC
Locals to DC/MD/VA are highly preferred,non locals are okay too.
Length: 3-6months (Will be extended)
TOP 2 SKILLS REQUIRED:
1. ETL
2. Pentaho PDI
The TOP 2 skills are Required. USAC ideally is looking to F2F interview but might but would consider hiring off a Skype interview for the right candidate. H1 candidates are OK but must have solid communication skills and be willing to start immediately.
I. Provide a brief description of the project in which they will be working on.
a. Project is for the development of datamarts using Pentaho Data Integration (PDI) for data analytics for USAC's ongoing Enterprise Data Strategy program. Specific USAC OLTP (Oracle) databases will be used and ETL jobs will be developed. The project involves the technical documentation of the ETL jobs developed also.
II. Provide any pre-screen questions for the vendors to use in sourcing candidates.
b. Years of experience with ETL - 4
c. Tools – Pentaho, PDI, MS-SSIS, Erwin
******************************************
Sr Data Warehouse Developer/Architect:
Overall Purpose:
Leads projects in designing enterprise data reporting architecture that includes strategic reporting databases, data marts and data warehouses. Creates complex ETL packages to extract data from various data sources and load into data warehouse. Takes ownership of system structure integrity and data integrity. Serves as technical team leader in the development of business intelligence solutions and other reports based on data from various sources.
The position's essential duties include the following:
§ Works together with IT management in defining enterprise data architecture strategy
§ Teams up with the USAC Programs and Architecture on implementing the data architecture consistently across vendor-hosted and USAC-operated data centers
§ Leads in designing and revising data model for data warehouse, and meta data and data dictionaries across the enterprise
§ Meets and collaborates with business users on requirements and objectives
§ Leads in reviewing and revising database designs and scripts on an ongoing basis
§ Leads in documenting meta-data about Data Warehouse System according to computer industry standards and knowledge of database management systems.
§ Manages data loads, and security, storage and performance strategies and implementations.
§ Serves as technical team lead in the development of business intelligence reports and analysis, providing mentoring, guidance and troubleshooting to analysis team members in solving complex reporting and analytical problems
§ Conducts complex analyses of strategic issues based on analysis of trends and interrelationships of key performance drivers documented in the data warehouse, especially the identification of test and control groups and comparison and evaluation of their relative performance; synthesizes research results and develops actionable strategic recommendations; communicates research results and strategic recommendations to nationwide and division strategy managers.
§ Devises ER diagrams and identifies unique foreign keys, entities, attributes, relationships and business rules for data warehouse
Type of Experience Years of Experience
- Knowledge of Relational Databases 8
- ETL 8
- Knowledge of Data Mart Modeling Schemas 8
- SQL Server management Studio 8
- SQL Server Analysis Services, Reporting Services and Integration Services 8
- Requirements Gathering 8
- SQL Programming 8
- Microsoft Office 8
- ERWin 5
Thanks & Regards
Maseeullah K | Sr. Technical Recruiter|
| CMMI Level 3 Certified Driving the Business Trend | 14175 Sullyfield Circle, Suite # 400,Chantilly, VA 20151, U.S.A Email: maseek@usmsystems.com , Phone: 703-880-6413 Skype: maseek_usm, Gtalk: maseek.usm ISO 9001 ,ISO 20000, CMMI Level 3 Certified Company Ranked No.7 in the Washington DC area-Washington Business Journal, 2013; Smart CEO Award Winner By SMART CEO Magazine, Baltimore, U.S.A; Inc5000 Recognized Fastest growing private company in U.S.A. www.usmsystems.com,
|
--
All Job Openings : http://groups.google.com/group/jobjunction/topics?hl=en
You received this message because you are subscribed to the Google Groups "Job Junction" group.
If you are a job seeker please join the group using the link http://groups.google.com/group/jobjunction/subscribe or you can join group or add Job Junction as your friend in Facebook (Search for Job Junction) or you can also follow my blog http://jobjunctionglobal.blogspot.com/
If you have any requirement to share please send the same with all job details, email ID to which the resume has to be sent to jobjunction@googlegroups.com and jobjunctionglobal@groups.facebook.com
To unsubscribe from this group, send email to jobjunction+unsubscribe@googlegroups.com
For more options, visit this group at http://groups.google.com/group/jobjunction?hl=en
---
You received this message because you are subscribed to the Google Groups "Job Junction" group.
To unsubscribe from this group and stop receiving emails from it, send an email to jobjunction+unsubscribe@googlegroups.com.
Visit this group at http://groups.google.com/group/jobjunction.
For more options, visit https://groups.google.com/d/optout.
No comments:
Post a Comment