Data Warehousing Etl Developer/Architect/Lead
Washington D.C. Metro Area
Ab Initio GDE Version 3.0.2.1 & COOP v3-0-2-5, UDB EEE, Humingbird AIX, Mainframe▪ Created/implemented/documented/supported numerous Ab Initio graphs and jobs over 11 years.▪ Developed ETL to process many types of data, Policy, Claims, E-Billing, Actuarial, Sales, etc...▪ Sourced data from Mainframe Flat Files, XML, RDBMS, formatting data for Enterprise Data Warehouse to load into DB2 UDB DataMarts.▪ Flattened ‘hierarchical data format’ data (HDF) to normalize into an RDBMS.▪ Used Parallel Multi File System (MFS) processing throughout ETL processes to maximize computing resources and minimize runtime.▪ Performed in ETL process optimization and re-design to meet customer run time targets.▪ Conducted testing at all levels, Unit, UAT (user acceptance), Regression, etc.▪ Coordinated Hand-Off of contracting resources’ ETL development to in-house DW team.▪ Performed ‘Route Cause’ analysis to resolve production data anomalies.▪ Developed in-house code review & promotion request process using SharePoint.▪ Created impact analysis KornShell (AWK, SED, Regular Expressions) script to analyze all production Ab Initio code (.ksh/.dml/.xfr/.sql etc.);▪ Participated in Ab Initio Tool upgrade activities / impact analysis and planning / graph modifications.▪ Mentored junior/contract resources in departmental procedures and ETL coding standards and practices.▪ Participated in on-call support rotation.▪ Performed Cross-Platform (Mainframe) job control using CA7 and Endevor.▪ Created/Maintained SharePoint site for ETL department documentation (VISIO scheduling schematics, etc) . Created and maintained different information repositories used for support activities.▪ Exposed to Netezza architecture.
