ETL; Informatica Developer Remote

CTEC is a leading technology firm that provides modernization, digital transformation, and application development services to the U.S. Federal Government. Headquartered in McLean, VA, CTEC has over 300 team members working on mission‑critical systems and projects for agencies such as the Department of Homeland Security, Internal Revenue Service, and the Office of Personnel Management.

Roles and responsibilities:

• 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.
• Analyze database schemas, triggers, and 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 related tools 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.

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

Bachelor's in IT or related field.

Active IRS MBI Clearance.

• Exceptional customer service—good oral and written communication skills.
• Proficiently read, write, and understand the English language.

• Paid vacation & sick leave.
• Health insurance coverage.
• Performance bonus programs.
• 401(k) contribution & employer match.

CTEC is a proud Equal Opportunity Employer! (EOE; M/F/D/V)

Applicants must undergo a thorough pre‑employment screening.