Hi, Good Morning
Available Sr. Informatica Developer-Open to Relocate
Name: SKR
Rate: $open/hr C2C
Availability: Immediate
Relocation: Yes
Current Loc TX
I appreciate if you have any requirements today, please forward to
<javascript:top.opencompose('[email protected]','','','')> [email protected]
. Please add me in your daily requirements distribution list
Summary of Experience
* 7+ years of work experience in IT Industry in Analysis,
Development and Maintenance of various software applications in Data
warehouse environment.
* Strong experience in providing Business Intelligence solutions
using Informatica PowerCenter 8.x/7.x/6.x/5.x.
* Good knowledge of Data warehouse concepts and principles
(Kimball/Inmon) - Star Schema, Snowflake, SCD, Surrogate keys.
* Experience in integration of various data sources with Multiple
Relational Databases like Teradata, Oracle, SQL Server, and XML files, Main
Frames, IBM DB2 and Worked on integrating data from flat files like fixed
width and delimited.
* Strong experience in activities related to the development,
implementation, administration and support of ETL processes for large-scale
data warehouses using Power Center and Power Exchange.
* Excellent knowledge of Informatica Administration. Involved in
grid management, creation and upgradation of repository contents, creation
of folders and users and their permissions.
* Well acquainted with Informatica Designer Components - Source
Analyzer, Warehouse Designer, Transformation Developer, Mapplet and Mapping
Designer.
* Worked extensively with complex mappings using different
transformations like Source Qualifier, Expression, Filter, Joiner, Router,
Union, Unconnected / Connected Lookups and Aggregator.
* Strong Experience in developing Sessions/tasks, Worklets,
Workflows using Workflow Manager Tools - Task Developer, Workflow & Worklet
Designer.
* Expertise in several key areas of Enterprise Data Warehousing
such as Change Data Capture (CDC), Data Quality, and lookup Tables and ETL
data movement.
* Profound knowledge about the architecture of the Teradata
database.
* Strong experience in developing Teradata Loading and Unloading
utilities like Fast Export, Fast Load, and Multiload (Mload).
* Extensive knowledge with Teradata SQLAssistant,Coded complex BTEQ
scripts to load the data from Teradata staging to Teradata warehouse and
then to datamarts as per reporting requirements and finely tuned the queries
to enhance performance.
* Experience in identifying Bottlenecks in ETL Processes and
Performance tuning of the production applications using Database Tuning,
Partitioning, Index Usage, Aggregate Tables, Session partitioning , Load
strategies , commit intervals and transformation tuning.
* Extensively worked with Oracle PL/SQL Stored Procedures,
Functions Cursors, Indexes and Triggers and involved in Query Optimization.
* Experience in using the Informatica command line utilities like
pmcmd to execute workflows in non-windows environments.
* Experience in debugging mappings. Identified bugs in existing
mappings by analyzing the data flow and evaluating transformations.
* Strong experience in Performance Tuning of sources, targets,
transformations and sessions.
* Good experience in documenting the ETL process flow for better
maintenance and analyzing the process flow.
* Experience in UNIX shell scripting, CRON, FTP and file management
in various UNIX environments.
* Created personalized version of reports as well as statements for
customers using the data from Informatica metadata and then generated
Business Objects reports using slice and dice capabilities.
* Highly Motivated to take independent responsibility as well as
ability to contribute and be a productive team member
Technical Skills
ETL Tools
Informatica Power center 8.6/8.1/7.1/6.2, DataStage.7.5/7.1, SQL*Loader,
Bulk Loader, SQL Server DTS
Reporting Tools
Cognos, Business Objects XI, MS SQL Server Reporting services 2005,
Developer 2000(Forms 5.0, Reports 6i), Crystal Reports 10, Crystal Reports
2008.
Databases
Oracle 11i/10g/9i/8i, SQL Server, Sybase 12.5, Teradata, DB2 UDB, MySQL, MS-
Access
Data Modeling
Erwin 4.0/4.1
Programming Skills
Shell Scripting, K-Shell, C-Shell, C, C++, SQL, PL/SQL, Pascal, FORTRAN.,
COBOL
Scripting Languages
Unix Shell Scripting , JCL
GUI
Toad 7.4,Oracle designer
Operating Systems
UNIX(Sun Solaris 2.x,HP/UX), Win 95/NT/98/2000/XP, MVS,MS-DOS, IBM AIX 4.2
Scheduling Tools
JOBTRAC, Autosys.
Applications:
MS Word, Excel, Outlook, FrontPage, PowerPoint
Utilities
SQL* PLUS, PVCS, Visio
Available Consultants: SQL,Java flex, informatica, Oracle dev/DBA,BO,Cognos,
.Net,QA,SAS, Data modeler, Teradata, OBIEE,ETL Arch, Datastage and etc.,
Thanks & Regards,
Sri Mathew
Zuven Technologies Inc
555 Republic Drive || PLANO, TX 75074
Cell: 469-361-2279
Mail to: <mailto:[email protected]> [email protected]
<http://www.linkedin.com/pub/sri-sri/13/b59/379> View my profile on
LinkedIn
Note: We respect your on-line privacy. This is not an unsolicited mail.
Under Bill 1618 Title III passed by the 105th US Congress this mail cannot
be considered Spam as long as we include contact information and a method to
be removed from our mailing list. If you are not interested in receiving our
e-mails then please reply with a "REMOVE" in the subject line. I am sorry
for the inconvenience caused to you
--
To unsubscribe, reply using "remove me" as the subject.
<<image001.gif>>
