Home  Post Resume Quick IT Job Search  Advanced IT Job Search 
Skip Navigation LinksHome » Job Details
Staff IT
  Company Profile

 
  Job Details 
Title: 

Oracle ETL Developer : Oracle, ETL, Oracle 10G : Knoxville, TN

Posted On:  9/12/2019 1:47:18 AM
Designation: 

Oracle ETL Developer

No. of vacancies:  1
Qualifications:  Degree in technical field
Essential Skills: 
SkillsSpecializationYears
IT-4
Minimum Total Experience:  4
Job Tenure:  Full-time Only
Salary Offered:  DOE
Job Location:  Knoxville Tennessee United States

  Job Description
Functions and Responsibilities:

· Works with data architect to identify and understand source data systems
· Maintains maps of source system data to target system rules associated with ETL processes
· Develops and tests extraction, transformation, cleansing, and load (ETL) processes for data warehouse
· Defines and captures meta data
· Adapts ETL processes to accommodate changes in source systems and new business requirements
· Champions the use of ETL standards across the IT organization
· Maintain and enhance existing data extraction, cleansing, transformation, and loading processes to improve efficiency.
· Identify and investigate data quality/integrity problems, determine impact and provide solutions to problems.
· Manage ETL defects, enhancement, and new functionality requests to meet changes in the business needs.
· Create ETL deployment instructions including failure recovery procedure, and monitor successful data load of each ETL deployment.
· Assist Quality Assurance teams in developing test scripts and test plans for validating the quality/integrity of loaded data.
· Provide post-conversion/post-migration support and perform functional/data discrepancy analysis as needed.

Requirements:

· Proficient in designing, developing, and implementing ETL solutions and providing quality data services, Oracle Warehouse Builder preferred.
· Proficient in analyzing business/data requirements, writing metadata definitions, and writing data mapping specifications.
· Minimum 3 years experience in querying and analyzing data sources to understand the data and determine logic for data transformations.
· Familiarity with Oracle data warehousing features such materialized views, bitmap indexes, IOTs, external tables, etc. especially as ETL pertains to them
· Experience with Oracle 10G or 9I preferred
· Proficient in data analysis, defect identifications and resolutions
· Excellence in oral/written communications, interpersonal relations, and team cooperation


  Contact Information
Reference Name (If Any): 





 
Terms and Conditions | Privacy Policy | FAQ | Contact Us | Why?? | Link to us