Perform technical analysis and translate business needs to create high-quality Business Requirements, Functional Specifications and Sources to Target Mapping (STTM). Solve complex problems including multiple interfaces with other systems across various business units. Consider all impacted components from an end-to-end perspective and retrieve and review data from the source systems in traditional DB2 databases by writing and executing complex SQL queries. Develop User Interface using Excel Forms and VBA Macros. Create the appropriate User-Interface Models to support projects and develop business workflow diagrams. Perform gap analysis between traditional data warehouse and new big data platform using IBM DB2. Conduct impact analysis of technology changes on business processes and existing technologies, contribute to the review of test planning and test execution strategies, and provide technical expertise of network systems Linux to perform UAT using tools like Putty. Support the implementation of systems into production, including integrating purchased solutions. Oversee or perform unit testing. Assist with integration and system testing, according to detailed test plans to ensure high-quality systems. Perform current state analysis, define systems strategy, develop system requirements, design and prototype systems, test, define support procedures and implementation. Assist in the development of data models and interface design specifications. Document, track and resolve issues related to data quality using Hadoop databases including Hive to perform data profiling/data analysis/root cause analysis on big data platform using Aginity and Hue. Support development of project plans, project implementation, and post-implementation support
Bachelor's Degree in Computer Science, Electronic Engineering or a related field.
Minimum 5 years of experience in business or system analysis. Must have experience developing software design and documentation of software design, business, system, and/or non-functional/technical requirements including scope analysis. Must also have experience with: SQL in medium complexity to complex SQL queries in Teradata/Hive/DB2/Oracle; Waterfall and Agile including project planning and application development lifecycles; Data architecture and Data Modelling concepts; Handling large Scale Data warehousing IT Projects and day to day operational requests from business; IBM Data Stage, Ab initio; Unix/Linux operating systems; and conducting Unit test cases, automated test cases, regression testing, and root cause analysis.
Percent of Travel Required
Aetna, a CVS Health company, we are joined in a common purpose: helping people on their path to better health. We are working to transform health care through innovations that make quality care more accessible, easier to use, less expensive and patient-focused. Working together and organizing around the individual, we are pioneering a new approach to total health that puts people at the heart.
We are committed to maintaining a diverse and inclusive workplace. CVS Health is an equal opportunity and affirmative action employer. We do not discriminate in recruiting, hiring or promotion based on race, ethnicity, gender, gender identity, age, disability or protected veteran status. 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.
Apply on company website