Share this Job
Apply now »

Advisor Informatica Application Designer

Date:  Sep 11, 2022

Any city, NY, US, 99999

Req ID:  9809

Be part of a team that unleashes the power of leading-edge technologies to help improve the health and well-being of those most vulnerable in our country and communities. Working at Gainwell carries its rewards. You’ll have an incredible opportunity to grow your career in a company that values work flexibility, learning, and career development. You’ll add to your technical credentials and certifications while enjoying a generous, flexible vacation policy and educational assistance. We also have comprehensive leadership and technical development academies to help build your skills and capabilities.




As an Advisor Informatica Application Designer at Gainwell, you can contribute your skills as we harness the power of technology to help our clients improve the health and well-being of the member they serve – a community’s most vulnerable.  Connect your passion with purpose, teaming with people who thrive on finding innovative solutions to some of healthcare’s biggest challenges.  Here are the details of this position. 

Your role in our mission


  • Provides highly complex design documents and translates into component-level designs to accelerate development. Develops strategy, design and data gathering approaches.
  • Leads development team efforts to provide flexible reusable components to increase cost effectiveness. Analyzes, designs and reviews design of applications and suites of applications to ensure that customer specifications are satisfied.
  • Oversees business process work sessions, project meetings and joint applications development sessions to ensure that product design decisions are communicated to departmental personnel.
  • Functions as a domain expert and works closely with software developers to explain the application design, and coordinates activities between the two functions to enhance product quality and efficiency. Conducts cost analysis studies to determine feasibility of approaches.
  • Provides leadership and work guidance to less experienced personnel. Guides the work of less experienced developers to create, maintain and communicate details of application designs to ensure that designs are according to specifications.
  • Develop, test, enhance processes and  perform root cause analysis, investigate errors, and implement corrective actions.
  • Design and develop new ELT/ETL processes using Linux/Unix scripting, SQL, ETL tool (i.e. Informatica), and database platforms like Teradata, Oracle, or Databricks.
  • Design, develop, and support data processing capabilities.
  • Collaborate with teams to maintain, develop, and enhance, and automated data processing / pipelines.
  • Work with users to resolve questions and provide information as needed.

What we're looking for


  • 7 - 9 years of experience in Informatica - PowerCenter 10.5, PowerExchange 10.5
  • Strong foundation on data modelling and normalization techniques for both OLTP and OLAP
  • Sound understanding of data structures (linear and nonlinear)
  • Design, develop and maintain robust Informatica PowerCenter mappings and workflows that process huge volumes of data across multiple platforms.
  • Intermediate experience with Linux scripting with the ability to leverage arrays and write scripts & functions

What you should expect in this role


  • Fully remote position allows you to work anywhere in the United States



The pay range for this position is $106,500.00 - $133,100.00 per year, however, the base pay offered may vary depending on geographic region, internal equity, job-related knowledge, skills, and experience among other factors. Put your passion to work at Gainwell. You’ll have the opportunity to grow your career in a company that values work flexibility, learning, and career development. All salaried, full-time candidates are eligible for our generous, flexible vacation policy, a 401(k) employer match, comprehensive health benefits, and educational assistance. We also have a variety of leadership and technical development academies to help build your skills and capabilities.


We believe nothing is impossible when you bring together people who care deeply about making healthcare work better for everyone. Build your career with Gainwell, an industry leader. You’ll be joining a company where collaboration, innovation, and inclusion fuel our growth. Learn more about Gainwell at our company website and visit our Careers site for all available job role openings.


Gainwell Technologies is committed to a diverse, equitable, and inclusive workplace. We are proud to be an Equal Opportunity Employer, where all qualified applicants will receive consideration for employment without regard to race, religion, color, national origin, gender (including pregnancy, childbirth, or related medical condition), sexual orientation, gender identity, gender expression, age, status as a protected veteran, status as an individual with a disability, or other applicable legally protected characteristics. We celebrate diversity and are dedicated to creating an inclusive environment for all employees.

Apply now »