Manager - ETL Development - Informatica/Power Center

  • Bangalore
  • Confidential
  • 10-20 years
  • Views
  • 22 Jan 2019

  • IT/ Information Technology

  • Accounting/ Taxation/ Audit
Job Description

Essential Functions :
- Design, develop, test, and deploy data integration processes using Informatica PowerCenter
- Collaborate with business users, analyze user requirements, translate & apply business rules to data transformations
- Lead and mentor junior developers in information integration standards, best practices, etc.
- Create functional & technical documentation - e.g. data integration architecture flows, source to target mappings, ETL specification documents, run books, test plans
- Performs data collection, profiling, validation, cleansing, analysis, and reporting
- Tests, debugs, and documents ETL processes, SQL queries, and stored procedures
- Extracts and analyzes data from various sources, including databases and flat files
- Initiates analysis to identify data inconsistencies and resolve in order to raise the level of data integrity
- Analyzes data volumes, data types and content to support the design of data architecture solutions
- Work with Data Warehouse Architects performing source system analysis, identification of key data issues, data profiling and development of normalized and star-snowflake physical schemas
- ETL design, development, deployment, optimization, and support
- Develop error handling processes
- Create and implement scheduling strategy. Desired Candidate Profile:  

Job Posted By

About Organisation