Oracle Database Developer

Insight Global; Chicago (IL); On-site; USD 95,000 - 140,000; Full time

Job summary

Insight Global is seeking an Oracle DB Developer to join a Bank of America facility onsite in Chicago, IL. The role focuses on design, development, and implementation of complex applications, with emphasis on robust source control and unit testing as part of the delivery process.

You will bring 5–10 years of Oracle Apps development with PL/SQL and 2–3 years of Informatica, plus strong SQL and shell scripting abilities to optimize performance and reliability across the data ecosystem.

Qualifications

• 5 to 10 years of Oracle Applications related development experience using PL/SQL.
• 2 to 3 years of Informatica development experience.
• Development and troubleshooting skills using SQL, PLSQL and Shell scripts.

Responsibilities

• Design, develop, and implement complex applications using the Oracle stack.
• Contribute across the application stack and follow team-best practices including source control.
• Build and debug code, and deliver unit tests to verify functionality.

Skills

Oracle PL/SQL

Informatica

Query tuning

SQL

Shell scripting

Tools

Informatica

Job description

Job Description

his specific role is required to be fulfilled onsite 5 days a week in a Bank of America facility.

Please put candidates' current location/intent on resumeApproved Location(s) + Rate(s):Source only in Chicago, IL.

Bank Job Title: Oracle DB Developer

Glider: candidate ID verificaiton

Position Summary:

We invite you to join the GIS team as an Oracle DB Developer. We are a tight-knit, supportive community passionate about delivering the best experience for our customers while remaining sensitive to their unique needs.In this role, you will be using the experience you have gained throughout your career to assist in the design, development, and implementation of various complex applications. We also like for our developers to feel comfortable contributing throughout the application stack and we believe it is important that you follow best practices established by the team, including proper source code control practices and delivery of unit test cases.Whether you are building applications from scratch, de-bugging existing code, or collaborating with various teams/team-members, for example, your skills will be tested and your knowledge-base will grow as you rise to meet the challenges.

Required Skills:

Oracle Development (PL/SQL)Informatica experienceAnalysis and Performance tuning of queries and scripts

Desired Skills:

Conducts logical and physical database designDesigns key and indexing schemes and designs partitioningConstructs and implements operational data storeAnalyze and Optimize query performanceEnsures that data models are consistent with the ecosystemAdheres to data management standards and advises on best practicesParticipates in building and testing business continuity disaster recovery procedures per requirementsHas experience with relational database internals, including both query processing and query planning, or other data processing infrastructureHas knowledge of key data structures and algorithmsHas knowledge of data modeling and understanding of different data structures and their benefits and limitations under particular use casesHas experience with dealing with data at scaleHas experience adhering to strict audit standardsHas experience with relational database management systems (e.g. Oracle)Has experience in different programming/scripting languages (e.g. python) and ETL tools (e.g. Informatica)Experience with Data Analysis and Science will be a plus, the ideal candidate should be able to understand the business driven off the data and how it fits into the Application platform

Skills and Requirements

5 to 10 years of Oracle Applications related development experience using PL/SQL.2 to 3 years of Informatica development experience.Development and troubleshooting skills using SQL, PLSQL and Shell scripts.

We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal employment opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment without regard to race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or the recruiting process, please send a request to [e-mail].