Title: Production Support Specialist(Remote)
Position Overview:
We are seeking an experienced Production Support Specialist to manage and support our data integration processes, particularly focusing on the VLM Checkbook and VLM/Encounter 837 processes.
This role will be responsible for ensuring the seamless operation of ETL and data management systems, including Informatica PowerCenter, Power Exchange, SQL, Kafka, and SSIS.
The ideal candidate will have a deep understanding of data flows, database systems, and message queues, with a strong ability to troubleshoot, optimize, and support large-scale data integration processes.
Key Responsibilities:
1.VLM Checkbook Process Support
• Monitor and manage the VLM Checkbook process to ensure the smooth flow of data. This includes the handling of transactions, file transfers, and status updates related to the checkbook process.
• Troubleshoot issues related to the VLM Checkbook process, ensuring that any interruptions are resolved quickly and efficiently to minimize impact on production environments.
• Ensure data accuracy and consistency by performing checks on the incoming and outgoing data related to the VLM Checkbook process.
• Collaborate with cross-functional teams (business, IT, and vendors) to address process improvements, data issues, and optimize workflow performance.
• Perform root cause analysis for recurring issues and proactively implement solutions to prevent similar incidents.
2. VLM/Encounter 837 Process Support
• Monitor and manage the VLM/Encounter 837 process, ensuring that the 837 EDI files are processed in a timely manner. This includes validating data integrity, ensuring proper file formatting, and ensuring timely file delivery.
• Oversee ETL processes using Informatica PowerCenter and Power Exchange, ensuring that data is correctly extracted, transformed, and loaded into the appropriate databases or systems.
• Work with Kafka to manage message queues and ensure that data is being properly transmitted across systems and applications within the VLM/Encounter 837 workflow.
• Perform SQL and Oracle database checks to validate the integrity of data within the systems and address any discrepancies or issues in the 837 data processing pipeline.
• Utilize SSIS (SQL Server Integration Services) for data integration, transformation, and loading processes, ensuring that the VLM and Encounter 837 data flows correctly between systems.
3. Issue Resolution & Incident Management
• Address and resolve production issues in real-time for the VLM Checkbook and VLM/Encounter 837 processes, ensuring that any disruptions are promptly mitigated with minimal impact to the business.
• Utilize monitoring tools to track job status and performance for all processes and initiate timely corrective actions for any errors.
• Escalate critical issues to appropriate teams and stakeholders for resolution, and provide detailed post-incident analysis to prevent recurrence.
4. Data Quality Management & Performance Optimization
• Validate data quality by ensuring the accuracy and integrity of data flows related to the VLM Checkbook and Encounter 837 processes. Identify any data discrepancies and work with stakeholders to correct them.
• Optimize performance of ETL processes, ensuring that Informatica PowerCenter, Power Exchange, and Kafka functions are running efficiently and that processing times for large volumes of data are minimized.
• Monitor and optimize SQL queries to ensure that databases are performing optimally, especially in terms of data retrieval and manipulation for VLM and Encounter data.
5. Documentation & Reporting
• Maintain documentation for all VLM/Encounter 837 processes, including workflows, troubleshooting guides, and best practices for supporting the process.
• Provide status updates and incident reports to stakeholders, including details of system performance, issues encountered, and resolutions implemented.
6. Collaboration & Communication
• Collaborate with other production support teams to ensure end-to-end
Mandatory Skill sets:
• 4+ years of experience in production support, particularly in the management of ETL processes, data integration, and large-scale data pipelines across on-prem and cloud-based environments.
• Hands-on experience with Informatica PowerCenter and Power Exchange for managing complex data transformations, extractions, and loads.
