PROFESSIONAL SUMMARY:
Complex flat file allows reading from complex file structures on a mainframe machine, such as MVS data sets, header and trailer structured files, files that contain multiple record types, QSAM and VSAM files. External Source - permits reading data that is output from multiple source programs. I have a CSV file with a comma separator, but the records have different formats. I want to import it to Datastage with a complex flat file stage. I don't know how to deal with the comma separator. Or, can I use another stage to achieve it? Data example: 1,aa,bb 2,bbbb,ffffff,89983,aa. Jun 13, 2020 The complex flat file allows reading on a mainframe machine similar to a header, MVS data sets, and trailer structured files from complex file structures. External Source allows reading data from multiple source programs to output. Lookup File Set is similar to File set Stage. Partitioned hashed file can be used for lookups. Database Stages.
EDUCATIONAL QUALIFICATION:
Bachelors in Electronics and Communication, TECHNICAL SKILLS:
ETL Tools
![]()
DATA STAGE- IBM Web Sphere Data stage and Quality Stage 8.0, Ascential Data Stage /7.5.2/5.1/6.0 Profile Stage 7.0, SSIS (SQL server 2005), Data Integrator.
Business Intelligence tools
Business Objects, Brio, SSRS(SQL Server 2005),IBM Cognos 8 BI
Development Tools and Languages
SQL, C, C++, Unix Shell Scripting, Perl, PL/SQL,oracle
Attic Manager is software used to build and maintain database of your assets: Keep track of all the stuff you have Look up something when you forget where you stored it In case of disaster, have the list ready for the insurance company. Attic Manager is software used to build and maintain database of your assets: Keep track of all the stuff you have. Look up something when you forget where you stored it. In case of disaster, have. A: Attic Manager shows the sum for current selection in the status bar at the bottom of screen at all times. The current selection are items shown in the list, and you can change it by clicking a different location on the left side, and/or filtering via search box. To sum up all items, just select 'My Locations' item on the left side. Attic manager.
Testing Tools
Auto Tester, Test Director, Lotus Notes
Data Modeling Tools
Erwin 4.0, Sybase Power Developer, SSIS,SSRS
Operating Systems
HP-UX, IBM-AIX 5.3, Windows 95/98/2000/ NT, Sun Solaris, Red-Hat Linux, MS SQL SERVER 2000/2005/2008& MS Access
WORK EXPERIENCE:Confidential, CANov 2010 – Present ETL Developer NetApp Inc is leading Network Appliance Manufacturer Company as well as data storage Company which provide Network appliance like hard disk, shelf for small business owners, large business owners. Also NetApp provides efficient data storage facility. The main aim is to provide variety of services like Data storage, Data Analysis, Data warehouse, Data mart etc. which can adopt consistent tailored processes in order to strive and fulfill promise of commitment and reliability to Customers.
Environment: IBM Web Sphere DataStage 8.1 Parallel Extender, Web Services, Quality Stage 8.1, (Designer, Director, Manager), Microsoft Visio, IBM AIX 4.2/4.1 IBM DB2 Database, SQL Server, IBM DB2,Teradata, ORACLE 11G, Query man, Unix, Windows.
Confidential, NJJan 2010 - Oct 2010 Lead Sr. Datastage Developer
Project was to design and develop enterprise data warehouse. Extract data from heterogeneous source system, transform them using business logic and load in to data warehouse.
Environment: IBM Web Sphere DataStage 8.0.1 Parallel Extender, Web Services, Quality Stage 8.0, (Designer, Director, Manager), Microsoft Visio, IBM AIX 4.2/4.1 IBM DB2 Database, SQL Server 2000, IBM DB2,Teradata, ORACLE 11G, Query man, BMQ, Unix, Windows.
Confidential, VAOct 2008 – Dec 2009 Lead Datastage ETL Developer
Project was involved in design and development of a group insurance system, which processes claims for group insurance. It covers benefits with subsystems covering Term Life Insurance, Medical Indemnity and Managed Health Care. Data Modeling:
ETL Process:
Environment: IBM / Ascential Data Stage E.E./7.5(Manager, Designer, Director, Parallel Extender), Quality Stage 7.5 Data Stage BASIC language Expressions,Autosys, Erwin 4.0, Windows NT, UNIX, Oracle 9i, SQL SERVER, Cognos, Sequential files, .csv files.
Confidential, PAJan 2007 -- Sep 2008
Sr. Data Stage Developer As a DW developer designed, developed, and deployed DataStage Jobs and associated functionality. The warehouse employed highly complex data transformations including Slowly Changing Dimensions and a series of Stored Procedures, which made performance tuning and efficient mapping highly critical. Along with designing jobs from scratch re-wrote existing code to enhance performance and trouble-shoot errors in both DataStage & Oracle10G. Responsibilities:
Environment:IBM Web Sphere Data stage and Quality Stage 7.5, Ascential Datastage7.5/EE (Parallel Extender), SQL Server 2005/2008, Linux, Teradata 12, Oracle10g, Sybase, PL/SQL Toad, UNIX (HP-UX), Cognos 8 BI
Confidential, NJ
Jr. DATASTAGE DEVELOPERJan 2006- Dec 2006
Merrill Lynchwas a global financial service provides capital markets services, investment banking and advisory services, wealth management, asset management, insurance, banking and related financial services worldwide.
Responsibilities:
Environment: IBM Web Sphere DataStage 7.5, Metastage 7.0, Business Objects 6.5, Oracle 9i, PL/SQL, SQL * Plus, UNIX Shell Scripts, Windows 2000/NT 4.0, ERWIN 4.1.
ConfidentialJune 2004 – Dec 2005 Jr. Datastage developer
Description:ICICI Prudential Insurance provides a wide range of insurance policies such as Life Insurance, Health Insurance, Motor Vehicle Insurance and General Insurance etc. This project is developed as a process of automation for insurance policy management by using centralized data warehouse and Data Mart. This application provides the provision to take in various related information regarding the region, generates premiums and desired data in the form of reports. Complex Flat File Stage Datastage Example Programs Download
Responsibilities:
Complex Flat File Stage Datastage Example Programs List
Environment: Datastage 5.2/6.0, Oracle 8i, SQL, TOAD, UNIX, Windows NT 4.0.
Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |