Sr. Data Systems Engineer - Informatica ETL
Core
Developing ETL applications and procedures using Informatica to support the Enterprise Data Warehouse (EDW) and Business Intelligence (BI) program.
Role type
Senior Informatica ETL Engineer
Builds
Data integration pipelines and data loading tasks for the EDW/BI project
Domain
Media & Entertainment / Data Engineering
Required skills
Informatica PowerCenter, Linux, MS SQL Server (complex SQL/stored procedures), Fact and Dimensional data modeling, SOAP/XML and REST/JSON API integration, Informatica ETL performance tuning, Shell and Perl programming
Preferred skills
Contract Management Systems, Ad Delivery Systems, Omniture, Nielsen Ratings data, Peoplesoft Financials, Salesforce, Yieldex, Java programming
Technologies
Informatica Suite, PowerCenter, Linux, MS SQL Server, SOAP, XML, REST, JSON, oAuth, oAuth2, Shell, Perl
Responsibilities
Develop ETL applications using Informatica tools; Implement data integration and loading tasks; Perform performance tuning for ETL processing; Convert shell and Perl scripts to Informatica Objects
Seniority
Senior, hands-on IC