JPMorgan Chase Bank, N.A.
Duties: Responsible for designing, developing, enhancing, modifying and maintaining of ETL based software applications under for Supervisory Controls in WM Technology. Analyze requirements and integrate application components. Performance software application maintenance and testing. Develop and enhance large Data warehouses for trading data and understand the entity relationship and dimensional modelling concepts. Extract, Transform and Load data primarily using tools like Informatica to develop highly efficient batch process that is well-documented. Map data elements from business requirements to RDBMS tables. Develop data flows diagrams, data models and data design specifications for managing RDMS based products like Oracle, Sybase. Work on sourcing data from global Trading platforms and external upstream systems and load into Actimize Data Mart (UDM) using Data Warehousing concepts like Facts and Dimensions.Utilize agile methodology and adhere to secure coding standards, procedures and techniques while contributing to the technical code documentation. Create and develop data definition language (DDL) and data modification language (DML) scripts and define roll back plans for releasing database changes to production. Adhere to ETL design, architecture standards, risk management and security policies. Fine tune Informatica Power Center (ETL) workflows to load data efficiently without breaching the service SLA for batch process. Work on optimizing the AutoSys jobs to comply with scheduling best practices as per company standards. Create oracle table partitions and perform PL/SQL performance tuning and suggested possible changes in Indexes to improve query performance. Work with users to understand business requirements and work with other technology stake holders for delivery of new supervision controls. Identify and communicate potential impacts of a change and issues. Work on resolving production defects, responsible for upstream issues or upstream SLA’s.
Minimum education and experience required: This position requires a Bachelor’s degree in Management Information Systems, Computer Science, or related field of study plus four (4) years of experience in the position offered or four (4) years of experience as an Application Developer, Software Engineer, or a related occupation.
Skills Required: This position requires four (4) years of experience with the following: ETL tools like Informatica to create complex load data from various upstream sources; database performance tuning skills to optimize SQL queries used for model runs; ETL based development tools like Informatica or Pentaho to extract, transform, and load data; ETL concepts, Data Warehouse, Data Mart and UNIX based infrastructure; build complex data load pipeline with multiple file dependencies; and relational database experience working with Data warehouses using products like Oracle 12c or Sybase. This position requires three (3) years of experience with the following: create UNIX shells scripts to invoke workflows and validate feed files. This position requires two (2) years of experience with scheduling tools like AutoSys or Control-M. This position requires one (1) year of experience with the following: writing complex PL/SQLs queries for data analysis, data profiling, and creating ad-hoc reports as per user requests.JPMorgan Chase & Co., one of the oldest financial institutions, offers innovative financial solutions to millions of consumers, small businesses and many of the world’s most prominent corporate, institutional and government clients under the J.P. Morgan and Chase brands. Our history spans over 200 years and today we are a leader in investment banking, consumer and small business banking, commercial banking, financial transaction processing and asset management.
We recognize that our people are our strength and the diverse talents they bring to our global workforce are directly linked to our success. We are an equal opportunity employer and place a high value on diversity and inclusion at our company. We do not discriminate on the basis of any protected attribute, including race, religion, color, national origin, gender, sexual orientation, gender identity, gender expression, age, marital or veteran status, pregnancy or disability, or any other basis protected under applicable law. In accordance with applicable law, we make reasonable accommodations for applicants’ and employees’ religious practices and beliefs, as well as any mental health or physical disability needs.
Equal Opportunity Employer/Disability/Veterans
To apply for this job please visit stackoverflow.com.