JPMorgan Chase & Co. (NYSE: JPM) is a leading global financial services firm with assets of $2.5 trillion and operations worldwide. The firm is a leader in investment banking, financial services for consumers and small business, commercial banking, financial transaction processing, and asset management. A component of the Dow Jones Industrial Average, JPMorgan Chase & Co. serves millions of consumers in the United States and many of the world's most prominent corporate, institutional and government clients under its J.P. Morgan and Chase brands. Information about JPMorgan Chase & Co. is available at www.jpmorganchase.com.”
Duties: Design and develop ETL jobs using Informatica power center or Pentaho BI tool to bring structured and unstructured data into Data Warehouse or Data Mart. Schedule and Automate complex data management jobs using CA, Autosys, Tidal or similar job management tools. Design, develop, code, test, debug and document database structures and objects (Tables, views, procedures etc.). Create and Implement data models, database designs, and data access and data maintenance strategies. Design OLTP relation databases. Work with Information Architects to ensure proper Logical Data Models are defined correctly, including a data dictionary that can be used to validate attributes and values. Design and develop triggers, complex PL Sql queries and stored procedure, troubleshoot SQL code and shell scripts to support Service and Ops application. Document and implement logical data integration strategies for data flows between disparate source/target systems for structured and unstructured data into common data mart and the enterprise information repositories. Work on different POC on latest technologies and scale them to project level. Develop the database performance monitoring process and analyze data for optimization opportunities. Analyze across multiple data domains and define strategies to reduce data redundancy, improve data availability, and accessibility by partnering with other teams and deliver a maintainable and reusable data architecture. Administer data transformation processing architecture. Partner with technology partners, including business analysts, release management, infrastructure, and other developers, at all levels. Utilize Agile methodology and adhere to coding standards, procedures and techniques while contributing to the technical code documentation. End to end projects via agile methodologies and working with the offshore team. This position does not supervise employees.
Minimum education required: Bachelor’s degree or equivalent in Computer Science, Engineering (any), or related technical field.
Minimum experience required: 5 years of experience in Database & ETL based application development, or related experience.
Skills Required: Must have Relational DB experience in Sybase, Oracle & SQL for writing queries and stored procedures. Must have experience in Logical and Physical Data Modelling experience. Must have experience in designing and building large scale data systems. Must have experience in Unix, Shell, Perl, or Python. Must have experience in ETL tools including Informatica or Pentaho. Must have experience in batch jobs development using tools such as Autosys, Control M, or CA or similar tool. Must have experience in source code management techniques including SVN/Git or similar tool. Must have experience with Object-oriented design & programming skills. Must have corporate industry experience. Must have experience with organizing multiple priorities and projects coupled with the flexibility to adapt to changes in a fast-paced environment. Must have experience with Agile and Waterfall SDLC Methodology to implement Data warehouse solutions. Employer will accept any amount of professional experience with the required skills.
Not ready to apply? Leave your information with us and we will keep you up to date with new career opportunities.
Sign in to our application system to continue your job search.
Current employees sign in here.
You can also apply using your LinkedIn® profile. It may save you some time because your information will be automatically transferred into our system. Just click on the LinkedIn logo when you get to the application screen and follow the directions.
During the application process, be sure you have an up-to-date copy of your Résumé, your cover letter and any other documentation you would like to submit.