Software Eng IV

* Design, develop, and maintain ETL workflows and mappings in Informatica Power Center
* Develop and optimize complex Oracle PL/SQL procedures, functions, triggers, and packages
* Build and maintain Shell scripts for data automation, monitoring, and job scheduling
* Gains a thorough understanding of functional requirements for new software requests
* Works with Business Systems Analysts to understand and clarify software requirements and translate into working software
* Designs, develops and performs testing of software to meet functional requirements
* Practices good software engineering techniques and standards to reduce coding errors and ensures robustness and efficiency of work products
* Partners with software team in the development of software engineering processes
* Works to identify and resolves technical or product problems
* Participates in software project meetings and provides status reports
* Translates technical designs into working software
* Maintains existing applications by enhancing software and troubleshooting issues
* Collaborates with team members and partners with others as needed to ensure successful completion of assigned software development tasks
* Ensures data quality, performance, and scalability of ETL processes and database solutions
* Participates in code reviews, release management, and process improvement efforts  Troubleshoot and resolve production issues related to data processing and performance
* Contributes to best practices, documentation, and continuous improvement initiatives within the team
* Applies software engineering and Object-Oriented Design principles in creating UML diagrams and technical design documents for software components
* Partners with team members and technical project lead to ensure component design fits in with the overall solution
* Adopts new techniques and technologies
* Initiates attendance at job related training to keep skills current; maintains current understanding of the industry’s best practices
* Assists with mentoring and training of less experienced IT staff members
** Supervisory Responsibilities*
* * Eight (8) plus years of experience with Informatica Platform and knowledge of Informatica best practices for Informatica Power Center and B2B Data Exchange products
* Hands-on experience with Power Center Mapplets, Mappings, Workflows, and Applications
* Experience in Power Center Developer using Data Transformation and Developer Studio tools
* Strong ETL and data modelling experience, including schema design, query optimization, and performance tuning
* Eight (8) plus years of experience in development of database processes using Oracle SQL, PL/SQL in Oracle 12c and Unix shell scripting
* Proficiency in Oracle PL/SQL, including advanced SQL, stored procedures, and performance optimization
* Familiarity with job scheduling tools such as UC4, Control-M, Auto Sys, or similar
* Excellent knowledge of debugging, tuning and optimizing performance of database queries
* Strong experience with Unix/Linux Shell scripting for ETL orchestration and automation Thorough knowledge of software methodologies, distributed networking, databases, communications, and multiprocessing applications
* Strong proficiency in database interfacing and relational database management systems
* Excellent problem-solving, analytical, communication skills and collaboration with cross-functional teams
* Demonstrated ability to work collaboratively on project teams and/or matrix-managed teams
* Ability to appropriately schedule and prioritize multiple projects to ensure timely and effective delivery of IT solutions
* Excellent written and verbal communications skills with emphasis on translating technical concepts to non-technical audiences
* Results oriented and ability to juggle multiple concurrent projects with changing priorities and deadlines
* Familiarity with PBM business model (plans, programs, and practices) as well as pharmaceutical practices (nomenclature, medications) helpful
* Medical / Dental / Vision / Wellness Programs
* Paid Time Off / Company Paid Holidays
* Incentive Compensation
* 401K with Company match
* Life and Disability Insurance
* Tuition Reimbursement
* Employee Referral Bonus Med Impact  was founded more than three decades ago by a pharmacist and independent drug store owner who saw firsthand how families struggled with the high cost of prescriptions, and how it impacted their lives, financial security, and health.
So, he started Med Impact to make prescription benefits understandable and accessible. While we have grown to be one of the leading PBMs in America, we remain as committed to these principles today as we did when it all began.
#J-18808-Ljbffr