Data Engineer
Current• Execute data analysis, data transformation, and extraction tasks required to integrate customer data into the Healthentic data warehouses.• Analyze raw medical and Rx eligibility and claims data to ensure that it can successfully be incorporated into Healthentic’s PhD application.• Design, develop, review, and unit test Oracle SQLLDR control files and Oracle PL/SQL scripts to map incoming raw data files to the Healthentic data file specifications, using the team’s established coding standards.• Work with the data providers to acquire the data required for Healthentic’s products, including phone conferences, examples, and detailed technical descriptions of issues.• Design, develop, review, unit test, and maintain data validation tests using Oracle PL/SQL.• Ability to research and troubleshoot technical issues.• Create and maintain procedures documentation for all work performed.• Document review and validation findings for both technical and business team members.• Participate in discussions with Engineering and QA team members regarding new feature development, data validation needs, and related topics. • Analyze, design, develop, and unit test assigned features to meet product requirements.• Responsible for the development and tuning of new and existing ETL, back-end support for internal tools, validation of incoming data files.• Working cooperatively with the data architect to apply data models and coding standards. • Working closely with the product team to review and understand business and customer requirements. • Responsible to develop, maintain, and enhance test suites to verify the validity and accuracy of ETL processes while ensuring all requirements are comprehensible and testable.• Working with the development team to efficiently resolve defects and maintain the highest level of quality for all data.