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 work we do effects millions of U.S. citizens daily as they interact with the systems we build. Our best-in-class commercial solutions, modified for our customers’ bespoke mission 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). In addition to our recent growth in Federal Civilian agencies, we are seeking to expand our 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 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
- Work with business analysts to gather business requirements from end-users and translate them into technical specifications.
- Gather requirements to develop solutions, define data extraction, transformation logic, and data models, data flow, and process.
- Ability to analyze databases, schemas, triggers, stored procedures
- 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.
- 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.
Education:
Bachelors in IT or related field Clearance Requirements:
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. 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. In addition, reasonable accommodation(s) may be made applicable and available 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)
Please note: Candidate(s) must undergo a thorough pre-employment screening.
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
Top Skills
What We Do
At Cybermedia Technologies, we’re driven by a relentless desire to meet our clients’ toughest challenges. We are industry veterans with a proven track record of tackling the biggest problems facing 21st Century organizations. Whether you’re seeking to manage your workforce more effectively, update your enterprise infrastructure, or ensure the security of your systems, you can count on Cybermedia Technologies to bring the best solutions to the table, each and every time.
Cybermedia Technologies, Inc. is a Woman Owned Small Business (WOSB) company headquartered in Reston, Virginia, with a stellar reputation throughout the Washington Metropolitan Area.
Founded in 1996, Cybermedia Technologies, Inc. exists to help our customers achieve the maximum return on their IT and human capital investments. We specialize in:
• Human Capital & Training Solutions
• Digital Transformation - Enterprise Applications Optimization, Infrastructure & Cloud Migration/Modernization
• Cybersecurity and Software Development
Our veteran team of designers, consultants, artists, and managers is dedicated to adding value to our organization's human capital, developing training, enterprise infrastructure, and cybersecurity solutions that exceed client expectations.
With a keen insight into the issues faced in the current economy, CTEC offers custom, well-crafted, and common-sense solutions to help our clients meet their strategic goals.
Call us on 703-766-5774
