BI-Informatica Developer

We learn continuously, both on the job and through formal training programs. Create, tuning and testing complex ETL processes for large and complex OLAP/OLTP data sets  Create and maintain Informatica 8.
Create ETL processes from business requirements.  Validate the accuracy of business rules and transformations  Informatica  Conforming and merging data from multiple data source types (ie MSSQL, Oracle, flat files, etc.)  o Using transformations to implement complex business rules  o Using Informatica to restart failed jobs  o Tracking performance and job status and job scheduling  Performance tuning  o Transformation optimization  Oracle  Experience with Oracle 11g preferred  Experience writing complex SQL queries against large data sets  Query optimization (indexing, partitioning, Oracle configuration, etc.)  o Experience capturing and interpreting Oracle performance based statistics is a plus  Familiarity with dimensional models and Operational Data Stores  Experience gathering and implementing business rules  Experience reconciling data output to existing reports and source data