Experience in Information Technology with a background in Database development and Data warehousing and nearly Four years of experience in ETL process using Informatica Power Center 9.x/8.x/7.x.
-
Good knowledge of Data warehouse concepts and principles (Kimball/Inman) - Star Schema, Snowflake, SCD, Surrogate keys, Normalization/De normalization.
-
Experience in integration of various data sources with Multiple Relational Databases like Oracle, SQL Server, DB2, COBOL files, XML Files and Worked on integrating data from flat files like fixed width and delimited.
Have extensively worked in developing ETL for supporting Data Extraction, transformations and loading using Informatica Power Center.
-
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 Qualifiers, Expressions, Filters, Joiners, Routers, Union, Unconnected / Connected Lookups and Aggregators.
-
Strong Experience in developing Sessions/tasks, Worklets, Workflows using Workflow Manager Tools - Task Developer, Workflow &Worklet Designer.
Experience with Type 1, Type2, Type3 Dimensions.
Experience with slowly changing dimension methodology and slowly growing targets methodologies.
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.
Hands on 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.
Worked with Stored Procedures, Triggers, Cursors, Indexes and Functions.
Experience with OLAP, ROLAP and other BI tools.
-
Experienced in NETEZZA data warehouse appliance to built Massive volumes of data.
Strong Knowledge in optimizing database performance.
Experience in UNIX shell scripting, CRON, FTP and file management in various UNIX environments.
Excellent communication skills.
Good team player with strong analytical skills.
You received this message because you are subscribed to the Google
Groups "Tech_Recruiters" group.
To post to this group, send email to tech_recruiters@googlegroups.com
To unsubscribe from this group, send email to
tech_recruiters+unsubscribe@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/tech_recruiters?hl=en
Get Paid To Read Emails. Free To Join Now!
http://www.emailcashpro.com/?r=antonynj
---
You received this message because you are subscribed to the Google Groups "Tech_Recruiters" group.
To unsubscribe from this group and stop receiving emails from it, send an email to tech_recruiters+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
No comments:
Post a Comment