ETL- DataStage, Informatica, Sagent Expert

Description

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. Responsibilities Although the primary focus of this role is ETL design/development/support, the ideal candidate will bring a strong mix of fulllifecycle datawarehouse 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 handson design, development and testing within the ETL tool environment using a mixture of GUI driven tools and handson SQLProvide 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 oncall, offhour support for ETL and Data Warehouse systems that are under strict SLAs for 24/7 availabilityEducate 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 administrationResponsible for supporting the architecture and design of the data warehouse, data marts and BI reports which will support various data initiativesIdentify data warehousing issues and assist in their resolution