SENIOR BI/DW EPN-ETL Developer needed/ Columbus , Ohio

Position: SENIOR BI/DW EPN-ETL Developer
Location: Columbus ,OHIO
Duration: 6+ months

C2C candidates may also be eligible to apply.

Our client is looking for a  SENIOR BI/DW EPN-ETL Developer.

A minimum of two (2) recent years of experience in ETL development (with
Ascential Datastage 7.5.2 or higher) and system analysis. Multi-module
experience preferred (e.g. EPM, HCM, FIN) and experience in PeopleSoft (EPM:
8.9/9.0, PeopleTools: 8.46 / 8.50) preferred. A minimum of two (2) years
working with Oracle (Version: 10g preferred) as a database engine. Three (3)
years experience with enterprise data warehouse architecture and/or design.
Two (2) years of Dimensional Data Modeling, and Data Profiling experience
for data warehouse development. EPM MDW experience preferred. Experience
integrating disparate systems of record into conformed dimensions and fact
tables. Excellent documentation and communication skills. UNIX (HP-UX
preferred) experience. Strong performance tuning skills with ETLs on
Ascential Datastage 7.5.2.

Role Responsibilities:
- Provides expert technical systems advice & guidance to information
technology professionals (e.g., FIN functional & tech teams, HCM functional
& tech teams, data security team, technical architecture team, PS
admin/database admin) regarding all facets of PeopleSoft FIN (Fin 8.8) and
PeopleSoft HCM (HCM 8.9) operations in support of the Business Intelligence
system (PeopleSoft EPM 8.9/9.0 and Ascential Datastage 7.5.2).
- Participates in multi-organizational, multi-disciplinary teams to
determine, articulate, & codify business requirements; models/designs and is
responsible for Extract, Transformation & Loading (ETL) design and
development, & work with ORACLE database(10g RAC) & networking staff, to
establish & maintain the business intelligence application-infrastructure
(EPM 8.9 and 9.0).
- Is responsible for enhancing PeopleSofts Delivered BI Suite (EPM 8.9 / 9.0
with Ascential Datastage ETL server 7.5.2).
-- Move to a business content focused, iterative BI development (monthly
releases).
-- Provide an agency driven, best practice based framework for intelligent
reporting, trend analysis and pro-active decision making.
-- Provide a standardized method for BI reporting.
-- Make reporting accessible and simple for the business users in all State
agencies.
- Design and development of ETLs in data warehouse (with Ascential Datastage
7.5.2 and PeopleSoft EPM 8.9 & 9.0 data warehouse with PT 8.46 & 8.50)
environment.
- Analyzes & designs components of the system (e.g., OAKS EPM running on
PeopleSoft application): conducts facilitated discussions with customers to
review current & gather additional business requirements; analyzes & writes
business requirements, scope documents, program specifications & system
documentation.
- Performs systems analysis, systems architecture & design and assistance to
data warehouse& report developers; maintains system design standards &
procedures; analyzes system problems & creates-resolves Customer Relations
Management (CRM) Help Desk cases.
- Analyzes, prioritizes, & resolves assigned CRM cases to appropriate party
for action; contacts customers to gather information about system issues;
coordinates issue resolution with technical & functional team members; tests
solutions & performs quality control; contacts users to gather information
on required accounts & their appropriate environment, roles, & tasks.
- Creates technical requests to create or modify user accounts; designs and
document test procedures & tests system for validity & reliability; tests
accounts for correct access; follows security procedures for new development
to ensure data security & correct user access.
- Designs test procedures & tests system for validity & reliability; ensures
logical & systematic conversion of customer requirements into total systems
solutions that acknowledge scope, schedule & cost constraints; provides data
analysis, data architecture & design assistance to functional/systems
analysts, application developers & users.
- Creates and maintains logical & physical data models & data dictionaries;
writes system requirements, general & detailed design documents;
participates in management short & long-term planning & assists in
agency-wide policy & program development as impacts automated systems.
- Creates & maintains Enterprise Data Warehouse architecture and guidelines.


Performs other related duties as assigned: stays abreast of available
reporting best practice methodologies and tools that may enhance the
capabilities of the Enterprise Data Warehouse/Business Intelligence. Ensure
that the Business Intelligence program goal with respect to Data Quality is
met: Provides consistent, reliable and integrated data for use in analytics.
Own, create, maintain and execute SAS-70 audit process on a daily basis.