Analyze and understand the business process and requirements
Discuss with BA’s on requirements and solution
Design new ETL mappings using Informatica as per the new requirements, modifying existing mappings as per the change requests
Enhanced existing ETL solution for optimized performance
Involved in populating data from flat files, oracle database from landing to ODS (Staging) and into Targets
Experience
Having 3+ years of experience as Informatica developer
Expertise in development and implementation of business intelligence system with meticulous knowledge in BI technologies like Informatica, DataStage, Oracle and Data modelling concepts
Thorough knowledge on Data warehousing concepts like star schema, snowflake star schema, dimension and fact tables
Experience in extractring of data from multiple sources and load to targets
Experience in Creating complex mappings using Aggregator, Expression, Joiner, Filter, sorter, Union, Sequence Generator, Connected & Unconnected Lookup, Router, Union and Update Strategy transformations using Informatica Power center designer.
Having good knowledge on
Education
EDUCATIONAL QUALIFICATIONS
B.Com (Computers) from Girraj Govt College (Autonomous), Nizamabad.(T.S.)
