ETL (Informatica) Developer

1 hour, 4 minutes ago
Full-time
Lead
Software Development

RCG-CyberMedia

RCG-Cybermedia describes itself as an SBA Certified Mentor-Protégé joint venture between Reston Consulting Group (RCG) and Cybermedia Technologies, LLC (CTEC), combining RCG’s 35+ years of IT experience with CTEC’s strengths in cybersecurity, IT modernization, and workforce training for Federal government clients.

Federal IT services, cybersecurity, IT modernization, workforce training, and government contracting

Description

  • Design, develop, and test ETL scripts on the Informatica platform following development standards and best practices.
  • Work with business analysts and end-users to gather business requirements and translate them into technical specifications.
  • Define data definitions, transformation logic, data model designs, data flow, and process requirements.
  • Lead and plan complex database design, development, implementation, administration, tuning, ETL, backup, and recovery activities for assigned projects.
  • Design and develop ETL processes using Informatica PowerCenter.
  • Analyze database schemas, triggers, and stored procedures.
  • Design, develop, implement, and maintain custom Oracle applications written in PL/SQL.
  • Review developed code and validate solutions against business and system requirements.
  • Develop test plans, test scripts, and test conditions to support solution testing.
  • Provide end-user support after deployment and address feedback to resolve issues.

Requirements

  • 8+ years of ETL experience.
  • 6+ years of Informatica experience required.
  • 8+ years of application development experience.
  • Bachelor’s degree in IT or a related field.
  • Active IRS MBI clearance.
  • Strong understanding of the software development lifecycle, including requirements gathering, analysis/design, development tools and technologies, release/version control, testing methodologies, and deployment management.
  • Hands-on experience with database design, normalization, data lakes, structured, semi-structured, and unstructured datasets.
  • Familiarity with HDFS, Kafka, ETL, RDBMS, NoSQL, SQL, data engineering, and related tools, programming languages, and technologies.
  • Experience analyzing databases, schemas, triggers, and stored procedures.
  • Excellent customer service and strong oral and written communication skills.
  • Ability to read, write, and understand English proficiently.

Benefits

  • Paid vacation and sick leave.
  • Health insurance coverage.
  • Career training opportunities.
  • Performance bonus programs.
  • 401(k) contribution with employer match.
  • 11 federal holidays.

Interested in this position?

Apply directly on the company website

Apply Now

Similar Roles

Clinical Data Manager (Senior)

Bioptimus 11-50 research

Bioptimus is seeking a Senior Clinical Data Manager to help structure and harmonize real-world clinical data for its STELA program and support the development of AI-ready biomedical datasets.

AWS GCP Git NumPy Pandas Python Statistics
34 minutes ago

Manager, Data/ML Platform

Inspiren 11-50 Internet Software & Services

Inspiren is seeking a Senior Manager to lead its Data + ML Platform group, building the core infrastructure that turns multimodal resident and care data into real-time insights and powers analytics, ML, and next-generation product capabilities.

LLM Machine Learning MLOps
34 minutes ago

Senior Data Engineer

Exadel 1K-5K Internet Software & Services

Exadel is hiring a Senior Data Engineer to help build and lead scalable data ingestion and curation platforms for an international transportation technology client modernizing rail operations.

Agile Apache Airflow Apache Spark AWS Cassandra CI/CD Elasticsearch GCP Hadoop Hive Java MySQL PostgreSQL Python Scala SQL Teradata
49 minutes ago

Intermediate Data Engineer

AB InBev 100K+ Beverages

An early-career Data Engineer role focused on supporting the development, reliability, and governance of data pipelines and analytics workflows at the company.

Apache Spark AWS Azure CI/CD Databricks dbt GCP Git GitHub Actions JSON Python Secrets Management SQL
49 minutes ago

You're on a roll! Sign up now to keep applying.

Sign Up

Already have an account? Log in

Used by 14,729+ remote workers