Skip to content

Senior Engineer

At Northwestern Mutual, we are strong, innovative and growing. We invest in our people. We care and make a positive difference.

Northwestern Mutual Life Insurance Company - 720 E Wisconsin Ave, Milwaukee, WI 53202

Job Title: Senior Engineer

Job Description: The Senior Engineer at Northwestern Mutual Life Insurance Company in Milwaukee, Wisconsin will author test scenarios and perform functional ETL testing using Informatica for OTL, Batch load and Run Continuous data. Create thorough documentation of functional and QA test scenarios from business requirements, designs and Informatica ETL code.  Execute manual testing of both real time and batch data movement processes.  Test and ensure that validation jobs are working as expected for source missing, target missing, and field mismatch cases. Capture and maintain evidence of functional and QA test results to meet industry regulatory requirements.  Have detailed understanding of NM’s product, field force and client data and processing for performing data profiling and data analysis based on business needs. Strong SQL knowledge and the ability to read and write complex SQL queries.  Automate manual ETL test scripts using node.js and enhance existing automation framework. Create Autosys jobs in all environments which will be used for execution of ETL jobs and scripts to populate data in respective tables.  Migrate code across multiple environment using internal migration tool and capturing logs in Kibana.  Model database schema changes to meet business functionality requirements while adhering to company modeling standards using Erwin tool.  Migrate schema changes across all environments in BIIPODS and BIIPCLD databases following the change control process.  Validate data flows as a part of test results, work with test and development engineers for solution changes and make design updates by understanding the data integration. Develop informatica mappings and code migrations in order to ensure business needs are met.

Minimum Requirements: Requires a Bachelor's degree in Computer Science, Electronics Engineering, or related field plus five years of software development and testing experience. Five years of experience must include three years of experience with each of the following: (1) SDLC Methodologies including V-model, Waterfall, and Agile Software Development (SCRUM & Kanban); (2) SQL; (3) node.js; (4) Test Automation; (5) SAP PowerDesigner and Erwin; (6) Informatica Designer, Workflow, and Monitor; (7) Java coding; (8) Unix; (9) Gitlab; and (10) QA testing.

Interested candidates send resume to vincentalbo@northwesternmutual.com. Reference code 121 in the subject line.

This job is not covered by the existing Collective Bargaining Agreement.

Required Certifications:

Grow your career with a best-in-class company that puts our client’s interests at the center of all we do. Get started now! 

We are an equal opportunity/affirmative action employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, gender identity or expression, sexual orientation, national origin, disability, age or status as a protected veteran, or any other characteristic protected by law.


FIND YOUR FUTURE

We’re excited about the potential people bring to Northwestern Mutual. You can grow your career here while enjoying first-class perks, benefits, and commitment to diversity and inclusion.