Position: ETL & OBIEE Consultant
Location: Pittsburgh, PA
Duration: Full Time
- Around 6 to 9 years of Business Discovery, Data Discovery & Analysis, ETL Design, Development, Testing, Implementation and Troubleshooting in the field of Data warehousing and Application Development and OBIEE.
- Strong Data warehousing experience specializing in RDBMS, ETL Concepts, Strategy, Design & Architecting, Informatica Administration, Development & Testing.
- Around 2 Years of experience in OLAP concepts and Report development, RDBMS
- An expert in the ETL Tool Informatica which includes components like PowerCenter, PowerMart, PowerConnect, Designer, Workflow Manager, Workflow Monitor, Repository Manager, Repository Server Administration Console, Power Exchange CDC,Teradata, IDE – Informatica Data Explorer, IDQ – Informatica Data Quality, Informatica Visio Data Stencil.
- Have had extensive experience in working with various PowerCenter Transformations using Designer Tool.
- Have handled various Data Sources like DB2, Oracle, SQL Server, MS Access, MS Excel including MF COBOL EBCDIC Files, Flat Files and XML Files.
- Have had extensive experience working with databases like IBM UDB DB2, Oracle and MS SQL Server, mainframe IMS and mainframe VSAM