Job: ETL/DW Developer
Client: STATE OF OH Franklin County Children's Services
Location: Columbus, OH. Candidates need to be local to Columbus and available for Hybrid work.
Duration: 6-12 Months or longer
Visa: USC,GC
Interview: Skype
Required
- 6 Years of development experience related to ETL/DW
- Experience with ETL on Oracle DB
- Understanding of Star Schema Concepts
- Local to the Columbus, OH Area
Franklin County Children Services (FCCS) seeks a Data Warehouse Software Developer that also has programmer skills with ETLs (Extract, Transform, Load) from Oracle databases, Star Schema data warehouse concepts.
Key Points
- Software development, data warehousing tools, oracle database table builds, ETL ( extract, translate and load)and star schemas.
- DW additional information:
- Publish IT Enterprise Artifacts
- Creates/edits/researches IT artifacts including policies, position papers, standards, procedures and best practices
- Ensures that all new and existing processes are well documented
- Solutions Design
- Works with the Technical Talent Pool, IT Managers and the IT Director to design solutions that meets the agencies requirements
- Assists with the analysis of the solution design’s business case
- Solution Fulfillment
- Implements/assists in implementing the high level solution design
- Data Confidentiality, Integrity and Availability
- Ensures all enterprise data is consistent in form and access across all systems (i.e, SharePoint, OnBase)
- Work to make sure that data flow across the aforementioned data repositories is consistent and accurate
- Ensures that enterprise data and applications that access it is always available to the end users and is timely and accurate
- Leads initiatives that safeguard confidential data in the enterprise
ADA Requirements
Equipment in use in job performance: Personal Computers, servers, network components, telephones, calculator, copy machines, printers, faxes, cell phones and common writing devices. Must be able to lift 50 pounds. Must be able to work from a step ladder.