Senior Engineer, Database Engineering
About The Position
DUTIES: Design, develop, and maintain ETL/Data Integration/Data Processing Flows using Oracle Data Integrator (ODI). Ensure data quality and integrity across various data sources and downstream applications. Design and implement data warehouse solutions to support business intelligence and analytics needs. Develop and maintain complex PL/SQL scripts and stored procedure. Perform database tuning and optimization ETL processes for performance and scalability. Utilize scheduling tools to automate and schedule jobs, ensuring adherence to necessary scheduling dependencies and execution sequences. Ensure timely and reliable data processing through effective job scheduling. Monitor job execution and troubleshoot any issues that arise. Utilize version control systems to manage codebase and track changes. Collaborate with cross-functional teams using project management tools like JIRA and TFS. Lead and participate in all phases of the project life cycle, from requirements gathering to deployment. Collaborate with business stakeholders to understand reporting requirements and deliver actionable insights. Support ETL Batch processing. Provide on-call support of Data Integration Batch processes on a rotating basis and other on-call as required. Perform other duties and responsibilities assigned. REQUIREMENTS: Bachelor’s degree in Computer Science, MIS, Business or related. Five (5) years in any occupation with Oracle Data Integrator (ODI) and experience in managing and optimizing ETL processes. Five (5) years in any occupation with Oracle Data Integrator (ODI) and experience in managing and optimizing ETL processes must include: Five (5) years of experience with PL/SQL development. Five (5) years of experience with Agile, Waterfall and Hybrid software development methodologies. Five (5) years of experience with Full Software Development Life Cycle (SDLC) . Four (4) years of experience with Building low latency Data Integration solutions. Four (4) years of experience with Prototyping and automating Data Integration Processes. Four (4) years of experience with Performance Optimization of Oracle Databases. Four (4) years of experience with Financial Services Industry. Three (3) years of experience with TFS, JIRA or any other requirements management tool. Two (2) years of experience with CI/CD practices and using software version control tools such as GIT.
Requirements
- Bachelor’s degree in Computer Science, MIS, Business or related.
- Five (5) years in any occupation with Oracle Data Integrator (ODI) and experience in managing and optimizing ETL processes.
- Five (5) years in any occupation with Oracle Data Integrator (ODI) and experience in managing and optimizing ETL processes must include:
- Five (5) years of experience with PL/SQL development.
- Five (5) years of experience with Agile, Waterfall and Hybrid software development methodologies.
- Five (5) years of experience with Full Software Development Life Cycle (SDLC) .
- Four (4) years of experience with Building low latency Data Integration solutions.
- Four (4) years of experience with Prototyping and automating Data Integration Processes.
- Four (4) years of experience with Performance Optimization of Oracle Databases.
- Four (4) years of experience with Financial Services Industry.
- Three (3) years of experience with TFS, JIRA or any other requirements management tool.
- Two (2) years of experience with CI/CD practices and using software version control tools such as GIT.
Responsibilities
- Design, develop, and maintain ETL/Data Integration/Data Processing Flows using Oracle Data Integrator (ODI).
- Ensure data quality and integrity across various data sources and downstream applications.
- Design and implement data warehouse solutions to support business intelligence and analytics needs.
- Develop and maintain complex PL/SQL scripts and stored procedure.
- Perform database tuning and optimization ETL processes for performance and scalability.
- Utilize scheduling tools to automate and schedule jobs, ensuring adherence to necessary scheduling dependencies and execution sequences.
- Ensure timely and reliable data processing through effective job scheduling.
- Monitor job execution and troubleshoot any issues that arise.
- Utilize version control systems to manage codebase and track changes.
- Collaborate with cross-functional teams using project management tools like JIRA and TFS.
- Lead and participate in all phases of the project life cycle, from requirements gathering to deployment.
- Collaborate with business stakeholders to understand reporting requirements and deliver actionable insights.
- Support ETL Batch processing.
- Provide on-call support of Data Integration Batch processes on a rotating basis and other on-call as required.
- Perform other duties and responsibilities assigned.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
Number of Employees
5,001-10,000 employees
