DATABASE ENGINEER - INFORMATICA POWER CENTER - IICS - 0479
YONKERS, NY, US
At Montefiore, 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, as well as Montefiore’s corporate decision makers 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,
The Database Engineer will assist in gathering business requirements, designing, and developing ETL pipelines, and logical models for relational, columnar, and multi-dimensional data stores, and ultimately building the physical database. They are expected to analyze business needs and create a complete database solution. The ideal candidate will be participating in overall design of the enterprise-wide data/information architecture, and focus on ETL design, architecture, and data modeling. The successful candidate will have a strong understanding of BI architecture, ETL design patterns, Data modeling, and Database management systems.
RESPONSIBILITIES INCLUDE:
- Perform source system analysis and meet with business stakeholders to create appropriate requirements for data modeling
- Strong understanding of dimensional data model concepts needed to optimize data analysis, ETL Development, and BI reporting tools
- Experience maintaining enterprise data model documentation through industry-leading tools like ER Studio/ERWIN
- Work closely with Business Intelligence Analysts and Database Engineers to ensure the needs of the customer are being met in the areas of reporting and analytics.
- Develop data standards in terms of nomenclature, storage, design, and deployments.
- Design, Develop and optimize ETL pipelines using Informatica Cloud (IICS) and Informatica PowerCenter
-
Knowledge in Data Warehouse approaches
-
Experience with building and maintaining physical and logical database models
-
Experience with data pipeline and workflow management tools: Informatica IICS, Informatica PowerCenter
-
Experience with DevOps: Jira, Bitbucket (CI/CD), Confluence
-
Experience with Data Architecture and Data Modeling: Erwin, Idera Embarcadero etc.
-
Experience with relational SQL including Oracle and SQL Server
-
Experience with scheduling or orchestration: AutoSys, ControlM
-
Experience with Azure cloud services: Azure Storage, ADF, Synapse, Databricks,
-
Experience with scripting languages (Nice to have): Python, Scala, Unix Shell Scripting etc.
-
Knowledge of clinical and financial systems within a Healthcare environment (Nice to have)
Montefiore offers an excellent benefits package including a generous 403B contribution; 37 PTO Days
Montefiore offers remote options, but requires employees to reside in NY, NJ, CT, or PA.;
Montefiore currently requires immunizations including for COVID and flu.
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: 213846 Salary Range/Pay Rate: $92,235.00 $122,980.00
For positions that have only a rate listed, the displayed rate is the hiring rate but could be subject to change based on shift differential, experience, education or other relevant factors.
To learn more about the “Montefiore Difference” – who we are at Montefiore and all that we have to offer our associates, please click here.
Diversity, equity and inclusion are core values of Montefiore. We are committed to recruiting and creating an environment in which associates feel empowered to thrive and be their authentic selves through our inclusive culture. We welcome your interest and invite you to join us.
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-KK1-REDIRECT; SF-DICE-MIT
Nearest Major Market: Yonkers
Nearest Secondary Market: New York City