ETL Informatica Developer

Buffalo, NY 14225

Posted: 08/29/2019 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.

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.

Send an email reminder to:

Share This Job:

Related Jobs:

Login to save this search and get notified of similar positions.