Job Description :
Direct End Client: State of New York
Job Title: ETL Developer with Oracle experience
Duration: 24 Months
Start Date: July, 2017
Location: Albany, NY , 12210
Position Type: Contract
Interview Type: Telephonic Interview/Face to face/Skype
Cbiz requirement ID: SNY_ETL526_AA

Required Skills:
Minimum 48 months experience in writing and tuning SQL scripts including: tables, views, indexes, and complex PL/SQL objects including: procedures, functions, triggers, packages, and using Oracle supplied utilities including: SQL Loader, external tables, and Oracle built in packages.
Minimum 48 months experience working with Oracle 10G or later.
Minimum 48 months experience in writing technical specifications including ETL source to target mapping documents, use cases, software architecture documents, ETL design documents, implementation documents, and data model UML design using modeling tools like Rational Software Architect or ERWIN data modeler.
Minimum 48 months experience using ETL tools like Oracle Data Integrator and Oracle Warehouse Builder and migrating data from various sources and targets including databases, flat files, and XML files, UNIX shell scripts.
Minimum 36 months experience using Oracle Data Integrator 10g or later.
Minimum 24 months experience in design, development and implementation of business intelligence architectures with analytical and problem-solving skills including technical writing, presentation and communication skills.


Description:
State of New York - Information Technology Services (ITS)
Project: PSC_DCJ_PRJ0072633GF (NIBRS)

The Bureau of Justice Statistics (BJS) is seeking proposals from state Uniform Crime Reporting (UCR) programs to expand the state’s capacity to report incident-based crime data to the FBI’s National Incident-Based Reporting System (NIBRS
This position will design and implement software solutions and assure current and new technologies are effectively integrated to fulfill the business needs. This individual will be expected to provide expertise and hands-on participation in the following activities:

Responsibilities:
Manages and administers ETL solutions for medium to large scale data warehouse projects.
ETL application analysis, design, development and implementation, including: data analysis, data access, data structures, data manipulation, data reporting solutions, database, and technical and user documentation.
Act as an ETL technical liaison working with technical infrastructure teams to resolve problems and implement solutions to technical issues impacting application performance.
Work with the Infrastructure team to execute activities such as performance test planning and execution failure failover planning and execution, endurance testing and deployment planning and testing.

-
V Group Inc is an IT Services company which supplies IT staffing, project management, and delivery services in software, network, help desk and all IT areas. Our primary focus is the public sector including state and federal contracts. We have multiple awards/contracts with the following states: AR, CA, DE, FL, GA, IL, KY, MD, ME, MI, NC, NJ, NY, OH, OR, PA, SC, TX, VA, and WA. If you are considering applying for a position with V Group, or in partnering with us on a position, please feel free to contact me for any questions you may have regarding our services and the advantages we can offer you as a consultant. Please share my contact information with others working in Information Technology.
Website:
Twitter: VGroupITServices @VGroupITService
Facebook:


Client : State of New York

             

Similar Jobs you may be interested in ..