ETL (Informatica) Developer

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.

S. citizens daily as they interact with the systems we build.

Requirements

, are enabling this future every day. The Company has experienced rapid growth over the past 3 years and recently received a strategic investment from Main Street Capital Corporation (NYSE: MAIN). S.

Intelligence Community. We are currently seeking a highly skilled ETL(Informatica) Developer to support and modernize legacy mainframe systems within a federal environment.

, following the development standards and best practices.

from end-users and translate them into technical specifications.

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.

from end-users and translate them into technical specifications.

to develop solutions, define data extraction, transformation logic, and data models, data flow, and process.

have been met; develop test plans, test scripts, and test conditions based on the business and system

. Provide end-user support in post-deployment phases; assess and evaluate all feedback to ensure that the

necessary to correct issues are addressed. Work Experience: 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.

: Clearance: Active IRS MBI Clearance. Skills: Exceptional customer service—good oral and written communication skills Proficiently read, write, and understand the English language. Additional Information: The above statements describe the general nature and level of work the individual(s) assigned to this position perform.

Responsibilities

: Design, develop, and test ETL scripts on Informatica platform according to the

, and skills. CTEC management reserves the right to modify, add, or remove duties and to assign other duties as necessary.