3- 6 years of experience at Enterprise-level ETL development and ETL architecture using Informatica and understanding the COBOL file structures.
Strong Database knowledge in the areas of general SQL
Strong Informatica technical knowledge in the areas on Informatica Designer Components -Source Analyzer, Warehouse Designer, Mapping Designer & Mapplet Designer, Transformation Developer, Workflow Manager and Workflow Monitor.
Good knowledge of analytical and logical conceptual level programming skills
Good knowledge of Erwin model generation tools (logical and physical)
Data analysis, data mapping, data loading, and data validation.
Understand reusability, parameterization, workflow design, etc.
Support other ETL developers; providing mentoring, technical assistance, troubleshooting and alternative development solutions
Should have thorough understanding of Entire life cycle of Software and various Software Engineering Methodologies.
Performance tuning and end-to-end lifescycle experience with Enterprise wide data warehouse.