Back to search results

Oracle/ ETL Developer

Atlanta, Georgia;

Job Description:

**Candidates requiring visa sponsorship will not be considered for this position**

This position will be worked onsite at one of the listed locations only. No remote options available.

Role Description*

Seeking a developer who possesses both Oracle/ PLSQL and ETL skills who will be part of a technical consulting team. The role requires a developer with experience in a large enterprise environment that is detail oriented and has the ability to learn and grow with the position. The developer will be responsible for developing and delivering complex software requirements to accomplish business goals. Ensures that software is developed to meet functional, non-functional, and compliance requirements. Codes solutions, unit tests, and ensures the solution can be integrated successfully into the overall application/system with clear, robust and well-tested interfaces. Familiar with development and testing practices of the bank. Contributes to story refinement/defining requirements. Participates and guides team in estimating work necessary to realize a story/requirement through the delivery lifecycle. Performs spike/proof of concept as necessary to mitigate risk or implement new ideas. Codes solutions and unit tests to deliver a requirement/story per the defined acceptance criteria and compliance requirements Utilizes multiple architectural components (across data, application, business) in design and development of client requirements. Assists team with resolving technical complexities involved in realizing story work. Contributes to existing test suites (integration, regression, performance); Analyzes test reports, identifies any test issues/errors; Triages the underlying cause. Documents and communicates required information for deployment, maintenance, support, and business functionality. Participates, contributes and can coach team members in the delivery/release (CI-CD) events. e.g. branching timelines, pull requests, issue triage, merge/conflict resolution, release notes.

In addition, the developer will performs data and requirements analysis, prototyping, development, and education to deliver solutions. The developer will bring a strong data focus with an emphasis on ETL and databases, along with an understanding of data management practices.

The developer will have the ability to explore, profile and understand data, and will devise ETL and data management solutions using a combination of the best practice processes, techniques, and technologies. The developer will have the opportunity to explore and learn new tools as data management needs mature and evolve. The developer will communicate findings and recommendations to stakeholders.

Responsibilities*

As part of an internal shared technology services group providing consulting services to internal clients.

  • Serves as a fully seasoned/proficient technical resource. Will not have direct reports, however may provide technical leadership on projects and direct activities of a team related to projects. May collaborate with external programmers to coordinate delivery of software application. Routine accountability is for technical knowledge and capabilities.
  • Works under minimal supervision, with general guidance from more seasoned team members.
  • Drives process improvements and innovation
  • Interprets business requirements into design solutions
  • Understands design and development of project lifecycle
  • Designs the conceptual and physical data model
  • Adapts best Database design and coding standards
  • Database coding
  • Code Unit Testing and Component Integration Testing.
  • Creation and maintenance of system, functional and reference documentation.
  • Provide support during testing phases as required.
  • Conduct analysis and recommend bug fixes for production incidents
  • Performance tuning
  • Provide On-call support
  • Carry out daily health-check activities involving application checks, system checks, and database checks and related on production systems / servers
  • Report root cause of the incidents and present ideas on how to prevent the incidents from occurring in future
  • Ensure adherence to incident and change management processes

Required Skills*

  • Advanced software engineering skills with 5+ years deep hands-on programming experience in database programming and design using Oracle SQL, PL/SQL, stored procedures, triggers, partitions, primary keys, different indexes, views
  • Oracle SQL
  • Oracle PL/SQL
  • Database Objects
  • Performance Tuning
  • Linux/Unix shell scripting
  • Debugging and modifying existing application
  • Database design and development
  • Installing configuration of applications and maintaining environments
  • Experience in ETL Design and Development (expert knowledge and experience of developing using Informatica, DataStage or both)
  • Monitor performance, troubleshoot and tune ETL processes as appropriate
  • Develop ETL workflows using Informatica and/or Datastage for periodic data loads from source to target databases
  • Apply ETL principles and practices, and be able to implement complex solutions to problems
  • Designing and building scalable DataStage and/or Informatica solutions
  • Knowledge of data modeling, database design, and the data warehousing ecosystem
  • Skilled at the ideation, design, and deployment of DataStage and/or Informatica Solutions
  • Agile development methodology
  • Planning skills -- ability to think ahead and be proactive
  • Must be able to clearly and succinctly articulate progress, issues, solutions, plans, results, and success
  • Strong presentation skills - ability to tell the story to leaders and stakeholders
  • Ability to build strong relationships with people of all levels of the organization and influence to bring about positive change
  • Positive "can do" attitude
  • Continuous improvement mindset
  • Ability to encourage and accept feedback from all stakeholders with an open mind and take appropriate actions to follow up
  • Ability to provide technical leadership to initiatives and teams
  • Voracious learner
  • Intellectually curious
  • Person should be self-motivated, good written and oral communicator who can work with minimum supervision

Desired Skills

  • Autosys
  • Jira
  • Data Warehouse
  • Python
  • SQL*Loader
  • External Tables
  • Common Packages
  • Oracle Enterprise Manager (OEM)
  • Hadoop Components experience such as HDFS, Spark, Hbase, Hive, Sqoop
  • Dimensional modeling experience
  • Data Modeling tools experience, such as Toad Data Modeler

Any other details/Certification needs

  • Experience in financial services industry, especially with Bank of America, is a plus.

Job Band:

H5

Shift: 

1st shift (United States of America)

Hours Per Week:

40

Weekly Schedule:

Referral Bonus Amount:

0

Job Description:

