* 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*
Raghunandan
* Informatica*
8 Years
NJ
Immediately
*Summary*
· Over 8 years of strong Data Warehousing experience using *Informatica
PowerCenter* (*Workflow Manager, workflow Monitor, Source Analyzer,
Repository Manager, Mapping Designer, Mapplet Designer, Transformation
developer*).
· 8 years of total IT experience and Technical proficiency in the
Data Warehousing involving Analysis, Application Design, Data Modeling,
Development Implementation and deployment of Data Warehouses/Data Marts.
· Experience in developing Informatica mappings, mapplets, sessions,
workflows and repository creation and maintenance.
· Experience in administering Informatica server activities
like *creating,
scheduling and managing sessions.*
· Knowledge of full life cycle development for building a Data
Warehouse.**
· *Good working knowledge in Data Modeling using Dimensional Data
modeling, Star Schema/Snow flake schema, FACT & Dimensions tables, Physical
& logical data modeling*.**
· Vast experience in designing and developing complex mappings from
varied transformation logic like *Unconnected and Connected lookups, Source
Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy,
Union, Sequence Generator, Sorter, Rank, Normalizer * etc.**
· Involved in writing various UNIX shell scripts for writing
automated scripts for scheduled queue process and PMCMD commands.
· Experience in writing, testing, and implementation of the cursors,
procedures, and functions at database level using PL/SQL and DB2.
· Familiar with Erwin 4.X and Sybase Power Designer 11 as data
modeling tools.
· Interacted and well managed various offshore teams.
· Expertise in Query Analyzing, performance tuning of informatica
mappings and testing.
· Extensive database experience and highly skilled in SQL in Oracle,
MS SQL Server, DB2, Teradata, Sybase, Mainframe Files, Flat Files, MS
Access.
· Exceptional hands on working knowledge and recent experience
working with *SQL* *Server* Integration Services (*SSIS*) and *SQL*
*Server*Reporting Services (
*SSRS*).
· Experience in creating reports using SSRS and worked on OLAP
environment
· Experience in creating packages to transfer data between ORACLE,
MS ACCESS and FLAT FILES to SQL SERVER using DTS/SSIS.
· Experience in writing database scripts such as SQL queries, PL/SQL
Stored Procedures, Indexes, Functions, Views, Materialized views and
Triggers.
· Experience in writing UNIX shell scripts to support and automate
the ETL process.
· Experienced in populating Fact/Dimension tables for adhoc queries
and summary tables.
· Excellent communication and inter personnel skills, Proactive,
Dedicated and Enjoy learning new Technologies and Tools.
· Strong commitment towards quality, experience in ensuring
compliance to coding standards and review process.
* *
*TECHNICAL SKILLS*
Operating systems: Windows 95/98/00/NT/XP, Windows Server
2003, UNIX .
ETL Tools: Informatica power center
6.x/7.x/8.x.
Data Modeling: Star-Schema Modeling, Snowflake Modeling,
FACT and Dimension Tables.
Databases: Oracle, MS SQL Server, DB2, MS
Access, TeraData.
Languages: PL/SQL, SQL, UNIX, C, C++.
Web technologies: HTML, DHTML, XML, ASP, ASP.NET.
Applications: MS Word, Excel, Outlook, FrontPage,
PowerPoint, MS-Vis.
Teradata Utilities: BTEQ, FastLoad, MultiLoad, FastExport,
TPump, Teradata Sql Assistant.
Other tools: ERWIN, Toad.
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.
