Oracle ETL Developer

Description

Oracle ETL Developer

Job Summary:

The ETL Developer position will be responsible for the development, configuration, testing, optimization, and maintenance of Southern Company's Data Warehouse solution. This position will also conduct unit and system testing. The individual will monitor and research errors for the data warehouse ODI load plans, Data Sync jobs and Oracle Analytic Cloud (OAC) platform. Additional activities include the delivery of ETL requirements in conjunction with approved project efforts and decision support against the data warehouse. It is also expected that new software technologies are learned especially those that are consistent with our support requirements. This position leverages strong partnerships with the Technology Organization's business partners, the internal business support groups, the Project Management Office, Oracle Corporation, and other technical and consulting resources across the Technology Organization to ensure the delivery of timely and quality solutions and support.

The ETL developer will also be responsible for providing timely production and end-user support for our ETL solutions both during and after business hours. This includes resolving performance issues along with identifying potential future problems before they become critical. This position will also be responsible for creating technical programming specifications from business documents, creating internal program documentation, and participating in peer reviews as both a reviewer and as one being reviewed. This will include creating comprehensive documents that all members of the team may understand and execute.

This position will also be required to provide time/effort estimates, contribute to project planning, provide task and project status to end users, peers and management. The ETL developer will be asked to communicate issues and issue resolution to management and business partners in a clear, concise manner while managing multiple priorities.

As our Analytics footprint expands this position will be given the opportunity to help Southern Company grow in the Enterprise Data Warehouse space utilizing technologies such as ODI, to build solutions which are flexible, performant and scalable.

Education & Experience:

• B.S. or M.S. in Computer Science, Management Information Systems, Engineering, Mathematics or related field
• Background in Oracle 12c or 19c database, Windows and Unix/Linux operating systems is required.
• Possess 5-7 years of data warehouse experience.
• 5 years of ETL experience with Oracle Business Intelligence Applications (OBIA 11g) and BI Publisher; OAC is a plus. Specific experience within the context of Oracle ERP Cloud/EBS Financials, Projects, Human Resources is desired.
• Strong knowledge of ETL design best practices and data warehousing is required; to include performance optimization.
• Experience with development utilities such as SQL query tools and processes to support, test and verify tasks.
• Strong experience with Oracle Data Integrator (ODI) 12c in development, administration, and scheduling ODI load plans/scenarios.
• Experience with Data Sync 2.6 in development, administration and scheduling activities.
• Experience with high volume, complex relational databases.
• Experience in troubleshooting application availability issue; monitoring system performance and understanding error/session logs, and in proposing solutions to potential risks.
• Strong understanding of database concepts including views, tables and indexing
• Proficient with performance tuning of complex ODI scenarios and SQL queries for optimal performance
• Possess strong systems/process orientation with demonstrated analytical thinking, organization skills and problem-solving skills.
• Experience deploying ODI objects from source to target environment
• Deep understanding of dimensional modeling (star schema)
• Experience in documenting Mapping Specifications, Technical Specifications, Deployment documents and Operational Support Run/Play books
• Aptitude and willingness to learn new technologies
• Strong experience in database concepts for data modeling and mapping including referential integrity, indexes, keys, common dimensions, star schemas, master data and metadata
• The following job requirements are a plus -
• 3 years of experience with Oracle Business Intelligence Enterprise Edition (OBIEE 12c) supporting development, configuration, administration and performance improvement activities
• Experience with Data Sync 2.6 in development, administration and scheduling activities
• Experience with PaaS/SaaS integration to meet OAC requirements
• Experience with Oracle FAW
• BI development experience with Oracle Business Intelligence Applications (e.g. OBIA 11g) , OAC and/or Oracle Transactional Business Intelligence (OTBI). Specific BI experience with Oracle ERP Cloud/EBS Financials, Project, and Human Resources desired.

Knowledge, Skills & Abilities:

