Development and management of data integration & ETL jobs consolidation, aggregation, filtering, validation, data quality routines, dimension creation, etc.
Creation of entity relationships, source to target data mapping
Develops, creates and prepares data marts for reporting consumption & / or analytics use cases.
Define and implement automation of jobs. Build and support reusable framework. Executes production-level jobs by considering data dependencies, schedules, validation routines, data stream updates.
Performs unit and system integration testing.
Collaborate with technical users to define data requirements & establish business rules to be applied
Required Technical and Professional Expertise
Designs and builds solutions to move data from operational and external environments to the business intelligence environment using Ab Initio software and DataStage (formerly Ascential) - IBM'
s WebSphere Data Integration Suite.
Skills include designing and developing extract, transform and load (ETL) processes.
Experience includes full lifecycle implementation of the technical components of a business intelligence solution.
Skills include : ETL, Ab Initio, DataStage, Informatica, IBM WebSphere Data Integration Suite, Extract Transform and Load (ETL)
Preferred Technical and Professional Expertise
Must Have skills DataStage (Enterprise ETL Tool) Knowledge in Unix and SQL