*ETL SSIS SSRS* *Columbus Ohio* *6 months contract to hire* *EAD GC/ Green Card/ US Citizen*
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 assstance to on-call support teams as needed. Create detailed design documentation from business specifications 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. At least 7 years experience working with ETL processes ideally with the Microsoft SQL Server platform. *Regard: Arnav Singh - IT Recruiter Direct: 609-388-1604 ar...@itbtalent.com arnavsing...@gmail.com* -- You received this message because you are subscribed to the Google Groups "oraapps" group. To unsubscribe from this group and stop receiving emails from it, send an email to oraapps+unsubscr...@googlegroups.com. To post to this group, send email to oraapps@googlegroups.com. Visit this group at http://groups.google.com/group/oraapps. For more options, visit https://groups.google.com/groups/opt_out.
