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 w/technical teams and functional leads for all aspects of data conversion requirements to develop conversion blueprint(s), 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 analyzing 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 utilizing

• 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)