Technical Specialist-Data Engg

Technical Specialist-Data Engg with 8+ years of experience in ETL Informatica tools, responsible for designing, developing, and maintaining complex data integration solutions using Informatica PowerCenter10.x and IDMC.

Requirements

• Must have at least 8+ Years of working experience in ETL Informatica tools.
• Strong experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Metadata Manger), Power Exchange, Power Connect as ETL tool on Oracle, SQL Server Databases.
• Extensive experience in developing Stored Procedures, Views, Complex SQL queries using SQL Server and Oracle PL/SQL.
• Gather the requirements from the business and create detailed technical design documents, and model data flows for complex ETL processes using Informatica PowerCenter
• Experience in resolving on-going maintenance issues and bug fixes, monitoring Informatica sessions as well as performance tuning of mappings and sessions.
• Ability and experience in managing/ coordinating with Onshore-Offshore teams