Job Description :
Title: Data Modeler - PL/SQL Developer
Location: Irving, TX

Requisition Details:
Build and Manage Data Modeling and Services (including Data Architecture, Logical and Physical Data Model, Data Investigation)
Provide Data Services for Financial Transactions impacting Finance, Risk, Regulatory Reporting etc
Work with application development teams to design new Citi application data structures and modify existing structures
Data analysis and develop models using Oracle, and document and maintain models in Erwin Data Modeler
Review data models and data structures developed by data modeling and application development teams
Ensure that SQL meets Citi’s standards and best practices, and evaluate performance impacts
Review data warehouse extract/load mapping documents. Review DWH ETL mapping documents and develop deployment data definition language (DDL) scripts
Involved with analytical and operational data store modeling, physical data model deployments, and script development
Identify and fix SQL performance issues, and support development teams including access/privilege requests, Tablespace assignments, and space capacity analysis.

Detailed Skills
Experience with development and maintenance using Oracle/Pl sql technologies, Teradata, Netezza,
Experience with Erwin for Conceptual/logical/Physical data model
Experience with performance tuning of SQL queries
Provide global guidance to off-shore development teams
Ability to support UAT and/or client test teams. -Banking or financial / Strong financial product domain knowledge is must
             

Similar Jobs you may be interested in ..