Informatica Engineer Jobs

Informatica Engineer

Lead II - Software Engineering

Who we are:

Advantasure is a growing company and a member of the UST HealthProof family, Advantasure champions innovative solutions with an eye on the future—providing health plans with the flexibility to adapt to a changing regulatory environment and evolving business needs. Leveraging the industry’s leading experts in government-sponsored health plans, Advantasure offers solutions for administrative cost management, quality patient outcomes and experiences, enrollment growth, risk adjustment and quality and provider engagement initiatives.

We achieve this mission together through teamwork, communication, collaboration, and focus. Our employees are our greatest assets, and we invite you to apply to be a part of our journey toward making a difference in healthcare in the United States.

You are:

Responsible for designing, developing, configuring, unit testing, and documenting applications, integrations, tools, systems, and components based on project or change request specifications and procedures. Knowledge of and ability to code using Informatica PowerCenter. Assists in the design and maintenance of existing software. Follows standard troubleshooting and development procedures using various tools. May assist with complex incident management situations. Works within agile and LEAN System Development Life Cycles.

The Opportunity:

• Mentor less experienced developers on technical and professional topics.
• Review program specifications for completeness and conformance to quality standards.
• Work closely with Configuration and Release Management on environment deployments ensuring changes follow appropriate processes.
• Periodically participate in groups/committees related to processes, standards, and best practices.
• Ensure documentation is created and updated for transition to the production support team.
• Collaborate with other software developers, business analysts, product owners, and IT professionals to develop, lead and implement new features, changes, and enhancements to existing complex software applications in accordance with written specifications.
• Identify and resolve advanced application issues using appropriate code languages, toolsets, or configuration processes.
• Create and review/approved technical design documents and specifications on change requests and assignments within a project while maintaining documentation and abstracts in conformance with standards.
• Work with the architecture group to set the direction of design and development standards. Assist with the implementation and execution of those standards. Serve as a technical leader to ensure quality deliverables and sound design execution.
• Works with minimum supervision and exercises sufficient discretion and independent judgment.
• Participate in Agile planning sessions, working closely with business analysts and leading development team members to analyze requirements and provides design recommendations for complex systems.
• Stay current on technology trends through online resources such as webinars and white papers.

This position description identifies the responsibilities and tasks typically associated with the performance of the position. Other relevant essential functions may be required.

What you need:

• GitHub preferred.
• SAFe Agile Framework
• Strong experience in Informatica ETL Developer role with good hands-on experience in developing complex ETL processes using Informatica PowerCenter and tuning ETL jobs adjudication system
• Continuous learning, as defined by the Company’s learning philosophy, is required.
• No-SQL databases
• Bachelor’s degree in computer science or related field.
• Good knowledge of ETL processes and Informatica Best Practices.
• 8+ years of progressively increasing responsibility and experience within a software engineering environment which provides the necessary skills, knowledge, and abilities.
• Combinations of relevant education, certifications, and experience may be considered in lieu of a degree.
• Working knowledge of CosmosDB or other document databases
• Strong knowledge of both the functional and performance testing aspects of software development.
• Ability to apply the principles of independent logical thinking to define problems, collect data, establish facts, and draw valid conclusions.
• Working experience with database schema design, stored procedures, and SQL scripts using SQL Server and T-SQL language.
• Ability to establish expected testing service level agreements (SLA) with technical partners.
• Certification or progress toward certification is highly preferred and encouraged.
• Experience with source code control systems, merging, versioning, and release and deployment activities.
• Demonstrated technical leadership and mentoring ability.
• RDBMS and SQL, specifically developing and tuning scripts, functions, and stored procedures
• Experience serving as a senior engineer throughout the full software development lifecycle, from conception, architecture definition, detailed design, scoping, planning, implementation, and testing to documentation, delivery, and maintenance.
• Knowledge of, and the ability to apply, necessary software programming practices and procedures.
• Good knowledge of PL/SQL
• Strong knowledge and experience with Informatica PowerCenter (must have worked on Informatica 9.1 or higher)

Compensation can differ depending on factors including but not limited to the specific office location, role, skill set, education, and level of experience. As required by local law, UST provides a reasonable range of compensation for roles that may be hired in California, Colorado, New York City, or Washington as set forth below.

Role Location: Range of Starting Pay for Role

Remote: $84,000-$126,000

Our full-time, regular associates are eligible for 401K matching, and vacation accrual and are covered from day 1 for paid sick time, healthcare, dental, vision, life, and disability insurance benefits. Depending on the role, some associates may also be eligible for stock options.

What we believe:

We’re proud to embrace the same values that have shaped UST and its subsidiaries since the beginning. Since day one, we’ve been building enduring relationships and a culture of integrity. And today, it's those same values that are inspiring us to encourage innovation from everyone to champion diversity and inclusion and place people at the center of everything we do.

Humility: We will listen, learn, be empathetic, and help selflessly in our interactions with everyone.

Humanity: Through business, we will better the lives of those less fortunate than ourselves.

Integrity: We honor our commitments and act with responsibility in all our relationships.

Equal Employment Opportunity Statement

UST HealthProof is an Equal Opportunity Employer.

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.

#Advantasure

#LI-Remote