* Informatica Developer AVAILABLE IMMEDIATELY*
**
*REQUEST**: **please take a minute and add **[email protected] ** in
your mailing list for current and future requisitions.***
* Please scroll down to know for other available consultant
Technologies.*
*Consultant*
*Skills*
*Exp*
*Location*
*Availability*
Prajwel
* Informatica*
7+ Years
NJ
Immediately
*Summary*
· *7+ years of experience* in Information Technology including *Data
Warehouse/Data Mart* development using *ETL/Informatica Power Center*.**
· Worked on various domains including Insurance, Finance, Banking,
Pharmaceutical and Retail.
· Good exposure in overall *SDLC* including requirement *gathering,
development, testing, debugging, deployment, documentation, production
support*.
· Worked in various Heterogeneous Source Systems like *Oracle**, DB2
UDB**, Teradata, MS SQL Server*, Flat files and Legacy systems.
· Practical understanding of the *Data modeling (Dimensional &
Relational)* concepts like Star-Schema Modeling, Snowflake Schema Modeling,
Fact and Dimension tables.**
· Good understanding of *views, Synonyms, Indexes, Joins and
Sub-Queries. Extensively used Cursors and Ref Cursors*.**
· Expertise in creating very detailed design documents and
performing *Proof of Concepts (POC)*.**
· Extensively created *mapplets*, *common functions, reusable
transformations, look-ups for better usability*.**
· Sound experience in Performance tuning of ETL process. Reduced the
execution time for huge volumes of data for a company merger projects.**
· Extensive experience in *Tuning* and *scaling* the procedures for
better performance by running explain plan and using different approaches
like hint and *bulk* *load*.**
· Used Power Exchange to integrate the sources like Mainframe MVS,
VSAM, GDG, DB2 and XML files. **
· Experienced with *Teradata* utilities *FastLoad*, *MultiLoad*, *
BTEQ* scripting, *FastExport*, *SQL* Assitant.**
· Extensively used *SQL, PL/SQL* in writing *Stored* *Procedures*, *
Functions*, *Packages* and *Triggers*.
· Great Expertise in using Exception Handling strategies to capture
errors and referential integrity constraints of records during loading
processes to notify the exception records to the source team.
· Experience in *UNIX shell scripting, job scheduling* and
communicating with server using *pmcmd*.
· Delivered all the projects/assignments within specified timelines.
· Effectively communicate with *business*, *project* *manager* and
team members.**
· Strong ability to work within a demanding and aggressive project
schedules and environments.**
· Excellent analytical, problem solving skills and a motivated team
player with excellent inter-personal skills.
· Good team player, strong interpersonal and communication skills
combined with self-motivation, initiative.
* *
*Education & Certifications:*
* *
· Informatica Power Center 8 Advanced Mapping Design.
· Brain Bench Certified in Data Warehousing Concepts.
*Technical Summary:*
ETL Tools
Informatica Power Center 8.6,8.1/7.1.2/6.2 , Informatica Power Mart 6.2,
Power Exchange
Databases
Oracle 10g/9i/8i/7i, IBM UD2 DB2 , Sybase SQL Server 11.0, MS SQL Server
6.5/7.0, MS Access 2000, Teradata
Programming Languages
C, C++, SQL, PL/SQL, UNIX, XML
BI Tools
Business Objects 6/5, Cognos
Web Technologies
JavaScript 1.2, HTML 4.0
Others
Erwin 4.1.2/3.5.2, TOAD, SQL Loader, MS Office, Winscp(FTP), Autosys,
Rational Clear Case/Clear Quest/ Req.pro, Control-M, Tivoli(IBM), MS.Visio,
Harvest, Mercury Quality center(defects)
Operating Systems
Sun Solaris, Windows NT 4.0, Windows 95/98/2000/XP, HP, AT & T Unix, MS DOS
6.22, IBM-PC Compatibles
* *
* *
Regards,
Ritesh Doddle
SVK Systems, Inc |Microsoft & Oracle Certified Partner
Direct : 205-538-2350, Alt : 205-510-7424 x 530
Email:-*[email protected]*
11465, Johns Creek Parkway, Suite #180
Johns Creek,Georgia, 30097
Do not merely listen to the word, and so deceive yourselves. Do what it
says.
James 1:22
--
You received this message because you are subscribed to the Google Groups
"KNOW.IT" 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/know_it_az?hl=en.
