JPMorgan Chase Associate/Software Engineer in Jersey City, New Jersey
Duties: Analyze business requirements and transform into functional requirements for IT solutions. Participate in project planning sessions with project managers, business analysts, and team members to analyze business requirements and to outline proposed IT solutions. Design and develop technical solutions including database schemas for large data sets that are efficient, scalable, maintainable, and cost-effective. Develop and support ETL workflow to meet project requirements. Develop scripts to automate the execution and deployment of ETL and database components using Shell and Perl scripts in a Unix environment. Extract data from various distributed and mainframe systems through different channels, applying data analytics and complex transformation and working on data warehouses. Develop, support, troubleshoot, and debug complex database objects like stored procedures, functions, triggers, and packages. Create and update Autosys scripts for job scheduling. Identify slow-running queries and perform SQL performance tuning. Document technical design and deployment plans as well as unit tests and test results. Adhere to best practices throughout the software development lifecycle. Deliver projects by coordinating across multiple teams.Minimum education and experience required: This position requires a Bachelor's degree (employer will accept either a 3-year or a 4-year Bachelor's degree) in Mathematics, Computer Science, or related field of study plus five (5) years of experience in the position offered or five (5) years of experience as Associate - Projects, Software Engineer/Developer, Programmer, or related occupation.
Skills Required: This position requires five (5) years of experience with the following skills: Informatica for ETL; database development and design experience in Oracle 9/10 or later database; PL/SQL; Perl; UNIX; Git, Subversion or any equivalent system for version control; ANT, Maven, or any equivalent system for build; Autosys for job scheduling; Jira, HP Quality Center (HP QC), or any equivalent tool for issue tracking; Toad and SQL Developer for SQL and PL/SQL; designing database models for large data warehouse or data mark including star, snow-flake schema, and cubing technology; working with complex data warehouse with large 5TB+ databases; scripting automation solutions using Unix and Perl scripts; utilizing Java to write and understand programs to extract data from DB or persisting to DB; writing complex stored procedures, functions, and triggers using SQL and PL/SQL; analyzing a query plan and identifying and fixing issues to tune SQL performance; resolving large-scale, complex production issues; and coordinating development and implementation of enhancements and changes to multiple applications.
JPMorgan Chase is an equal opportunity and affirmative action employer Disability/Veteran.