carrierlist.co - Today's task recruitment is quite aggressive, that's why should you work properly which is not really a difficult activity. carrierlist.co will provide you with possiblity to do it therefore you would be able to make the best choice in far better strategy to obtain rapid as well as much better result. Because of this you'll get far better possibility and better reside down the road. CSRA is amongst the corporations that you could confidence to present you and your family appropriate as well as greater are living in the foreseeable future. Joining this provider will always make a person competent to accomplish your own target easier and help make your current aspiration become a reality.
To produce the business eye-sight in addition to quest arrives genuine; CSRA is actually open pertaining to completely new location as Position as Data Integration Engineer (SQL Server, SSIS, NiFi and MongoDB) Companies CSRA in Bethesda, MD in January 2018 within Bethesda, MD begin as January 2018. Everybody who's keen on filling this empty, remember to engage in that Position as Data Integration Engineer (SQL Server, SSIS, NiFi and MongoDB) Companies CSRA in Bethesda, MD in January 2018 January 2018 recruitment with Bethesda, MD. It truly is suggested for many participants to prepare just about all important needs just for this job recruitment treatment, because procedure need someone to allow suited spec the firm would like for this situation. If you are that you'll be one that could populate the particular specs, you can look at to read more info 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 6 Day ago
No Active Clearance Required
Clearance Level Must Be Able to Obtain:
No Active Clearance Required
Engineering & Sciences
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.