ETL Developer-Senior

Employer
Octo Consulting Group
Location
Arlington, VA
Posted
Sep 15, 2017
Closes
Sep 18, 2017
Hours
Full Time
Take your career to the next level with Octo! Octo Consulting is searching for a dynamic ETL Developer to join our growing team and support a Navy Business Intelligence Program. What does Octo do? At Octo, our focus is on delivering results that matter. We are a premier provider of digital solutions and services to the federal government specifically in the areas of UI/UX, Agile, Data, and Cloud services. Our clients are federal agencies that are making a difference in the world. Responsibilities - Create and maintain data warehouse schemas and ETL processes. - Coordinates the data administration technical function for both data warehouse development and maintenance. - Will work closely with IT Architects, Analysts, Data Scientists, UI/UX designers, functional practitioners, and clients/stakeholders to gather data requirements - Facilitates change control, problem management, and communication among data architects, programmers, analysts, and engineers. - Establishes and enforces processes to ensure a consistent, well managed, and well-integrated data warehouse infrastructure. - Analyzes and identifies data and metadata requirements. - Defines user requirements and database design specifications. - Designs, implements, and supports data warehousing requirements. Implements business rules via stored procedures, middleware, or other technologies. - Provides product support and maintenance of the data warehouse. - Performs data warehouse design and construction. - Prepares/implements data verification and testing methods for the data warehouse. Requirements: - Experience 6+ years with technical applications focusing on data - Experience working with relational databases (Oracle, PostgreSQL, MySQL or similar) - Ability to create complex SQL queries and tuning runtime performance of the queries - Ability to create stored procedures and database views - Knowledge with ETL tools (ie, SSIS, Oracle Data Integrator, Informatica, InfoSphere, etc.) and having the ability to implement complex, parallel data migration systems - Ability to quickly solve problems that arise during ETL due to data problems, network problems or similar events. - Understanding of data warehouse modeling, data migration and auditing - Deep understanding of data warehouse modeling, especially Kimball method - Extensive knowledge building high performing data transfer processes. - Experience planning and leading major technology assignments. - Strong consulting and client management skills. - Demonstrated track record of analytical and critical thinking skills. - Organized, motivated and demonstrate the ability to work under minimal supervision to achieve desired objectives. Educational Requirements: Bachelor's degree in an IT related field Location: Arlington, VA Clearance Requirements: An active SECRET clearance is required Physical Requirements: Regularly required to sit for extended periods up to 80% of the time; frequently required to move about to access file cabinets and use office equipment such as PC, copier, fax, telephone, cell phone, etc. Occasionally required to reach overhead, bend, and lift objects of up to 10 lbs. Specific vision abilities required by this job include use of computer monitor screens up to 80% of time Work Environment: Individual's primary workstation is located in an office area The noise level in this environment is low to moderate Why Octo? Octo has been voted an employer of choice for a reason! We offer AMAZING benefits and competitive compensation combined with an unparalleled company culture. Our office is a friendly and fun place to work (even if we do say so ourselves!). Everybody looks forward to our company events and Octo has a very transparent leadership style where employees matter. At Octo, you'll be working with inspiring industry experts working on projects that have a great impact. Please, no Corp-to-Corp or 1099 candidates; this position is W-2 only. US citizenship is required by the contract Relocation will not be offered. Octo Consulting Group is an Equal Opportunity/Affirmative Action employer. All qualified candidates will receive consideration for employment without regard to disability, protected veteran status, race, color, religious creed, national origin, citizenship, marital status, sex, sexual orientation/gender identity, age (40 or over), or genetic information. Octo Consulting Group's commitment to diversity and inclusive selection practices includes ensuring qualified long-term unemployed job seekers receive equal consideration for employment. Selected applicant will be subject to a background investigation. The description provided above is not intended to be an exhaustive list of all job duties, responsibilities, and requirements. Duties, responsibilities, and requirements may change over time and according to business need.