The Senior Informatica/Oracle Developer is a critical member of the Informatics & Analytics team, responsible for supporting the implementation and on-going development and operations of the Enterprise Data Warehouse (EDW) in support of the overall DFCI mission to improve quality and manage healthcare expense trends. This is a hands-on position that requires a technical and functional understanding of healthcare analytics and data warehouse architecture. Responsibilities include analyzing business requirements, and designing, developing, and unit testing integration solutions to meet customer needs.
The role is expected to understand and apply best practices and provide expertise in acquiring data from source systems to build database analytic content. As such, it is expected that the individual will understand the full lifecycle of data warehousing and business intelligence projects. The individual in this position will interact with directors, leads, architects, consultants, business analysts, co-developers and business/clinical users. The successful candidate will be an experienced lead developer with extensive enterprise background using Oracle and Informatica. The Senior Informatica/Oracle Developer will be required to identify business requirements, develop data models, perform data analysis, write advanced SQL queries and triggers, design and code complex stored procedures, and maintain and performance tune existing databases.
This role is currently 100% remote and will switch back to office environment when COVID-19 ramps down.
Located in Boston and the surrounding communities, Dana-Farber Cancer Institute brings together world renowned clinicians, innovative researchers and dedicated professionals, allies in the common mission of conquering cancer, HIV/AIDS and related diseases. Combining extremely talented people with the best technologies in a genuinely positive environment, we provide compassionate and comprehensive care to patients of all ages; we conduct research that advances treatment; we educate tomorrow's physician/researchers; we reach out to underserved members of our community; and we work with amazing partners, including other Harvard Medical School-affiliated hospitals.
Designs, builds and maintains data warehouse solutions to support Reporting and Analytics projects
Work with end users, business analysts, technical staff, and other project team members to plan, design, develop, implement, and enhance application processes and overall data and process flow and user interface applications
Integrates source system data into the EDW, including initial development of extraction/integration routines
Self-starter with a strong desire to learn and apply the latest technologies related to database solutions
Create and execute test plans using end-user success criteria as a guide
Implement security through a combination of data and application level using role based user access
Coordinate with DBAs on capacity planning, data archival, data purging, transaction log maintenance as well as backup and data recovery
Supports on-going production operations and maintenance of current and legacy systems
Applies design principals and architectural standards, including those that support security and auditing requirements
Develops strong working relationships with key project team members and customers to ensure activities are aligned with business objectives
Supports troubleshooting and problem resolution activities as needed, including acting as an escalation point for technical and process issues
Perform Peer document reviews and code reviews to ensure adherence to user requirements as well as established standards and conventions.
Bachelor's Degree required, preferably in Computer Science, financial/operating systems data architecture, or a related technical field
6+ years of related professional experience including 4+ years in data warehouse architecture, design, development and data integration
4+ years of experience working with Informatica Repository, Designer, Workflow and Monitor. Substantial experience with creating source qualifiers, targets, all mappings transformation objects, lookup cache management, workflows, worklets, scheduling, monitoring and performance tuning jobs
6+ years of experience programming in Oracle PL/SQL and SQL Server T-SQL
Working, hands-on expertise with Informatica PowerCenter, Data Quality, Analyst, Metadata Manager including Informatica software installation, configuration and administration
Monitor daily batch data loads and primary on call contact for the batch failures during the off hours and weekends
Must have a strong understanding of Kimball approach to data warehousing using denormalized star schemas and snowflakes
A strong understanding of Data Architecture, ETL Architecture, advanced SQL concepts and Data warehousing tools is required
Experience working with Epic and Peoplesoft a plus
Experience maintaining complex database applications, ability to write, understand, and tune complex SQL, PL/SQL, stored procedures, functions, views and triggers
Rewrite and correct existing inefficient or poorly performing queries and stored procedures to run more efficiently and to ensure stronger performance
Hands on experience performance tuning database applications including indexing, with ability to interpret execution plans
Dana-Farber Cancer Institute is an equal opportunity employer and affirms the right of every qualified applicant to receive consideration for employment without regard to race, color, religion, sex, gender identity or expression, national origin, sexual orientation, genetic information, disability, age, ancestry, military service, protected veteran status, or other groups as protected by law. #LI-CP1
Internal Number: 2020-20267
About Dana-Farber Cancer Institute
Located in Boston and the surrounding communities, Dana-Farber Cancer Institute brings together world renowned clinicians, innovative researchers and dedicated professionals, allies in the common mission of conquering cancer, HIV/AIDS and related diseases. Combining extremely talented people with the best technologies in a genuinely positive environment, we provide compassionate and comprehensive care to patients of all ages; we conduct research that advances treatment; we educate tomorrow's physician/researchers; we reach out to under-served members of our community; and we work with amazing partners, including other Harvard Medical School-affiliated hospitals.