Informatica Developer
Location : Vizag, India,
Experience : 7 Year
Rate: $16 / Hourly
Availability : Immediate
Work From : Any
Category : Information Technology & Services
• 6.6 years of experience in business Intelligence as ETL Informatica PowerCenter developer, Informatica PIM (Informatica Product 360) and Informatica Data Quality (IDQ) for PIM DQ rules creation. Informatica DIH for Data Integration to publish and subscribe the data.
• Worked on build of Import, Export, Merge, Data Quality, Structure functionality of Informatica Product 360(Informatica PIM).
• Extensively used Informatica PowerCenter 10.x/9.x as ETL tool for extracting, transforming and loading from various source data inputs to various targets, in batch.
• Knowledge of data warehouse approaches – Top down (Inman’s approach) and Bottom up (Kimball’s approach), methodologies- Star Schema, Snowflake.
• Experience in relational databases like Oracle, DB2 and SQL Server.
• Experience in integrating data from flat files - fixed width, delimited, XML by using various transformations available in Informatica such as – Source qualifier, XML parser transformation.
• Used various Informatica PowerCenter transformations such as – source qualifier, aggregator, update strategy, expression, joiner, lookup, router, sorter, filter, Normalizer transformation, XML Parser to perform various data loading and cleansing activities.
• Used various performance techniques in Informatica such as – partitioning, tuning at source/target/transformation, usage of persistent cache, replacing transformations that use cache wherever possible.
• Created complex mapplets to be shared among team members.
• Extensive experience in developing various tasks, workflows, worklets, mapplets and mappings.
• Extensive knowledge on debugging of Informatica mapping/workflows, unit testing of the mapping/workflows.
• Extensively used Informatica repository manager for exporting / importing of workflows. Workflow monitor for workflow status.
• Extensive knowledge on different types of dimension tables – type 1 dimension, type 2-dimension, junk dimension, confirmed dimension and degenerate dimension.
• Extensive knowledge on scheduling tools – Control-M and Informatica Scheduler.
• Extensively used Control-M enterprise manager to schedule jobs, perform initial data loads, data copy from one environment to another when the environment is initially setup