Lighthouse Technology Services https://www.lhtservices.com/wp-content/uploads/2018/05/logo.png http://www.lhtservices.com http://www.lhtservices.com
ETL Informatica Developer
Buffalo, NY Buffalo, NY 14225
Posted: 08/29/2019 2019-08-29 2019-11-21 Employment Type: Contract - 6 months Industry: IT Job Number: 1373 Pay Rate: Negotiable
Lighthouse Technology Services is seeking an ETL Informatica Developer for a 3-6 month contract role in Buffalo, NY.
- 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.
- Minimum 5-7 years’ experience in data warehousing concepts and tools.