Informatica Developer
The Group: Fueling the technologies that drive our products and support our company’s infrastructure, the Technology team within our Corporate team consists of talented developers, network architects, and IT experts who help make technology one of Morningstar’s core strengths. Though our technologists represent a range of skills and knowledge bases, they all view technology as a craft and care deeply about creating positive user experiences. From Agile methodologies to mobile applications, to software as a service (SaaS) delivered from our private cloud, we push technology’s boundaries to build scalable, elegant solutions that help investors reach their financial goals.
The Role: The Senior Database 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 ETL/ELT, 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, ETL 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:
- Design analytical SQL (Window Functions).
- 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 and construct databases in both Netezza as well as SQL Server.
- 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.
- Minimum of three years’ experience of prior Analytical SQL experience, 5+ years SQL experience.
- Skills in database design with some data modeling skills, as well as proficiency with ANSI SQL-99.
- Proven SQL skills in performance tuning and creating efficient stored procedures and functions.
- Experience developing ETL programs and familiarity with Informatica.
- 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.