Modeler – Erwin
Create standard abbreviation document for logical, physical and
dimensional data models Create logical, physical and dimensional data models
and document it
Interact with Business Analysts to get the functional requirements.
Interact with end users and find out the reporting needs.
Conduct interviews, brain storming discussions with project team to
get additional requirements.
Gather accurate data by data analysis and functional analysis
Create SQL code from current data model and create staging databases
for development, testing, and regression testing.
Check to see data models and databases are in sync.
Adding data base objects (like indexes,
partitions in oracle database) for performance. Generating reports.
At least 8
years of development experience involving data modeling.
& Exposure Required:
Experience in defining and documenting enterprise data flows across
transactional, data warehouse and BI systems
Able to collaborate closely with the Solution Architect, Business
Intelligence Architect and Data Architect, to define structure and management
of Data Warehouses.
Support data conversion and integration activities from both a
technology and as a team lead
Investigate source systems for data availability and accuracy
Have an overall view of where data is being used and assess impact of
changes across systems and processes
Hands on with SQL and able to optimize it
Work with business and IT partners on improving data integrity and
Maintain a data dictionary by creating and updating definitions for
database columns and tables
Partner with Business Analysts and internal customers to define
opportunities to improve our data and analytic capabilities
Lead effective data definition and requirements gathering
A Bachelor’s Degree in relevant field of
work or equivalent work experience
Capgemini America, Inc and its U.S. affiliates are EEO/AA employers. Capgemini conducts all
employment-related activities without regard to race, religion, color, national
origin, age, sex, marital status, sexual orientation, gender
identity/expression, disability, citizenship status, genetics, or status as a
Vietnam-era, special disabled and other covered veteran status.
Click the following
link for more information on your rights as an Applicant: