OCTO Lead ETL Business Analyst

Job Responsibilities

Summary:

 

SILLC is looking to fill an immediate opening for an OCTO Lead ETL Business Analyst for a project in downtown Washington DC (Metro accessible). This is our DIRECT CLIENT. If you are interested, please send me your resume along with your expected hourly rate on 1099.

 

Job Title: OCTO Lead ETL Business Analyst

Location: Washington DC

 

Description:

 

The data curation program requires a Lead ETL specialist support data warehousing operations.  This will provide OCTO’s data program with a resource to manage and lead ETL, data transfer, and data transformation tasks.

 

Responsibilities:

 

  • Coordinates the data administration technical function for both data warehouse development and maintenance.
  • 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.

 

Job Qualifications

Required Skills:

 

  • 11 years’ BA experience
  • 11 years’ Software Development Lifecycle experience
  • 11 years’ requirements gathering and documentation
  • 11 years’ MS Office/PowerPoint experience
  • Bachelor’s degree in IT or related field or equivalent experience
  • 11 years’ demonstrated experience using the complete suite of Informatica 10.x software including software configuration and upgrade
  • 11 years’ understanding data warehousing, business intelligence and information management concepts. Also, relational and dimensional databases.
  • 3 years’ possessing understanding of visualization and reporting software such as Microstrategy, Tableau, and ArcGIS
  • 3 years’ demonstrated experience directing and managing ETL development, testing, and implementation
  • 1 year understanding of FME suite of products