Job Description :
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.

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.
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

Skills:
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
             

Similar Jobs you may be interested in ..