Job description

The ETL Informatica Systems Engineer will support of our EDW/BI program. This individual will act as the Sr. ETL Engineer for the TWC EDW/BI project and will be responsible for developing ETL applications using Informatica. Successful candidates will have demonstrated proficiency using the Informatica Suite of tools including Standard Edition Power Center, Team Based Development, Parallel Processing, and more. The role will focus on developing Extract, Transformation and Loading (ETL) procedures for implementing data integration and data loading tasks in support of the EDW/BI project. ·BS in computer science, or its equivalent ·7 years of relevant experience with demonstrated proficiency and progressive responsibilities to include the following experiences: ·Informatica PowerCenter ·Linux ·Solid MS SQL Server database skills including the ability to write complex SQL and stored procedures ·Fact and Dimensional data, including slowly changing dimensions ·Demonstrated proficiency with SOAP/XML and REST/JSON API use, including the use of oAuth and oAuth2. ·Demonstrated ability to establish priorities, organize and plan work to satisfy established timeframes. ·Proven ability to handle multiple tasks and projects simultaneously. ·Demonstrated experience in performance tuning for Informatica ETL processing ·Excellent analytical skills, attention to detail and problem-solving skills. ·Demonstrated proficiency converting shell and Perl programming to Informatica Objects ·Strong interpersonal and leadership skills and demonstrated ability to work comfortably with all levels within an organization and across business function ·Demonstrated proficiency with any of the following will be considered a plus. ·Contract Management Systems (Operative.one), ·Ad Delivery Systems (Google Double Click for Publishers Premium), ·Omniture, ·Nielson Ratings data, ·Peoplesoft Financials, ·Salesforce ·Yieldex ·Java and Perl programming Must apply to : career8.successfactors.com Requisition Number: 1475

Requirements

Must-haves

BS in computer science, or its equivalent
7 years of relevant experience with demonstrated proficiency and progressive responsibilities to include the following experiences:
Informatica PowerCenter
Solid MS SQL Server database skills including the ability to write complex SQL and stored procedures
Fact and Dimensional data, including slowly changing dimensions
Demonstrated proficiency with SOAP/XML and REST/JSON API use, including the use of oAuth and oAuth2.
Demonstrated ability to establish priorities, organize and plan work to satisfy established timeframes.
Proven ability to handle multiple tasks and projects simultaneously.
Demonstrated experience in performance tuning for Informatica ETL processing
Excellent analytical skills, attention to detail and problem-solving skills.
Demonstrated proficiency converting shell and Perl programming to Informatica Objects
Strong interpersonal and leadership skills and demonstrated ability to work comfortably with all levels within an organization and across business function
Contract Management Systems (Operative.one),
Ad Delivery Systems (Google Double Click for Publishers Premium),
Nielson Ratings data,
Peoplesoft Financials,
Java and Perl programming
Requisition Number: 1475

Nice-to-haves

Demonstrated proficiency with any of the following will be considered a plus.

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

sqlrestapijava

Platform: smartrecruiters
Effort: medium