ETL and Business intelligence Administrator

Company Name: Comsys
Location: Columbia, Maryland-21044
Max Salary: 95000 $/yr
Status: Permanent
To Apply Go To www.staffitnow.com and Enter job Id 656295

Description: (Visit the site for detailed description)
ETL and Business Intelligence Administrator
Columbia, MD
6 month temp to perm position



This position is for some that is ETL and BI savvy, someone that is team oriented, and loves a fast paced environment, and wishes to be in a stable position.
This position is right for a candidate that can perform administration of Informatica and Business Objects Tools and interface with DBAs and Enterprise Infrastructure Groups.


Responsibilities:
- Perform ETL Administration using the Informatica tool
- Perform Informatica code migrations and monitoring
- Perform all informatica and Business Objects administration functions such as user access accounts, roles, setting standards, etc.
- Perform all Informatica and Business Objects software upgrades as needed.
- Perform Business Intelligence Administration responsibilities in Business Objects
- Work as an ETL Architect to support production data delivery needs.
- Interface with the Database Administration Group to ensure proper configuration of database objects in support of ETL code.
- Interface and lead discussions with the System Services organization for configuration of ETL and Business Intelligence infrastructure.
- Work with DBAs and Data Architects in planning and implementing appropriate data partitioning strategy for the Data Warehouse.
- Profile production data and ensure enterprise data quality using FirstLogic tool set.
- Perform basic DBA functions as needed in the Development and System Test environments in support of Enterprise Data Development process and Configuration Management practices.
- Develop new and support existing ETL processes using the Informatica Tool.
- Performance tune databases and SQL statements in connection to ETL code as required
- Perform source system analysis as required.
- Develop stored procedures, database triggers and SQL queries where needed.
- Proactively monitor development, test and production class database servers.

Education / Experience:
- 4 year college degree or equivalent experience required.
- Minimum 3 years experience in using and administering Informatica ETL tools for data integration tasks.
- Minimum 2 years experience in using Business Intelligence tools for enterprise reporting.
- Minimum of 5 years experience with Oracle DBMS.
- Minimum of 5 years experience in performance tuning databases and SQL statements.
- Minimum of 2 years experience in Unix, writing SHELL scripts.
- Minimum of 5 years experience in administering data warehouse environments.
- Minimum 1 year experience in using FirstLogic Data Quality Tool for data cleansing.
- Demonstrated ability to learn and apply new technologies quickly.
- Comfortable in a fast-paced and team-oriented environment.
- Strong written and verbal skills from both business and technical perspectives.