CyberMedia Technologies - ETL (Informatica) Developer

Developer is needed in McLean, United States.

Client: CyberMedia Technologies

Location: McLean, VA

Contract: undefined

Job Description

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. The company is currently seeking a highly skilled ETL (Informatica) Developer to support and modernize legacy mainframe systems within a federal environment.

Requirements

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.
• Define data definitions, transformation logic, and data model logical/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 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, 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 business and system requirements.
• Provide end-user support in post-deployment phases and evaluate feedback to address issues.
• Work Experience: Minimum 8+ years of ETL and 6+ years of Informatica experience; Minimum eight years 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 Requirements:

Active IRS MBI Clearance.

Skills:

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

Additional Information

The statements above describe the general nature and level of work the individual(s) assigned to this position perform. They are not intended to be an exhaustive list of all required duties, responsibilities, and skills. CTEC management reserves the right to modify, add, or remove duties and to assign other duties as necessary. Additionally, reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions of this position.

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

Candidate(s) must undergo a thorough pre-employment screening.

Employee Benefits

If you are looking for a fun and challenging environment with talented, motivated people to work with, CTEC is the right place for you. In addition to employee salary, we offer an array of employee benefits including:

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