Role : Oracle Data Management consultant with enterprise architecture and data architecture concepts
Location : West Chester, PA
Duration : Long term
Experience : 10+ Years
Roles and responsibility :
Hands on experience with technical design, coding and delivering enterprise class data management systems in the Oracle environment (must be Oracle PL-SQL expert).
* Design, development and implementation of complex data management and reporting solutions, with integrated UI and workflow components.
* Demonstrated experience with design and construction of data interfaces from transactional legacy systems into a dimensional data model.
* Promote design of re-usable components and services
* Ensure software projects are completed according to project requirements and are properly documented with traceability through project specifications including functional and technical documents.
* Provide Level 2 production support on a rotating basis.
* Provide IT representation with internal customers and USFS IT areas.
* Participate in architecture and design sessions with team members and peers.
* Interact and work directly with customer team members on projects and support issues.
* Build relationships with business customers and peers across the IT organization.
* Facilitate communication upward and across project teams including project status.
* Follow change management and problem management processes.
* Assist in the definition and implementation of architectural improvement measures within the
* Propose and institute software development process improvements.

Mandatory Technical / Functional Skills :
Bachelor’s degree in Computer Science preferred
10+ years’ experience in the area of data management, modeling, data analysis, and/or reporting
Strong technical documentation and technical writing skills
Prior experience with financial services, retirement, insurance, or medical records industry highly desirable
Expertise with Star, Snowflake, and 3NF data modeling techniques as well as data warehousing & data mart principles and methodologies
Hands on expertise with data modeling tools such as ERwin or Embarcadero ER Studio
Hands on experience working with relational databases such as Oracle, SQL Server, DB2, Sybase
Hands on experience working with ETL tools such as Informatica or SSIS
Familiarity with master data management tools and concepts
Familiarity with industry standard models like ACORD or IIA
Hands on experience with designing and modeling ODS/Warehouses
Expertise on dimensional modeling and slowing changing dimensions
Familiarity with BI tools like Business Objects, OBIEE, etc.
Knowledge of Big Data technologies a plus
Ability to collaborate in a multi-site matrixed work environment
Proficient with enterprise architecture and data architecture concepts
Eagerness to learn new tools and technologies
Experience working in an agile or continuous improvement environment
Eagerness to learn new tools and technologies

Kindly send us the following Mandatory details along with the updated resume for immediate Consideration:

Phone No:

Please send to