Kloudhire

ETL Developer Loc: Newport, KY

ETL Developer Loc: Newport, KY

Posted on : 09-08-2023
Job Type : Full Time only
Salary : 100,000 - 200,000

Job Description:

The ETL Developer will support the Business Analytics and Reporting Manager and other IT groups by extracting and manipulating data from mission-critical system databases and third-party data sources and exporting it to various data warehouses and data marts.
This position will report to the Director of Information Technology.Gathering, compiling and synthesizing information into a data warehouse for decision making and reporting.
Supporting the development and management of a data warehouse comprised of data imported from Oracle 11g Enterprise, Microsoft SQL server databases and various flat files imported from third party systems.
Migrating data using ETL technologies.Participating in possible overnight and weekend support during maintenance windows.
Reviewing business requirements and current data models to develop a framework that supports BI reporting/Data Warehouse.
Identifying gaps and developing tactical and strategic plans to support implementation of initiatives by working with a wide spectrum of key vendors and internal personnel.
This incorporates using innovative approaches to better serve the customer as well as improve processes.
Monitoring data warehouse performance and size with Oracle DBAs.
Qualified Candidates Should Be a Focused And Efficient Team Player, As Well As HaveProficiency in Oracle PL SQL, Stored Procedures, Stored Functions, external table manipulation.
Experience with performance tuning SQL .Experience with Oracle Data Integration (ODI) or similar data integration tools a plus.
Experience in process design, data profiling and analysis, data quality testing, data modeling, and entity design.
Experience with importing/exporting flat text files (CSV, TXT, TAB delimited, EXCEL, etc.).
General understanding of monitoring and analyzing database structures for efficiency and growth.
Experience creating Cron jobs.
Ability to produce concise Technical Documentation detailing all aspects of the project.
Strong experience with major operating systems such as UNIX, LINUX, Windows.Java, VB.net or other programming experience strongly preferred.
Demonstrated problem-solving abilities.Ability to work effectively in a fast-paced team environment, with short deadlines, and high customer expectations.
Ability to meet deadlines.Strong interpersonal skills, team work, technical writing ability, negotiation, and presentation skills.
Basic understanding of cellular networks or networking fundamentals a plus.
Experience with Oracle Business Intelligence or similar enterprise level reporting system a plus.
Experience with Microsoft SQL Server, T-SQL, Stored Procedures and Views a plus.

Latest Jobs

Oracle Cloud SCM Lead

Oracle Cloud SCM Lead

Location

Apply

Artificial Narrow AI

Artificial Narrow AI

Location

Apply

Artificial Narrow AI

Artificial Narrow AI

Location

Apply

Artificial Intelligence

Artificial Intelligence

Location

Apply

Artificial Intelligence

Artificial Intelligence

Location

Apply

PL/SQL Developer / Reports Dev...

PL/SQL Developer / Reports Dev...

Location

Apply

Featured Jobs

Data Scientist

Data Scientist

Location

Apply

Data Scientist Tech Lead

Data Scientist Tech Lead

Location

Apply

Oracle Manufacturing Consultan...

Oracle Manufacturing Consultan...

Location

Apply

Staff Data Scientist, Growth &...

Staff Data Scientist, Growth &...

Location

Apply

Java Lead Developer

Java Lead Developer

Location

Apply

Trending Jobs

Lead Azure Data Engineer

Lead Azure Data Engineer

Location

Apply

Team Lead

Team Lead

Location

Apply

Head of Engineering Operations...

Head of Engineering Operations...

Location

Apply

Data Analyst

Data Analyst

Location

Apply

Artificial Intelligence

Artificial Intelligence

Location

Apply

View All Jobs In This Company

Email Now

Send your resume at support@kloudhire.com