*Please share resume to ch...@bourntec.com <ch...@bourntec.com>* *GC/USC*
*ETL Lead* *Dulles VA**2 to 3 year but the project will run in 5 different phases* *Responsibilities:*Design and develop/modify SSIS packages for extracting and importing data from internal systems into shared data repositories and applications to support the client’s data integration processes. This includes, but is not limited to the following tasks: Review and interpret source to target mapping specification documents, and communicate any gaps. Establish ETL framework and ensure standardized protocols are used and are based on the framework. Coordinate and conduct ETL team code reviews to ensure conformity to framework and overall solution and specification Identify subset of existing code that can be leverage as part of the ETL solution and ensure approach for re-use is consistent throughout the delivery effort Define unit test success criteria, develop unit test plan and test cases *Qualifications/Requirements:*BA/BS degree in Statistics, Engineering, Physics or Mathematics, Computer Science or equivalent practical experience. Advanced Degree preferred. *10 years of experience developing, designing and architecting enterprise scale solutions* *5+ years creating data warehouses/data marts* *5+ years of experience designing and architecting logical data models for enterprise class solutions*Minimum 5 years conceptual, logical, physical data modeling experience; Experience with data modeling tools Previous data architect roadmap development and execution Data integration, business intelligence reporting, data analysis, business rule management Solid understanding of all architectural components of a data warehouse *Experience with ETL tools such as Informatica, SSIS*Expert with SQL Experience with reporting/BI tools (SSRS) Data integration experience with ESB architecture a plus Working knowledge of common architectural patterns, design patterns and best practices Previous experience working within an Enterprise Data Management role including transactional Data, Analytical Data, and Data Governance/ Administration a plus Preferred background experience in Application Development, ETL Development, Report Development and/ or other Data Warehouse Projects ** Prefer candidates with financial industry experience. -- 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 https://groups.google.com/group/oraapps. For more options, visit https://groups.google.com/d/optout.