Informatica Data Engineer- Development & Data Modeling Specialist
As a Data Engineer / Developer and Data Modeler at Mutual of Omaha, there are numerous professional growth opportunities to explore and expand your skill set. This role allows you to advance your expertise in ETL tools and technologies while keeping pace with the latest developments in cloud data technologies and integration patterns. Your commitment to excellence will contribute significantly to our mission of delivering innovative solutions and maintaining our competitive edge in the market WHAT WE CAN OFFER YOU: • Estimated Compensation (Levels have variable responsibilities and qualifications) • Estimated Salary Engineer II: $115,000 - $130,000, plus annual bonus. • Benefits and Perks, 401(k) plan with a 2% company contribution and 6% company match. • Regular associates working 40 hours a week can earn up to 15 days of vacation each year. • Regular associates receive 11 paid holidays in 2024, which includes 2 floating holidays that are added to your prorated personal time to be used at your discretion. Applicants for this position must not now, nor at any point in the future, require sponsorship for employment. [remove if open to sponsorship] WHAT YOU'LL DO: • Design and implement ETL processes to efficiently extract data from various sources, transform it to meet specific business requirements, and load it into data warehouses or data marts, ensuring seamless data integration. • Develop and maintain robust data pipelines using ETL tools, ensuring the reliable and timely flow of data from source systems to data storage solutions. • Ensure data quality through comprehensive validation, cleansing, and error handling mechanisms throughout the ETL process, maintaining high standards of data integrity and accuracy. • Optimize ETL performance by addressing bottlenecks, improving query efficiency, and ensuring scalability as data volumes grow, contributing to the overall efficiency and effectiveness of the data processing infrastructure. • Provide production support for the ETL jobs that we own. WHAT YOU’LL BRING: • Proficiency in IICS (Informatica Intelligent Cloud Services) for cloud-based data integration and management tasks. • Expertise in Informatica tools, relational databases i.e. Teradata, DB2, scripting languages (Unix/Windows), and knowledge of Snowflake. • Enabling the development of custom data transformations, complex mappings, and efficient ETL processes. • Hands-on experience with Amazon Web Services (AWS) for cloud-based data storage, processing, and analytics solutions. Knowledge of Python is needed. • You promote a culture of diversity and inclusion, value different ideas and opinions, and listen courageously, remaining curious in all that you do. • Able to work remotely with access to a high-speed internet connection and located in the United States or Puerto Rico. • Able to work remotely with access to a high-speed internet connection in a listed location. PREFERRED: • Shell script skills to understand and modify, as needed. • Testing / Automation Testing • API integration for robust data processing and connectivity and experience in migrating to Cloud from relational databases. We value diverse experience, skills, and passion for innovation. If your experience aligns with the listed requirements, please apply! If you have questions about your application or the hiring process, email our Talent Acquisition area at [email protected]. Please allow at least one week from time of applying if you are checking on the status. #Circa Apply tot his job