Etl/Bo Developer

Jpmorgan Chase & Co. Houston , TX 77020

Posted 2 months ago

ETL/BO Developer

Req #: 200025046

Location: Houston, TX, US

Job Category: Technology

Job Description:

"

Our Corporate & Investment Bank relies on innovators like you to build and maintain the technology that helps us safely service the world's important corporations, governments and institutions. You'll develop solutions for a bank entrusted with holding $18 trillion of assets and $393 billion in deposits. CIB provides strategic advice, raises capital, manages risk, and extends liquidity in markets spanning over 100 countries around the world.

As a member of our Software Engineering Group you will dive head-first into creating innovative solutions that advance businesses and careers. You'll join an inspiring and curious team of technologists dedicated to improving the design, analytics, development, coding, testing and application programming that goes into creating high quality software and new products.

You'll be tasked with keeping the team and other key stakeholders up to speed on the progress of what's being developed. Coming in with an understanding of the importance of end-to-end software development-such as AGILE frameworks-is key. And best of all, you'll be working with and sharing ideas, information and innovation with our global team of technologists from all over the world.

This role requires a wide variety of strengths and capabilities, including:

1.Advanced knowledge of application, data and infrastructure architecture disciplines

2.Understanding of architecture and design across all systems

3.Ability to collaborate with high-performing teams and individuals throughout the firm to accomplish common goals

4.Participate in Development activities, write ETL mappings/workflows, SQL queries, performance tuning etc.

5.Minimum 5 year experience in Informatica, Oracle PL/SQL, Unix scripting, scheduling tools such as Autosys

6.Minimum 5 year experience in Columnar Database like Vertica, Redshift is a must

7.Strong technical development experience on, effectively writing code, code reviews, best practices on configuration management and code refactoring.

8.Proficiency in SQL and Database development.

9.Strong problem solving and analytical skills



  1. A delivery focused approach to work and the ability to work without direction

  2. Ability to mentor team and instruct individuals to get best outcomes in various aspects of SDLC.

  3. Minimum 3 year experience in SAP Business Objects, Qlikview

  4. Experience in Agile development techniques like Scrum and Test Driven development

  5. Exposure to GIT, Maven, Sonar and JIRA desirable


"

"

Informatica

Vertica

Oracle

Business Objects

Autosys

"

"Our Corporate & Investment Bank relies on innovators like you to build and maintain the technology that helps us safely service the world's important corporations, governments and institutions. You'll develop solutions for a bank entrusted with holding $18 trillion of assets and $393 billion in deposits. CIB provides strategic advice, raises capital, manages risk, and extends liquidity in markets spanning over 100 countries around the world.

When you work at JPMorgan Chase & Co., you're not just working at a global financial institution. You're an integral part of one of the world's biggest tech companies.

In 14 technology hubs worldwide, our team of 40,000+ technologists design, build and deploy everything from enterprise technology initiatives to big data and mobile solutions, as well as innovations in electronic payments, cybersecurity, machine learning, and cloud development. Our $9.5B+ annual investment in technology enables us to hire people to create innovative solutions that will not only transform the financial services industry, but also change the world.

At JPMorgan Chase & Co. we value the unique skills of every employee, and we're building a technology organization that thrives on diversity. We encourage professional growth and career development, and offer competitive benefits and compensation. If you're looking to build your career as part of a global technology team tackling big challenges that impact the lives of people and companies all around the world, we want to meet you.

@2019 JPMorgan Chase & Co. JPMorgan Chase is an equal opportunity and affirmative action employer Disability/Veteran."



icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
ETL Developer (Supporting Nasa At Johnson Space Center)

KBR

Posted 4 weeks ago