• Knowledge and experience with SDLC
• Ability to provide mentoring and training services for teammates and business partners
• Ability to partner with various teams to develop both ad-hoc and reporting solutions
• Ability to document and facilitate resolution of data related project issues
• Ability to build and effectively manage relationships within a large, multi-state organization
• Ability to estimate task or project costs and timelines
• Ability to manage production support and project related activities simultaneously
• Ability to negotiate and influence others within a team environment
• Ability to work effectively with a team
• Ability to work in a professional environment with limited direct supervision
• Ability to effectively move forward on tasks even with ambiguous or changing requirements.
• Ability to perform the analysis necessary to design and architect solutions that meet business partner requirements
• Strong analytical and problem-solving skills
• Strong communication and interpersonal skills
• Experience in development of clear and concise technical documentation
• Experience in requirement gathering

Behavioral Attributes

• Takes personal ownership of career development
• Demonstrates " Our Values " - Safety First, Unquestionable Trust, Superior Performance, Total Commitment
• Continuous learner with a high level of interest in learning and applying new technologies and concepts
• Result Oriented, can act with speed and decisiveness; take initiative and does what it takes to meet commitments.
• Strong focus on quality, reliability, efficiency, and cost effectiveness of solutions
• Effective in organizing tasks, managing multiple priorities, meeting schedules, and delivering on commitments
• Strong presentation skills and ability to relate and connect with a variety of audiences
• Methodical approach to solving problems

Other:

Candidate must be available weekends and after normal business hours for on-call support. Some travel may be required within the Southern Company footprint.

The core team is based out of Atlanta, GA; however, we are open to remote candidates that are based out of other locations in the U.S. as well.

#LI

Disclaimer:

This information describes the general nature and level of work performed by employees in this job. The description is not designed to be a comprehensive inventory of duties, responsibilities and qualifications required in the job. Reasonable accommodations may be made to qualified disabled individuals for performance of essential duties and responsibilities.

Southern Company (NYSE: SO ) is America's premier energy company, with 46,000 megawatts of generating capacity and 1,500 billion cubic feet of combined natural gas consumption and throughput volume serving 9 million customers through its subsidiaries . The company provides clean, safe, reliable and affordable energy through electric operating companies in four states, natural gas distribution companies in seven states, a competitive generation company serving wholesale customers across America and a nationally recognized provider of customized energy solutions, as well as fiber optics and wireless communications . Southern Company brands are known for excellent customer service, high reliability and affordable prices that are below the national average. Through an industry-leading commitment to innovation, Southern Company and its subsidiaries are inventing America's energy future by developing the full portfolio of energy resources, including carbon-free nuclear, 21st century coal, natural gas, renewables and energy efficiency, and creating new products and services for the benefit of customers. Southern Company has been named by the U.S. Department of Defense and G.I. Jobs magazine as a top military employer, recognized among the Top 50 Companies for Diversity by DiversityInc, listed by Black Enterprise magazine as one of the 40 Best Companies for Diversity and designated a Top Employer for Hispanics by Hispanic Network. The company has earned a National Award of Nuclear Science and History from the National Atomic Museum Foundation for its leadership and commitment to nuclear development and is continually ranked among the top energy companies in Fortune's annual World's Most Admired Electric and Gas Utility rankings. Visit our website at www.southerncompany.com .

Southern Company is an equal opportunity employer where an applicant's qualifications are considered without regard to race, color, religion, sex, national origin, age, disability, veteran status, genetic information, sexual orientation, gender identity or expression, or any other basis prohibited by law.

Job Field: Information Technology

Job Type: Standard

Primary Location: Georgia-Metro Atlanta-Atlanta

Operating Company: Southern Company Services

Other Locations: Alabama-Metro Birmingham/Eastern AL-Birmingham

Job Type: Standard

Travel (Up to): No

Work Location(s):

Georgia Power Headquarters - 241 Ralph McGill Blvd. NE (241ATLANTA)

241 Ralph McGill Blvd. NE

Atlanta, 30308

The Energy Center - 3535 Colonnade Parkway (3535Birmingham)

3535 Colonnade Parkway

Birmingham, 35243

Req ID: SCS2010532