**Candidates requiring visa sponsorship will not be considered for this position**

This position will be worked onsite at one of the listed locations only. No remote options available.

Role Description*

Seeking a developer who possesses both Oracle/ PLSQL and ETL skills who will be part of a technical consulting team. The role requires a developer with experience in a large enterprise environment that is detail oriented and has the ability to learn and grow with the position. The developer will be responsible for developing and delivering complex software requirements to accomplish business goals. Ensures that software is developed to meet functional, non-functional, and compliance requirements. Codes solutions, unit tests, and ensures the solution can be integrated successfully into the overall application/system with clear, robust and well-tested interfaces. Familiar with development and testing practices of the bank. Contributes to story refinement/defining requirements. Participates and guides team in estimating work necessary to realize a story/requirement through the delivery lifecycle. Performs spike/proof of concept as necessary to mitigate risk or implement new ideas. Codes solutions and unit tests to deliver a requirement/story per the defined acceptance criteria and compliance requirements Utilizes multiple architectural components (across data, application, business) in design and development of client requirements. Assists team with resolving technical complexities involved in realizing story work. Contributes to existing test suites (integration, regression, performance); Analyzes test reports, identifies any test issues/errors; Triages the underlying cause. Documents and communicates required information for deployment, maintenance, support, and business functionality. Participates, contributes and can coach team members in the delivery/release (CI-CD) events. e.g. branching timelines, pull requests, issue triage, merge/conflict resolution, release notes.

In addition, the developer will performs data and requirements analysis, prototyping, development, and education to deliver solutions. The developer will bring a strong data focus with an emphasis on ETL and databases, along with an understanding of data management practices.

The developer will have the ability to explore, profile and understand data, and will devise ETL and data management solutions using a combination of the best practice processes, techniques, and technologies. The developer will have the opportunity to explore and learn new tools as data management needs mature and evolve. The developer will communicate findings and recommendations to stakeholders.

Responsibilities*

As part of an internal shared technology services group providing consulting services to internal clients.

  • Serves as a fully seasoned/proficient technical resource. Will not have direct reports, however may provide technical leadership on projects and direct activities of a team related to projects. May collaborate with external programmers to coordinate delivery of software application. Routine accountability is for technical knowledge and capabilities.
  • Works under minimal supervision, with general guidance from more seasoned team members.
  • Drives process improvements and innovation
  • Interprets business requirements into design solutions
  • Understands design and development of project lifecycle
  • Designs the conceptual and physical data model
  • Adapts best Database design and coding standards
  • Database coding
  • Code Unit Testing and Component Integration Testing.
  • Creation and maintenance of system, functional and reference documentation.
  • Provide support during testing phases as required.
  • Conduct analysis and recommend bug fixes for production incidents
  • Performance tuning
  • Provide On-call support
  • Carry out daily health-check activities involving application checks, system checks, and database checks and related on production systems / servers
  • Report root cause of the incidents and present ideas on how to prevent the incidents from occurring in future
  • Ensure adherence to incident and change management processes

Required Skills*

  • Advanced software engineering skills with 5+ years deep hands-on programming experience in database programming and design using Oracle SQL, PL/SQL, stored procedures, triggers, partitions, primary keys, different indexes, views
  • Oracle SQL
  • Oracle PL/SQL
  • Database Objects
  • Performance Tuning
  • Linux/Unix shell scripting
  • Debugging and modifying existing application
  • Database design and development
  • Installing configuration of applications and maintaining environments
  • Experience in ETL Design and Development (expert knowledge and experience of developing using Informatica, DataStage or both)
  • Monitor performance, troubleshoot and tune ETL processes as appropriate
  • Develop ETL workflows using Informatica and/or Datastage for periodic data loads from source to target databases
  • Apply ETL principles and practices, and be able to implement complex solutions to problems
  • Designing and building scalable DataStage and/or Informatica solutions
  • Knowledge of data modeling, database design, and the data warehousing ecosystem
  • Skilled at the ideation, design, and deployment of DataStage and/or Informatica Solutions
  • Agile development methodology
  • Planning skills -- ability to think ahead and be proactive
  • Must be able to clearly and succinctly articulate progress, issues, solutions, plans, results, and success
  • Strong presentation skills - ability to tell the story to leaders and stakeholders
  • Ability to build strong relationships with people of all levels of the organization and influence to bring about positive change
  • Positive "can do" attitude
  • Continuous improvement mindset
  • Ability to encourage and accept feedback from all stakeholders with an open mind and take appropriate actions to follow up
  • Ability to provide technical leadership to initiatives and teams
  • Voracious learner
  • Intellectually curious
  • Person should be self-motivated, good written and oral communicator who can work with minimum supervision

Desired Skills

  • Autosys
  • Jira
  • Data Warehouse
  • Python
  • SQL*Loader
  • External Tables
  • Common Packages
  • Oracle Enterprise Manager (OEM)
  • Hadoop Components experience such as HDFS, Spark, Hbase, Hive, Sqoop
  • Dimensional modeling experience
  • Data Modeling tools experience, such as Toad Data Modeler

Any other details/Certification needs

  • Experience in financial services industry, especially with Bank of America, is a plus.

Shift:

1st shift (United States of America)

Hours Per Week: 

40

Learn more about this role

Full time

JR-22001481

Band: H5

Manages People: No

Travel: No

Manager:

Talent Acquisition Contact:

Geeta Upadhye

Referral Bonus:

0