ETL Developer with Security Clearance

Praescient Analytics
District Heights, MD
Sep 24, 2021
Sep 26, 2021
Full Time
Praescient Analytics, LLC is a Veteran-led, certified Woman-Owned Small Business (WOSB) founded in 2011 which specializes in implementing advanced analytics solutions across the defense, intelligence, and law enforcement communities. With over 40 contracts across 6 continents, over 70% of our employees are veterans and or have intel/law enforcement experience. We fully understand the unique challenges of our clients and work to identify, vet, implement, and enhance commercial and proprietary technologies to provide full scope solutions. Praescient has extensive experience designing, developing, and integrating solutions for customers including the US Army, Special Operations Command (SOCOM), US Navy (USN), US Marine Corps (USMC), US Coast Guard (USCG), Department of Justice (DOJ), Drug Enforcement Administration (DEA), and Federal Bureau of Investigation (FBI), Immigration and Customs Enforcement (ICE), Intelligence Community, state and local law enforcement agencies, among others. The Return Review Program (RRP) performs automated Identity Theft (IDT), Income verification, tax compliance and pre-refund anomaly detection and fraud detection. RRP continues to evolve and enhance system capabilities, providing greater security for the Internal Revenue Service (IRS or Government) and our nation's taxpayers, leading the charge against IDT and the filing of fraudulent returns. To keep pace with the complex, ever-evolving world of tax fraud, the RRP program has embraced the Agile framework in support of more frequent and rapid delivery. This enhances the Government's ability to respond to IDT and fraud threats by quickly updating analytical tools to protect taxpayers' identities and prevent refunds from falling into the wrong hands. The program is improving both individual and business tax return anomaly & fraud detection with more sophisticated capabilities for data comparison/data analysis through its filters, predictive models, data visualization and using data computing appliances. The goal is to create predictive fraud and non-compliance detection models using vast amount of data from various sources that will seek out subtle data patterns to determine reliability of return data. Praescient Analytics is in search of an ETL Developer to support activities for RRP, including, ongoing continuous improvement and repetitive IT products and services to sustain RRP in production. Primary Responsibilities: * Develop, implement, configure, and administer ETL processes for large scale data warehouses using Informatica * Use Informatica to create validation process to validate data conversions * Maintain and monitor Unix/Linux file system for ETL project * Support Schema Modeling for data ingestion * Create SQL scripts/queries for data verification * Monitor testing and ensure defects are being entered, tested and closed * Document and maintain testing results and test logs * Enable restoration of ETL application in case of server crash or degradation * Manage internal client needs and expectations ensuring issues are identified, resolved and escalated quickly and appropriately * Communicate known problems and fixes to team members and other technical groups Required Qualifications: * Active Public Trust Clearance * Bachelor's degree (preferred in Computer or Data Science) * Experience working with: * Graph database, Kibana, Neo4J, Elastic Search, Angular and related frameworks * Informatica Power Center latest version including the Repository Manager, Designer, Workflow Manager, Workflow Monitor, and the web-based Admin Console * Informatica PowerExchange * Informatica Data Transformation (B2BDT studio) * Business Objects Enterprise (BOE) and other visualization tools (Tableau, Palantir) connecting to elastic search. * Information Design Tools (IDT) What you can expect from us: * Real opportunity for career growth in an environment where your achievements will be celebrated * Constant collaboration with numerous teams to ensure client success * A team that respects and embraces your ideas and expertise * Coworkers that are motivated by pursuing excellence, rather than the prospect of personal gain * A workplace dedicated to supporting and bettering public safety and government agencies Benefits: * Very competitive salary based on qualifications and experience * Comprehensive, Company paid United Health Care Medical for you and your family (We pay your premiums and deductibles) * 401(k) & 4% matching * Travel & performance incentives * 3 weeks paid time off (plus Federal Holidays) * $5K annual training allowance * $500 book allowance * Tuition reimbursement program Praescient Analytics is committed to providing equal employment opportunities for all. Employees and applicants without regard to race, color, age, religion, sex, sexual orientation, marital status, gender identity, national origin, legally protected physical or mental disability, genetic information, citizenship status, or status in the uniformed services of the United States, status as a disabled veteran or veteran of the Vietnam era, or on any other basis which is protected under applicable law. This includes a commitment to provide a work environment that is free from all forms of illegal harassment including sexual harassment. This covers all terms and conditions of employment including (but not limited to): * Hiring, placement, promotion, transfer, or demotion of all job classifications; * Recruiting, advertising or solicitation for employment; * Treatment during employment; * Rates of pay or other forms of compensation; * Benefits; * Selection for training; * Company sponsored social and recreational activities; and * Layoff or termination Applicants selected will be subject to a government security investigation and must meet eligibility requirements for access to classified information. US Citizenship Required Praescient Analytics is an Equal Opportunity Employer. Interested Candidates: Please forward your resume to and please visit our website to apply online at

Similar jobs