Data Architect at Columbus,OH (Face2Face Interview; GC/USC only)
HI, Greetings from Oberon IT Inc!!! We have a Direct Client Requirement for you and the details are as follows Job Title: Data Architect Location: Columbus, OH Duration: 6+ months Industry: Government ** NOTE: *Face to Face Interview* ; *GC/US Citizens only* ** *Job Description:* Required: • 10 or more years of experience in design, development, modification and testing of databases designed to support Data Warehousing and BI business teams • 10 or more years of experience with design, development and support of normalized data structures (commonly referred to as Inmon) • 7 or more years of experience developing Data Warehouse databases using Oracle RDBMS platform and tools. • 5 or more years of experience with design, development, tuning and support of dimensional/star-schema based data structures including fact tables. *• 5 or more years of experience with Kimball and Inmon methodologies* • 5 or more years of experience with the AllFusion Erwin modeling tool, including Model Mart Repository advanced features (e.g. checkin/out, complete compare) *• 3 or more years of experience in data profiling, data mining and data cleansing.* 3 or more years of experience in the use of organizational tools methods (MS Excel, MS Word, MS outlook, VISIO, Clarity) • Experience developing complex SQL against normalized as well as dimensional data structures • Experience using oracle SQL*Plus, Toad, Oracle PL/SQL Developer • Experience on an IBM/DB2 platform • Experience in measuring and tuning the performance of Oracle Data Warehouse databases Desired: • 3 or more years of experience working with designers/developers who use the Cognos Business Intelligence tools. • Ability to effectively communicate with business and IT staff • Ability to quickly adapt to changes, enhancements, and new technologies • Knowledge of the PowerSuite Claims, Policy, and Billing application Nice To Have: • Knowledge of Ohio BWC business model and processes • Knowledge of property and casualty insurance systems Typical Daily Activities: • Work with PowerSuite SME to understand the PowerSuite application business functionality and write complex queries to understand how the data is stored in the PowerSuite Transactional System. • Work with Cognos Framework Model SME, PowerSuite SME and other Data Architects to identify dimension and facts tables to be built. • After designing dimension and fact tables, hold design review sessions to obtain approval and sign off. • Deploy new tables directly to the test environment using the Erwin tool • Produce diagrams and table/column definitions reports from Erwin and upload to the project Sharepoint site. • Map the data from the Operational Data Store to the dimension/fact tables and create an ETL mapping document, using a predefined template, for the ETL developers. • Work with Business Analysts and potentially business customers to verify requirements Work with IT ETL and Report Developers to communicate database designs, answer questions and refine/update ETL mapping documents as needed. • Analysis and Performance tuning of queries developed to access dimensional and relational models • Work with Business Analysts and potentially business customers to verify requirements *** Please send us the following details along with the updated resume for immediate Consideration * Full Name: Contact number: Email Id: Current Location: Relocation: Visa Status validity: Interview Availability: Earliest Availability: F2F Interview: Total Experience: Rate: Skype ID: Education (Bachelors): Last 4 Digits of SSN: Skills (years experiences with the key skills): Is the Candidate on a project currently? Communication skills (1 out of 10): Provide any 2 Local references of previous projects: 1) Industry/ Client: Name: E-mail: Phone: Designation: 2) Industry: Name: E-mail: Phone: Designation: Regards, Purushotham Oberon IT Inc 1300 W. Walnut Hill Lane, Suite: 263, Irving, TX 75038. Email: purushot...@oberonit.com Tel: 972-330-5903 | Fax: 1-800-218-2820 www.oberonit.com -- You received this message because you are subscribed to the Google Groups OracleD2K group. To unsubscribe from this group and stop receiving emails from it, send an email to oracled2k+unsubscr...@googlegroups.com. To post to this group, send email to oracled2k@googlegroups.com. Visit this group at http://groups.google.com/group/oracled2k. For more options, visit https://groups.google.com/d/optout.
Data Architect at Columbus,OH (Face2Face Interview; GC/USC only)
HI, Greetings from Oberon IT Inc!!! We have a Direct Client Requirement for you and the details are as follows Job Title: Data Architect Location: Columbus, OH Duration: 6+ months Industry: Government ** NOTE: *Face to Face Interview* ; *GC/US Citizens only* ** *Job Description:* Required: • 10 or more years of experience in design, development, modification and testing of databases designed to support Data Warehousing and BI business teams • 10 or more years of experience with design, development and support of normalized data structures (commonly referred to as Inmon) • 7 or more years of experience developing Data Warehouse databases using Oracle RDBMS platform and tools. • 5 or more years of experience with design, development, tuning and support of dimensional/star-schema based data structures including fact tables. • 5 or more years of experience with Kimball and Inmon methodologies • 5 or more years of experience with the AllFusion Erwin modeling tool, including Model Mart Repository advanced features (e.g. checkin/out, complete compare) • 3 or more years of experience in data profiling, data mining and data cleansing.3 or more years of experience in the use of organizational tools methods (MS Excel, MS Word, MS outlook, VISIO, Clarity) • Experience developing complex sql against normalized as well as dimensional data structures • Experience using oracle SQL*Plus, Toad, Oracle PL/SQL Developer • Experience on an IBM/DB2 platform • Experience in measuring and tuning the performance of Oracle Data Warehouse databases Desired: • 3 or more years of experience working with designers/developers who use the Cognos Business Intelligence tools. • Ability to effectively communicate with business and IT staff • Ability to quickly adapt to changes, enhancements, and new technologies • Knowledge of the PowerSuite Claims, Policy, and Billing application Nice To Have: • Knowledge of Ohio BWC business model and processes • Knowledge of property and casualty insurance systems Typical Daily Activities: • Work with PowerSuite SME to understand the PowerSuite application business functionality and write complex queries to understand how the data is stored in the PowerSuite Transactional System. • Work with Cognos Framework Model SME, PowerSuite SME and other Data Architects to identify dimension and facts tables to be built. • After designing dimension and fact tables, hold design review sessions to obtain approval and sign off. • Deploy new tables directly to the test environment using the Erwin tool • Produce diagrams and table/column definitions reports from Erwin and upload to the project Sharepoint site. • Map the data from the Operational Data Store to the dimension/fact tables and create an ETL mapping document, using a predefined template, for the ETL developers. • Work with Business Analysts and potentially business customers to verify requirements Work with IT ETL and Report Developers to communicate database designs, answer questions and refine/update ETL mapping documents as needed. • Analysis and Performance tuning of queries developed to access dimensional and relational models • Work with Business Analysts and potentially business customers to verify requirements *** Please send us the following details along with the updated resume for immediate Consideration * Full Name: Contact number: Email Id: Current Location: Relocation: Visa Status validity: Interview Availability: Earliest Availability: F2F Interview: Total Experience: Rate: Skype ID: Education (Bachelors): Last 4 Digits of SSN: Skills (years experiences with the key skills): Is the Candidate on a project currently? Communication skills (1 out of 10): Provide any 2 Local references of previous projects: 1) Industry/ Client: Name: E-mail: Phone: Designation: 2) Industry: Name: E-mail: Phone: Designation: Regards, Purushotham Oberon IT Inc 1300 W. Walnut Hill Lane, Suite: 263, Irving, TX 75038. Email: purushot...@oberonit.com Tel: 972-330-5903 | Fax: 1-800-218-2820 www.oberonit.com -- You received this message because you are subscribed to the Google Groups OracleD2K group. To unsubscribe from this group and stop receiving emails from it, send an email to oracled2k+unsubscr...@googlegroups.com. To post to this group, send email to oracled2k@googlegroups.com. Visit this group at http://groups.google.com/group/oracled2k. For more options, visit https://groups.google.com/d/optout.
