Dear , Hope your doing good, Job Title : Data Warehouse Engineer Location : *King of Prussia, PA* Duration : 6+ Months Contract.
REQUIRED EXPERIENCE: ETL tool environment using a mixture of GUI driven tools and hands-on SQL · Provide ETL design, development and testing estimations based business requirements and research into data that is currently sourced. · Interface with the BI Team to support the design of reports and dashboards meeting business requirements downstream. · As part of a rotating team schedule, provide on-call, off-hour support for ETL and Data Warehouse systems that are under strict SLAs for 24/7 availability · Educate client management and business users on business value and capabilities of data warehousing · Provide advice and guidance on data warehousing approaches and solutions, and use of data warehousing methodology · Assist in identifying and prioritizing business information needs, and defining business benefit of data warehousing · Assist in evaluating and selecting data warehousing tools for business intelligence, data population, data management, metadata management, and warehouse administration · Responsible for supporting the architecture and design of the data warehouse, data marts and BI reports which will support various data initiatives · Identify data warehousing issues and assist in their resolution · Review project work products, including project work plans, business activity and information models, test plans, content storage design, and application component design · Performs table and interface design, development of logical and physical data model/database, ETL processes, BI reporting/OLAP cubes/OLAP reporting, and population and tuning of databases/ETL processes/BI reports/queries while meeting business/user requirements · Facilitates requirements definition and contributes to documentation of project and system documentation · Provide infrastructure support for the BI/ETL environment · Research and analyze various data source systems, applications and perform data research/analysis · Provide project, system and other technical documentation as required · Bachelor's degree in Computer Science, Information Technology or related field · Strong SQL Skills · Knowledge of ETL tool inner workings, appropriate design techniques to support restartability, and high volume data load techniques · Knowledge of a BI/reporting tool functions and report execution/performance concepts · Ability to work on multiple small projects simultaneously, multi-tasking and balancing work based on priority · 6-9+ years of IT development experience in developing full lifecycle implementations, support, and upgrades. · 6+ years of Data Warehouse experience. · 3+ years of experience with ETL tool, preferably *DataStage* 6+ years of relational database experience (SQL, tuning, optimizer, relational concepts) · Oracle specific and PL/SQL skills is preferred · Strong MS Windows OS knowledge · 2+ years UNIX experience · Excellent written and verbal communicate skills with both technical and non-technical staff · Ability to form durable, flexible work relationships · The candidates will be working on portfolio and production support tasks (PS Tickets) as required. · Portfolio work will include the full SDLC o Requirements, design, development, testing, and deployment Thanks, Prakash D: 713-370-5242 ID: [email protected] -- You received this message because you are subscribed to the Google Groups "Open Source J2EE frameworks" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/open-source-j2ee-frameworks?hl=en.
