ETL Developer, Informatica

Cybermedia Technologies, LLC (CTEC)

ETL Developer supporting and modernizing legacy systems in a federal environment. Collaborating with business analysts to gather requirements and develop ETL processes using Informatica.

Posted 6/2/2026full-timeRemote • 🇺🇸 United StatesSeniorLeadWebsite

Tech Stack

Tools & technologies

ETLHDFSInformaticaKafkaNoSQLOracleSQL

About the role

Key responsibilities & impact

Design, develop, and test ETL scripts on Informatica platform according to the requirements, following the development standards and best practices.
Work with business analysts to gather business requirements from end-users and translate them into technical specifications.
Gather requirements to define data definitions, transformation logic, and data model logical and physical designs, data flow, and process.
Leads and plans complex database design, development, implementation, administration, tuning, ETL, and backup and recovery for assigned project(s).
Design and develop ETL processes using Informatica Power Center.
Ability to analyze database schemas, triggers, stored procedures.
Design, develop, implement, and maintain custom oracle applications written in PL/SQL.
Conduct reviews of developed code.
Hands-on experience with database design, normalization, data lake, structured/semi-structured/unstructured datasets, and familiarity with HDFS, Kafka, ETL, RDMS, NOSQL, SQL, Data Engineering and data related tools, programming languages and technologies.
Test solutions to validate whether requirements have been met; develop test plans, test scripts, and test conditions based on the business and system requirements.
Provide end-user support in post-deployment phases; assess and evaluate all feedback to ensure that the requirements necessary to correct issues are addressed.

Requirements

What you’ll need

Minimum 8+years of ETL, and 6+ years of Informatica is a must.
Minimum eight years of experience in application development.
Solid understanding of the software development process, including requirement gathering, analysis/design, development tools/technologies, release/version control, contemporary testing methodologies, and deployment management.

Benefits

Comp & perks

Paid vacation & Sick leave
Health insurance coverage
Career training
Performance bonus programs
401K contribution & Employer Match
11 Federal Holidays

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

ETLInformaticaPL/SQLdatabase designdata modelingdata transformationdata flowdata lakeSQLNOSQL

Soft Skills

requirement gatheringanalytical skillscommunicationleadershipproblem-solving