Job Description
Job Summary
The Sr. Data Engineer will implement data integration architecture and solutions and design and develop ETL logic using Informatica to support existing and future deployments. This role will work to independently solve problems and fix technical issues and be responsible for unit test construction and execution.
Duties and Responsibilities
- Implement data integration architecture and solutions
- Design and develop ETL logic using Informatica to support existing and future deployments
- Design and execute technical aspects of data management functions including creating, loading, transforming, cleansing, processing, analyzing, and visualizing data
- Collaborate directly with teammates and business partners to build technical solutions that solve problems, are reusable, scalable, fast, and maintainable through large datasets, both clean and un-clean
- Work with multiple development technologies including SQL
- Interact cross-functionally with other technical teams both internally and externally to implement complete technology solutions
- Design and develop code to support existing and future deployments
- Independently solve problems and fix technical issues
- Responsible for unit test construction and execution
Experience and Education Requirements
- Associate’s/Bachelor's Degree (preferred emphasis in technology, engineering or math related field) or equivalent combination of education and experience
- 4-7 years of experience designing, building, and supporting real-time data pipelines and analytical solutions using Informatica
- 2+ years of experience in supporting ETL, production data operations (File processing, data distribution etc.,) including debugging, addressing production issues and performing Root Cause Analysis
- Strong ability to write SQL queries and interpret data models
- Experience with SQL Server and/or Oracle
- Experience building data structures, solutions and products
- Experience writing automated unit, integration, and acceptance tests for data interfaces & data pipelines
- Understanding of object-oriented analysis and design
Preferred Requirements
- Experience building data pipelines and interfaces with object-oriented languages (.Net, Java, Python)
- Experience with database modeling
- Preferred to have experience in supporting DTCC and data transfers from / to external organizations and internal systems using EFT (Electronic File Transfer)
- Working knowledge of Informatica Data Quality, Business Glossary, Metadata Manager
- Experience with database design/modeling tools such as Erwin
- SSIS experience
- SSRS experience
- Experience within a Financial Services/Insurer’s IT Organization
- Experience with APIs, Boomi or Informatica preferred
#LI-Remote #LI-MB1
Work Environments
F&G believes in an employee-centric flexible environment, which is why we offer the ability for in-office, hybrid and remote work arrangements. During the hiring process, you'll work with your leader to decide what works best for your role.
Join our employee-centric hybrid work environment: F&G Careers
About F&G
Since 1959, Fidelity & Guaranty Life Insurance Company (F&G) has offered annuity and life insurance products to those who are seeking security in retirement and protection during life’s unexpected events.
As a national Top Workplace1, an Iowa Top Workplace2 and a proud equal opportunity employer, F&G team members are empowered, collaborative, dynamic and authentic. We believe that by embracing these values, we will continue to build and strengthen the company while continuing to be a great place to work.
1Top Workplaces USA 2022 – 2023
2Des Moines Register Top Workplaces 2018 – 2022
Notice for all Applicants who are California residents under the California Privacy Rights Act. Please click here to review the policy.
Explore More
Date Posted
06/24/2023
Views
1