*HOTLIST: Sr. .Informatica Lead* Hi,
Senior Informatica Lead consultant available immediately for your direct client requirements only in TX- please email requirements and other details to [email protected] Informatica Certified - *PowerCenter 8 Mapping Design* Informatica Certified - *PowerCenter 8 Advanced Mapping Design* Informatica Certified - *PowerCenter 8 Architecture and Administration* *Oracle 9i SQL Certified* *Oracle 9i PL/SQL Certified* *Summary:* - 7+* *years* *of total IT experience, *Business and Technical proficiency* in the Data Warehousing which includes *Business Requirements Analysis*, Application Design, *Data Modeling*, *and Development*, *testing*, *production support* and documentation. Implementation of full lifecycle in Data warehouses and Data marts in different domains. - *6+* years of *Data Warehousing *ETL experience using Informatica *PowerCenter 8.x/7.x/6.x *Experience in developing Strategies for Extraction, Transformation and Loading (ETL) mechanism using Informatica PowerCenter. - Experience *in leading on-shore/off-shore teams, resource estimation and allocation*. - Experience in *Dimensional Data modeling* (*Star Schema* modeling, * Snow-Flake* modeling, Fact and Dimension tables), along with *ER *modeling skills.** - Proficient in working with different *databases* like *Oracle 11g/10g/9i/8i*, *Teradata V2R6, SQL Server 2005* and hands on experience in *SQL*, *SQL*Plus*, *SQL*Loader*. Experience in Integration of various data sources. - Skilled in building queries using Teradata, Oracle and SQL Server and in writing *Stored procedures* using Oracle. - Experienced in loading data to and from *flat files* and *XML files.* - Skilled in writing *Teradata Utilities* scripts for Bteq, Fastload, * Multiload*, Tpump and Fast Export. - Experienced in performance tuning of complex queries and mappings. - Skilled in ETL tools of *Datastage*, *Ab Initio* and OLAP tool of *Business Objects*. - Experience in integration of *Informatica* and* Network Engineer* for * XML* transport mechanism and Load * * *TECHNICAL SKILLS* * * ETL and BI Tools *: Informatica* *Power Center 8.6.1/8.5.1/8.1.1/7.1.4/6.2*, *Datastage*, *Business Objects* and *Ab Initio* Modeling Tools :* MS Visio, Erwin, Altova XML Spy* Databases :* TeradataV2R6*, *Oracle* *11g/10g/9i/8i, SQL Server 2005, db2*. * * Database Tools :* SQL *plus*, *SQL *Loader, *Teradata SQL Assistant 7.2, Toad 8.6.1** * * Languages :* SQL*, *PL/SQL*,* *C, XML, HTML * * Operating Systems :* *Windows XP/2000/NT/98/Vista, *UNIX*, Linux. Thanks & Regards *Ajay * *(469-713-1976 (M)* * 972-607-9595 Ext- 6 (O))* ePower. Inc, 7423 Las Colinas Blvd, Suite 102, Irving, Texas 75063. [email protected] Fax: (972) 409-9018 www.epowerus.com -- You received this message because you are subscribed to the Google Groups "ORACLE DWH DBA" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/oracle-dwh-dba?hl=en.
