Hello Business Partners
*GREETINGS FROM VIRGO INC* Let me know if you have any opening Positions for my below *Available Consultants!!!! * *(Note: Our consultants are authorized to submit only to your direct clients or prime vendors. Third party layers are strictly prohibited)* ** ü Over 7 years of IT experience in *development, design and implementation with major focus on database and data warehousing applications* ü Strong in Data warehousing Concepts, *Star Schema and Snowflakes Schema methodologies, understanding business process/requirements* ü Experience with dimensional *and relational database design*. ü Good understanding of *Software Development Life Cycle (SDLC) and Project Life Cycle*. ü Data Processing Experience in Designing and implementing Data Mart applications, mainly transformation Process using ETL tools like *Informatica, Sagent, Genio Designer, Business Objects Data Integrator* Extensively worked on *Extraction Transformation and Loading (ETL)* using * Informatica* *8.5 / 7.1 / 6.1.2 / 5.1 / 4.7* (Power Center / Power Mart) *(*Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Task Developer, Worklet Designer, Workflow Designer),Power Exchange, Power Connect*.* ü Experience in *Data Modeling* *(Logical and Physical Design for distributed databases, Reverse-engineering and Forward-engineering using Erwin*). ü Expertise in *Designing Fact Tables, Dimension Tables, Summary Tables*. ü Involved in extracting source data from *DB2, Flat Files, VSAM files* on different systems and populated target data warehouse on *NCR Teradata. *** ü Utilized *Teradata Fast Load, Multi Load options* for loading data to *Teradata database*. ü Used *Teradata Tools* and Utilities like *BTEQ/ODBC/JDBC/OLE* ü Developed* *sql code for* data validations and data computation process on source DB2 *transaction system and on target warehouse using* Teradata* ü Excellent experience in tuning *Informatica Mappings and Sessions *for optimum performance. ü Expertise in working with *Oracle Stored Programs, Packages, Cursors, Triggers, Database Link*, Snapshot, Roles, Privileges, Tables, Constraints, Views, Indexes, Sequence, and Synonyms Dynamic SQL and SQL*Loader in distributed environment** ü Experience in performing *Integration, System, Functionality, User Acceptance Testing.* ü Implemented *performance tuning techniques at *application, database and system levels.** ü Worked extensively with *OLAP / BI tools such as Business Objects, Cognos.* ü Experience in *Unix and Perl Shell scripting for automating the Jobs*. ü Effective in cross-functional and global environments to manage *multiple tasks & assignments concurrently.* ü Highly organized and detail-oriented professional with strong business and technical skills. * * *Education:* Bachelors Degree in Computer Science from JNT University, India – April 2001 * * Technical Skills: ETL Tools Informatica 8.1//7.1.x/6.2/6.1/5.1 (Power Mart/ Power Center) 6.x, Informatica Power Exchange,Informatica Power Connect, Datastage 7.5.x Reporting Tools Business Objects XI r2/r1/6.5/6.1/5.1, CognosReportnet,Cognos8, SSRS(SQL Reporting Services),SAS Databases Oracle 10g/9i/8i/8.0/7.x, IBM DB2 UDB 8.0/7.0, Teradata v2r5/v2r6,MS SQL Server 2005/2000/7.0/6.0, Sybase,MS Access. Database utilities SQL *plus, Stored procedures, Functions, Exception handling. Data Modeling tool/ Methodology MSVisio, ERWIN 4.x/3.x, Ralph-Kimball Methodology, Bill-Inmon Methodology, Star Schema, Snow Flake Schema, Extended Star Schema, Physical And Logical Modeling. Languages C, C++, JAVA, Visual Basic, T-SQL, PL/SQL ,XML Operating Systems HP-UX, Unix, IBM AIX 4.3/4.2, SunSolaris 9/8/7, Windows 2003/2000/NT ** ** *Thanks & Best **Regards**,* *Kumar M.A.* *Virgo, Inc || "Technology Leaders"|| 333 N Oxford Valley Road ||* *Suite 405 Fairless Hills || PA 19030 || Fax: (805) 926 4256 || * *Ph: 215-310-1562 Ext 214||* *Email: [EMAIL PROTECTED] <[EMAIL PROTECTED]>**||* *Web: www.virgosystemsinc.com* --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "jobinusa" 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/jobinusa?hl=en -~----------~----~----~----~------~----~------~--~---
