Summary: Under direction uses extract, transform, and load (ETL) methodologies to take data from one database to another during a conversion or for use in a data warehouse, and other related assigned duties.
Responsibilities:
Develops, tests and implements ETL jobs for warehouse, conversion, or other usage
Develops and deploys ETL job workflows with reliable error/exception handling and rollback framework
Supports operation and expansion of data warehouse and reporting environments
Adapts ETL code to accommodate changes in source data and new business requirements
Documents the ETL detailed design and test results and ensures data quality throughout entire ETL process
Manages automation of file processing as well as all ETL Processes within a job workflow
Collaborates with subject matter experts, department leaders and consultants to define and execute cross-functional data movements
Develops technical understanding of how the data flows from file to database, database to database, database to file and file to file
Analyzes and translate functional specifications and change requests into technical specifications
Promotes and enforces RDMS architectural principals, standards and processes via governance practices
Establishes and maintains change control policies, procedures, and documentation for all data interfaces
Must report to work on a regular and timely basis
Qualifications:
Training and Experience: Graduation from an accredited college or university with a bachelor's degree in computer science, mathematics, statistics, business administration, or other related fields; and three (3) years of progressively responsible experience in systems analysis and/or application or ETL development; or an equivalent combination of training and experience per Personnel Policies and Procedures, Section 128.
Knowledge, Abilities and Skills: Comprehensive knowledge of the methods and techniques used in systems analysis and related maintenance procedures; comprehensive knowledge of Structured Query Language (SQL), MS SQL Server DBMS, MS SSIS, MS SSRS, and Oracle DBMS and PL/SQL; and considerable knowledge of data processing concepts and techniques. Ability to independently recognize, analyze and solve system and database problems immediately; ability to use standard SQL and write SQL procedural scripts to query tables; ability to communicate effectively both verbally and in writing; ability to successfully use a graphical user interface, telephone, and pager.
Physical Requirements: Physical requirements include arm and hand dexterity enough to use a keyboard and telephone; frequent lifting up to 20 pounds; occasional lifting and carrying up to 60 pounds; occasional pushing and pulling up to 60 pounds; may be subject to sitting, walking, standing, reaching, bending, kneeling, crawling, handling, feeling, climbing, smelling, and twisting; and vision, speech and hearing sufficient to perform the essential tasks.
Licenses and Certificates: Possession of a valid Oklahoma Class "D" Operator's License
Working Environment: Working environment is primarily indoors in an office setting; and may require some travel to various City locations.
...processes for all Food & Beverage areas of the store.**At Target** **,** **we believe in our... ..., freshness and quality, inventory management, guest shopping patterns and pricing and... ...+ Lead team to uphold and maintain all Starbucks and Pizza Hut Brand Standards and...
...stoop, kneel, lift overhead, work at heights, walk/work in rough terrain in order to access equipment, tools, materials, and jobsite in order to complete work. # Initial project is located in Great Falls, Montana # Must be able to pass a drug test and join union....
...Summary Become a Showing Assistant and Elevate Your Real Estate Career Launch your journey in real estate by working alongside the top 20% of agents in North America. We offer a proven framework for success featuring efficient strategies, cutting-edge systems, vital...
...Account Representative (Entry Level) At Skyline Visions Inc, we put our people first. When people grow, business grows. For our clients... ... Utilize the best technology the industry can offer, SalesForce for better customer service and sales presentations Work...
...equipment manufacturer (OEM) supplier and service provider for advanced automotive diagnostic systems tailored for Hyundai and Kia dealerships in the North American market, setting the benchmark for excellence in the industry. We currently have exciting career...