ETL Senior Engineer

Job DescriptionThe ETL Senior Engineer is responsible for the technical and functional impact analysis, design & review activities associated with development of software releases for the CVS Retail Pharmacy systems. Strong technical, functional, and interpersonal skills are key to perform this role successfully. The current suite of systems includes multiple applications including, but not limited, to the Tier 1 systems for Retail Pharmacy (RxConnect).Sr. ETL Engineer will partner and collaborate with the development manager, business analysts, architects, quality assurance, business partners, other developers, and project managers to deliver Business change and innovation into our Informatica and PL/SQL based business applications software.The Engineer will be involved throughout the development life cycle of a product and must be able to deliver an efficient solution, as well as identify and properly mitigate any risks to the product before deployment to production.Pay RangeThe typical pay range for this role is:Minimum: 90,000Maximum: 180,000Please keep in mind that this range represents the pay range for all positions in the job grade within which this position falls. The actual salary offer will take into account a wide range of factors, including location.Required Qualifications Overall 7+ years of professional IT experience A minimum of 5 years of experience in Requirement Analysis and Design Experience for projects delivered via Waterfall, Agile, and/or XP methodologies Proven experience as technical SME (with domain knowledge) in understanding business requirements and translating into software solutions Meeting with various end users/Business groups of the application to decide project scope Proven experience in Story grooming while working with Business/Business Analysts Designing the solution to meet the business requirements as part of To Be Flows. Discussing Gaps and Workarounds at the To Be stage with the business and obtaining concurrence. Strong hands-on experience in understanding and analyzing functional and technical function points, finding gaps in functionalities or in/out Data conditions which need to be fixed before implementing enhancements. Strong hands-on experience in informatica power center tool to create ETL jobs to load, extract feeds, business reports and system maintenance jobs. Strong hands-on experience in Unix shell scripting to automate ETL jobs. Strong hands-on experience in Control-M for scheduling and monitoring ETL jobs. Strong knowledge of data base partitioning, indexes, and data modeling. Good knowledge of triaging performance issues and provide solutions. Knowledge on object-oriented design and design patterns. Working closely with architecture, Performance Testing and Prod team to understand capacity/architecture of system and support project according to requirement. Expertise in Functional aspects of Pharmacy Domain. Knowledge of Prescription dispensing System will be a plus Extensive experience in preparing the functional and Technical solution documents for ETL jobs. Experience in figuring out ways to improve workflow proposed with planned changes in initiatives and improve benefit to end users Experience working with developers to explain and clarify Requirements and act as Release SME Work with Development Manager to review defects during development Iterations, identify recurring patterns and provide recommendations. Responsible to improve on code quality focusing on defect containment Understanding and functioning with internal/external interacting systems via feeds and golden gate replication. Basic understanding of HIPAA practices Exceptional ability to work in a high-pressure environment Working experience on an Active-Active Site implementation of software Application Preferred Qualification Database knowledge - Oracle 11g or higher, MySQL or MariaDB, Oracle PL/SQL, Data Modeling concepts Strong leadership and presentation skills to share reviews/feedback on business Requirements to executives Good interpersonal skills, dedicated, disciplined, hardworking and a team player Strong communication skills Flexible to work in onsite/offshore modelPreferred Qualifications A minimum of 5 years of experience successfully working in IT projects in an Agile development methodology. Knowledge about Agile Tools (Rally, Jira, etc.) will be a plus Experience with Best practices implementing End to End, Unit Testing & Integration Testing Working experience on an Active-Active Site implementation of software Application Conceptual Knowledge of Replication Technologies e.g. Oracle Golden Gate Extensive Knowledge of Informatica Power Center, Unix shell scripting, Control-M tool and PL/SQL. Clarify the Functional & Technical issues that may come up during the Dev/Test CyclesEducation Bachelor's Degree in Computer Science, Information Systems, or related technical field or comparable work experience required Master's in Computer Science related program preferredBusiness OverviewBring your heart to CVS Health Every one of us at CVS Health shares a single, clear purpose: Bringing our heart to every moment of your health. This purpose guides our commitment to deliver enhanced human-centric health care for a rapidly changing world. Anchored in our brand - with heart at its center - our purpose sends a personal message that how we deliver our services is just as important as what we deliver. Our Heart At Work Behaviors support this purpose. We want everyone who works at CVS Health to feel empowered by the role they play in transforming our culture and accelerating our ability to innovate and deliver solutions to make health care more personal, convenient and affordable. We strive to promote and sustain a culture of diversity, inclusion and belonging every day. CVS Health is an affirmative action employer, and is an equal opportunity employer, as are the physician-owned businesses for which CVS Health provides management services. We do not discriminate in recruiting, hiring, promotion, or any other personnel action based on race, ethnicity, color, national origin, sex/gender, sexual orientation, gender identity or expression, religion, age, disability, protected veteran status, or any other characteristic protected by applicable federal, state, or local law. We proudly support and encourage people with military experience (active, veterans, reservists and National Guard) as well as military spouses to apply for CVS Health job opportunities.

Created: 2025-11-15