* Pentaho Developer Needed in DC for Contract!!* *Kindly reply to **[email protected]* <[email protected]>
Location: DC Length: 3-6months (Will be extended) TOP 2 SKILLS REQUIRED: **ETL **Pentaho PDI **.Provide a brief description of the project in which they will be working on. **Project is for the development of datamarts using Pentaho Data Integration (PDI) for data analytics for ongoing Enterprise Data Strategy program. Specific OLTP (Oracle) databases will be used and ETL jobs will be developed. The project involves the technical documentation of the ETL jobs developed also. **Provide any pre-screen questions for the vendors to use in sourcing candidates. **Years of experience with ETL - 4 **Tools – Pentaho, PDI, MS-SSIS, Erwin *The position’s essential duties include the following:* **Works together with IT management in defining enterprise data architecture strategy **Teams up with the Programs and Architecture on implementing the data architecture consistently across vendor-hosted and -operated data centers **Leads in designing and revising data model for data warehouse, and meta data and data dictionaries across the enterprise **Meets and collaborates with business users on requirements and objectives **Leads in reviewing and revising database designs and scripts on an ongoing basis ** Leads in documenting meta-data about Data Warehouse System according to computer industry standards and knowledge of database management systems. **Manages data loads, and security, storage and performance strategies and implementations. **Serves as technical team lead in the development of business intelligence reports and analysis, providing mentoring, guidance and troubleshooting to analysis team members in solving complex reporting and analytical problems **Conducts complex analyses of strategic issues based on analysis of trends and interrelationships of key performance drivers documented in the data warehouse, especially the identification of test and control groups and comparison and evaluation of their relative performance; synthesizes research results and develops actionable strategic recommendations; communicates research results and strategic recommendations to nationwide and division strategy managers. **Devises ER diagrams and identifies unique foreign keys, entities, attributes, relationships and business rules for data warehouse Type of Experience *Knowledge of RelationalDatabases *ETL *Knowledge of Data Mart Modeling Schemas *SQL Server management Studio *SQL Server Analysis Services, Reporting Services and Integration Services *Requirements Gathering *SQL Programming *Microsoft Office *ERWin Regards, *Sara Wilson* - Staffing Manager Direct : 646-340-0603 [email protected] -- 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.
