Vacancy expired!
- 5+ years of experience with Snowflake, Snaplogic, or Informatica.
- Participate and contribute in the full project life cycle, including: gathering requirements; system design; implementation; testing; deployment; and, support of applications.
- Create data mapping and workflows using Informatica PowerCenter to extract, transform and load data into the target environments (batch files, databases).
- Creates Technical design documents and develops test plans for ETL unit testing and integration testing.
- Work and interact with functional and integration teams on architecture and design.
- Tune and optimize ETL batch jobs for performance and throughput.
- Conform to Informatica workflow and mapping standards so that development is done in a consistent manner across all development resources (no hard coding, leverage of mapplet / reuse concept)
- Develop ETL workflows and mappings from ODS to Datawarehouse using Informatica PowerCenter.
- Provide development support and mentor junior developers.
- Assist with troubleshooting ETL batch job issues in production, PreProd, QA and UAT.
- Work and Support Infrastructure and development teams.
- Experience in Informatica PowerCenter Installation, Administration and Configuration is a plus.
- Familiarity with Informatica PowerCenter HTTP Adapter, JMS Adapter, Webservices Hub is good to have.
- Perform the detailed design of ETL to DataMart (informatica)
- Analyze data in the data warehouse, data mart or operational systems
- Perform statistical analysis of business data
- Load the data into the enterprise data warehouse
- Support the lifecycle of physical data models and data maps for data warehouse system
- Perform analysis on the data
- Support the development and design of the internal data integration framework
- Create data mappings from source systems to the target systems, data warehouses and data marts
- Lead the development /integration of the following: data loading for data marts and enterprise data-warehouse
- Obtaining table designs and analyzing data structures in preparation for data exchanges, and completing data testing for data exchanges
- Perform data analysis and data profiling against source systems
- Perform detailed data analysis to understand the source system data
- Drive the design of solutions for the business
- Develop data solutions to help the product and business teams make data driven decisions
- Transform Load) and interface/integration of data into the data warehouse and data marts)
- Participate in data modeling and data design with BI Tech Lead
- Support new and existing data using Informatica
- Develop and maintain data management standards and conventions, data dictionaries, data element naming standards and data dictionary metadata standards
- Lead development on creating data-dictionaries of key tables and libraries within the data-warehouse
- Integrating disparate sources of data.
Vacancy expired!