SENIOR ETL DEVELOPER WITH SECURITY CLEARANCE

Spalding Consulting, Inc. is seeking a Senior ETL Developer in Lexington Park, MD. Spalding Consulting, Inc. is a professional services company delivering cutting-edge solutions to the Department of Defense since 2001. Our expert-level solutions include software development, information technology, program management, financial management and business intelligence services. Spalding Consulting offers competitive compensation, career development, flexible work schedules and excellent benefits. Position Type: Full-Time Work Location: This is a remote position (see on-site requirements below). **On-Site Requirements: On-boarding will require 1-2 visits to Patuxent River, MD for candidates that are local to the area. Candidates out of state will be onboarded virtually. Training will be virtual and telework maximized/permitted to the greatest extent possible, however for local candidates, training/tasking may require on-site work a few hours per week. Future on-site/telework requirements/schedules may change as additional client direction is received. Essential Functions: * Participates in extracting, transforming, and loading of data from various source systems into a data warehouse. * Participates in all phases of life cycle development, including analysis, design, development, testing, implementation, and documentation. * Creates and maintains scripts, procedures, and functions. Participates in software design, code, and release reviews. * Other duties as assigned or required. Qualifications and Experience: Required: * 10 years of hands-on programming experience required. * Ability to program complex queries, macros, stored procedures, and build extract/load scripts using Informatica (or similar ETL tool), SQL, load utilities, and Unix and/or Korn shell Scripting is required. * Background with Oracle and/or Teradata databases, Teradata Tools and Utilities, Teradata SQL*Assistant, Oracle SQL*Loader, SQL*Developer, Citrix, and or other database query tools is required. * Ability to read and interpret requirements and create design documents based on requirements. * Database and Informatica programming experience is a must. * Uses Informatica to transfer data within the data warehouse and to external systems. * Must be able to conduct analysis, document analysis results, and recommend solutions. * Must be a self-starter, able to come into the position ready to take on tasks. Desired: * Familiar with GovCloud, Cloud Technology, AWS, S3, SQS, Neptune, SageMaker, Lambda, Python, Databricks, EC2, EKS, ECS, and RDS (MSSQL, PostgreSQL). * Familiarity with Configuration Management processes is a plus. Security Clearance: Active Secret clearance required. Requirements to obtain a clearance include US Citizenship, security investigation, etc. Education: Bachelor's Degree in Computer Science or Information Systems required. Spalding Consulting, Inc. is committed to providing equal employment opportunities to all applicants and employees. We will not discriminate against any employee or applicant on the basis of race, color, ethnic origin, national origin, creed, religion, political belief, sex (including pregnancy), sexual orientation, gender identity, marital status, age, military status, physical or mental disability, or any other legally protected basis, in accordance with applicable federal, state or local laws. Spalding Consulting, Inc. is an Affirmative Action/Equal Opportunity Employer and encourages minorities, women, disabled, and veterans to apply for job openings within our company. Accessibility: If you are interested in applying for employment with Spalding Consulting, Inc. and need special assistance or an accommodation to apply for a posted position, contact our Recruiting department via email at or call us at 301-737-0150 Ext. 500. Pay Transparency Employee Polygraph Protection Act Employee Rights under the Family and Medical Leave Act Equal Employment Opportunity Know Your Rights: Workplace Discrimination is Illegal