Sr. Developer

Requisition ID:882091

Store #:110351 EM Assignment Claims - OH CSC

Position:Full-Time

Total Rewards:Benefits/Incentive Information

At EyeMed, we have a unique perspective on vision benefits. By listening and staying curious, we create innovative vision benefits that are a joy to use.

Our mission is to help people see life to the fullest-and our commitment goes beyond vision benefits. Our passionate employees proudly support the OneSight EssilorLuxottica Foundation, a leading not-for-profit organization with a 100% focus on eradicating the world's vision crisis.

EyeMed is part of EssilorLuxottica, a global leader in the design, manufacture and distribution of world-class vision care products, including iconic eyewear, advanced lens technology and cutting-edge digital solutions. Join our global community of over 200,000 dedicated employees around the world in driving the transformation of the eyewear and eyecare industry. Discover more by following us on LinkedIn.

GENERAL FUNCTION

The Senior Developer is a key member of the EyeMed IT team, responsible for leading the ETL development of complex software solutions that support strategic business objectives. This role involves working within a diverse team, utilizing both Agile and Waterfall development methodologies. The Senior Developer is responsible for executing development tasks using best practices, analytical skills, and technical expertise to transform business requirements into detailed designs and fully functional solutions. This includes building software based on design specifications and validating solutions through manual and automated unit testing.

MAJOR DUTIES AND RESPONSIBILITIES

• Partner with business operation teams to manage inbound and outbound ETL Data Exchange with Clients
• Working as part of a team, develop new customer facing data exchange applications to support new business initiatives and client demand
• Manage day-to-day changes and enhancements to custom and standard ETL mappings
• Work with Business Analyst and business leads to understand the scope of work, priorities, and requirements for development
• Supports the technical design and development of software solutions
• Responsible for making key system design and integration decisions, ensuring that architectural principles are communicated and followed.
• Responsible for timely project deliverables.
• Ability to collaborate with development teams, requirements teams, and business units to identify, define, develop, and implement ETL code
• Oversee the development lifecycle of both internal and vendor development resources.
• Monitors usage of ETL jobs to identify potential performance issues, overloads, and bottlenecks.
• Identify, recommend and implement ETL process and architecture improvements.
• Lead code reviews, quality assurance processes, and build phases to ensure compliance with development standards and ETL architecture best practices
• Triage and troubleshooting performance issues on Oracle SQL / PLSQL / Powercenter Workflows

BASIC QUALIFICATIONS

• BS in Computer Science, Information Systems, or related
• Strong understanding of all phases of the software development life cycle
• Strong understanding of relational database design and architecture
• Advanced Informatica design and development skills using Informatica Power Center 10.x and B2B Data Exchange 10.x. Expereince with IDMC, or a comparable ETL tool
• Minimum 4 years of experience in developing Informatica PowerCenter ETL mappings using Designer,Workflow Manager, Workflow Monitor, and Repository Manager
• Minimum 2 years of experience in Oracle PL/SQL (19c preferred)
• Minimum 4 years of experience in writing advanced complex queries for analysis and troubleshooting as needed
• Must be well versed with database concepts like indexing, partitioning, performance tuning, explain plans, materialized views
• Minimum 2 years of experience writing Unix/Linux shell scripts
• Excellent oral/written communication
• Excellent organizational and analytical abilities & problem solver
• Ability to quickly learn and apply new concepts and emerging technologies

PREFERRED QUALIFICATIONS

• Experience in healthcare / insurance industry
• Experience integrating with Facets
• Works well under high pressure / critical situations
• Flexibility to work non-business hours to meet critical business needs
• Experience with HIPAA EDI

Employee pay is determined by multiple factors, including geography, experience, qualifications, skills and local minimum wage requirements. In addition, you may also be offered a competitive bonus and/or commission plan, which complements a first-class total rewards package. Benefits may include health care, retirement savings, paid time off/vacation, and various employee discounts.

Upon request and consistent with applicable laws, EssilorLuxottica will provide reasonable accommodations to individuals with disabilities who need assistance in the application and hiring process. To request a reasonable accommodation, please call the EssilorLuxottica SpeakUp Hotline at 844-303-0229 (be sure to provide your name and contact information so that we may follow up in a timely manner) or email HRCompliance@luxotticaretail.com.

We are an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, gender, national origin, social origin, social condition, being perceived as a victim of domestic violence, sexual aggression or stalking, religion, age, disability, sexual orientation, gender identity or expression, citizenship, ancestry, veteran or military status, marital status, pregnancy (including unlawful discrimination on the basis of a legally protected pregnancy or maternity leave), genetic information or any other characteristics protected by law. Native Americans in the US receive preference in accordance with Tribal Law.