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.
Location: Patuxent River, MD
Posted: Nov. 11, 2024, 2:06 a.m.
Apply Now Company Website