CTEC is seeking to support and modernize legacy mainframe systems within a federal environment, expanding capabilities in cloud development and footprint in national-security focused agencies.
Requirements
- 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.
- 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
- 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.
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.
Other
- Active IRS MBI Clearance.
- Exceptional customer service—good oral and written communication skills
- Proficiently read, write, and understand the English language.
- Bachelors in IT or related field
- Candidate(s) must undergo a thorough pre-employment screening.
