Need Datastage Developer in NY - 6 Months contract!

2015-12-23 Thread Adam Gill
*kindly reply to : adam.g...@itbtalent.com <adam.g...@itbtalent.com>*

*Need Datastage Developer in NY - 6 Months contract!*

Position : Datastage Developer
Location : NYC,NY*(Need Locals for onsite interview)*
Duration : 6 Months
*Need GC or USC!*

Principal Duties and Responsibilities:
Responsible for analyzing data requirements and developing ETL for clinical
systems. The individual in this role will work closely with data
architects, translate complex business data requirements into efficient ETL
packages, will understand and apply the concepts of proper ETL design, and
gain a strong understanding of source data to ensure the design approach
results in a logical and efficient ETL solution to support the Data
Conversion efforts.
Provide technical/user documentation and training; perform peer reviews of
work items produced at various stages of the project.
To design, build, program ETL procedures (DataStage/Unix)
Prepare Technical Design / Specifications; develop routines for data
extraction and loading
Assists in the identification and resolution of inefficiencies in ETL
designs
Determines and implements solutions for ETL design problems
Validates ETL designs for accuracy and performance, identifying
opportunities for improvement
Analyzes the impact of source system data design changes as they relate to
existing ETL solutions and makes appropriate changes to existing ETL
solutions
Performs analysis to prevent data redundancy across systems and employs
data integration best practices.
Performs data profiling, understands source data, and designs ETL solutions
to accommodate any nuances that may exist
Works with implementation team to ensure smooth deployment of packages and
ensures resolution of outstanding issues
ETL development using IBM DataStage
Interface with the business analyst to define technical requirements
Make recommendations on changes required to implement clinical systems
Familiarity with drafting a technical design documents
Prior experience with Master Data Management software and/or Data
Conversion processes in a complex healthcare setting (network of multiple
hospitals) is a plus
Assist the business in assessing the data requirements of the solution
Document the functional specifications of the solutions

Qualifications / Required Skill:
8+ yrs IT experience,   6+ yrs ETL experience
Strong DataStage Developer
QualityStage, Information Analyzer and other tools such as metadata
workbench is a plusPL/SQL,
T-SQL Scripts, UNIX Shell scripts, Stored Procedures, Triggers, etc.
Performance tune of large clinical databases, employing various techniques
such as schema bound views, database partitioning, and ETL/Query
optimization.
Extensive knowledge of data architectures related to large database
implementations geared towards OLTP

Thanks & Regards
Adam Gill | Sr. IT Recruiter
Direct: 609-423-4355
E-mail: adam.g...@itbtalent.com
Gtalk : adamg...@gmail.com
ITBrainiac Inc
Princeton Forrestal Village
116 Village Blvd,Suite 200
Princeton,NJ 08540
Website: www.itbrainiac.com

-- 
You received this message because you are subscribed to the Google Groups "SAP 
or Oracle Financials" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to sap-or-oracle-financials+unsubscr...@googlegroups.com.
To post to this group, send email to sap-or-oracle-financials@googlegroups.com.
Visit this group at https://groups.google.com/group/sap-or-oracle-financials.
For more options, visit https://groups.google.com/d/optout.


Need DataStage Developer in NY - 6 Months contract!

2015-08-20 Thread Adam Gill
*Kindly reply to my official ID : adam.g...@itbtalent.com
adam.g...@itbtalent.com*

*Need DataStage Developer in NY - 6 Months contract!*

Position : DataStage Developer
Location : NYC,NY(Need Locals for onsite interview)
Duration : 6 Months
*Need GC or USC!*

Description:
The ETL-data integration position has a detailed familiarity using IBM
InfoSphere DataStage extracting data (structure/unstructured) from multiple
data sources of varying complexity including flat file, relational, and
complex hierarchical systems. This role requires expertise in Business
Intelligence, Data Warehousing, Data Architecture, Data Analysis, Data
Modeling, Logical  Physical Database Design, Metadata, Reporting. Must
know IBM InfoSphere DataStage ETL in combination with Netezza/PureData
appliance.
Have used IBM Datastage for at 5-8 years, in a unix environment
Write Unix scripts
Write PL/SQL code and/ or knows stored procedures
Must know Netezza/PureData appliance
The Datastage Developer will be responsible for designing, developing,
testing and implementing data warehouse and other subscriber feeds for all
IBM InfoSphere DataStage ETL processes .
Using defined Source-target mappings, modify and create code compatible
with the data model and the Netezza system requirements. Maintain
documentation, project and resource management, performance tuning,
security.
Deliver design, development and validation of the IBM InfoSphere DataStage
ETL application to integrate enterprise data with business data warehouse
platform.
Participate in design and development reviews with business.
Work with Business and Technical teams to resolve source/target data issues
and manage life cycle of the enterprise transformation rules to ensure
integrity of data lineages.
Activities will involve participating in Business Requirements sessions,
project planning, assistance with functional and system specifications,
developing technical specifications, developing codes in the IBM InfoSphere
DataStage and other ETL platforms thorough unit testing, integration
testing  and implementation in production, including all required change
control.
Define development processes to manage life cycle of ETL codes with
multiple developers in multiple environments.
Production support of the overall ETL platforms and Data Warehouse related
issues. Includes availability for monitoring the data console and
responding to errors with SLA.
Define and implement process management of ETL job scheduling and ETL Job
dependencies, and job restart procedures.
Audit final ETL products against the data warehouse platform and the sources

Must Have:
IBM InfoSphere DataStage ETL development and data integration skills
Experience in a Netezza/PureData environment. Must be familiar with the
PureData system requirements for obtaining the best performance. Must be
able to analyze and tune existing jobs for efficiency.
Hands-on experience with reading and loading high-volume Type 2 dimensions
(SCD) in Multi-Dimensional Datamarts (Star  Schema).

Basic Qualifications:
5-7 years hands on experience in development of ETL programming in a major
platform using IBM InfoSphere DataStage 8.x version.
Hands on experience with Netezza or PureData
Ability to work in a collaborative environment that promotes a team-based
service atmosphere.
Seek opportunities continuously for improvement and suggest ways in which
procedures may be modified to accomplish tasks/goals efficiently and
effectively.
Effectively communicate technical concepts and work products orally and in
writing.
Broad knowledge of Business Intelligence Architectures, Methodologies,
tools and integration with ETL processes and workflows.

Thanks  Regards
Adam Gill | Technical Recruiter
Direct: 609-423-4355
E-mail: adam.g...@itbtalent.com
ITBrainiac Inc
Princeton Forrestal Village
116 Village Blvd,Suite 200
Princeton,NJ 08540
Website: www.itbrainiac.com

-- 
You received this message because you are subscribed to the Google Groups SAP 
or Oracle Financials group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to sap-or-oracle-financials+unsubscr...@googlegroups.com.
To post to this group, send email to sap-or-oracle-financials@googlegroups.com.
Visit this group at http://groups.google.com/group/sap-or-oracle-financials.
For more options, visit https://groups.google.com/d/optout.