Senior Data Integration Developer

Following a 2022 merger of CNSI and Kepro, Acentra Health combines clinical services, technology solutions, and data analytics to accelerate better health outcomes. This is a great time to join our team of passionate individuals working together to pursue the most effective solutions to today’s complex healthcare challenges. Our culture is fueled by passion and driven by purpose. Senior Data Integration Developer - Are you an experienced Senior Data Integration Developer looking for a new challenge? - Are you looking to join a team that ensures a collaborative and inviting culture where everyone can thrive? If so, you might be our next new team member! Who we need: As a Senior DataStage Data Integration Developer, you will work on a team responsible for the analysis, design, development of conversion programs, Data Warehouse, and unit/integration testing of the developed programs satisfying the project requirements and business rules for large MMIS (Medicaid Management Information System) systems. Singularly Focused. Mission Driven. Accelerating Better Outcomes is our Mantra! We are mission-driven to innovate health solutions that deliver maximum value and impact. We do this through our people. You will have meaningful work that genuinely improves people's lives across the country. We are a company that cares about our employees, and we give you the tools and encouragement you need to achieve the finest work of your career. Benefits are a key component of your rewards package. Our benefits are designed to provide you with additional protection, security, and support for both your career and your life away from work. Our benefits include comprehensive health plans, paid time off, retirement savings, corporate wellness, educational assistance, corporate discounts, and more. What you’ll do: - Collaborate with technical teams and functional leads for all aspects of data conversion requirements to develop conversion blueprints, data migration plan, data design, facilitate development, testing, and execution. - Develop and modify complex database applications based on requirements using specific Extract Transform & Load (ETL) integration tools (Infosphere Datastage). - Design programs and systems that match the complex Medicaid business requirements and record all the specifications that are involved in the development and coding process. - Create models and process flow diagrams after analyzing business/user needs in the design specification document. - Capture key business requirements and specifications for each module of the application and develop pseudocodes accordingly. - Use Dimensional Modeling Techniques (Star Schema and Snow Flake Schema) to create and identify Dimensions, Cubes, and Fact tables. - Work on CDC (Change Data Capture) to implement SCD (Slowly Changing Dimensions) Type 1 and Type 2. - Support the data conversion team in data analysis leveraging legacy data sets and provide the results of the analysis to the client/internal teams and other teams as needed. - Accelerate legacy data corrections and/or formalization of business rules for effective data migration. - Create and maintain artifacts as needed by the project. - Participate in technical/functional reviews and ensure the conversion artifacts comply with Acentra data conversion standards and practices. - Assist conversion/migration team in performing thorough unit testing of conversion artifacts and ensure smooth transition to system test, user acceptance test, and implementation. Required Qualifications - Bachelor’s degree with a minimum of 8+ years of relevant work experience; preferred majors: Computer Science, Information Systems, or a closely related field. - 8+ years of hands-on experience performing data migrations of mainframe and relational data, including identifying and analysing source data, transforming source data into the required format, loading the transformed data into the target system, and validating all source data is tracked and transformed. - 6+ years of hands-on experience with IBM DataStage tool for data migrations. - 5+ years of MMIS (Medicaid Management Information System) implementation experience. - 5+ years of demonstrated skills working with Oracle SQL, PL/SQL, and Shell scripting and relational database concepts. Experience - Proven track record in conversion development and cutover experience across all stages of software development life cycle (SDLC) and software testing life cycle (STLC). - Demonstrates analytical skills and thinking to resolve technical issues in conversion. Thank You! We know your time is valuable and we thank you for applying for this position. Due to the high volume of applicants, only those who are chosen to advance in our interview process will be contacted. We sincerely appreciate your interest in Acentra Health and invite you to apply to future openings that may be of interest. Best of luck in your search! - The Acentra Health Talent Acquisition Team EOE AA M/F/Vet/Disability Acentra Health 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, status as a protected veteran or any other status protected by applicable Federal, State or Local law.