Dear Folks, Wishes for the Day !!! This is Sam from Panzer Solutions LLC We Need consultant for ETL Data Warehouse Engineer Please share suitable profiles to [email protected]
*Job Title : ETL Data Warehouse Engineer Location : King of Prussia, PA Duration : 6 month Rate : Market* The Senior Data warehouse Engineer will plan and execute projects that require close coordination with Business and Information Technology groups. Position supports overall development and service delivery projects reporting to the Manager of ETL Processing. Although the primary focus of this role is ETL design/development/support, the ideal candidate will bring a strong mix of full-lifecycle data-warehouse development skills that includes experience with reporting/BI concepts. The resource will function as part of a broader team that is responsible for not only supporting the ETL solution, but supporting the reporting tools and processes that run on a daily basis. Duties include, but are not limited to: Perform hands-on design, development and testing within the 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 Requirements, design, development, testing, and deployment ----------------------------------------- Thanks and Best Regards, Sam Riley | Sr Technical Recruiter Panzer Solutions LLC 45 Stuart Ave, K Norwalk CT 06850 USA Email: [email protected] Direct: 201-710-8278 -- You received this message because you are subscribed to the Google Groups "oraapps" 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/oraapps?hl=en.
