Hi,
Hope you are doing great,
Please find the my consultant summery please let me know if any position is available for her...
Alekya
248-793-9043
Summary:
· 7 years of overall experience in IT Industry with Data warehousing tools using industry accepted methodologies and procedures.
· Overall IT industry experience includes Data Integration, Data Migration and Analysis for Decision Support Systems in Health Care, Banking, Financial, Retail Business and Pharmaceutical Industries.
· 7 years of Data Warehousing experience using Informatica Power Center 9.x/8.x/7.x, Power Connect, Data marts, OLAP and OLTP.
· Experience with Database Systems like Oracle BRM, MS SQL Server and DB2 etc.
· Experience with CRM applications like Salesforce.
· Extensive development, support and maintenance experience working in all phases of the ETL Life Cycle.
· Good understanding of Salesforce Object Query Language (SOQL)
· Used Apex Data Loader to export and import data into Salesforce as well as eclipse plug-in for Salesforce which is used to test the data in a sandbox by querying
· Involved in understanding client Requirements, Analysis of Functional specification, Technical specification preparation and Review of Technical Specification.
· Involved in identifying bugs and enhancement of existing mappings by analyzing the data flow, evaluating transformations and fixing the bugs so that they conform to the business needs and redesign the existing mappings for improving the performance.
· Extensive experience in using various Informatica Designer tools like Source Analyzer, Transformation Developer, Mapping Designer, Mapplet Designer and Target Designer.
· Experienced in Performance of Mapping Optimizations in Informatica.
· Developed Informatica Mappings/Mapplets to extract data from multiple sources, transform data and then loaded to the Salesforce database using Informatica Power Exchange.
· Used transformations like Aggregator, Joiner, Source Qualifier, Lookup, Expression, Router, Filter, Salesforce Lookup, XML etc to develop Mappings/Mapplets using Informatica Power Center Designer.
· Loaded data into lookup tables from heterogeneous source systems.
· Worked directly with non-IT business analysts throughout the development cycle, and provide production support for ETL.
· Involved in analysis, review and development of Informatica Mappings, its corresponding Sessions and Workflows.
· Experience in integration of various data sources with Multiple Relational Databases command line utilities like PMCMD (Informatica command line utility) to execute workflows in non-windows environments.
· Experienced in using Informatica Team Based Development which is an SCM functionality that allows multiple versions of objects to be stored in the repository.
· Involved in implementing Slowly Changing Dimensions mainly Type1, Type2 and Type3 methodologies.
· Involved in Testing, Test Plan Preparation and Process Improvement for the ETL developments.
· Strong experience with UNIX Shell Scripting.
· Have extensive knowledge in Database and Application Performance Tuning.
· Experienced in Salesforce Integration and Data Migration
· Involved in the creation of custom fields, custom objects and maintaining the relationships between objects in Salesforce
· Good exposure to development, testing, debugging, implementation, documentation, user training & production support.
· Quick learner and adaptive to new and challenging technological environments.
· Excellent communication skills and ability to work effectively and efficiently in teams and individually.
Technical Skills:
| ETL Tools
| Informatica Power Center 9.x/8.x/7.x: OLAP, ROLAP, MOLAP, Star Schema, Snowflake Schema, OLTP. |
| Data Modeling | Dimensional Data Modeling, Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables, Physical / Logical Data Modeling, Erwin 7.0 |
| Databases | Oracle 11/10g, SQL Server 2008R2, DB2, MS Access 2000. |
| Reporting Tools | BUSINESS OBJECTS – Designer COGNOS- Power Play transformer. |
| Programming | SQL, PL/SQL, Transact SQL, HTML, DHTML, XML, C, C++, ASP.NET, Shell, Perl |
| Environment | Windows95/98/2000/XP/2003, Unix-AIX 5.2/4.3,Sun Solaris7, WinNT4.0 |
| ETL Tools
| Informatica Power Center 9.x/8.x/7.x: OLAP, ROLAP, MOLAP, Star Schema, Snowflake Schema, OLTP. |
Thanks & Regards,
Kartheek
Technical Recruiter, ePromptus, Inc,
43155 MAIN STREET,
SUITE # 2212C,
NOVI, MI 48375.
Kartheek@epromptus.com
Phone# (248) 468-1603/Ext:110
Direct: 248-793-9043//Fax: (248) 928-9235//
Web: epromptus.com
You received this message because you are subscribed to the Google Groups "IT JOBS in USA" group.
To unsubscribe from this group and stop receiving emails from it, send an email to it-jobs-in-usa+unsubscribe@googlegroups.com.
To post to this group, send email to it-jobs-in-usa@googlegroups.com.
Visit this group at http://groups.google.com/group/it-jobs-in-usa.
For more options, visit https://groups.google.com/groups/opt_out.
No comments:
Post a Comment