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 solutionThis position will also conduct unit and system testingThe individual will monitor and research errors for the data warehouse odi load plans, data sync jobs and oracle analytic cloud (oac) platformAdditional activities include the delivery of etl requirements in conjunction with approved project efforts and decision support against the data warehouseIt is also expected that new software technologies are learned especially those that are consistent with our support requirementsThis 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 hoursThis includes resolving performance issues along with identifying potential future problems before they become criticalThis 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 reviewedThis 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 managementThe 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.sOr m.sIn 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 plusSpecific 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.gObia 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 supportSome 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.sAs well.
#li
Disclaimer:
This information describes the general nature and level of work performed by employees in this jobThe description is not designed to be a comprehensive inventory of duties, responsibilities and qualifications required in the jobReasonable 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 subsidiariesThe 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 communicationsSouthern company brands are known for excellent customer service, high reliability and affordable prices that are below the national averageThrough 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 customersSouthern company has been named by the u.sDepartment of defense and g.iJobs 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 networkThe 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 rankingsVisit 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 blvdNe (241atlanta)
241 ralph mcgill blvdNe
Atlanta, 30308
The energy center – 3535 colonnade parkway (3535birmingham)
3535 colonnade parkway
Birmingham, 35243
Req id: scs2010532
Hiring insights
Job activity
Posted 30+ days ago
Job Type: Full-time Company Description Career Banega HR Solutions is a leading Human Resources (HR) Solutions provider in India, located...
Apply For This JobAt branch, we`re transforming how brands and users interact across digital platformsOur mobile marketing and deep linking solutions are trusted...
Apply For This JobRemote: Hybrid Kellton is Hiring for Project Manager with HRMS Domain Experience for Mumbai Location.Experience : 12+ Year.Good knowledge of...
Apply For This JobJob description Looking for “Information Technology Analyst” with WFH option Job Title: Trainee System Analyst Location: Work from anywhere Experience:...
Apply For This JobUrgently Hiring Applicants must possess strong communication skills in both written and spoken English. If you meet this requirement, Then...
Apply For This JobJob Description Air Products is a thriving Fortune 500 global company that is growing and looking for hardworking, driven Digital...
Apply For This Job