Hi All, Oracle DBA/ Data Modeler
Company Overview: wireless carrier Location: Bellevue (Factoria), WA Type: 6 month contract- possible extensions Pay Rate: $55-$60/ per hour on corp to corp The candidates must have experience working with teradata, Oracle, Oracle Partitioning. Selling Points: 6 mos+ contract that could be extended Interview Process: 1st phone screen then face to face panel interview As a Data Architect/Modeler you'll work as a part of the Information Management (IM) organization, specifically the Architecture and Modeling team. This position should have expert level understanding of both ER and Dimensional modeling components. Familiarity with ETL for data warehousing and knowledge of data models to support ETL such as job control, data quality efforts and load auditing is also required. This role is for a data expert and understand data relationships and how those are practically applied to information reporting, OLAP, operational and general analytical reporting. The data modeler is on a team lead by the data modeling lead. This team will work in parallel to complete data models for T-Mobile's Enterprise Data Warehouse Environment, including an integration layer (Oracle) model and data warehouse (Teradata) model. They will work from business data models gathered from business user sessions (data modeling workshops), and from the data requirements document provided by the Business Analyst team. These business data modeling sessions will be lead by data modelers with an interest in this and/or the Lead Data Architect/Modeler. The specific data modeling expertise needed is with a data modeling tool -- ERwin preferred. Teradata and Oracle database (skills on UNIX) are also helpful in order to perform DB functions such as DDLs and custom DML's as needed. Familiarity with Informatica is helpful. Understanding reporting performance turning concepts and how they relate to building data models and Teradata/Oracle database tuning assistance will be helpful. Experience modeling complex hierarchies, models for performance and experience with logical and physical modeling techniques with Teradata is a plus. Greenplum experience also a plus. The Architecture team is a leadership group within the Information Management team and is responsible for regular communications with the Enterprise Architecture team, IT groups, across IM and into development and support groups. The IM architecture strategies must line-up with overall IT architecture and strategies for the strategic vision for data warehousing at T-Mobile - working with and aligning to other business IT groups. Another responsibility is to work with the Solution Architect to help assess business requests and align to business data requirements to ensure the most efficient and effective architectural solutions are designed and implemented. As a senior data warehouse resource and subject matter expert, this team member need to work closely with the requirements teams, business groups, and other ETL and data modeling team members. This person will be a key leader in the area of data warehouse design Implement the overall data architecture strategy, development standards and templates, and enforce the go-forward strategy of no database development on existing IR databases. General Responsibilities q Work with the front-end reporting/requirements gathering team to produce adequate requirements documentation including Use Cases, DDS and conceptual/business data model. q Build on existing data model for integration layer- landing flat tables - non-relational q Build on existing data model - normalized area for storage of data and retaining data integrity and deltas. q Build on existing data model for denormalized and aggregated layer as-needed for high-performance reporting. q Model all data subjects assigned. Ongoing data modeling and other roles picked-up as time permits. q Work with T-Mobile DBA group and communicate needs, environment migrations for DDL, schema/database, backups, and other data requirements q Work in an ambiguous, large and complex organization on tight-timelines with DBA team to ensure set-up of environment q Work with all IM teams with MTP's and migrations q Work with Testing team for set-up of testing environment q Manage all models through ERwin q Provide complete Data Modeling design documentation q Create templates and best practices for data modeling as needed q Create Conceptual/Business, Logical and Physical model and manage implementation Requirements for this position include: * Extensive experience with end-to-end data warehouse implementations. * DW industry expert with knowledge of, and interest in leading edge, best practice data warehousing/BI components * Knowledge of governance and current best practices for large scale enterprise data warehouses to ensure modeling meets these standards. * Expertise in both federated or hybrid-federated, normalized and de-normalized data warehouse designs * Familiarity with all data warehousing components (Sourcing, ETL, Data Modeling, Infrastructure, profiling and Reporting) * Familiarity with reporting tool concepts such as Business Objects and/or Business Objects, MicroStrategy * Expert database knowledge and SQL skills required - Oracle, Teradata, or DW Appliances * Teradata expertise at the database level desired * Deep knowledge of data modeling techniques for 3NF, dimensional models and hyper-normalized models (or generic data modeling components a plus), or dimensional-normal form * Able to communicate and persuasive with technical information to a wide audience -- inside the team of experienced architects all the way to executives Regards David Recruiting Manager Vyshnavi Infotech Inc 201 Elden Street, Suite # 201 Herndon, VA 20170 703-880-5122 703-563-9200 Fax [email protected] www.vyshnaviinfotech.com <http://www.vyshnaviinfotech.com/> Yahoo Messenger: [email protected] <mailto:[email protected]> Certified Minority Owned Business Enterprise To be removed from our mailing list please reply with "REMOVE" in the subject line of your e mail. We apologize for the inconvenience if any caused.
