Previous Job
Previous
Informatica Analyst With AWS Knowledge -
Ref No.: 20-02603
Location: nyc, New York
Position Type:Contract
  • 5 to 8 years of experience., Worked extensively on SQL, ETL tools include INFORMATICA., With AWS Knowledge
  • Experience in gathering and writing detailed business requirement and translating them into technical specifications and design., Extensive knowledge in Business Intelligence and Data Warehousing Concepts with emphasis on ETL and System Development Life Cycle (SDLC).,
  • Extensive knowledge on Data Profiling using Informatica Developer tool.,
  • Experience in Performance Tuning and Debugging of mappings and sessions.
  • Strong in optimizing the Mappings by creating/using Re-usable transformations, Mapplets and stored procedures, Worked on data profiling & various data quality rules development using Informatica Data Quality.,
  • Implemented Exception Handling Mappings by using Data Quality, data validation by using Informatica Analyst, Implemented Change Data Capture using Informatica., worked on Informatica tools like source analyzer, mapping designer, workflow manager, workflow monitor, Mapplets, Worklets and repository manager.,
  • Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables, Used Debugger in Informatica Power Center Designer to check the errors in mapping., Created test cases and completed unit, integration and system tests for Data warehouse.