JPMorgan Chase Associate, Software Engineering in Newark, Delaware
Duties: Provide ETL (Extract Transform and Load) design services, code development, implementation and support enterprise data integration. Facilitate ETL related data quality data management. Work with DBA and Technology Architecture to Optimize ETL Performance. Facilitate full product life cycle of new requests as necessary. Utilization of data integration and BI tools (Informatica, Business Objects) to integrate data across multiple interfaces for complex business solutions. Provide ETL repository administration services and enforce ETL object reusability. Develop Unix Shell Scripts for automation of ETL. Responsible for the development of ETL flows using Informatica, Oracle Database, PL/SQL, JAVA and web services in Informatica power center. Develop Datamarts and Datwarehouse using concepts of Data Warehousing, Real Time load processing and data Recovery procedures. Participate in Full Testing Cycle including bug fixes (Unit, Integration, System, User Acceptance and Production support). Participate in continuous improvement of the application, develop best practices and participate in companywide ETL initiatives as required.
Minimum education required: Bachelor’s degree or equivalent in Information Technology, Engineering, or related field.
Minimum experience required: 5 years of application development experience, or related experience.
Skills Required: Must have ETL design and development experience using Informatica Power Center and Power Exchange. Must have demonstrated knowledge of Relational Database Management Systems, Oracle, SQL Server and Sybase, PL/SQL. Must have demonstrated knowledge of ETL Repository Administration Services. Must have demonstrated knowledge of ETL related Data Quality Management. Must have Data Profiling experience. Must have experience with Datawarehousing Concepts and Dimensional Data Modelling. Must have demonstrated knowledge of Web services and JAVA/J2EE Application Development. Must have Unix Scripting experience. Must have demonstrated knowledge of automation and scheduling of jobs using Autosys. Must have experience with utilization of BI tool Business Objects for Data Analytics and Reports. Employer will accept any amount of professional experience with the required skills.
JPMorgan Chase is an equal opportunity and affirmative action employer Disability/Veteran.