We have a Lead Informatica developer rolling of the project in next two
weeks. His current location is CO, but will relocate nationwide for 6
months plus assignments.
Here is the brief profile ;
Mr. Sunil has over ten years experience in information technology.
Throughout his carrier he has lead efforts in the technical design and
development primarily within the areas of *Business Intelligence* and *Data
Warehousing*. His experience includes star/snowflake modeling, ETL
architecture design as well as ETL development using Informatica, SQL,
PL/SQL and UNIX/Windows scripting. His extensive work within Date
warehousing has helped him to gain experience with multiple databases like
Oracle, Exadata, SQL Server, Teradata and DB2. He has also been responsible
working with business users for decision support with Business intelligence
reporting tools such as Business objects.
* *
- Experienced in Enterprise Architecture, Dimensional Modeling, Data
Analysis, Data Integration, Data cleansing/quality and implementation of
Data Warehouse and Database Applications systems.
- Experienced in *Financial, Banking, Healthcare, Manufacturing, CRM,
Security, Insurance, Telecommunication, and Mortgage *domains to reflect
business requirements into Business Intelligence.
- Experienced in Audits/Controls, Error management, ETL design, QA, EDW
standards and CMMI level process guidelines.
- Experienced in creating Functional specifications, Technical design
specifications including process and dataflow documents.
- Good experience in onsite/ offshore models execution.
- Skilled in developing *Type1*, *Type2, Type3 and Hybrid SCD *mappings.
- Experienced in *Performance Tuning* of Source, Targets, mappings,
sessions and Transformation.
- Strong understanding of logical and physical designs used in
developing Database schemas like *Star schema* and *Snowflake
schema*used in dimensional modeling.
- Excellent working knowledge in writing SQL, PL/SQL code, Cursors,
Stored Procedures, Packages and solving performance related issues.
- Experienced in using *parameter files*, *Exp mapping parameters,
mapping variables* in mappings.
- Experienced in *UNIX* shell scripting to support and automate the ETL
process
- Expertise in *Unit testing*, *User documentation* and
Application/Product Demos
- Excellent problem solving, communication, analytical, interpersonal
skills and ability to perform independently and as part of a team
- Experienced in Data Integration with different *CRM (Salesforce.com,
CVent) and* *ERP* systems using PowerExchange for Salesforce/SAP and Web
services.
*TECHNICAL SKILLS*
*ETL*
Informatica PowerCenter 9.1.x/8.6.1/8.x/7.1/6.2/, Data Integrator XI
*OLAP*
Cognos Report Net 1.1/1.02,Business Objects6.1x*, *Qlikview
*Databases*
Oracle 11/10g/9i/8i, Exadata, DB2, SQL Server2000, MS Access, Teradata V2R5
*Operating System*
IBM AIX 5L, Sun Solaris10/9/8/7, HP, Linux ,Windows 7/XP/2000/NT/98/95
*Languages*
UNIX Shell Scripting, Perl, SQL, PL/SQL, HTML, XML, C, C++, and Java.
*Methodologies*
Star Schema, Snow Flake Schema, Fact and Dimension Tables
*Data Modeling*
Erwin 4.0/3.5
*Scripting Tools*
C Shell, Korn Shell, Born Shell, Bash Shell, Perl
*Data warehouse Tools *
SQL Developer,* *SQL*Loader, SQL Navigator, Toad, RAPID SQL, BTEQ,
Fast Load, Multi Load, Tpump, Fast Export**
*Contact Management*
ACT! V5.04, ACT! V6.0.3, ACT! 2006/8.0.2, Goldmine5.0/6.0
Call me if you are interested in talking to him
--
Ravi Reddy
UBCI
Kendall Park NJ 08824
Tel:732-297-9960
email:[email protected]
--
You received this message because you are subscribed to the Google Groups
"DSP_" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/dsp_?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
