Sr. Application Engineer (Platform Admin)

OneAmerica Financial; Indianapolis (IN); Hybrid; USD 110,000 - 150,000; Full time

Benefits offered by this job

Medical & prescription insurance

Dental & vision insurance

401(k) Plan with company match

Pension Plan

Paid time off

Parental leave program

Wellness program

Employee assistance program

Office access in multiple locations

Job summary

OneAmerica Financial in Indianapolis is seeking a Senior ETL Application Engineer to design, develop, and optimize Informatica workflows and mappings to solve mission-critical data challenges within an Agile team. You will collaborate with customers, architects, and partners, analyze requirements, provide estimates, and ensure high performance of data pipelines across systems.

Candidates should have 5+ years in data integration, strong communication, and expertise with Informatica PowerCenter,

Qualifications

• Bachelors degree in a related field required.
• 5+ years in an application engineering role focused on data integration.
• Experience with Informatica PowerCenter and ETL mappings.
• Expert knowledge of software development methodologies.
• Strong communication and coaching skills for development teams.

Responsibilities

• Debugs complex ETL code and resolves defects.
• Develops and tunes Informatica workflows and mappings.
• Leads requirements/story development discussions.
• Provides accurate effort estimates for ETL work.
• Ensures performance and reliability of data pipelines.

Skills

ETL development

Data integration

Informatica

Agile / Scrum

Performance tuning

Education

Bachelor's Degree

5+ years in data integration

Informatica PowerCenter experience

Software development methodology

Strong communication skills

Tools

Informatica PowerCenter

Job description

At OneAmerica Financial, our purpose is to create more certainty for our customers that leads to better moments, every day. Our commitment is to advance stability and growth in every solution and relationship. We deliver financial strength that builds for generations, and we are always aspiring, looking ahead, and collaborating to achieve more, together. Come be a part of this journey with us as we champion lives!

The ETL Application Engineer Senior works with customers, architects, and partners to implement solutions with Informatica workflows and mappings in order to solve mission critical business challenges. The role requires execution in code analysis, design, testing, development, and performance tuning as part of Agile / Scrum Develop Team. This role will build and maintain workflows for multiple systems and must be capable of understanding business requirements, working with end users, and developing and deploying integrations.

Primary Responsibilities Include, But Are Not Limited To

• Debugs complex code and resolves defects
• Interprets, identifies, and solves unique and meaningful problems
• Development of code and procedures affecting hundreds of daily users
• Leads technical contribution to requirements / story development conversations
• Ensures thorough technical grooming
• Communicates complex findings in a structured and clear manner to a non-technical audience (written and verbal) including communication to leadership
• Follows best practices and standards, identifies gaps and suggests changes
• Responsible for understanding environmental constraints and planning to mitigate
• Leads design around performance testing and can performance tune complex environments
• Works respectfully with all team members, both OneAmerica colleagues and vendor partner team members
• Emphasis on evaluating that the requirements are solid from the ETL coding perspective
• Understands the system(s) ETL setup, and the Product Owner's / Sponsor's expectations for ETL
• Provides estimates on ETL effort at any point required, and demonstrates a track record of accuracy
• Leads analysis and profiling of data to identify patterns
• Responsible for the creation of expert ETL code that aligns with the overall Sprint Plan; Development and enhancement of Informatica workflows and mappings as per the business requirements
• Responsible for creating and/or editing ETL procedures
• Intermediate level expertise in advanced database and reporting tools to analyze and interpret data in order to effectively define system requirements or solve business problems
• Works with Enterprise and Solution Architecture team leads to review data pipeline designs and data development best practices
• Demonstrates expertise in a variety of the data warehouse concepts, practices, and procedures
• Bridge, integrate, and extract meaning from different sources of business data - Product and 3rd Party feeds
• Represents the ETL community on various governance committees
• Understands different databases and how to efficiently join data across systems
• Provides recommendations for overall enterprise data architecture
• Synthesize data and strategy to provide clear concise recommendations to the product teams

Required Education/Certifications

• Bachelors Degree
• 5+ years in an Application Engineering field related to data integration
• Experience in Informatica PowerCenter (or comparable tool) developing ETL mappings
• Expert knowledge of software development methodology
• Superb communication and coaching skills with the ability to connect with members of the development teams

Recommended Education/Certifications

• Relevant Certifications a plus

Salary Band: 6C

This selected candidate will be expected to work hybrid in Indianapolis, IN. The candidate will also be expected to physically return to the office in CA, IN or ME as business needs dictate or for team building and collaboration.

Benefits

• Medical & prescription, dental, vision insurance
• Health Savings Account & Flexible Spending Accounts
• Paid Time Off
• 10 weeks 100% paid parental leave (after completing 12 months of employment)
• 401(k) Plan with company match
• Pension Plan
• Company paid life & disability insurance
• Wellness Program & Company paid employee assistance program
• Clinic access subject to location* (*Indianapolis, Charlotte, Cincinnati)

If you are offered and accept this position, please be advised that OneAmerica Financial does not have any offices located in the State of New York and OneAmerica Financial associates are not permitted to work remotely in the State of New York.

Selected employees must be able to perform the essential functions of the position satisfactorily and, if requested, reasonable accommodations will be made to enable employees with disabilities to perform the essential functions of their job, absent undue hardship.

Disclaimer: American United Life Insurance Company (“OneAmerica Financial”) is committed to a policy of Equal Employment Opportunity and will not discriminate against an applicant or employee based on race, color, religion, creed, national origin or ancestry, ethnicity, sex (including gender, pregnancy, sexual orientation, gender identity), age, physical or mental disability, veteran or military status, genetic information, citizenship, or any other legally recognized protected basis under federal, state, or local law.

For All Positions

Because this position is regulated by the Violent Crime Control and Law Enforcement Act, if an offer is made, applicants must undergo mandated background checks as a condition of employment. Such background checks include criminal history. A conviction is not necessarily an absolute bar to employment. Consistent with applicable regulatory guidelines and law, factors such as the age of the offense, evidence of rehabilitation, seriousness of violation, and job relatedness are considered.

To learn more about our products, services, and the companies of OneAmerica Financial, visit oneamerica.com/companies.