Contract: 6+ months Rate: Open
Location: Warren, NJ Please send me your updated resumes to *[email protected]* *Data Modelers *having prior experience with creating logical data models for Long Term / Short Term Debt and Cash & Due products. Data Modeler is responsible for designing and supporting physical data models in support of a global data warehouse and Reporting Database for use by Finance, Enterprise Risk and Compliance across all lines of business. Modeler will be responsible for all deliverables associated with the model, including source to Client mappings and data dictionary. Modeler will also support development, testing, and production of the data warehouse as part of the Data Investigation team.** *Responsibilities:* Participate in the development and maintenance of logical data models. Transform logical models into physical database designs for staging areas, data warehouses, and data marts. Create DDL for required database objects and migration scripts to load data into new structures when needed. Develop mappings of sources to Client databases, including documentation of transformation rules. Maintain reference data such as lists of valid values. Assess the quality of data during development and test phases of the projects, and open trouble tickets when defects are found. Follow up with development teams to insure that issues are resolved expeditiously. Respond promptly to trouble tickets opened by testers and production users who report defects in the data. Pinpoint the root cause and assign the tickets to the appropriate development teams. Develop scripts to correct bad data as required. *Knowledge/Skills Required:* Prior experience with creating logical data models for Long Term / Short Term Debt and Cash & Due is required. Experience using Erwin to create logical and physical data models. Experience building Data Warehouses and back-office systems. Experience working with and supporting ETL and Front-End development teams. Strong Database experience with RDBMS: Netezza and Teradata preferred, but DB2, Oracle, are acceptable. Ability to write complex SQL needed to investigate data issues, repair damaged data, and migrate data to new structures. Familiarity with tuning and performance optimization techniques. Excellent written and oral communication skills, including use of Excel for presentation of data and mappings. Overall from 5+ years of data modeling experience. Ability to work independently under strict deadlines Thanks and have nice day! ___________________________ *Madhulika | Jr. Recruiter* [image: image002] Tech Tammina Solutions, LLC 203 Elden St Suite 404 Herndon VA 20170. Direct: 703-349-1138 | Fax: 703-991-5532 E-Mail: [email protected] <[email protected]> | www.Tammina.com<http://www.tammina.com/> IT Solutions | Staff Augmentation -- You received this message because you are subscribed to the Google Groups "Open Source Erp & Crm" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/open-source-erp-crm. For more options, visit https://groups.google.com/groups/opt_out.
