Keywords
Skills
- Have 6+ years of Experience In the field of IT as Data warehouse Analyst, Design, Development and utilizing my technical skills and experience with opportunity for learning.
- Experience in source systems analysis and data extraction from various sources (Flat files, XML files, Oracle 8i/9i/10g/11g, DB2, SQL Server, Teradata, MQ and SAP) into staging area and target Data warehouse.
- Experience in converting the Business Logic into Technical Specifications.
- Extensive professional expertise in Extraction, Transformation and Loading (ETL).
- Extensively worked on processing stages like join, merge, lookup, transformer, change capture, Remove duplicates, Funnel, Filter and Pivot stages.
- Strong in UNIX. Extensively used UNIX scripts for scheduling the jobs.
- Exposed to various segments of Data warehouses like BANKING and Retail
- Experience in development and administration of Data Stage.
- Excellent analytical skill, problem solving skill, interpersonal skill, good communication skill, presentation skills and team player with ability to work under tight schedule.
Project history
- Configured IBM Infosphere Datastage and Qualitystage, created users, groups, credential mappings and assigned administrator and user roles, privileges in different environments.
- Configured Environment variables, security, and connectivity.
- Added, deleted and setup DataStage projects from Data stage administrator.
- Used Technical transformation document to design and build the extraction, transformation, and loading (ETL) modules.
- Designed the mappings between sources (external files and databases) to operational staging targets.
- Configured the server files uvobdc.confg and .odbc.ini files and setup TNS entries.
- Developed Parallel jobs using Parallel stages like: FTP, Dataset, Sequential file, Complex flat file, Funnel, Filter, Modify, CDC, Merge, Join, LookUp, Transformer, Oracle enterprise stage, Oracle Connector, etc.,
- Used Data stage Director for Scheduling the sequences and jobs.
- Designed the jobs in Data Stage Designer to extract the data from the OLTP to staging area and target
- Responsible for monitoring/troubleshooting Data Stage jobs during the production data load processes
- Resolved errors in compilation and execution of different jobs.
- Extensively used UNIX scripts (Crontab) for scheduling the jobs.
- Performed Unit Testing, Integration Testing and User Acceptance Testing (UAT) for every code change and enhancement.
Local Availability
Only available in these countries:
Haiti
