About Northern Trust: Northern Trust provides innovative financial services and guidance to corporations, institutions and affluent families and individuals globally. With 130 years of financial experience and nearly 20,000 partners, we serve the world's most sophisticated clients using leading technology and exceptional service.
As a Northern Trust partner, you will be part of a flexible and collaborative work culture, which has a strong history of financial strength and stability. Movement within the organization is encouraged, senior leaders are accessible, and you can take pride in working for a company that is committed to strengthening the communities we serve!
We recognize the value of inclusion and diversity in culture, in thought, and in experience, which is why Forbes ranked us the top employer for Diversity in 2018.
We'd love to learn more about how your interests and experience could be a fit with one of the world's most admired and ethical companies. Build your career with us and apply today!
Want to learn more about our company? Visit www.northerntrust.com
We are a leading global financial institution- Click here to check out our company accolades!
The C&IS Technology Department is looking for a self-motivated, enthusiastic, nimble, and pragmatic individual with a digital mind-set to join our team as a DataStage expert with Oracle DBA experience.
What You Will Do: As a DataStage engineer with strong knowledge of Oracle DB environments, you will design and build solutions to move data from operational and external environments to the business intelligence environment using DataStage. Additional responsibilities will include:
Building, configuring and managing the DataStage application architecture for NT's DTM DataMart (Oracle), including configuration and maintenance of all jobs, scheduling & enhancement requests.
Liaising closely with NT DataStage Admin/Engineering teams to ensure Tech Standards are maintained.
Demonstrating automated & repeatable deployments, supplemented with technical documentation, e.g. generation of technical Implementation Guides, etc.
Undertaking BAU DataStage support operations for the NT DataStage application architecture DTM (including platform tuning and support for Prod & UAT)
Performing Unit Testing of DataStage dev efforts, and participate in project System/Integration/UAT testing cycles
Performing code fixing and code deployment through different cycles of testing
The ideal candidate should possess a fair amount of the following qualities:
Proven experience with Advanced ETL using DataStage
Strong ETL performance tuning skills. The ability to quickly and efficiently analyze and resolve performance issues within variety of operational environments
Strong understanding of Data warehousing design concepts/skills
Proven experience with data modelling for data warehouse 3NF & DataMart - star schema
Strong SQL skills including complex query building and query performance tuning
Knowledge of Batch Data Movement - ETL (DataStage experience is preferred)
Knowledge of Traditional Relational Databases
Data analysis skills - ability to dig in and understand complex models and business processes
Strong UNIX shell scripting skills
ETL-related Python coding skills
Proven experience in working directly with business customers
Demonstrated ability to understand Oracle schemas and LDM/PDMs, and design/build DataStage jobs to meet requirements
Demonstrated ability to write complex SQL queries to support trouble-shooting of ETL jobs across Oracle schemas
Proven data migration & extraction experience, including appreciation of data governance & quality controls
Proven performance & tuning experience with DataStage set-up and config (with various data load scenarios)
Strong communicator & focus on documentation for continuous improvement, e.g. repeatable and automated deployment processes
Ability to work with Global teams (mainly London/Dublin-based, however some Dev teams are in India time zone & NT DataStage admin teams in Chicago time zone)
Working with Us: We'd love to learn more about how your interests and experience could be a fit with one of the world's most admired and ethical companies. In return, we will support you with your personal and career goals in a number of ways: Financial - Life Assurance, Disability Plan, Pension/ Gratuity, Annual Pay Review Work Life Balance - Flexible Work Options, Incremental Annual Leave, Community Volunteer Days Health & Wellbeing - Private Medical Insurance, Active Sports & Social clubs (lunchtime and after-work groups), Employee Assistance Program Professional Development - Clear Career Path, Education Assistance, Recognition Programme, NT University (wide range of online, virtual & in-house training options) and employee-led Business Resource Councils dedicated to diversity and inclusion initiatives.
And Finally We hope you're excited about the role and the opportunity to work with us. We value an inclusive workplace and understand flexibility means different things to different people. Apply today and talk to us about your flexible working requirements and together we can achieve greater.
Internal Number: 8720077
BACK TO TOP
Power Platform UGs Career Center is Just One of the Benefits.
Discover what else User Group has to offer!
The job you are trying to reach from was originally posted at Power Platform UGs Career Center.