Job Location: Bangalore/Bengaluru
Must Have:
- Experience in Data warehousing projects using Informatica ETL tool
- Data extraction from different sources such as SQL Server, Teradata, flat files, Excel, and XML files
- Should be proficient using PowerCenter and Informatica Data Quality
- Should have good understanding of Data Quality processes, methods and project lifecycle.
- Should have hands on experience of Profiling, Standardization and Address Validation, Matching and Consolidation Techniques
- Should be able to manage reference tables in the Analyst Tool, Design and develop Mapplets, validate addresses, Identify duplicate records
- Should be expert in working with Informatica Developer 9.x, GUI, Mappings, Mapplets, Transformations, Content Sets, Data Objects
Should be Able to Profile –
- Join Analysis Profiling, Column Profiling
- Multi Object Profiling, Mappings and transformations
- Mid-stream profiling, Comparative profiling
- Business Rule profiling – Out of box as well as customized rule profiling
- Experience validating the ETL and writing SQL queries
- Strong knowledge in DWH concepts
- Should have expertise in Third party schedulers (Cronicle, UC4, etc.,)
- Should have clear understanding of DW Lifecycle and contributed in preparing technical design documents and test plans
- ETL performance tuning, lead a small team and providing technical guidance to them to meet critical timelines.
- Good analytical problem-solving skills
- Good communication and presentation skills
Desired Knowledge / Skills:
- Experience / Knowledge on other ETL tools
- Sound knowledge on Cloud environment like AWS, Azure, IICS
- Worked in Offshore / Onsite Engagements
Submit CV To All Data Science Job Consultants Across India For Free
