*Visa & Photo ID Must* USG direct client is looking for *Data Modeler _** Minneapolis, MN*
*Job Description:* The Worker shall work on the OLTP/OLAP systems, work with ETL (extract/transform/load), BI (business intelligence), and DBA (data base administrator) teams to develop models and reporting structures to support current and projected reporting and data requirements. The Worker will work collaboratively with the architect team to create, manage, and modify logical and physical data models using a variety of data modeling philosophies and techniques including Bill Inmon and/or Ralph Kimball. The Worker will work closely with database administrator(s) to establish and maintain highly resilient, scalable and high performance architecture when the data model is implemented physically on the target databases. The Worker will identify and analyze data discrepancies and data quality issues and work to ensure data consistency and integrity. The Worker will take an organization-wide view of the business and its data, (e.g. maintain re-usable or enterprise data models) while providing detailed project-specific modeling and analysis support. Perform performance monitoring and query tuning as needed. Thoroughly document developed solutions and communicate knowledge to team to ensure continuity and maintainability. *WORKER SKILLS AND QUALIFICATIONS: -* *Minimum Requirements:* · 8+ years of experience with data modeling (conceptual, logical and physical data model design) and metadata management. Experience designing tables and views for efficiency, flexibility, maintainability and performance. · 8+ years of experience with Erwin, Sybase Power Designer or comparable data modeling tools. · 8+ years of experience working with relational databases (RDBMS) such as Oracle, SQL Server etc. · Experience in Source to Target mappings, Data transformations and Validations · 5+ yrs. of Experience architecting large scale data systems with increasing scope and responsibility. · 3+ yrs. Experience with reporting/analysis tools such as IBM Cognos, Business Objects, Micro strategy, Tableau, etc. · 3+ yrs. Experience in ETL tools such as IBM Data Stage, Informatics etc. · 3+ yrs. Professional working experience modeling data requirements based on complex business needs across multiple information domains. · 3 Experience in skilled writing and maintaining complex SQL and PL/SQL scripts. · Strong Verbal and written communication skills. · Strong Analytical and problem solving skills with ability to clearly articulate solution alternatives. · Strong Attention to detail, seasoned judgement and experience to anticipate business needs. · Strong Ability to embrace change, adapt to the unexpected, and focus energies, people, and solutions on practical and positive results. · Degree Equivalent combination of relevant education and experience may be substituted as appropriate. *Preferences:* · 5+ yrs. of experience architecting large scale data systems with increasing scope and responsibility and working with enterprise data warehouse projects. · 5+ yrs. of experience with data modeling in an Oracle environment. · 5+ yrs. of experience with resolving data anomalies and conducting data integration analysis. · 5+ yrs. of experience working with financial and card payment data · 3+ yrs. of experience with data profiling techniques and tools. Please share your updated resume at *shivan...@usgrpinc.com* <shivan...@usgrpinc.com> or feel free to contact me* at 614-401-5196* -- You received this message because you are subscribed to the Google Groups "Oracle-HRMS-India" group. To unsubscribe from this group and stop receiving emails from it, send an email to oracle-hrms-india+unsubscr...@googlegroups.com. To post to this group, send email to oracle-hrms-india@googlegroups.com. Visit this group at https://groups.google.com/group/oracle-hrms-india. For more options, visit https://groups.google.com/d/optout.
