Hi,
Greetings from Ampcus Inc
We are looking for a Data Warehouse Consultant to support world's leader in providing IT consulting and software services to the finest global organizations client.
This is a 6 Months to Long term Contract extendible Position based in Washington DC
Position: Data Warehouse Consultant
Locations: Washington DC
Duration: 6 Months to Long term Contract
Job Description:
OVERALL PURPOSE OF POSITION:
Serves as technical team leader in the development of business intelligence solutions and other reports and analysis across all divisions of the organization. Writes complex SQL scripts to extract data from various databases and systems to make data available for enterprise reporting. Provides day-to-day management of overall reporting environment. The results provide ongoing support to client decision-makers, the FCC, Congress, and other interested parties.
ESSENTIAL DUTIES:
The position's essential duties include the following:
· Serve 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
· Manage reporting environment including report data sources, security, subscriptions and metadata
· Assist in initiative towards data normalization and data integrity across the enterprise
· Assist Data Warehouse Engineer in identifying and revising enterprise reporting requirements
· Evaluate, test and implement new or upgraded software
· Troubleshoot reported problems pertaining to reports and the reporting database environment, working closely with other IT members, especially DBAs, Systems Analysts and Systems Engineers, identifying the cause and designing or developing an approach for resolution
· Assess impact of changes and updates to source production systems, planning and implementing resulting changes to reports
· Conduct end user training on reporting system
Below is additional information I have received from the hiring manager:
1. Please identify the key requirements (must-haves) for this candidate.
a. ETL
b. Pentaho PDI
2. 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 client's ongoing Enterprise Data Strategy program. Specific client OLTP (Oracle) databases will be used and ETL jobs will be developed. The project involves the technical documentation of the ETL jobs developed also.
3. Provide any pre-screen questions for the vendors to use in sourcing candidates.
a. Years of experience with ETL - 4
b. Tools – Pentaho, PDI, MS-SSIS, Erwin
If you find it interesting do send the following details:
| Checkpoint | |
| Full Name of the Candidate | |
| Contact number |
|
| Email ID |
|
| Salary/Rate |
|
| Last 5 digits of SSN |
|
| Current Location |
|
| Openness to relocate OR Travel |
|
| Total years of experience | |
| Relevant experience |
|
| Reason for Change |
|
| Availability/Notice Period |
|
| Highest Educational qualification with Year of Passing and Institute | |
| Certifications if any |
|
| Immigration Status - If H1B- name of the employer and H1B Validity | |
| Best Time to reach for a pre-screen/Interview | |
Thanks & Regards,
Girish Chavan
Ampcus Inc |Talent Acquisition
14900 Conference Center Dr Suite 230
Suite 230 Chantilly VA 20151
610-621-1220 (Direct)
703-956-6996 (Fax)
SBA 8(a) Certified; ISO 9001:2008; ISO 27001:2005; ISO 20000:2005; SEI CMMi Level 3 Company
---
You received this message because you are subscribed to the Google Groups "Best IT Consulting Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to best-it-consulting-group+unsubscribe@googlegroups.com.
To post to this group, send email to best-it-consulting-group@googlegroups.com.
Visit this group at http://groups.google.com/group/best-it-consulting-group.
For more options, visit https://groups.google.com/d/optout.
No comments:
Post a Comment