Job Details

Overview

CTEC is a leading technology firm providing 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 for agencies such as the Department of Homeland Security, Internal Revenue Service, and the Office of Personnel Management. The work we do effects millions of U.S. citizens daily as they interact with the systems we build. We are seeking to expand capabilities in cloud development and footprint in national-security focused agencies within the Department of Defense and U.S. Intelligence Community. We are currently seeking a highly skilled ETL(Informatica) Developer to support and modernize legacy mainframe systems within a federal environment.

Roles and responsibilities:

• Design, develop, and test ETL scripts on Informatica platform according to requirements, following 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.
• Lead and plan complex database design, development, implementation, administration, tuning, ETL, and backup and recovery 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.
• Conduct reviews of developed code.
• Possess hands-on experience with database design, normalization, data lake concepts, and familiarity with HDFS, Kafka, ETL, RDMS, NoSQL; familiarity with data engineering tools and related technologies.
• Test solutions to validate requirements; develop test plans, test scripts, and test conditions based on business and system requirements.
• Provide end-user support in post-deployment phases; assess feedback and ensure requirements for issue correction are addressed.
• Maintain strong collaboration with stakeholders to ensure alignment with business goals.
• Work Experience:
  • Minimum 8+ years of ETL experience, and 6+ years of Informatica experience required.
  • 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, testing methodologies, and deployment management.

Education:

Bachelors in IT or related field.

Clearance: Active IRS MBI Clearance.

Skills:

• Exceptional customer service with strong oral and written communication skills.
• Proficient in reading, writing, and understanding the English language.

Additional Information:

The above statements describe the general nature and level of work performed. They are not intended to be an exhaustive list of duties, responsibilities, and skills. CTEC reserves the right to modify, add, or remove duties as necessary. Reasonable accommodations may be made to enable individuals with disabilities to perform essential functions. CTEC is an Equal Opportunity Employer (EOE; M/F/D/V). A thorough pre-employment screening is required.

Benefits

• Paid vacation and sick leave
• Health insurance coverage
• Performance bonus programs
• 401K contribution and employer match