Hi
If you are Interested and available for the Job, Please revert back with latest resume, expected pay rate, availability and other details required for submission to nik...@vastika.com. *TITLE: Data Warehouse Engineer - Pentaho Data Integration (PDI)* *LOCATION: Washington DC* *TERM: 12+ months* *MOI: Telephonic+ Skype* *Need USC or GC only* *Key requirements: * *DATA MODELING* *DATA WAREHOUSE DESIGN* *PENTAHO* * ETL Pentaho Data Integration (PDI)—MUST HAVE MS-SSIS Erwin * *Type of Experience Needed: Pentaho Data Integration (PDI) 8 years with Relational Databases 4-8 years with ETL 8 years with Data Mart Modeling Schemas 8 years with SQL Server management 8 years with SQL Server Analysis Services, Reporting Services and Integration Services 8 years with Requirements Gathering 8 years with SQL Programming 8 years with Microsoft Office* Project: Project is for the development of data marts using Pentaho Data Integration (PDI) for data analytics for clients ongoing Enterprise Data Strategy program. Specific client OLTP (Oracle) databases will be used and ETL jobs will be developed. The project also involves the technical documentation of the ETL jobs developed. Overall Purpose: Leads projects in designing enterprise data reporting architecture that includes strategic reporting databases, data marts and data warehouses. Creates complex ETL packages to extract data from various data sources and load into data warehouse. Takes ownership of system structure integrity and data integrity. Serves as technical team leader in the development of business intelligence solutions and other reports based on data from various sources. The positions essential duties include the following: Works together with IT management in defining enterprise data architecture strategy Teams up with clients Programs and Architecture on implementing the data architecture consistently across vendor-hosted and client-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 *Nikhil Gupta* *214-628-5329\ nik...@vastika.com <nik...@vastika.com>* *Pls share your Daily c2c req with me on nik...@vastika.com <nik...@vastika.com>* *Add me on your g-talk id:-nikhil.rgtal...@gmail.com <nikhil.rgtal...@gmail.com>* *LinkedIn:-* *https://www.linkedin.com/pub/us-tr-recruiter/91/373/a46 <https://www.linkedin.com/pub/us-tr-recruiter/91/373/a46>* -- You received this message because you are subscribed to the Google Groups "US_IT.Groups" group. To unsubscribe from this group and stop receiving emails from it, send an email to us_itgroups+unsubscr...@googlegroups.com. To post to this group, send email to us_itgroups@googlegroups.com. Visit this group at https://groups.google.com/group/us_itgroups. For more options, visit https://groups.google.com/d/optout.