*Reply me on [email protected] <[email protected]>Job Title: Datastage with PL/SQLWork Location: King Of Prussia, PADuration: Long Term*
*Job description:* *Mandatory Skills: Datastage, PL/SQL, SQL Server, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS),* *Responsibilities:* • Experience in design, requirements gathering, timeline estimation, documentation, and testing of large-scale processes that ingest and extract data from warehouse and transactional database systems. • Designing, writing and debugging back-end SSIS packages used to handle input and output flat-file feeds, data transformations, and data loads into transactional and warehouse databases. • Designing, modifying and debugging SSRS reports. • Modifying and debugging nightly ETL SSIS processes. • Configuring SQL server jobs. • Provide assistance to on-call support teams as needed. • Create detailed design documentation from business specifications job Requirements • Experience designing and modifying large-scale ETL processes. • Strong knowledge of SSIS packages and familiarity with control flows, data flows, tasks, transformations, paths, merges, joins, script tasks, event handlers, data sources and data destinations. • Skills in debugging, tracing, and fixing issues in SSIS packages and Stored Procedures. • Working knowledge of custom SSIS script tasks and VBScript. • Experience working with large (100 million+) record data sets. • Working knowledge of SQL and TSQL • Knowledge in data warehousing concepts such as facts, dimensions, conformed dimensions, etc. • Working knowledge of DB concepts such as tables, indexes, locks, views, and stored procedures *Basic Qualifilication: *At least 7 years experience working with ETL processes ideally with the Microsoft SQL Server platform. Thanks & Regards *Syed Zameer*Direct: +1-678-250-9860 Toll Free: +1-888-8SYSTEL (879-7835) x 249 E: [email protected] E: [email protected] G: [email protected] -- You received this message because you are subscribed to the Google Groups "Oracle-Projects" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/oracle-projects. For more options, visit https://groups.google.com/d/optout.
