Software Engineering #210053700
Software Engineering (210053700) Jersey City, NJ.
Duties: Responsible for design, development and delivery of strategic data-centric applications leveraging the firm’s next generation ETL (Extract-Transform-Load) and reporting technologies. Build solutions for a magnitude of applications, including batch processing, OLAP and data warehouse architecture. Architect, standardize and support technology platforms using industry leading Business Intelligence/Reporting solution vendors. Integrate data from multiple data stores, profile the data for quality, cleanse it and apply transformation rules as per the business need. Leverage Data visualization tools like Qliksense and Tableau to create interactive enterprise dashboards and apply cutting-edge visualization techniques. Utilize database design techniques, dimensional modeling best practices and advanced SQL and NoSQL skills to develop backend data models for application specific enhancements. Write Oracle database scripts including complex stored procedures, triggers, functions and performance tune the database as needed. Automate and schedule data process flows through Control-M and Autosys. Explore new ETL technologies and perform proof of concepts to take advantage of advancements in technology. Utilize agile methodology for project delivery and adhere to coding standards, procedures and techniques while contributing to technical code documentation. Collaborate with multiple stakeholders to understand the business requirements and come up with a highly scalable, resilient and reusable solution. Resolve Level 3 production issues and recommend preventive actions.
Minimum education and experience required: This position requires a Bachelor’s degree in a scientific or quantitative field of study plus five (5) years of experience in the position offered or five (5) years of experience as a Systems Engineer, Software Engineer/Developer or related occupation.
Skills Required: This position requires five (5) years of experience with: Informatica Powercenter; ETL; and SQL. This position requires two (2) years of experience in the following: Relational Databases such as Oracle or Sybase; Database Design and Dimensional Modeling; ETL design for Data warehouses and Data Marts; PL/SQL; Performance tuning techniques; Unix Scripting; Qlikview; SAP Business Objects; JIRA; and Version Control.
EOE, AAE, M/F/D/V. JPMorgan Chase & Co. All rights reserved.