Home  Post Resume Quick IT Job Search  Advanced IT Job Search 
Skip Navigation LinksHome » Job Details
ASC Technologies of CT, LLC.
  Company Profile
ASC can help you identify, recruit and hire temporary, temp-to-perm and full-time top technology professionals. Our standard practice of screening, interviewing and skill assessment testing each candidate as well as reference checks allows us to provide clients with the most appropriate and technically competent personnel.
 
  Job Details 
Title: 

ETL Developer : SQL, T-SQL, Workflows, CDC, Informatica : New York, NY

Posted On:  10/8/2020 2:52:26 AM
Designation: 

ETL Developer

No. of vacancies:  1
Qualifications:  Degree in technical field
Essential Skills: 
SkillsSpecializationYears
MS SQL 7.0/2000/2005-3
Informatica-3
ETL-3
Minimum Total Experience:  4
Job Tenure:  Full-time Only
Salary Offered:  DOE
Job Location:  New York NY United States

  Job Description
Responsibilities:

** Install and configure Data Integrator (DI) XI from Business Objects
** ETL coding in DI XI
** Ongoing support\maintenance for an existing ETL process
Requirements:
** Extensive experience in Data Warehousing implementation methodologies
** 1-3 years experience in DI tool
** 3- 5 years relevant experience in any other ETL tool (Informatica etc.)
** General database expertise (Ms SQL2005)
** Good knowledge of SQL language, preferably T-SQL
** Able to follow program specifications to write, test, debug, document, and implement complex Batch jobs and Real time jobs to extract data from a variety of data sources, transform the data, and load the data to specified destinations using Data Integrator XI (ETL).
** Know how to define database Data Stores and File Formats to allow Data Integrator XI to connect to the source or target database and files.
** Experience in performing simple and complex transformations in Data Flows.
** Ability to design and develop Data Integrator scripts for data transformation.
** Experience in cleansing data in DI using proper data types and mappings.
** Ability to create Workflows using object library and tool palette to execute data flows.
** Experience in Creating, Testing and Executing Data Integrator jobs using Data Integrator Designer to transfer data from source to target.
** Experience in debugging execution errors using Data Integrator logs (trace, statistics, and error) and by examining the target data.
** Expert in implementing Change Data Capture (CDC).
** Familiarity with scripting (Perl, Bash scripts, etc.)
** Bachelor's degree preferred

Pluses:
** 5-8 years of DBA experience
** Good knowledge of Business Object products (MDM in particular)
** Knowledge of various ETL techniques

Pass on to your friends too and check out www.iitjobs.com

# This position is for New York, NY, United States.

  Contact Information
Reference Name (If Any): 





 
Terms and Conditions | Privacy Policy | FAQ | Contact Us | Why?? | Link to us