VIEW JOBS 5/6/2020 12:00:00 AM 2020-08-04T00:00 Title: ETL Developer (Supporting NASA at Johnson Space Center) Position Description (PURPOSE/FUNCTION): The Human Health & Performance IT (HHPIT) Interface Developer will provide support for the design, development, testing and implementation of interfaces connecting systems for various users, including the JSC clinics, Space Medicine staff, and mission medical support teams. The general purpose of many of these systems is to support the accumulation, storage, display, analysis and exchange of human subject health and research related data between various groups. Software development activities may be performed using a variety of technologies, including HTML, JavaScript, Microsoft Visual Studio, SQL Server, XML, SQL Server Reporting Services, ASP.NET, C#, BizTalk, Pentaho, and SharePoint. However, the primary focus is on BizTalk and Pentaho, with other development languages being secondary. Responsibilities: * Know, and adhere to, KBR policies, procedures and work rules, and demonstrate a strong work ethic. * Maintain confidentiality of all medical and personal information to which access has been granted. * Participate in all areas of the design, development, testing, implementation, training and support of various application development projects according to applicable HHPIT work instructions & processes. (with a particular focus on ETL and interfaces). * Support the technical goals of the Application Development Team by working closely with the Architects in all application design and development phases. * Participate in design and planning meetings to support the technical infrastructure needs of various projects. * Meets and collaborates with business users on requirements and objectives * Develop ETL scripts in Pentaho Data Integration tool to move data from multiple source systems into a Hadoop based data warehouse * Participate in the integration of a hadoop based data warehouse with a modern, leading business intelligence platform * Lead the design of data model and meta data and data dictionaries across the enterprise * Develop and maintain a thorough knowledge of business processes supported by software systems/products * Analyze and document "as-is" and "to-be" scenarios (processes, models, use cases, plans and solutions) * Perform Source system analysis to identify the source data that needs to be moved into the target tables * Perform Data Analysis and Data validation by writing SQL queries * Identify new ways to standardize existing data processes and optimizing current workflows * Create custom data sets for use within our Analytics teams * Create Data Mapping documents, data dictionaries and Interface Control Documents (ICDs) * Manage data loads, and security, storage and performance strategies and implementations. * Serve as technical team member in the development of business intelligence reports and analysis, providing mentoring, guidance and troubleshooting to analysis team members in solving complex reporting and analytical problems * Devise ER diagrams and identifies unique foreign keys, entities, attributes, relationships and business rules for data warehouse. * Develop documentation of technical design specifications and as-built technical system documentation. * In cooperation with the Architects and other Application Developers, design all layers of proposed applications, including user interface, middle-tier and database, as well as interfaces between applications. * Develop code to support the requirements and design for all layers of proposed applications and interfaces, including user interface, middle-tier and database. * Conduct appropriate unit testing and system/integration testing of all developed applications and interfaces. * Assist with the proper coordination and conduct of user acceptance testing of all developed applications. * Work with users and technical support staff to coordinate and execute proper migration of developed applications into a production environment. * Assist in the development and delivery of user and/or technical support staff training on developed applications. * Support the adoption, implementation and constant continual improvement of accepted processes for software development, code migration and configuration control. * Assist in the evaluation, selection and implementation of commercial off-the-shelf (COTS) products related to all of the above. * Provide weekly status reports of work activities to Application Development Lead(s). * Create documentation to support all of the above, as well as additional items as necessary. * Develop, execute, and adhere to project plans and project schedules for all work as approved by the Application Development Lead(s), * Balance academic software development principles with practical constraints to meet project deadlines. * Ensure compliance with all applicable KBR and NASA standards and work instructions. * Establish, promote and maintain a service-oriented, customer-service focused culture that supports new custom development, COTS and sustaining activities. * Ensure that deliverables meet KBR and NASA quality standards. * Other duties as assigned. Responsibilities occasionally require work on weekends and/or evenings, sometimes with little to no advance notice. KNOWLEDGE, SKILLS & ABILITIES EDUCATION/EXPERIENCE 1. REQUIRED: The position requires a Bachelor's degree plus 6 years work experience in the information technology field, with a minimum of 4 years of most recent experience in application development of interfaces using Pentaho ETL. Experience with object oriented programming is required. Knowledge of, and experience with relational database design/development and analytical database design/development is required. Knowledge of, and experience with formal software development project management tools and methods is required. A proven ability to coordinate with team members, project staff, customers, users, and other stakeholders to successfully develop, conduct, and implement software development projects is required. The ability to communicate effectively, both verbally and in writing with personnel at all levels, both one on one and in groups, is essential. The flexibility to adapt to new development tools and technologies is essential. Candidates must be self starters who have a proven ability to work independently. 2. DESIRED: * Familiarity with AxioWorks and BizTalk 2016. * Prior NASA experience is desirable. * MCSD or other software development related certification is desirable. * Experience with software development in a medical environment is desirable. * Experience with modeling concepts and modeling tools is desirable. * Experience with integration tools and standards is desirable. B. SKILLS/TRAINING 1. REQUIRED: * Demonstrable experience in the following technologies is required: Pentaho, C#, HTML, Microsoft Visual Studio, SQL Server, basic SharePoint skills, XML, ASP.NET, JAVA and JavaScript. 2. DESIRED: * Experience with the following technologies is desirable: BizTalk, AxioWorks, SQL Server Reporting Services, Team Foundation Server, jQuery, Linux, SharePoint developer skills. * Also desirable is experience with HL7 Medical Data format. Scheduled Weekly Hours: 40 KBR is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, disability, sex, sexual orientation, gender identity or expression, age, national origin, veteran status, genetic information, union status and/or beliefs, or any other characteristic protected by federal, state, or local law. KBR Houston TX

Etl/Bo Developer

Jpmorgan Chase & Co.