Job Description:
Position Description:
Builds a data and reporting platform in the cloud using Oracle Business Intelligence Enterprise Edition (OBIEE) and PL/SQL. Builds, tests, and releases product features in Agile delivery environment using modern Object-Oriented Programming Languages -- Java, Scala, and Python. Manages data intensive application development, data integration, and data pipeline design patterns on a distributed platform. Supports use of Relational Databases such as Oracle Exadata 12c to analyze data. Manages batch job scheduling and dependency management using BMC Control-M for distributed systems. Provides business solutions by developing complex or multiple software applications.
Primary Responsibilities:
Develops original and creative technical solutions to on-going development efforts.
Designs applications or subsystems on major projects and for/in multiple platforms.
Develops applications for multiple projects supporting several divisional initiatives.
Supports and performs all phases of testing leading to implementation.
Assists in the planning and conducting of user acceptance testing.
Develops comprehensive documentation for multiple applications supporting several corporate initiatives.
Responsible for post-installation testing of any problems.
Establishes project plans for projects of moderate scope.
Works on complex assignments and often multiple phases of a project.
Performs independent and complex technical and functional analysis for multiple projects supporting several initiatives.
Education and Experience:
Bachelor’s degree (or foreign education equivalent) in Computer Science, Engineering, Information Technology, Information Systems, Mathematics, Physics, or a closely related field and three (3) years of experience as a Senior Software Engineer/Developer (or closely related occupation) building data and reporting platforms using Oracle Business Intelligence Enterprise Edition (OBIEE) and PL/SQL in a cloud environment.
Or, alternatively, Master’s degree (or foreign education equivalent) in Computer Science, Engineering, Information Technology, Information Systems, Mathematics, Physics, or a closely related field and one (1) year of experience as a Senior Software Engineer/Developer (or closely related occupation) building data and reporting platforms using Oracle Business Intelligence Enterprise Edition (OBIEE) and PL/SQL in a cloud environment.
Skills and Knowledge:
Candidate must also possess:
Demonstrated Expertise (“DE”) designing and optimizing joins in OBIEE stars within Rapid File Database (RPD) using Oracle Administration tool; designing and developing reports for business users using OBIEE; and implementing Dashboards and Paginated Reports in PowerBI using multiple data sources.
DE performing data engineering, migration, and modelling in a Cloud based data warehouse platform using Snowflake, Apache Airflow and AWS S3 containers (staging layer); and developing code, maintaining version controls, and performing automated deployments using CI/CD tools (GIT, Jenkins and UDeploy).
DE designing, developing, and delivering robust, efficient, and scalable database code and constructing with large datasets, using Oracle, PL/SQL, SQL Loader, DB2, Oracle Golden Gate Replication, Python, Java, Scala, Cloud technologies (MS Azure and AWS), and Snowflake automating repetitive processes using Unix Shell Scripting, and performing continuous development, integration, and deployment, using IDEM, GIT/STASH, Jenkins, and uDeploy.
DE designing and developing data pipelines for data warehouses, using ETL tools -- Informatica PowerCenter, Snaplogic and Alteryx -- and integrating the data pipelines with external PL/SQL, Python, and UNIX Shell scripting; creating and managing batch jobs, using Control-M and Informatica servers; and identifying bottlenecks in extract, transform, load (ETL) packages and providing best suited solutions.
#PE1M2
#LI-DNI
Certifications:
Category:
Information TechnologyFidelity’s hybrid working model blends the best of both onsite and offsite work experiences. Working onsite is important for our business strategy and our culture. We also value the benefits that working offsite offers associates. Most hybrid roles require associates to work onsite every other week (all business days, M-F) in a Fidelity office.