Sr BI/Cognos

Location: St. Louis, MO, United States Minor Outlying I
Date Posted: 10-10-2016
Description:
Drive, design, and determine the ETL requirements mainly focusing on Informatica and PL/SQL development processes for reporting and analytics within a large Data Warehouse environment.  The following skills are pretty much a must from that perspective
 
(Highlighted Items are required):
 
  • Perform an active, leading role in developing / shaping and enhancing overall ETL Informatica & PL/SQL architecture, including ETL standards, patterns and best practices.
  • Perform development activities such as Source to target mapping validations, identify, document and execute unit test cases/scripts, peer and lead code reviews per code review checklist, and document test and review results.
  • Well-versed in developing ETL using Informatica and PL/SQL at a minimum in support of large-scale data warehouse and reporting projects (2TB and above).  Must have a minimum of 3-5 years development experience using Informatica in multiple environments (Oracle, SQL and Netezza) and with PL/SQL (Oracle). 
  • Makes recommendations on the increasing scalability and robustness of ETL platforms and solutions.
  • Good Communication Skills are a must in this position as well as some minor PM skills as in some cases they will be the main contact for any process they are working on
  • Strong experience in client interaction and understanding business application, business data flow and data relations from them
  • Working with the development team in creating Process Flows for ETL processing
  • Familiarity with Implementation Plans and Documentation
  • Experience in documenting processes of this nature, in order to write Turnover Documentation to support this on our Production Support Team
  • Requirements/Certifications:
Experience with the following Tools and Resources:
  • Informatica
  • Informatica Monitor & Workflow Manager
  • PL/SQL
  • Netezza (NZ SQL)
  • Quest Toad
  • Embarcadero Rapid SQL
  • MS SQL Server / Enterprise Manager
  • Unix/Linux editing tools (Telnet, Putty)
  • Cognos BI Suite (Framework Manager, Report Studio, Workspace Advanced)
  • Microsoft Suite (MS Word, Excel, Project, Visio, Power Point, Outlook and Access)
  • CA ERWIN for Data Modeling
  • Data Flux
Our environments are broken out at about 65% Oracle, and 20% SQL, and 15% Netezza - so skills in Oracle and SQL are a must, with Netezza being a nice to have. 
The Timberline Group
Phone: 636-209-5537
PO Box 565, Sullivan, Mo 63080
"Delivering quality solutions through quality people"
or
this job portal is powered by CATS