ETL Developer

Every day CSRA makes a difference in how the government serves our country and our citizens. We are inspired by the important missions of our customers and we believe that by working together we can deliver exceptional solutions and services to enable the safety, security, health and well-being of our nation.

CSRA is seeking a Senior level ETL Developer with a focus on ETL design, development and support. This individual will be responsible for ETL processes and tools as well as database loading and manipulation to ensure that the data sources are efficiently and effectively loaded into the NIH Biomedical Translational Research Information System (BTRIS Data Repository).

* Collaborate with the Technical Manager to plan, design and analyze performance of ETL programs to address data requirements from new data sources * Provides guidance on strategies that minimize implementation risk and time and/or improve system reliability and performance * Reviews ETL programs developed for compliance with best practices, standards, enterprise architecture and documentation requirements, ETL process, programs and scripts * Validate the data in the database and also responsible for testing the routines developed * Provide ongoing maintenance and support of assigned ETL applications * Determines data warehousing strategy; selects tools and techniques, including middleware, data cleansing tools, and/or data management systems to provide the solution to data and client issues and other matters of significance and to meet business needs. * Conducts research into new data warehouse applications and determines viability for adoption. * Assists in several components of the overall architecture of the data warehouse system. * Documents tasks for end-user, technical, and managerial review to ensure high quality customer service. * Provides descriptive analyses of customer, product, and market trends and identifies and resolves data issues. * Performs quality assurance testing of data integration and report development. Monitors data load operations to ensure accuracy.

* Bachelor's degree or equivalent combination of education and experience * Bachelor's degree in engineering, computer science, business administration, software engineering or related field preferred * Seven or more years of database engineering, design, development experience * Experience working with relational data modeling * Experience working with data warehousing * Experience working with relational databases such as SQL, PL/SQL, Oracle, etc. * Experience working with database development methodologies, design and implementation **Other Qualifications** * Must be able to obtain and maintain a Public Trust background investigation. * At least 2-5 years of experience in ETL/Data warehouse development. Experience with ETL development for large, complex data sets preferred. * Highly skilled in SQL and capable of working with database administrator to enhance query performance. * Experience in SQL Server 2008 preferred * Solid experience in analyzing query performance issues and modifying data structures or application code to remedy performance problems * Advanced knowledge of integration technologies such as Web Services and messaging systems * Python programming experience * Excellent understanding of relational and dimensional data models * Experience with SSIS development preferred * Strong skills in data administration, repository management, and data warehousing * Good analytical and problem solving skills * Good communication skills * Good personal computer and business solutions software skills * Good, demonstrated skills in using a Windows development language, programming or scripting such as VBScript, COM, COM+, XML, Java, Perl, etc. * Good interpersonal and human relations skills to interact with clients and less experienced personnel * Ability to comprehend and integrate business unit/client needs into appropriate database system