*Please share me the requirements if you are interested in this Profile.*
*Hardeep Singh Arora* *Title: BI DW ETL Lead/Architect* *Current Location: Chicago, IL* *Relocation: Open* *Available: Immediately* Professional Summary - Over *8 years* of experience in the IT industry. His main area of expertise is in *Teradata, Informatica, Oracle and Data Warehousing*. He is currently working for a Data warehousing project for one of the biggest global biopharmaceutical company*. * - Extensive experience in Data Warehousing, Data Analysis, Reporting, ETL, Data modeling, Development, Maintenance, Testing and Documentatio *n.* - Involved in Project planning, Scheduling, System design, Functional specification, Design specification, Coding and System test plan. - Thorough understanding of *Business Intelligence* and Data Warehousing concepts with emphasis on ETL and Full Life Cycle. - Extensive Experience in data staging, database design, data warehouse requirement analysis and Implementation. - *Extensively used ETL methodology* for supporting data extraction, transformation and loading process, in a corporate-wide-*ETL Solution using Informatica*. - Extensive experience with Data Extraction, Transformation, and Loading (ETL) from Operational Data sources using Informatica. Strong experience in Performance of Data warehouse by SQL tuning, Query optimizer and Indexing. - Strong understanding of Performance tuning in Informatica and databases. Experienced in loading data into Data Warehouse/Data Marts using Informatica. - Experience in writing *UNIX Shell scripts*. - Good Knowledge in *Teradata* data warehouse architecture. - He is *Teradata Certified Professional*. · Extensive Experience in using Teradata utilities *Fast load*, *Fast Export*, *Multiload* and *BTEQ* using shell scripting*.* · Provided *performance tuning and physical/logical database design*support in projects for Teradata systems. · Teradata performance tuning via *Explain plan, PPI, AJI, Indices, Collect statistics or rewriting* of the code. - Extensive experience in database design for data warehouses with *strong understanding of Dimensional Modeling, Star and Snowflake Schemas, 3rd normal form* Data models. - Specialist in Retail, RMA, Service Contract, Install Base & Service, Sales and Finance related subject area. - Experience in Informatica PowerCenter (versions 8.x/9.x), Mappings, Mapplets, Transformations, Workflow Manager, Workflow Monitor, and Repository Manager. - Have extensive experience in Onsite / Offshore Client Handling Technical Skills *OPERATING SYSTEMS :* Windows 98, XP, UNIX *LANGUAGES * *:* SQL, PL/SQL, C/C++, Oracle/Teradata SQL *DATABASES* *:* Teradata V2R6, Oracle9i *DOMAIN KNOWLEDGE* *: *Media, Aviation, Services, Sales Order, Finance, Data Warehousing *TOOLS & UTILITIES :* Erwin, HP Quality center, Kintana, $U, Teradata SQL assistant 13.0, Teradata Toad, Teradata Manager, PVCS, HPSD, Viewpoint, Shell Scripting *ELT/ ETL TOOLS* *:* Teradata Load Utilities, TOAD, Informatica 8.x/9.x Certifications *Teradata Certified Professional V2R5*<https://www.certmetrics.com/teradata/candidate/cert_progress.aspx?cert=37048> *Teradata Certified SQL Specialist V2R5*<https://www.certmetrics.com/teradata/candidate/cert_progress.aspx?cert=37050> Thanks and Regards, Mamatha Paladugu, Business Development Manager Libsys Inc 630 303 9072 mama...@libsysinc.com www.libsysinc.com http://www.linkedin.com/in/mamathalibsys -- You received this message because you are subscribed to the Google Groups "IT Auditor Resumes" group. To unsubscribe from this group and stop receiving emails from it, send an email to itresumes+unsubscr...@googlegroups.com. To post to this group, send email to itresu...@googlegroups.com. Visit this group at http://groups.google.com/group/itresumes. For more options, visit https://groups.google.com/d/optout.