SQL Developer

Company: Seneca Resources
Location: Arlington
Posted on: February 18, 2021

Job Description:

This organization is looking for an Applications Developer to serve on the ODS BI Reporting team for this large, complex task order. The successful candidate will support the OBIM data warehousing and business intelligence (BI) environment and reporting capability in GovCloud.--You are expected to apply your extensive technical expertise and knowledge in the continued development of data and BI report validation processes.--You will apply your development skills to streamline our current data validation regime across multiple databases and environments.--You will create Informatica ETL mappings and workflows based on existing templates.--You will develop Oracle and Redshift tables and create Informatica mappings and workflows to perform high volume sampling data validation.--You will perform exception analyses for data count and/or data value discrepancies.--You will use you application skills to automate and stream-line validation methods and reporting.--You will present findings and work with team on mitigations.--You may also validate Business Intelligence reports.Specific responsibilities include but are not limited to:--- Perform daily data validation of ETL processes for staging and datamart.--- Perform exception analyses on daily validation results.--- Manage and maintian data validation and analyses.I--- mplement automated solutions to improve and streamline validation methods and reporting.--- Work across heterogeneous platforms - On-prem Oracle, AWS/GovCloud Redshift.--- Based on existing ETL mappings, create additional etl mappings and workflows to run validation samples.--- Perform Business Intelligence report validationRequired Skills / Qualifications:--- U.S. citizen--- DHS HQ EOD required to start; must be able to obtain DHS HQ Final Suitability--- 4022SC-Associate's Degree or higher and/or 5-15 years experience.--- Develop SQL Queries and PL/SQL Programs, MS Excel/VBasic functions, Linux scripting, cron jobs.--- Data validation/quality experience--- Manage validation of up to 200 + tables--- Capture the artifacts (Text and/or MS Excel formats) in SharePoint and manage them.Desired Skills / Qualifications:--- AWS, S3, and Redshift experience-----Experience with Informatica PowerCenter, AWS DMS.--- Experience with BI tools, e.g. Birst, Quicksignt, others--- Experience with DHS vetting-related data and/or application solutions--- AWS certification.

Keywords: Seneca Resources, Arlington , SQL Developer, IT / Software / Systems , Arlington, Virginia