Developer - Database/Data Integration Information

Job Details

[The logo is protected from the company]

(0) (0)

GlaxoSmithKline Pte Ltd

CTG was founded in 1966 by Randolph A. Marks and G. David Baer in Buffalo, New York. The new company specialized in providing computer programmers, designers, and managers to clients looking for outside expertise to set up their own computing systems. By 1969, when CTG went public, we were already one of the country's top 70 software companies. In the 1970s and early 80s, CTG set up branch offices in 45 North American cities. We began to expand overseas in 1986, acquiring a U.K.-based c... Read More

Address	800 Delaware Avenue, Buffalo, NY 14209
Website	www.ctg.com/
Holding	No Holding Details

View Company Page

Apply to job

Developer - Database/Data Integration

Our client in New York City has an opening for a Developer (Database/Data Integration) for a year-long contract assignment. (possibility of extension)

Monday through Friday, 35 hours/week

If interested, please immediately apply to this requisition.

For additional information please call the recruiter,

Kristy Jones at 888-414-6076 x5614.

All candidates will need to submit via our website for consideration to CTG job # 12203133. Thank you for your interest!

W2 ONLY. NO CORP-TO-CORP OR 1099.

SCOPE OF SERVICES

The Developer / Interface Specialist will be part of the project team that will implement a new system to integrate processes of multiple departments. Under this project, the consultant is required to integrate the software products of commercially-available off-the-shelf” (“COTS”) software products into a new system to replace the current system. While an objective of the initial implementation must be meeting the identified specifications, the Interface Specialist will also be creating a scalable, enterprise-wide solution.

Approximately ½ million records, going back to 1996 are in the current Operational Data Warehouse. Addresses are standardized in ODS but de-duplication of the entities needs to be done for allowing access to it by the new system. The de-duplication of entities needs to be done for at least the last Seven years of data. De-duplication would require the analyst to set up the matching process and to set up data correction procedures and coordinate with internal programs, working closely with programs over a period of 6 months. This will ensure that unique entities are identified and data is migration ready to be accessed by new system.

Qualifications

MANDATORY SKILLS

·         At least 4 years of overall development experience

·         Develop, design, implement, enhance, maintain and analyze database systems, queries, and procedures in Oracle 9i & up environment

·         Advanced expertise in building high performance data integration solutions, including extraction, transformation, and load (ETL) packages

·         Advanced expertise in data

·         Proficient in writing SQL queries, defining and manipulating Database schemas

·         Experience with Microsoft SQL Server database development using Microsoft SQL Server 2005 & above

·         Strong data analysis skills to ensure that data is properly converted from legacy database to new database

·         Familiarity with the exactness of data and able to compare data set, finding common or differing elements

·         Adhere to all the data management procedures

·         Experience in documentation of Conversion and Cutover strategy, plan and tests

DESIRABLE SKILLS

·         A Bachelors or Masters degree in MIS, Computer Science, or equivalent experience

·         Knowledge Database Tuning

·         Experienced with formal SDLCs and business analysis methodologies

·         Working knowledge of business analysis documentation standards