Apply Now    

Data Warehouse/ETL Developer (Associate)

Req #: 170112155
Location: Glasgow, SCT, UK
Job Category: Technology
Potential Referral Amount: 3500 Pound Sterling (GBP)
Data Warehouse/ETL Developer
Associate
 
Glasgow Technology Centre
 
 
Client Intelligence is a platform that provides analytics on clients, deals, bankers, products, and profitability measures at the detail and aggregated level across key business metrics and dimensions. It contains a service-oriented, secure and scalable information platform; it is a corporate finance dashboard targeted at senior and junior bankers across different lines of business within the firm.
 
IBIE serves as data warehouse for Banking and Research, Client Profitability/Analytics for IB Markets and Wholesale Client Profitability system for the Firm. The warehouse has five data marts and feeds to 20+ downstream systems. The platform uses many tools including Informatica, Oracle and columnar database Vertica. IBIE is one of the biggest database clusters in the Firm and runs about 1500 jobs every day.
 
Data warehouse Developer who is proficient in database and ETL implementations to support IBIE platform
 
Key Requirement
 
  • Ability to work in a highly energetic global environment showing ability to quickly overcome technical challenges and respond appropriately.
  • Experience in working on projects with demanding timelines.
  • Keeps abreast of industry trends and able to bring industry standards and best practices, lessons learned to projects.
  • Strong communication skills as this individual will need to work closely with clients, users and managers.
  • Excellent analytical and problem-solving skills.
  • Good team player, gets on well with others and able to work with people of different skill levels.
  • An understanding of quality and process improvement.
  • Good organization skills to keep track of issues & requests and ensure proper follow-up and closure
Duties
 
Design, development and L3 support of:
 
  • Informatica PowerCenter mappings, sessions and workflows.
  • Oracle Data Warehouse structures and content.
  • Oracle and Vertica Data Mart structures and content.
  • Autosys batch-schedule and associated unix bash scripts.
  • Participate in agile daily scrums, sprint planning and sprint retrospective activities
Required Skills: 
  • Proven track record in the following tools/skill sets are a must: Informatica, Oracle and UNIX scripting, delivering high quality solutions.
  • Able to convert Business requirements into Functional / Technical specs Demonstrate ability to understand and work effectively within complex IT environment containing onshore/offshore model, multiple development and testing environments, sharing of environment with multiple teams, load balancing and disaster recovery setup.  
  • Ability to quickly grasp problems and issues and communicate effectively with other team members.
  • Understanding of development using SCRUM and Agile practices
  • Possess excellent written and verbal communications skills
 
Closing date: 11th December 2017
Location: Glasgow
Salary: Competitive Salary Package
Apply Now    

Join our Talent Community

Not ready to apply? Leave your information with us and we will keep you up to date with new career opportunities.

Things to note

Sign in to our application system to continue your job search or update your profile.

Current employees sign in here. Contractors sign in here.

Any information you provide is confidential and will only be viewed by our recruiters in an effort to fill open positions. In addition, the information you provide is subject to our privacy policy practices.

Please note that J.P. Morgan will not accept unsolicited approaches or speculative CVs, nor will J.P. Morgan be responsible for any related fees, from Third Party Firms who are not preferred suppliers.

The firm invites all interested and qualified candidates to apply for employment opportunities.

Need disability related assistance?

If you are a US or Canadian applicant with a disability who is unable to use our online tools to search and apply for jobs, please click here.

Important links

Click here to view the "EEO is the Law" poster.

Click here to view the "EEO is the Law" supplemental poster.

Click here to view our U.S. Pay Transparency Policy.

JPMorgan Chase is an equal opportunity and affirmative action employer Disability/Veteran.