. Manages development and testing tasks and ensuring adherence to previously agreed to timelines communicating status.
2. Evaluates the integration a various data sources like Oracle, SQL server, VSAM and sequential files into staging area and recommends and/or implements efficiencies.
3. Counsels team members on the evaluation of data using the Informatica Data Quality (IDQ) toolkit. Applies data analysis, data cleansing, data matching, exception handling, and reporting and monitoring capabilities of IDQ
4. Performs technical walk-through as needed to communicate design/coded solution and to seek input from team members.
5. Develops ETL processes using Informatica, ETL control tables, error logging, auditing, data quality, etc.
Bachelors Degree in Computer Science or related field required
experience at Enterprise-level ETL development and ETL architecture using Informatica and understanding the COBOL file structures.
Strong Teradata technical 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.