Location: Telecommute with occasional (2-3/ year) travel to Springfield, IL
The ETL Developer is responsible for loading and extracting data into and out of the Teradata database. The ETL developer must learn and understand the technical structure of the data and the business use of the data. Knowing what the data is supposed to do and how end-users will use the data supports accurate loading, staging, transformation, and testing/troubleshooting of data. Our team is responsible for a wide range of data to support business needs. Our developers must work with their Lead to determine the steps (or plan) needed to implement the solution.
Our projects range from small (8 – 10 hours), medium (300-1000 hours), or large (more than 1000 hours). The developer will work with the customer to define the requirements, create the technical design, code the solution, and implement the code into development, UAT, and production.
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
Required Qualifications:
- 7+ years of Informatica PowerCenter / ETL Experience
- 5+ years of complex SQL and Performance Tuning Experience
- 5+ years of Teradata Version 15+ experience, including Teradata Utilities (Fastload, TPT, Multiload)
- 5+ years of ETL / Informatica PowerCenter administrative experience
- Excellent verbal/written communication skills, end-client facing, team collaboration, and mentoring skills
- Experience with Unix Shell scripting
- Strong organizational skills and ability to set priorities and schedule work deadlines.
Preferred Qualifications:
- Located in Springfield, IL area is preferred
- 5+ years of Data Warehouse experience
- 5+ years logical and physical data modeling experience using ERWIN or other data modeling tool
- 2+ years of Azure Data Factory and Snowflake DB development
- 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
- Experience working in Agile
- Experience with Data Warehouse technologies within the domain of ETL/data integration, Business Intelligence, relational and multi-dimensional database systems
- Experience with Korn and Bash Shell scripting.
- 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
