052112-01 TWSS - Sr. ETL & Oracle Pl/Sql Developer @ NYC, NY PDF  ICON_SEP Print ICON_SEP  Email
Written by   
DATE_FORMAT_LC2

Dear partner,

Please go through the below requirement and send me the suitable profiles with best rate and contact details to -- CLOAKING  

Submit Resume
First Name (*)
Invalid Input
Last Name
Invalid Input
Email (*)
Invalid Input
Job Position (*)
Invalid Input
Contact Number (*)
Invalid Input
Submit Resume (*)
Invalid Input
Submit

Job Title: Sr. ETL & Oracle Pl/Sql Developer

Location: NYC, NY

Duration: 9+ Months

Rate: Open

Responsibilities:

  • Design, develop and implement ETL solutions using Talend Integration Suite and Oracle PL/SQL
  • Architect core ETL functionality including, but not limited to: cleansing and quality handling, error event tracking, auditing, changing dimension management, fact/dimension providers, data propagation processes, parallelization and recovery/restart functions
  • Create and maintain documentation for ETL processes; source to target data mapping, operations run books, etc.
  • Perform process optimization tasks, including query and stored procedure tuning, process structuring and scheduling, schema adjustments, code refinements and scaling analysis
  • Perform technical problem assessment and resolution tasks

Skills & Experience Required:

  • 5+  years industry full cycle experience in ETL architecture design and development in an Oracle-based environment, preferably for asset / investment management firms
  • 5+ industry experience with ETL tools (such as Talend) and PL/SQL development
  • Strong knowledge of core ETL architectural principles such as modularity, cleansing and quality handling, error event tracking, auditing, changing dimension management, fact/dimension providers, data propagation process, parallelization and recovery/restart functions
  • Solid knowledge of data warehousing concepts: Dimensional Modeling – Fact and Dimension Tables, De-normalization / Normalization, Indexing Strategies, Physical & Logical Data Modeling, Slowly Changing Dimensions, etc.
  • Experience in integrating data quality toolsets with ETL processes
  • Knowledge in Data Analysis, Data Profiling, Data Management, Troubleshooting, Reverse Engineering and Performance tuning in various levels of the ETL Process
  • Experience in disciplines such as metadata and master data management a plus
  • Experience in SQL Server database development a plus
  • Experience with Scheduling Tools such as Cisco Tidal Enterprise Scheduler a plus

Thanks,


Mike Smith - Resource Manager

Thoughtwave Software & Solutions, Inc.

E-mail | Web URL| Linked-in 

Ph: 630-448-6681 Ext # 112 | Fax: 630-689-5746