ETL Business Analyst

Location: Washington, DC
Date Posted: 09-25-2017
ETL Business Analyst
Washington, DC
12 Months
Interview Mode: Phone and Inperson interview
Exp Level: Need Min 12+ Years of exp

Short 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..
Complete Description:
  • The Lead ETL specialist will support to the OCTO data curation program for various data enhancement, update, and creation activities.  Specifically, the Lead ETL specialist will be responsible for the following tasks:
  • Leads and manages all ETL creation, testing, and maintenance efforts across the data curation team program.
  • Designs, architects, develops, and delivers applications using the entire suite of Informatica software.
  • Analyzes data structures in existing legacy systems to design extract, transform and load processes and data warehouse data structures using Informatica and FME server.
  • Develops routines for ETL performance optimization.
  • Provides technical support for issues including hands-on troubleshooting and implement enhancements and customizations.
  • Uses standard data modeling, data flow, and data documentation tools to analyze, document and present data analysis work.
  • Works cooperatively with others to resolve data transformation and process issues.
  • 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.
  • Formulates and defines systems scope and objectives based on both user needs and a thorough understanding of business systems and industry requirements.
  • Devises or modifies procedures to solve complex problems considering computer equipment capacity and limitations, operation time, and form of desired results. Includes analysis of business and user needs, documentation of requirements, and translation into proper system requirements specifications.
  • Provides consultation on complex projects and is considered to be the top level contributor/specialist of most phases of systems analysis, while considering the business implications of the application of technology to the current and future business environment.
Minimum Education/Certification Requirements:
Bachelor’s degree in Information Technology or related field or equivalent experience; or a current Project Management
Professional (PMP) Certification
  • Experience11-15 yrs BA experience Required 11Years
  • 11-15 yrs Software Development Lifecycle experience Required 11 Years
  • 11-15 yrs requirements gathering and documentation Required 11 Years
  • 11-15 yrs MS Office/PowerPoint experience Required 11 Years
  • Bachelor’s degree in IT or related field or equivalent experience Required 11 Years
  • Demonstrated experience using the complete suite of Informatica 10.x software including software configuration and upgrade Required 11 Years
  • Understands data warehousing, business intelligence and information management concepts. Also, relational and dimensional databases. Required 11 Years
  • Possesses understanding of visualization and reporting software such as Microstrategy, Tableau, and ArcGIS Highly desired 3 Years
  • Demonstrated experience directing and managing ETL development, testing, and implementation Required 3 Years
  • Understanding of FME suite of products highly desired 1 Years
|| Office: 916 646 2080 Ext 222|| Fax: 916 646 2081 || Email: || Website: ||
Note: This email is not intended to be a solicitation.  Please accept our apologies and reply in the subject heading with REMOVE to be removed from our Mailing list.
this job portal is powered by CATS