Share this Job

 

 

 

 

 

DATABASE ENGINEER - 1244

YONKERS, NY, US


Our Business Intelligence and Analytics organization is a large (40+) and growing department that provides complex information solutions to our corporate leadership.  The team focuses on the timely delivery of accurate, relevant and easily accessible information to all of its, hospitals, Montefiore corporate decision makes and external regulators or partners.  The technical team is comprised of data architects, DBAs, database engineers, business intelligence developers and business analysts who shepherd data from Montefiore’s multiple source systems to the Enterprise Data Warehouse and then to our customers through the business intelligence self-service platform. We are seeking an ETL Database Engineer to work with Informatica Powercenter. For this role, Informatica training is available to a Database Engineer who has experience working with another ETL tool such as Datastage or Ab Initio.

 

Responsibilities:

  • Establish and maintain database management systems, standards, guidelines, and quality assurance for database deliverables including conceptual design, logical database, capacity planning, external data interface specification, data loading plan, data maintenance plan and security policy.
  • Develop scripts and modules that determine data quality and accuracy for multiple processes that transform and move data.
  • Leverage data extract, transform and load (ETL) technologies to accelerate development of data flows, to schedule them and to organize them for on-going maintenance by a team.
  • Conduct analysis of source system data with client stakeholders and source system owners to determine a) capacity to meet reporting needs and b) specific transformation rules that need to be applied.
  • Determine how tables relate to each other and how fields interact within the tables for relational & dimensional models.
  • Participate in decisions around data warehouse architecture and more specifically data models and database design.
  • Generate data for testing purposes.  Auto-generate massive amounts of data with rules for performance and data quality testing.
  • Assist with process engineering (definition, training and improvement) for all software development lifecycle processes.
  • Work with software developers, business intelligence analysts and report analysts to insure compliance with database practices

 

Required:

  • Bachelor’s degree preferred or equivalent experience
  • 7+ years of work experience working with Oracle 11 or higher
  • 3+ years of experience hands-on with ETL with a tool such as Informatica, Datastage, or Ab Initio
  • PL/SQL skills strong enough to write stored procedures
  • Kimball knowledge of Data Warehouse preferred
  • Experience in healthcare specific reporting or other exposure to healthcare business constructs is a plus.
  • Bachelor’s degree preferred     

 

 

Department: Montefiore Information Technology Bargaining Unit: Non Union Campus: YONKERS  Employment Status: Regular Full-Time Address: 3 Odell Plaza, Yonkers
Shift: Day Scheduled Hours: 8:30 AM-5 PM Req ID: 173846 

 

Montefiore is an equal employment opportunity employer. Montefiore will recruit, hire, train, transfer, promote, layoff and discharge associates in all job classifications without regard to their race, color, religion, creed, national origin, alienage or citizenship status, age, gender, actual or presumed disability, history of disability, sexual orientation, gender identity, gender expression, genetic predisposition or carrier status, pregnancy, military status, marital status, or partnership status, or any other characteristic protected by law. 

 

LI-MF1-REDIRECT; SF-DICE-MIT 


Mission:
To heal, to teach, to discover and to advance the health of the communities we serve.

Vision:
To be a premier academic medical center that transforms health and enriches lives.

Values
Define our philosophy of care, they shape our actions and motivate and inspire us to pursue excellence and achieve the goals we have set forth for the future. Our values include:

  • Humanity
  • Innovation
  • Teamwork
  • Diversity
  • Equity

 

 

 


Nearest Major Market: Yonkers
Nearest Secondary Market: New York City