- Today's work recruitment is very aggressive, which is why should you perform wisely in fact it is not only a hard course of action. offers you probability to undertake it so you could help to make the proper decision within greater technique to find speedy and also much better end result. This way you'll get better probability in addition to better are living sometime soon. CSRA is amongst the firms that one could believe in to supply family and friends suitable along with far better dwell later on. Joining this provider is likely to make anyone in a position to attain your own objective simpler and produce your own aspiration becoming reality.

To make the business eyesight as well as mission happens correct; CSRA can be open intended for brand new situation seeing that Position as Data Integration Engineer (SQL Server, SSIS, NiFi and MongoDB) Companies CSRA in Bethesda, MD in January 2018 in Bethesda, MD begin with January 2018. Anyone who's considering stuffing this empty, please participate in that Position as Data Integration Engineer (SQL Server, SSIS, NiFi and MongoDB) Companies CSRA in Bethesda, MD in January 2018 January 2018 recruitment throughout Bethesda, MD. It's encouraged for everyone individuals to organize most necessary demands because of this career recruitment course of action, as the practice will be needing someone to give suited spec that this business wishes because of this position. If you feel that you are this can populate the standards, you can search you just read more information about Position as Data Integration Engineer (SQL Server, SSIS, NiFi and MongoDB) Companies CSRA in Bethesda, MD in January 2018 January 2018 in Bethesda, MD below.


Data Integration Engineer (SQL Server, SSIS, NiFi and MongoDB)

Company CSRA
Location Bethesda, MD
Update 9 Day ago
Clearance Level Must Currently Possess:

No Active Clearance Required

Clearance Level Must Be Able to Obtain:

No Active Clearance Required


Public Trust

Job Family:

Engineering & Sciences

Job Description:
CSRA has an opportunity for a Senior Data Integration Engineer with a focus on backend data flows design, development, and support. In this role, you will help migrate our ETL/ELT processes from the current system, using MS SQL Server Integration Services (SSIS) to load data into MS SQL Server, to a new system using Apache NiFi to load data into MongoDB. Additional responsibilities will include development of new processes for loading and manipulating data in order to ensure the data sources are efficiently and effectively connected with the NIH Biomedical Translational Research Information System (BTRIS Data Repository). On this program, CSRA helps to develop and manage a large data warehouse with over 19 billion rows of data collected from 50 different sources nightly for NIH clinical research studies. Our team follows a modified Agile methodology and is implementing continuous integration / continuous development (CI/CD). Position is for full time employment with CSRA and will be based at the NIH customer site off Democracy Blvd in Bethesda, MD. You can work a flexible schedule Monday through Friday around core business hours. Responsibilities : Design and develop NiFi workflows to replace SSIS packages Collaborate with the Technical Manager to plan, design and analyze performance of, integration routines to address data requirements from new data sources Provide guidance on strategies that minimize implementation risk and time and/or improve system reliability and performance Review integration solutions developed for compliance with best practices, standards, enterprise architecture and documentation requirements, ETL process, programs and scripts Conduct root cause analysis and resolve performance and production problems and data issues Validate the data in the database and test the routines developed Provide ongoing maintenance and support of assigned integration routines Establish and enforce data warehousing standards at the client site to meet client requirements and business needs Provide descriptive analyses of customer, product, and market trends and identifies and resolves data issues Perform quality assurance testing of data integration and report development Monitor data load operations to ensure accuracy Assist and/or provide limited direction to junior technical personnel Required Qualifications: Bachelor’s degree and 5+ years of experience in data integration and/or computer programming (or equivalent combination of education and experience) Experience with Extract, Transform, and Load (ETL) processes, including document parsing techniques and managing large complex data sets Experience with SSIS, or equivalent tool (such as Informatica, Talend, Pentaho, etc) Experience with MS SQL Server stored procedures, functions, cursors, and dynamic SQL Experience working with NoSQL Databases (preferably MongoDB) Experience with scripting languages (Python preferred) Experience working with industry standards, regulations and guidelines in database warehousing and other relevant systems Experience working with domain structures, user authentication, and digital signatures Good understanding of JSON Competencies: Proactive, self-starter, who takes initiative on projects Ability to articulate challenges, creatively solve problems and resolve ETL issues (should be able to give examples of complex projects) Great attention to detail Strong communication skills to interact with team members, clients, and support personnel Ability to work independently and as part of a team Desired : Degree in information science, data management, computer science or related field preferred 5+ years of experience in ETL/Data warehouse development. Highly skilled in SQL and capable of working with database administrator to enhance query performance. Experience with Apache NiFi is preferred Experience with multiple OS including UNIX, Linux, and Windows Experience with advanced SQL query writing, data retrieval, and data mining from relational databases, such as Microsoft SQL Server Solid experience in analyzing query performance issues and modifying data structures or application code to remedy performance problems Excellent understanding of relational and dimensional data models Experience with Netezza Data Warehouse appliances Experience with data replication in a distributed environment Experience with MS SQL Server Change Data Capture Experience with Elasticsearch Java programming experience Experience working in an agile environment #dicepost # of Openings: 1 Scheduled Weekly Hours: 40 T elecommuting Options: Telecommuting Not Allowed Work Location: USA MD Bethesda - 6707 Democracy Blvd (MDC035) Additional Work Locations: CSRA is committed to creating a diverse environment and is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability, age, or veteran status.