AlbanyNYRecruiter Since 2001
the smart solution for Albany jobs

IT Specialist-10190

Company: Optimal Solutions and Technologies
Location: Albany
Posted on: October 11, 2019

Job Description:

POSITION: IT Specialist-10190

Albany, NY

JOB ID: 3634-RCAT - 4



Optimal Solutions & Technologies (OST, Inc.) is focused on excellence. We specialize in providing Management Consulting, Information Technology, and Research Development and Engineering services. OST is one of an elite set of companies worldwide to be externally appraised CMMI Level 5.

The fundamental distinction of the OST team is its business knowledge in both the public and private sectors. We serve the aerospace & transportation, association & nonprofit, defense, education, energy, financial, healthcare, and technology & telecommunications industries. OST is successful because we listen to our clients, we learn from our clients, and we know our clients.


30 Months


8:00 am to 6:00 pm


Alfred E. Smith Building,80 South Swan Street, Albany, NY, 12210


1. Manages ETL solutions for medium to large scale data warehouse projects.
2. IT experience in 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.
3. Act as the primary ETL technical liaison working with technical infrastructure teams to resolve problems and implement solutions to technical issues impacting application performance.
4. 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.
5. Provide the analysis, design development, and code review enterprise applications using JAVA/JEE, JSF, XML, XSLT and the IBM Portal/Websphere Application development software.
6. Perform oversight of development activities which may include data analysis, data access, data structures, data manipulation, preparing logical database models, testing and implementation.
7. Prepare, and/or review technical documentation such as designs, schemas, etc, as appropriate.
8. Provide technical guidance to team of developers.

1. 84 months experience in writing and tuning SQL scripts including: tables, views, indexes, and complex PL/SQL objects including: procedures, functions, triggers, and packages.
2. 84 months experience using Oracle supplied utilities including: SQL Loader, external tables, and Oracle built in packages.
3. 84 months experience working with Oracle 10G or later.
4. 64 months experience writing technical specifications including ETL source to target mapping documents.
5. 64 months experience developing ETL/E-LT objects including Interfaces, Packages, Scenarios and Procedures and load strategies for relational, Type 1, 2, and 3 slowly changing dimensions using Oracle Data Integrator.
6. 48 months experience as a technical team lead responsible for data warehouse ETL components architecture.
7. 48 months experience using Oracle Data Integrator or Oracle Warehouse Builder to migrate data from various sources and targets including databases, flat files, and XML files.

OST is an equal opportunity employer. Applicants are considered for positions without regard to race, religion, gender, native origin, age, disability, or any other category protected by applicable federal, state, or local laws.

Keywords: Optimal Solutions and Technologies, Albany , IT Specialist-10190, Other , Albany, New York

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category

Other Other Jobs

Medicare Insurance Agent - Sell Advantage, license required
Description: Medicare Insurance Agent Industry-best comp plan, total work freedom Join the revolutionary ASSURANCE platform, and earn from the industry s best comp plan, selling trusted Medicare plans to inbound, (more...)
Company: Assurance
Location: Albany
Posted on: 10/20/2019

Educator - Entry-Level K-12 - Bachelor Required
Description: Teach For America works in 51 communities regions across the country. After attending your interview, you'll have the opportunity to choose and rank 10 regions where you prefer to teach.In joining (more...)
Company: Teach For America
Location: Springfield
Posted on: 10/20/2019

Parent Educator
Description: Job Description: ABOUT THE FAMILY RESOURCE CENTER Family Resource Center concept promotes comprehensive, integrated, community-based systems of family support and child development services located in (more...)
Company: The Village for Families and Children
Location: Springfield
Posted on: 10/20/2019

Call Center Representative
Description: At MassMutual, we re passionate about helping millions of people find financial freedom and this passion has driven our approach to developing highly personalized experiences for our customers. This role, (more...)
Company: MassMutual
Location: Springfield
Posted on: 10/20/2019

Field Investigator - Insurance Fraud
Description: Litigation Solutions, LLC is a growing private investigations firm that is in need of experience Field Investigators. THIS IS A REMOTE OPPORTUNITY IN HARTFORD, CT AND THE SURROUNDING AREA. Full time Position (more...)
Company: Litigation Solutions
Location: Springfield
Posted on: 10/20/2019

Amazon Delivery
Description: Amazon Holiday Delivery Driver br br Shifts: Early Morning, Day, Evening, Weekend br br Currently hiring for 10:30am - 8:30pm, Wednesday thru Saturday shift. br br Location: Holyoke, MA br (more...)
Company: Amazon Workforce Staffing
Location: Springfield
Posted on: 10/20/2019

Travel Dosimetrist - $3,100.00 per week
Description: NurseFly Travel Nursing with TaleMed Allied is seeking a travel dosimetrist for a travel job in Springfield, Massachusetts: br - Specialty: Dosimetrist br - Title: Therapy br - Start Date: 10/7/2019 (more...)
Company: TherapyFly Travel Therapy
Location: Springfield
Posted on: 10/20/2019

Insurance Sales - LIFE INSURANCE LICENSED REQ'D (Springfield,MA)
Description: CURRENT LIFE INSURANCE LICENSE REQUIRED TO BE CONSIDERED Are you an individual with a strong desire to succeed in the business world and help families at the same time We have a wide range of mortgage (more...)
Company: The Alliance
Location: Springfield
Posted on: 10/20/2019

Interviewing Now
Description: Our healthcare company is growing rapidly, and we are looking for people who are self-motivated and
Company: Garcia Healthcare
Location: Springfield
Posted on: 10/20/2019

Life Insurance Sales Representative - LIFE INSURANCE LICENSED REQ'D (Springfield,MA)
Description: CURRENT LIFE INSURANCE LICENSE REQUIRED TO BE CONSIDERED Are you an individual with a strong desire to succeed in the business world and help families at the same time We have a wide range of mortgage (more...)
Company: The Alliance
Location: Springfield
Posted on: 10/20/2019

Log In or Create An Account

Get the latest New York jobs by following @recnetNY on Twitter!

Albany RSS job feeds