Sr. Data Systems Engineer - Informatica ETL

The Weather Channel; Atlanta (GA); On-site; USD 90,000 - 120,000; Full time

Job summary

The Weather Channel is looking for an ETL Informatica Systems Engineer in Atlanta, Georgia. This position involves developing ETL applications using Informatica and supporting the EDW/BI project.

Successful candidates should have a BS in Computer Science and 7 years of relevant experience. Proficiency in SQL Server, SOAP/XML, and REST/JSON APIs is essential. The role also requires strong analytical abilities and effective multitasking skills. Join a leading media company and contribute to accurate weather forecasting.

Qualifications

• 7 years of relevant experience with progressive responsibilities.
• Demonstrated proficiency in ETL applications and Informatica tools.
• Strong analytical skills and attention to detail.

Responsibilities

• Develop ETL applications using Informatica.
• Support the EDW/BI project.
• Handle multiple tasks and projects simultaneously.

Skills

MS SQL Server Database Skills

SOAP/XML and REST/JSON APIs

Performance Tuning for Informatica ETL

Shell and Perl Programming

Interpersonal Skills

Leadership Skills

Education

BS in Computer Science or Equivalent

Job description

• Full-time

Company Description

The Weather Channel is the world's leading cross-platform media company with a portfolio that includes The Weather Channel television network, TWC digital properties (weather.com, mobile and tablet applications) and Weather Services International (WSI). Headquartered in Cobb County since 1982, The Weather Channel brand has connected millions of consumers by providing the most accurate weather forecasts, 24 hours a day. Seen in more than 100 million U.S. households, The Weather Channel network is one of the most widely-distributed cable networks. The Weather Channel online properties reach 60 million unique Web consumers each month. This includes 32 million consumers monthly throughweather.comon mobile Web and mobile apps. TWC has the No.1 app on all smartphones and is the second most used app on all smartphones. WSI provides business-to-business weather services to media, aviation, marine and energy sectors.

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.

Qualifications

• BS in computer science, or its equivalent
• 7 years of relevant experience with demonstrated proficiency and progressive responsibilities to include the following experiences:
• Solid MS SQL Server database skills including the ability to write complex SQL and stored procedures
• 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.

• Ad Delivery Systems (Google Double Click for Publishers Premium)
• Nielson Ratings data
• Salesforce
• Java and Perl programming

Additional Information

Requisition Number: 1475