Rate: Depends on Experience

Work location: Remote w/ occasional travel to client site (Springfield, IL).

Required Qualifications:

• 7 years of Informatica PowerCenter / ETL Experience
• 5 years of complex SQL and Performance Tuning Experience
• 2 years of Teradata Version 15 experience, including Teradata Utilities (Fastload, TPT, Multiload)
• 2 years of ETL/Informatica PowerCenter administrative experience
• Excellent verbal/written communication skills, end-client facing, team collaboration, and mentoring skills.
• Strong organizational skills and ability to set priorities and schedule work deadlines.
• Bachelors or Advanced Degree in a related field such as Information Technology/Computer Science, Mathematics/Statistics, Analytics, Business Technology
• Adapting to the team and organizational culture

Preferred Qualifications:

• 5 years of Data Warehouse experience
• Experience in Reporting/Analytics tool shall be a plus (SAP BO, Tableau, SAS, PowerBI)
• Experience in Windows, Unix/Linux scripting, R, React, or Python
• Experience in Informatica Data Quality (IDQ), Address Doctor, Metadata Manager
• Experience with State Medicaid / Medicare / Healthcare applications.
• ETL/Informatica or SQL or BI or Teradata Certification
• Experience working in Agile.
• Experience with Data Warehouse technologies within the domain of ETL/data integration, Business Intelligence, relational and multi-dimensional database systems.

Primary Responsibilities:

• Use Informatica PowerCenter to Extract, Transform, and Load (ETL) source data from agency sources, applying numerous transformations to the data that are required, applying corrections to the source files, and adding new fields via the change request process.
• Automate the staging of data by scheduling scripts to run at optimal times, enhancing overall system performance and efficiency.
• Create, maintain, and support an ETL/Informatica architectural and system environment for development and production.
• Perform domain/repository backups and recovery operations.
• Implementing ETL jobs by creating mappings, mapplets, sessions, and workflows
• Working with different ETL transformations, including Aggregator, Expression, Filter, Router, Sequence Generator, Update Strategy, Joiner, Rank and Source Qualifier, Lookup, and Sorter
• Scheduling and monitoring ETL/Informatica jobs in development, system testing, and production environment
• Developing proactive processes for monitoring capacity and performance tuning
• Supporting and advising the development teams on technical issues
• Troubleshoot production support issues post-release deployment and comes up with solutions.
• Developing and maintaining complex SQL queries and scripts used to create data marts in Teradata.
• Participating in project discussions to document and recommend alternative technical solutions or requirements.
• Participating in unit, integration, and system testing
• Maintaining effective communication and relationships with all individuals involved with the project.
• Learning new technologies as needed to be able to perform job duties effectively.
• Providing status progress and meeting deliverables to Optum’s leadership and Optum’s customer