The ETL Developer extracts, transforms, and loads data for business needs, developing mappings and maintaining ETL processes using Informatica and Teradata with a focus on performance and troubleshooting issues.
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
Top Skills
Azure Data Factory
Informatica Data Quality
Informatica Powercenter
Python
R
React
Snowflake
SQL
Teradata
Unix Shell Scripting
Similar Jobs
AdTech • Cloud • Digital Media • Information Technology • News + Entertainment • App development
As a Sr Cyber Data Systems Engineer, you'll design and implement security platforms, onboard data elements, and ensure efficient data ingestion while providing support and documentation for security systems.
Top Skills:
AnsibleAWSAws Security LakeAzureBashChefCi/CdData BricksDatadogLogstashPuppetPythonSnowflakeSplunkVector
Big Data • Cloud • Software • Database
Join the Storage Layer Services Team at MongoDB to architect cloud storage solutions, enhance performance, and manage cross-team projects. Lead development in Rust for multi-tenant services, mentor new engineers, and contribute to product roadmaps.
Top Skills:
CC++Rust
Healthtech • Insurance • Other • Sales • Software
The Senior Software Engineer will enhance the core platform for brokers, collaborating with teams to develop and maintain web applications using JavaScript and Python, focusing on scalability and user experience.
Top Skills:
DjangoDockerGitJavaScriptPythonReactTailwind CssVueWebpack
What you need to know about the Los Angeles Tech Scene
Los Angeles is a global leader in entertainment, so it’s no surprise that many of the biggest players in streaming, digital media and game development call the city home. But the city boasts plenty of non-entertainment innovation as well, with tech companies spanning verticals like AI, fintech, e-commerce and biotech. With major universities like Caltech, UCLA, USC and the nearby UC Irvine, the city has a steady supply of top-flight tech and engineering talent — not counting the graduates flocking to Los Angeles from across the world to enjoy its beaches, culture and year-round temperate climate.
Key Facts About Los Angeles Tech
- Number of Tech Workers: 375,800; 5.5% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Snap, Netflix, SpaceX, Disney, Google
- Key Industries: Artificial intelligence, adtech, media, software, game development
- Funding Landscape: $11.6 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Strong Ventures, Fifth Wall, Upfront Ventures, Mucker Capital, Kittyhawk Ventures
- Research Centers and Universities: California Institute of Technology, UCLA, University of Southern California, UC Irvine, Pepperdine, California Institute for Immunology and Immunotherapy, Center for Quantum Science and Engineering
