Software Engineer IV - ETL Developer

Role Description

The Software Engineer is responsible for working on projects that are currently being visualized or developed by our organization. This role will be involved with the Software Development Life Cycle methodology and framework, directing software system validation and testing methods, as well as directing software programming initiatives. This position works closely with clients and cross-functional departments to communicate project statuses and proposals.

This role is specific to ETL Development:

• Knowledge of Programming languages: XML, JavaScript, SQL
• Developer Tools: Git, Azure Devops, CDIPC - Cloud Data Integration for PowerCenter
• ETL Process Development: Design, develop, and maintain ETL processes using Informatica PowerCenter or other relevant Informatica tools.
• SQL Proficiency: Utilize SQL/PLSQL to extract, transform, and load data.
• Exposure to advanced transformations like data transformations, Parsing JSON/XML messages

Qualifications

• Associate's degree in computer science, information technology or related field. In lieu of a degree, three (3) years of experience required. Bachelor’s degree preferred.
• Basic knowledge of at least one (1) programming language, such as C#/.NET, Java, SQL, C++, Python, Visual Basic or JavaScript.
• Basic understanding of one (1) of the following tools/platforms such as: Informatica, CI/CD, Pega, Power BI, Cognos.
• Basic knowledge of at least one (1) operating system, such as Unix-Based or Windows.
• Basic database experience
• Basic understanding of software testing and quality.
• Demonstrated basic ability to effectively communicate and partner with team members and direct leadership to understand user stories and identify application and system impacts.
• Demonstrated advanced problem-solving skills.
• Demonstrated basic ability to implement security architecture principles, and best practice standards that align to the Organization’s overall business and strategy.
• Basic technical knowledge of techniques, standards, and state-of-the-art capabilities for authentication and authorization, applied cryptography, data masking, encryption, security vulnerabilities, and remediation.
• Basic understanding of OpenAPI Specification (OAS) and Open Web Application Security Project (OWASP) vulnerabilities and risks.

Requirements

• Level I: Develops code, analyzes, researches, and resolves associated system issues.
• Participates in on-call production support rotation.
• Supports, maintains, creates and follows all documented IT processes and standards, application documentation and design and code reviews.
• Collaborates and communicates with team members and associates throughout the business to understand requirements and identify application impacts.
• Creates individual work plans, specifications and programs with guidance utilizing development procedures and standards.
• Develops skillset in one tool and ability to utilize the approved source control.
• Establishes a basic understanding of the Software Development Life Cycle methodology and framework use by your team, post one year demonstration of basic understanding and application of this skill.
• Consistently demonstrates high standards of integrity by supporting the Lifetime Healthcare Companies’ mission and values, adhering to the Corporate Code of Conduct, and leading to the Lifetime Way values and beliefs.
• Maintains high regard for member privacy in accordance with the corporate privacy policies and procedures.
• Regular and reliable attendance is expected and required.
• Performs other functions as assigned by management.
• Level II: Participates in strategic discussion and decision-making.
• Serves as a mentor in their area(s) of technical expertise.
• Provides input to creation and documentation of organizational standards.
• Continuous development including the skillset of a second programming language and one tool/platform.
• Develops and implements an intermediate understanding of the Software Development Life Cycle methodology and framework.
• Develops understanding in one supported enterprise technology, post one year demonstration of intermediate understanding and application.
• Level III: Proactively identifies process and technical deficiencies, troubleshooting and offering solutions to resolve.
• Identifies best practices and participates in creation of organizational standards.
• Progresses the Software Development Life Cycle methodology and framework forward by demonstrating advanced understanding and application.
• Provides intermediary understanding of one supported enterprise technology and developing an additional basic understanding of another enterprise technology. Post one year demonstration of intermediate understanding, and application of an additional technology.
• Level IV: Assists with software and system design and architecture within the assigned portfolio.
• Develops strategies to mitigate risk and translates those strategies into specific action plans.
• Acts as a subject matter expert in their area(s) of technical expertise. Identifies best practices and drives creation of Organizational Standards and processes.
• Progresses the Software Development Life Cycle methodology and framework forward by demonstrating advanced understanding and application.
• Provides understanding and expertise of two (2) supported enterprise technologies and developing an additional basic understanding of another enterprise technology. Post one year demonstration of advanced understanding, and application of, additional technologies.

Benefits

• Participation in group health and/or dental insurance
• Retirement plan
• Wellness program
• Paid time away from work
• Paid holidays

Physical Requirements

• Ability to work prolonged periods sitting and/or standing at a workstation and working on a computer.
• Ability to work while sitting and/or standing at a workstation viewing a computer and using a keyboard, mouse and/or phone for three (3) or more hours at a time.
• Ability to travel across the Health Plan service region for meetings and/or trainings as needed.
• Ability to work in a home office for continuous periods of time for business continuity.