Sr. Datawarehouse Engineer- Full Time
Our Client in the King of Prussia area is looking for a Sr. Datawarehouse Engineer to join them on a permanent basis. All candidates must be interested and able to join our client as a W2 Perm. employee. Please review the description below.
**INTERESTED CANDIDATES PLEASE FORWARD A WORD VERSION OF YOUR RESUME TO: erwoods@teksystems.com. ONLY QUALIFIED CANDIDATES WILL BE CONTACTED**
Senior Data Warehouse Engineer
Job Description
The Senior Data warehouse Engineer will plan and execute projects that require close coordination with Business and Information Technology groups. Position supports overall development and service delivery projects reporting to the Sr. Manager of Business Intelligence Systems department.
Duties include, but are not limited to:
- Educate client management and business users on business value and capabilities of data warehousing
- Provide advice and guidance on data warehousing approaches and solutions, and use of data warehousing methodology
- Assist in identifying and prioritizing business information needs, and defining business benefit of data warehousing
- Assist in evaluating and selecting data warehousing tools for business intelligence, data population, data management, metadata management, and warehouse administration
- Responsible for supporting the architecture and design of the data warehouse, data marts and BI reports which will support various data initiatives
- Identify data warehousing issues and assist in their resolution
- Review project work products, including project work plans, business activity and information models, test plans, content storage design, and application component design
- Performs table and interface design, development of logical and physical data model/database, ETL processes, BI reporting/OLAP cubes/OLAP reporting, and population and tuning of databases/ETL processes/BI reports/queries while meeting business/user requirements
- Facilitates requirements definition and contributes to documentation of project and system documentation
- Code, test, implement, monitor ETL processes in our data warehouse environment
- Provide infrastructure support for the BI/ETL environment
- Research and analyze various data source systems, applications and perform data research/analysis
- Provide project, system and other technical documentation as required
- Provide on-call, off-hour support of BIS systems
Required skills include, but are not limited to:
- Bachelor's degree in Computer Science, Information Technology or related field
- 6-9+ years of IT development experience in developing full lifecycle implementations, support, and upgrades.
- 6+ years of Data Warehouse experience.
- 3+ years of experience with ETL tool, preferably Sagent, DataStage or Informatica
- 6+ years of relational database experience (SQL, tuning, optimizer, relational concepts)
Strong Oracle and PL/SQL skills and relational database experience
- Strong MS Windows OS knowledge
- 2+ years UNIX experience
- Excellent written and verbal communicate skills with both technical and non-technical staff
- Ability to form durable, flexible work relationships
- Minimum of 5 years experience in the development and maintenance of data warehouse/data mart and BI reporting applications
Required Skills for Sr. Datawarehouse Engineer- Full Time Job:
- INFORMATICA
- DATASTAGE
- UNIX
Join TEKsystems® and get your career on the fast track. As the leading technology staffing and services firm, we are passionate about deploying high-caliber IT and communications expertise. To satisfy our constant need for expertise, we actively seek talented Technical Professionals with all levels of information technology and communications skills. TEKsystems knows that every professional has different needs, so we'll work together to determine a suitable benefits package. We offer options to our Technical Professionals that could include: a health plan, 401k, provisions for vacation and holiday pay, and technical and professional training. With a foundation as the nation's largest IT staffing firm, we've become a billion-dollar services company by blending superior client service with an unrivaled ability to source and manage talent to precise specifications, resulting in successful technology executions. Allegis Group and its subsidiaries are equal opportunity employers. M/F/D/V
Contact Information
|