Become an integral part of a diverse team that leads the world in Mission, Cyber, and Intelligence Solutions. FiveTwelve is a Maryland-based small business focused on providing the highest quality software and system engineering solutions to Intelligence Community and the Department of Defense. Our mission is to apply the most advanced software and system engineering techniques to maintain and strengthen our customers’ decision advantage.
TS/SCI with FS Polygraph Required
This position requires you to ALREADY have a TS/SCI. FiveTwelve cannot obtain a security clearance for you at this time.
Senior ETL (Extraction, Transformation, and Loading) Developer
Responsibilities:
Designs, implements, and supports ETL processes for data warehouse. Designs and supports ETL processes for data cleansing, data auditing, and data profiling. Collaborates and implements ETL best practices. Coordinates with Government leads to gather and analyze requirements to translate into technical specifications and solutions.
Qualifications:
- Twelve (12) years’ experience with ETL Development is required. (A Bachelor’s Degree from an accredited college or university in Computer Science or related discipline is required. An additional four (4) years of ETL Development experience on projects with similar scope may be substituted for a Bachelor’s Degree.)
- Five (5) years’ experience designing data warehouse schemas, relational and dimensional
- Five (5) years’ experience programming in Oracle PL/SQL.
- Two (2) years’ experience using computer based COTS data modeling tool.
- Two (2) years’ experience programming in PERL.
- Two (2) years’ experience in Korn, Bourne, or C shell programming.
- Two (2) years’ development experience with Informatica PowerCenter version 8 or above or three (3) years development experience with a comparable ETL Tool.
- Three (3) years’ experience with UNIX and/or LINUX operating systems, including basic monitoring of operating systems.
- Completion of Informatica PowerCenter Developer Level 1 training or 1 year of experience using Informatica version 7 or later to develop ETL.
- Completion of Informatica PowerCenter Developer Level 2 training.
Shall possess the following capabilities:
- Clarifies and documents requirements on assigned tasks, in conjunction with the customer.
- Develops basic ETL objects, according to the design.
- Writes technical documentation (design specifications, data model diagrams, Configuration Management, and Production Support documents).
- Negotiates and documents data owner permission to release data to customer.
- Deigns basic to moderately complex ETL processes and related database schemas.
- Develops moderately complex ETL objects, according to the design.
- Monitors developed ETL processes in production, and trouble-shoots production problems when they occur.
- Recommends best practices, standards, and advanced techniques for designing and implementing ETL objects to the development team.
- Designs and implements complex solutions focused on data extraction, transformation, and loading of data.
- Analyzes source system data, defines database schema, and defines ETL strategy for loading data into the schema.
- Develops ETL objects to ingest data from multiple sources and populate the data warehouse.
- Verifies that overall solution provides appropriate security protection and adheres to data owner release agreements(s).
- Leads migration of existing ETL loads and database structures to new database platform.
More job details can be shared once you contact FiveTwelve
In addition to competitive salaries, we offer a variety of unique benefits!
- PTO: Our variable PTO plan lets you decide the amount that’s best for you. Choose as few as 2 weeks or as much as 6 weeks.
- Holidays: 10 annually
- 401k: 5% Company match; fully-vested from Day 1
- Quarterly Bonus: Totaling 2.5% of your base salary annually
- Training Budget: Up to $5,250 annually
- Cell Phone/Internet Allowance: Monthly reimbursement up to $75
- Gym/Health Club Membership: Monthly reimbursement up to $50
- Personal Technology Allowance: Up to $500 annually
- Logo Wear: $100 annually
- Health Insurance: Provided through CareFirst Blue Cross/Blue Shield. Three plans to choose from – HMO, PPO, HSA. FiveTwelve covers 80% of the premium for employees and their dependents.
- Dental and Vision Insurance: Provided through CareFirst Blue Cross/Blue Shield. FiveTwelve covers 100% of the premium for employees and their dependents.
- Short-Term and Long-Term Disability: FiveTwelve pays 100% of the premium
- Referral Bonus: Up to $10,000 for fully-cleared referrals
* TS/SCI with Polygraph Required*