HI Partners,
We have an excellent Informatica ETL Developer available for your requirements. Please find his brief details below Feel free to contact me at at 732 993 6175; 732 410 2100 Ext 201 or anil@sunmergesystems.com for Resume and Contact Details.
Name: Pradeep Kumar
Skill: ETL/Informatica Developer
Location: Philadelphia, PA
Rate: Open
Relocation: Open
Availability: Immediate
Visa H1
SUMMARY
· 8+ years of Strong experience in Complete Software development Life cycle (SDLC) which includes Business Requirements Gathering, System Analysis, Design, Data Modeling, Development, Testing and Implementation of Data Warehouse.
· 5+ yrs of technical hands-on experience in development of Data warehousing solutions using Informatica PowerCenter 9.0.1/8.1/7.1/6.1(Workflow Manager, Workflow Monitor, Repository Manager, Designer -- Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, and Transformation Developer), Informatica, DataMart, ETL, OLAP, ROLAP, MOLAP, OLTP, Star/Snowflake Schema, Autosys.
· Strong experience in installation of Informatica and configuration of Informatica PowerCenter 8.6/9.0.1.
· Experience in using Oracle 11g/10g/9i/8i, MS SQL Server 2005, MS Access 2007, SQL, PL/SQL.
· Worked with Dimensional Data warehouses in Star and Snowflake Schemas, Slowly changing dimensions and created slowly growing target mappings, Type1/2/3 dimension mappings.
· Proficient in transforming data from various sources (flat files, XML, Oracle) to Data warehouse using ETL tools.
· Extensively worked on transformations such as Source Qualifier, Joiner, Filter, Router, Expression, Lookup, Aggregator, Sorter, Normalizer, Update Strategy, Sequence Generator and Stored Procedure transformations.
· Extensive experience in developing Informatica Mappings / Mapplets using various Transformations for Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse and Creating Workflows with Worklets & Tasks and Scheduling using Workflow Manager.
· Extensively involved in development of Informatica mappings and tuned for their better performance.
· Experience in integration of various data sources Multiple Relational Databases like Oracle, Autosys, SQL Server, MS Access, DB2 and Worked on integrating data from flat files, XML files.
· Experience in design of logical and physical data modeling using Erwin.
· Expertise in using SQL*LOADER to load Data from external files to Oracle Database.
· Worked with various SQL Editors such as TOAD, SQL Plus, and Query Analyzer.
· Experience in Optimizing the Performance of SQL scripts and Oracle database/application tuning.
· Extensive experience in writing PL/SQL programming units like Triggers, Procedures, Functions and packages in Unix and windows environment.
· Strong experience in RDBMS (Oracle and MS Access).
· Strong knowledge on Oracle Business Intelligence.
· Developed Batch Jobs using UNIX AIX Shell scripts (csh, bash, ksh) to automate the process of loading, pushing and pulling data from & to different servers.
· Excellent verbal and communication skills, has clear understanding of business procedures and ability to work as an individual or as a part of a team.
TECHNICAL SKILLS
| Data Warehousing/ETL Tools | Informatica PowerCenter 9.0.1/8.5/8.1/7.1(Source Analyzer, Data Warehouse Designer, Mapping Designer, Mapplet, Transformations, Workflow Manager, Workflow Monitor, Worklets), Informatica Data Analyzer 8.5/8.1, Informatica Power Exchange, Data cleansing, OLAP, ROLAP, MOLAP, Autosys, Control M, Star Schema, Snowflake Schema, OLTP, SQL*Plus, SQL*Loader |
| Data Modeling | Dimensional Data Modeling, Star Join Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, Erwin 7.2/7.0, Toad, Oracle Designer, PL/SQL Developer 5.1.4. Dimensional Data Models /, 3rd NF, TOAD. |
| Databases | Oracle 11g/10g/9i/8i,MS SQL 7.0, SQL Server 2005/2000, MS Access. |
| BI & Reporting Tools | Business Intelligence. |
| GUI | Visual Basic 5.0/6.0, Oracle Forms 6.0, Oracle Reports 6.0, VC++, MS Excel-VBA Macros, MS Word (VBA) Macros, FrontPage 97/98/2000. |
| Programming | C, C++, SQL, PL/SQL, T-SQL, SQL*Plus 3.3/8.0, HTML, UNIX Shell Scripting. (AIX) |
| Environment | UNIX, Windows 2000/2003/XP/Vista. |
Thanks & Regards,
Anil Kumar
T- 732.410.2100 x 201
C- 732. 993.6175
E Mail: anil@sunmergesystems.com
Sunmerge Systems Inc. |Ranked 692 in all USA in INC 5000 | Winner of INC 5000 and Inc 500. for 2009 and 2010| Continuous Winner of NJ Finest for 2007,2008.2009,2010....
You received this message because you are subscribed to the Google
Groups "Tech_Recruiters" group.
To post to this group, send email to tech_recruiters@googlegroups.com
To unsubscribe from this group, send email to
tech_recruiters+unsubscribe@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/tech_recruiters?hl=en
Get Paid To Read Emails. Free To Join Now!
http://www.emailcashpro.com/?r=antonynj
No comments:
Post a Comment