| SQL Developer :: Remote at Remote, Remote, USA |
| Email: [email protected] |
|
http://bit.ly/4ey8w48 https://jobs.nvoids.com/job_details.jsp?id=2115280&uid= Hi, I hope you are well. I request you to go through the below requirements help me with updated resume, SQL Developer with Informatica, SSIS, Tableau, Oracle PL/SQL with Production Support Experience Job Location:-Remote Mandatory Skill sets :- SQL Developer, Informatica, SSIS, Tableau, Oracle PL/SQL with Production Support Experience . 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 imize 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 imization 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. imize 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 imize SQL queries to ensure that databases are performing imally, 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 system integrity and ensure data flows as expected across multiple systems. Communicate effectively with business and IT stakeholders to ensure that any requirements, changes, or issues are addressed promptly. 7. Testing and Deployment Support Support post-deployment validation by verifying the proper functioning of the VLM Checkbook and VLM/Encounter 837 processes after updates or system changes. Participate in testing of new features or fixes to the VLM/Encounter 837 workflows, ensuring that new releases do not disrupt current operations. 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. -- Thanks and Regards, S Siva Prasad | Technical Recruiter HCL Global Systems, Inc 24543 Indoplex Circle,Suite 220, Farmington Hills, MI 48335 Phone 248-473-0720 Ext: 222 Email: [email protected] | [email protected] LinkedIn: https://www.linkedin.com/in/siva-prasad-somavarapu-2a4727228/ -- Keywords: information technology golang procedural language Michigan SQL Developer :: Remote [email protected] http://bit.ly/4ey8w48 https://jobs.nvoids.com/job_details.jsp?id=2115280&uid= |
| [email protected] View All |
| 09:11 PM 27-Jan-25 |