* Informatica Developer AVAILABLE IMMEDIATELY* **
*REQUEST**: **please take a minute and add **rit...@svksystems.com ** in
your mailing list for current and future requisitions.***
* Please scroll down to know for other available consultant
Technologies.*
*Consultant*
*Skills*
*Exp*
*Location*
*Availability*
Vilash
* Informatica*
8 Years
MA
Immediately
*Summary*
· *8 years* of IT Experience in *Data Warehousing*, *Database Design
* and *ETL Processes* in the Test and Production environments of various
business domains like finance, manufacturing and health care industries.
· Highly proficient in *Development, Implementation, Administration
*and* Support* of ETL processes for Large-scale Data warehouses using
Informatica Power Center.
· Worked extensively on ETL process using *Informatica** Power
Center** 8.6/7.x**.*
· SQL database experience in a high transaction and multi server
production environment.
· ETL implementation using *SQL Server Integration Services* (SSIS)
· Expert Knowledge of *Integration Services (SSIS)**, Analysis
Services (SSAS) *and *Reporting Services (SSRS). *
· Experience in *Database Development, Data Warehousing, Design *and
*Technical Management*.
· Good understanding in database and data warehousing concepts (OLTP
& OLAP).
· Hands on Experience in *Installing, Configuring, Managing,
Monitoring *and *Troubleshooting* SQL Server 2005/2008.
· Hands on experience in *tuning mappings, identifying
*and*resolving performance bottlenecks
* in various levels like sources, targets, mappings, and sessions and at
database.
· Extensive experience with data modeling techniques, logical and
physical database design.
· Experience in Extracting, Transforming and Loading (ETL) data from
*Excel, Flat file, Oracle* to *MS SQL Server* by using DTS and SSIS
services.
· SQL Server 2008/2005 RDBMS database development including *T-SQL
programming*.
· Extracted data from *File Sources, Relational Sources, XML *and*COBOL
* sources using Informatica PowerCenter.
· Experience in administrating the created reports and assigning
permission to the valid users for executing the reports.
· Worked on OLAP Data warehouse , Model ,Design, Implementation
· Experience in deploying created reports in various sources like
Web browser, XML and PDF.
· Experience in Creating and Updating Clustered and Non-Clustered
Indexes to keep up the SQL Server performance.
· Used Power Exchange to integrate the sources like Mainframe MVS,
VSAM, GDG, DB2 and XML files.
· Experience in *UNIX shell scripting, job scheduling* and
communicating with server using *pmcmd*.
· Experience in Analyzing Execution Plan and managing indexes and
troubleshooting deadlocks.
· Good knowledge in using system tables such as *sysindexes,
sysprocesses, sysobjects *and *syscomment* in various queries and
using *Database
Console Commands (DBCC).*
· Good knowledge in Normalizing and De-normalizing the tables and
maintaining Referential Integrity by using Triggers and Primary and Foreign
Keys.
· In-depth understanding of Data Warehousing and Business
Intelligence concept
· Designed and developed efficient Error handling methods and
implemented throughout the mappings in various projects.
· Experience in querying from multiple databases and write scripts
to manage transactions between two or more DBs
· Experience in Creating Roles and Assigning Permissions to the
users.
· Good knowledge in SQL Server 2005/2000 Client Server Architecture.
· Responsible for interacting with business partners to identify
information needs and business requirements for Reports.
[image: Text Box: Databases Oracle 10g/9i, DB2, SQL server
7.0/2000/2005/2008, MS Access 2000/2005, Teradata Languages Transact- SQL,
SQL,HTML, C, C#, PERL Operating Systems Windows NT/98/2000/XP/Vista/2003,
Linux, Unix, MS-DOS, Sun Solaris. OLAP/Reporting Tools SQL Server Analysis
Service(SSAS), SQL Server Reporting Service(SSRS), Share Point MOSS 2007,
Business Objects 6.x, Cognos ETL Tools SQL Server Integration Services
(SSIS), SQL Server DTS, Informatica Power Center 8.6/7.x Data Modeling Tools
Microsoft Visio 2000/2003 SQL Server Tools SQL server Management Studio, SQL
server Query Analyzer, SQL server mail service , DBCC, BCP , SQL server
profiler Web Technologies MS FrontPage, MS Outlook Express, FTP, TCP/IP, LAN
Other Tools Microsoft Office, MS Visio, Visual Basic 6]*Technical Skills*
Regards,
Ritesh Doddle
SVK Systems, Inc |Microsoft & Oracle Certified Partner
Ph : 205-510-7424 x 530 / Email:-*rit...@svksystems.com*
11465, Johns Creek Parkway, Suite #180
Johns Creek,Georgia, 30097
Give thanks to the Lord, for he is good. His love endures forever. Give
thanks to the God of heaven. His love endures forever.
— Psalm 136:1 <http://www.searchgodsword.org/desk/?query=Psalm+136%3A1>
--
You received this message because you are subscribed to the Google Groups
"KNOW.IT" group.
To post to this group, send email to know_it...@googlegroups.com.
To unsubscribe from this group, send email to
know_it_az+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/know_it_az?hl=en.
