Database Developer
The Role: The Senior ETL Developer will be a leader in a wide variety of responsibilities critical to the implementation of our next generation data platform, including the design, construction, and, maintenance of warehousing processes, which includes design and development of ETL jobs, ODS/Warehouse Data Modeling, Metadata Definitions and Scripting. You will be responsible for creating conceptual, logical, and physical data models. In this role the candidate will design analytical SQL, data models, work very closely with our project managers, business analysts, data architects, SQL developers, and DBAs to ensure the requirements are well understood, design and develop solutions that meet those specifications. This candidate must demonstrate knowledge of the full life cycle of the data warehouse implementation process, from business requirements through logical modeling, physical database design, data sourcing and data transformation, data loading, and performance tuning. This position will be based in our Chicago office.
Responsibilities:
- Has expertise in Informatica suite v9 or higher of products specifically PowerCenter
- ETL performance tuning and optimization
- Develop Informatica code, Design, Develop and modify Informatica mappings and workflows
- SQL Performance Analysis.
- Optimize and debug SQL queries.
- Design Tables, Views, and Distributions.
- Translate user requirements and needs into database schema and table design.
- Provide thought leadership on data modeling best practices and provide advice and guidance around database design.
- Implement and support data calculation, collection, and harvesting.
- Design physical database objects including fact tables, dimensions, staging, materialized views, and indexes.
- Provide input for planning, estimation, and implementation activities using the Agile methodology.
- Ability to work with multiple projects that share the same data entities and to help guide the projects on overall data design.
Requirements:
- A bachelor’s degree in computer science or a related field with a specialization in relational database management systems.
- This is a senior position that requires 5+ years of Informatica development experience.
- 5+ years SQL experience.
- Demonstrate in-depth understanding of Data Warehousing (DWH) and ETL concepts, ETL loading strategy, ETL Error Handling, Error logging mechanism, standards and best practices.
- Proven SQL skills in performance tuning and creating efficient stored procedures and functions.
- Knowledge of SQL window functions as well as data visualization tools, and applications.
- Financial or accounting industry knowledge very helpful.
Morningstar is an equal opportunity employer.