Phone/skype Hire
Location: Raleigh, NC Duration: 12+ months Rate: Open The client is seeking a contractor to perform in the capacity of Data Developer/ with strong technology and solution delivery experience. This individual will be accountable for the successful design, development, and delivery of ETL, data cleansing and data integration solutions using Microsoft and other leading platforms. This position will work closely with development teams, business, architecture, project management, business analysts, and QA areas. The scope of the ETL Lead role involves all aspects of the project life cycle from inception to implementation and support. Essential Functions: . Drive design and determine the ETL requirements for the project. Participate in functional design sessions. Ensure ETL design is implemented correctly by the development team. . Responsible for ETL design, optimization, development, and hand off to support. Develop reusable ETL components and routines that can be shared across multiple ETL processes. . Perform an active role in shaping and enhancing overall ETL architecture, including ETL standards, patterns and best practices. Work with the team to ensure standards and patterns are followed. . Act as recognized subject matter expert (SME) across regional or functional programs/applications/systems and as single point of contact for ETL. . Partner with the enterprise architecture team to implement the enterprise patterns. Work closely with the data architect to ensure the ETL architecture fits within the overall data strategy and architecture. . Mentor ETL developers and transfer ETL design and development knowledge. Support developers by providing technical assistance, troubleshooting and alternative development solutions. . Determine organizational strategies for data integrity validation processes. Recommend policies and best practices for optimizing ETL data throughput/accessibility. . Recommend a plan to expand ETL strategy and best practices from a project level to the enterprise level. . Remain current on new ETL techniques and methodologies and communicate trends and opportunities to management and other developers as needed. . Communicates risks & ensure understanding of these risks. Skills Needed: . 8+ years IT industry experience . 5+ years data integration and ETL experience with SQL Server Integration Services (SSIS) or other industry leading tools including ability to configure SQL Server agent . 8+ years of experience in SQL programming . 5+ years of experience in designing and developing ETL processes including naming conventions, connection to variety of systems and processing of large volume of data . 5+ years of experience in identifying and mapping data elements across multiple systems including creating templates and best practices to maintain the mapping information . Strong understanding of data integration, quality and validation . Understanding of MOM, Data warehouse/Data mart. . Experience moving data across different types of databases . Strong understanding of various data modeling techniques including party model, star and snowflakes schemas . Excellent written and verbal communication skills and be able to interact with multiple IT teams and business partners both formally and informally Preferred Skills: . Clear understanding and experience with Microsoft platforms, including Windows operating systems for both desktop and server, Microsoft Office, SharePoint, SQL Server, SQL Server Reporting Services, SQL Server Integration Services (SSIS) and Data Quality Services (DQS) and Master Data Services (MDS). . Knowledge of physical database administration with SQL Server . Experience in logical and physical data modeling . Reporting and analytics using SQL Server Reporting Services (SSRS) Thanks Sandeep Sandeep Jain Software People Inc. [email protected] Ph: 631-863-0299, 631-410-4741, 631-921-2111 C Fax: 631-574-3122 Twitter: Software People @spincjobs Certifications: SBA 8a/SDB, NY MWBE, VA SWaM, DE OMWBE, MA MWBE -- You received this message because you are subscribed to the Google Groups "Exact Match" 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/exact-match. For more options, visit https://groups.google.com/d/optout.
