ETL (Informatica) Developer

2 weeks, 6 days 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

Data Engineer IV (6249)

Dan.com - a GoDaddy brand Internet Software & Services

itD is hiring a Data Engineer IV to build and optimize AWS-based data infrastructure and pipelines that support AI infrastructure and inference initiatives in a remote role.

AWS
1 day, 19 hours ago

Senior Data Engineer (GCP)

Xebia 1K-5K Internet Software & Services

Xebia is hiring a data engineer to support a BigQuery migration by building and maintaining scalable data pipelines for production reporting, analytics, and business intelligence solutions.

Apache Airflow CI/CD Databricks dbt Git Python Snowflake SQL
1 day, 19 hours ago

Staff Data Engineer (Coupang Pay)

Coupang 1K-5K Internet Software & Services

쿠팡페이 핀테크 데이터 플랫폼 팀의 Staff Data Engineer로서 실시간 결제·주문 데이터를 기반으로 데이터 파이프라인과 분석 인프라를 구축·고도화하는 역할입니다.

Apache Spark AWS ClickHouse Flink Hive Java Presto Python Scala SQL Tableau
1 day, 20 hours ago

Data Migration Engineer (SQL Server / TSQL)

Cresteo 51-200 information technology & services

Cresteo is hiring a Data Migration Engineer to own end-to-end SQL Server data migrations from legacy schemas into reconciled, production-ready data for US-based clients and international teams.

JSON SQL Server
1 day, 20 hours 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