Job Description :
Lead ETL Business Analyst (575468)
Washington, DC
Duration: 12 Months
Both Phone and In Person
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
1. Coordinates the data administration technical function for both data warehouse development and maintenance.
2. Facilitates change control, problem management, and communication among data architects, programmers, analysts, and engineers.
3. Establishes and enforces processes to ensure a consistent, well managed, and well-integrated data warehouse infrastructure.
4. Analyzes and identifies data and metadata requirements.
5. Defines user requirements and database design specifications.
6. Designs, implements, and supports data warehousing requirements. Implements business rules via stored procedures, middleware, or other technologies.
7. Provides product support and maintenance of the data warehouse.
8. Performs data warehouse design and construction.
9. Prepares/implements data verification and testing methods for the data warehouse.
Minimum Education/Certification Requirements:
Bachelor’s degree in Information Technology or related field or equivalent experience
CONTRACT LABOR CATEGORY DESCRIPTION
Complete Description
Responsibilities:
1. Formulates and defines systems scope and objectives based on both user needs and a thorough understanding of business systems and industry requirements.
2. 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.
3. 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
Skill
Required / Desired
Amount
of Experience
11-15 yrs BA experience
Required
11
Years
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
Questions
Description
Question 1
Absences greater than two weeks MUST be approved by CAI management in advance, and contact information must be provided to CAI so that the resource can be reached during his or her absence. The Client has the right to dismiss the resource if he or she does not return to work by the agreed upon date. Do you accept this requirement?
Question 2
Please list candidate''s email address that will be used when submitting E-RTR.
Question 3
There are no reimbursable expenses. Do you accept this requirement?