ETL Informatica Developer
Buffalo NY
Long term
Responsibilities Include:
- Apply advanced DW techniques and Informatica best practices to load a Financial, HR & Supply Management Data Warehouse, Data Marts and Downstream Systems.
- Be proficient in working with multiple Informatica repositories, version control, deployment groups, mapping and folder migrations
- Develop new Informatica programs and debug existing programs and tables within the data warehouse, applying an advanced understanding of relational database design concepts and of writing SQL queries, knowledge of UNIX, and experience using a job scheduler.
- Ensure that all Enterprise procedures such as unit and system testing, change management, documentation, promote to production, etc. are followed.
- Work with Data Architects to understand requirements prior to design of ETL solutions.
- Collaborate with the DBA team to ensure optimized performance of all Informatica mappings.
- Work with the Reporting/Analysis teams when dealing with testing and modifications to Data Marts.
- Works closely with the Scheduling team to develop and test AutoSys jils prior to production implementations.
Requirements Include:
- Minimum 5-7 years’ experience in data warehousing concepts and tools.
Post a Comment