Athenium LLC

Sr. Data Systems Engineer - Informatica ETL

Athenium LLC • $110K — $130K *
Information Technology
5 - 7 years of experience
Job Overview by Ladders

Qualifications

  • BS in computer science or equivalent
  • 7+ years of relevant ETL experience with rising responsibilities
  • Proficient in Informatica PowerCenter
  • Solid skills in MS SQL Server with complex SQL and stored procedures
  • Experience with Fact and Dimensional data, including slowly changing dimensions
  • Skillful in SOAP/XML and REST/JSON API use, including OAuth and OAuth2
  • Strong ability to prioritize, organize, and manage multiple tasks effectively
  • Demonstrated experience in performance tuning for Informatica ETL processes

Responsibilities

  • Develop ETL applications using Informatica for EDW/BI project
  • Implement data integration and loading tasks
  • Utilize the Informatica Suite of tools including Parallel Processing
  • Conduct performance tuning for Informatica ETL processing
  • Collaborate with cross-functional teams to gather and assess requirements

Benefits

  • Work within a progressive environment supporting advanced BI initiatives
  • Opportunity to enhance ETL development skills with the Informatica Suite
  • Engagement in diverse projects involving various data systems
  • Collaborative workplace culture with access to leadership and mentorship opportunities
Full Job Description
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:
• 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

Additional Information

Must apply to: https://career8.successfactors.com/sfcareer/jobreqcareer?jobId=1475&company=[redacted]P&username=

Requisition Number: 1475

About Athenium LLC

Athenium Analytics is a software company that provides data analytics solutions for the insurance industry. The company was founded in 2004 by David Coons and is headquartered in Boston, MA. Athenium's flagship product, Insurity, is a data analytics platform that enables insurers to improve their underwriting and claims processes. The platform uses machine learning algorithms to analyze large amounts of data and provide insights into risk and fraud. Athenium also offers consulting services to help insurers implement and optimize their data analytics strategies.
Learn more about Athenium LLC
Size
100 employees
Industry
Founded
2005

Similar Jobs

More Jobs at Athenium LLC

More Information Technology Jobs

Find similar Sr. Data Systems Engineer - Informatica ETL jobs: