Etl Testing Jobs in Indiana (NOW HIRING)

In Some Jobs You Take Orders. In This One, You Write History. 

Join the healthcare information technology team that's turning drug and medical device data into knowledge used by thousands of hospitals; the majority of U.S. health plans, retail pharmacies, and pharmacy benefit managers; and millions of healthcare decision makers throughout the world. Partnering with our information system developer and healthcare institution customers, you'll help evolve leading-edge thinking into reality and make a measurable difference in improving human health. 

We're looking for people who are: Intelligent. Productive. Committed. Willing and able to go above and beyond. Passionate about making a difference. Innovative. Energized. And want to play an essential role in a successful company's continued growth.

 Are you ready for this exciting challenge? 

____________________________________________________________________________________________

First Databank (FDB) is currently seeking an FDB Prizm Application Specialist (Developer) within the Quality Management department for the Prizm Medical Device Database and its Medical Device Data Management System (MDMS). This role is responsible for the design, development, maintenance, testing, and continuous improvement of the database, MDMS user interface, supporting data workflows, ETL processes, APIs, and AI-enabled tools that enhance system capabilities. This includes writing, reviewing, testing, and maintaining AI-assisted and manually generated code; managing data integrations from FDA sources, categorization sources, client APIs, and data files; and developing AI-driven automation to improve data throughput, consistency, validation, and overall data quality. The developer will work closely with the database administrators, build team, Quality Management, and other cross-functional partners to ensure reliable data builds, effective issue resolution, and continued improvement of Prizm-related systems. This position is critical to ensuring the reliability, effectiveness, scalability, and data integrity of FDB's medical device data solutions, thereby contributing to the goals of the department and company. The candidate must have 3-5 years of software development experience with Python, Java, HTML, and CSS.

This position is a hybrid role working out of our Carmel, IN office.

Responsibilities:

• Assist in the design, development, maintenance, and continuous improvement of the Prizm Medical Device Database
• Own and implement the Medical Device Data Management System (MDMS), including scalable database and UI solutions that support web applications and data-driven workflows.
• Leverage Python to automate data workflows, create and maintain ETL and integration pipelines, validate incoming medical device data, and enhance back-end systems linked to MDMS front-end interfaces.
• Manage ETL processes that ingest, transform, validate, and load medical device data from various internal and external sources, including FDA data sources, categorization sources, client APIs, and client or vendor data files.
• Implement and refine MDMS user-facing features using HTML, CSS, Java, and templating engines to support efficient workflows and clear data presentation.
• Use modern AI-assisted development tools, such as Cline and Cursor, to improve productivity, code quality, documentation, and testing while reviewing and validating AI-generated code before release.
• Develop, evaluate, and integrate AI-enabled tools, validation routines, and workflow automations into the MDMS and supporting data pipelines to enhance system capabilities, increase data output, and improve the quality, consistency, and validation of medical device data.
• Analyze complex medical device datasets to identify trends, data integrity issues, normalization needs, and opportunities for database optimization or schema redesign.
• Partner with the Prizm database administrator on database-related planning, schema and data model considerations, query optimization, performance monitoring, deployment coordination, and production support activities.
• Develop and maintain comprehensive documentation of data models, architecture, code, workflows, release/change processes, work instructions, and training materials for cross-functional teams.
• Monitor and troubleshoot MDMS and database performance, implementing indexes, partitioning, query tuning, and other optimization techniques to ensure availability, reliability, and responsiveness.
• Ensure ETLs function properly and on a scheduled cadence and frequency.
• Troubleshoot API, integration, ETL, and data build issues, including APIs used in build processes, and assist the build team in diagnosing and resolving Prizm-related issues throughout build, QA, and release workflows.

• Collaborate with Quality Management, clinical/content, product, technology, database administration, and build teams to translate business and data requirements into reliable MDMS enhancements; perform other duties as assigned.

Required Skills:

• Strong analytical, problem-solving, interpersonal, and organizational skills, with the ability to own technical work from requirements through delivery.

• Proficiency developing, reviewing, testing, and debugging applications written in Python, Java, CSS, and HTML, including AI-assisted and manually generated code.

• Working knowledge of relational database design, data modeling, data integrity principles, workflow automation, and performance optimization for data-driven systems.

• Experience with ETL/data integration concepts, API troubleshooting, data mapping, data validation, and ingestion of structured or semi-structured data files from multiple sources.

• Ability to evaluate, develop, integrate, and validate AI-enabled tools or automation within data management workflows while maintaining appropriate human review, data quality, and documentation standards.

• Strong communication and collaboration skills, including the ability to work effectively with a database administrator, build team, and cross-functional stakeholders; well organized work habits with attention to detail and a commitment to quality improvements.

Required Experience:

1. Minimum Education (or Substitute experience) required:

• Associate degree in MIS, CIS, Computer Science, or related field; equivalent professional experience may be considered.

1. Minimum Experience required:

• 3-5 years of software development experience with Python, Java, CSS, and HTML required.

• Preferred experience developing database-backed web applications, data management systems, ETL/data integration pipelines, Python automation workflows, API integrations, and AI-enabled tools or integrations, including Cline, Cursor, or similar platforms, that improve system capabilities, data output, and data quality. Experience working with FDA data sources, categorization data, client APIs, client or vendor data files, data build processes, or production support workflows is also preferred.

_____________________________________________________________________________________________

About FDB:

FDB is the leading provider of drug and medical device knowledge that helps healthcare professionals make precise decisions. With thousands of customers worldwide, FDB enables our information system developer partners to deliver valuable, useful, and differentiated solutions. We offer more than three decades of experience in transforming medical knowledge into actionable, targeted, and effective solutions that help improve patient safety, operational efficiency, and healthcare outcomes. For a complete look at our solutions and services, please visit www.fdbhealth.com or follow us on LinkedIn.

We value Integrity, Respect, Responsibility, Teamwork, and Creativity. Our offices in South San Francisco and Indianapolis have been awarded with Top Workplaces honors by The Bay Area News Group and the Indy Star, respectively, including the most recent honor awarded to our Indianapolis office since 2016 (the Top Workplaces honors are based solely on the results of an employee feedback survey by a leading research firm that specializes in organizational health and workplace improvement). 
We are an Equal Employment/Affirmative Action employer. We do not discriminate in hiring on the basis of sex, gender identity, sexual orientation, race, color, religious creed, national origin, physical or mental disability, protected Veteran status, or any other characteristic protected by federal, state, or local law.

If you need a reasonable accommodation for any part of the employment process, please contact us by email at careers@fdbhealth.com and let us know the nature of your request and your contact information. Requests for accommodation will be considered on a case-by-case basis. Please note that only inquiries concerning a request for reasonable accommodation will be responded to from this email address.

For more information about our commitment to equal employment opportunity, please visit EEO is the Law, EEO is the Law Supplement,  Pay Transparency, and FDB EEO/AA Statement.

In accordance with applicable law, Hearst is required to include a reasonable estimate of the compensation for this role if hired in Carmel, IN. The reasonable estimate, if hired in Carmel, is $85,000 - $100,000. Please note this information is specific to those hired in this location. If this role is open to candidates outside of this location, the compensation range would be aligned to that specific location. A final decision on the successful candidate's starting compensation will be based on a number of permissible, non-discriminatory factors, including but not limited to skills and experience, training, certifications, and education.

This role is also eligible for medical, dental, vision, life, and disability insurance; 401(k) retirement plan; flexible spending account; paid holidays; paid time off; employee assistance program; and other company benefits.