Create and analyze business requirements to compose functional and implementable technical data solutions. Identify integration impact, data flows and data stewardship.

Create new data constraints, leverage existing constraints for reuse.

Create a data dictionary, Data mapping for ETL and application support, DFD, ERD, mapping documents, metadata, DDL and DML as required.

Anticipate JAD sessions as primary models in expanding existing DB and developing new ones.

Evaluate and enhance current data models to reflect business requirements. Generate, write and run SQL script to implement the DB changes including table update, addition or update of indexes, creation of views and stored procedures.

Consolidate and update various data models through reverse and forward engineering.

Compare different WFHM DB environments and determine, resolve and document discrepancies. Analyses DB discrepancies and synchronizes the Staging, Development, UAT and Production DB environments with data models.

Review and revise data models for soundness of data structures and adherence to client standards.

Consult with application development business analysts to translate business requirements into data design requirements used for driving innovative data designs that meet business objectives.

Involve in information-gathering meetings and JAD sessions to gather business requirements, deliver business requirements documents and preliminary logical data models.

Performs requirements gathering and design analysis for customer contact history for customer relationship management.

Work as business requirements analysts with subject matter experts to identify and understand requirements.

Supports data warehouse projects with logical and physical data modeling in Oracle environment and assure accurate delivery of DDL to the development teams.

Document the data requirements and system changes into detailed functional specifications.

Perform Extraction, Transformation and Loading (ETL) using Informatica power center.

Bachelor’s degree with 2 plus years of experience required.