Hi Partners, Greetings!!!
We have very urgent requirement for BI/Data warehouse with our client in MI Please send matched resumes to *[email protected]. <[email protected]>* *Position : *BI/Datawarehouse Consultant *Location* : Dearborn, MI *Duration* : Long-term *Information Management Consultant* - (160000W9) *Description* The Auto Club Group (ACG) provides membership, travel, insurance and financial services offerings to approximately 9 million members and customers across 11 states and 2 U.S. territories through the AAA, Meemic and Fremont brands. ACG belongs to the national AAA federation and is the second largest AAA club in North America. Primary Duties and Responsibilities (details of the basic job functions): Designs logical data models and leads and serves on small to large, complex projects that require increased skill in multiple technical environments. Serves as a lead/project team member on various projects and may coach one or more technical staff members. Analyzes and develops complex logical database designs, logical data models and relational data definitions to support corporate and customer information system requirements. Designs, develops and validates data integration and provides oversight to the development and improvement of the technology framework. Identifies and resolves data/information integrated related issues in a production environment and translates requirements into applications that employ appropriate decision support and reporting tools. Responsible for database administrative functions including loading data from external sources, reviewing queries for performance issues, identifying opportunities to reduce data redundancy and reviewing and validating data input for accuracy. *Preferred Qualifications:* Knowledge of: · Emerging and relevant regulatory issues (e.g., consumer privacy laws, and specific industry guidelines such as HIPPA, PCI) to develop checks and controls of information assets. Experience in: · Designing, developing, testing and implementing a BI reporting and dashboard solutions. · Installation / Configure / Customize OBIA (11g and lower) & OBIEE Infrastructure with recommended Web Servers and Hardware. · Data modeling (Kimball /Dimensional Modeling) in OBIEE demonstrating expertise in Oracle BI Server, Oracle BI Answers, Oracle BI Interactive Dashboard, and Oracle BI Publisher, BI Delivers, DAC server. · Different configuration options that exist for failover, load balancing, caching, security, etc. with respect to OBIEE. · Customizing the Functional Setups of OBIA & ETL Mappings (Pre-Packaged Analytics) for modules like Service Analytics, Financial, SCM, and HRMS respectively. · Expertise in industry leading ETL/Data Integration tools like Informatica (9.x, 8.x,); Oracle Data Integrator; Oracle Warehouse Builder. · Integrating OBIEE with OLTP web applications. · Strong communication skills with the ability to liaise with all levels of the business. · Performance monitoring, tuning of OBIEE infrastructure and BI reporting. · BI tools (e.g. WebFocus, OBIEE, COGNOS, Business Objects). · Data Integration (ETL) tools (e.g. Informatica, CRM / MRM) and Data Quality tools. Strong understanding of relational database design concepts and Structured Query Languages. *Work Environment:* Works in a temperature controlled office environment. *Qualifications* Required Qualifications (these are the minimum requirements to qualify): Bachelor’s Degree in Computer Science, Information Systems or related field preferred/extensive experience in technology field. Typically has 3 to 5 years of IT work experience in information management tools and systems including data warehousing and business intelligence. Experience in/with: · Analyzing and developing complex logical database designs, logical data models and relational data definitions in support of corporate and customer information systems requirements · Design, development and validation of data integration (ETL) including Informatica PowerCenter or equivalent tools · Overseeing the development and improvement (including the design, development, testing and implementation) of the technology framework that supports the data integration strategy · Translates requirements into applications that employ appropriate decision support and reporting tools · Performing data base administration functions including loading data into database from external sources · Supports users in constructing queries and generating output files · On-going design and performance enhancements, including: reviewing queries for performance issues, estimating, monitoring and tuning · Developing methodologies and technologies that reflect the flow of data within and between technology systems and business functions/operations · Identifies opportunities to reduce data redundancy/trends in data uses and single sources of data · Modeling (Conceptual, Logical and Physical in both 3NF and Kimball forms) of data sources and flows · Assisting in defining operational frameworks, developing and implementing information management policies and security frameworks · Reviewing and validating the accuracy of the data loaded into the data warehouse Technical Skills *Significant experience in:* · Mainframe, distributed and/or Web based system design and development · Database management systems (IMS, DB2, Oracle, SQL), relational database concepts and complex mart or warehouse design and modeling (Relational and Dimensional) · Data integration (ETL) using Informatica, Data Modeling (3NF and Kimball) and Data Quality tools · Project management tools and techniques · Prototyping and database design and administration · Structure query languages (i.e. SQL, PL/SQL) · Multi-platform capabilities · HTML and Web developments tools Strong written and verbal communication skills to include procedures and technical material, report/proposal preparation and oral presentation. (A writing and/or presentation sample may be required at time of interview). John Digital Minds Technologies Inc 1111 Plaza Drive, Suite 470, Schaumburg, IL - 60173 Desk: 1 847 585 3438 <1%20847%20585%203438> Fax: 1 847 995 0373 [email protected] www.digitalmindstech.com <http://www.digitalmindtech.com/> -- You received this message because you are subscribed to the Google Groups "SAP BASIS" 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 https://groups.google.com/group/sap-basis. For more options, visit https://groups.google.com/d/optout.
