9+ years of experience in design and implementation of Data Warehouses/Data Marts using IBM WebSphere DataStage. Experience in developing ETL processes to extract, transform and load data from various source systems into…
9+ years of experience in design and implementation of Data Warehouses/Data Marts using IBM WebSphere DataStage. Experience in developing ETL processes to extract, transform and load data from various source systems into Data Warehouses and Data Marts. Experience in using various stages like Transformer, Aggregator, Join, Merge, Lookup, Surrogate Key Generator, Sequential File, Copy, Remove Duplicate, DB2 Enterprise, Funnel, Sort, Sequencer job stages such as Job Activity, Execute command. Understanding of Data Warehousing principles using Fact Tables, Dimension Tables, Star Schema modelling and Snowflake Schema modelling. Experiance on XML stages.like to create or parse XML in datastage. Experience in Data Migration Project and Migrated Jobs from One ETL tool to another. Implemented Local containers for same job and shared containers for multiple jobs, which have the same business logic. Good knowledge in finding the Business logic for different domains in Insurance and Retail. Experience on SSIS ,Abinitio , CDS Cogos
• 9+ years of experience in design and implementation of Data Warehouses/Data Marts using IBM WebSphere DataStage.
• Experience in developing ETL processes to extract, transform and load data from various source systems into Data Warehouses and Data Marts.
• Experience in using various stages like Transformer, Aggregator, Join, Merge, Lookup, Surrogate Key Generator, Sequential File, Copy, Remove Duplicate, DB2 Enterprise, Funnel, Sort, Sequencer job stages such as Job Activity, Execute command.
• Understanding of Data Warehousing principles using Fact Tables, Dimension Tables, Star Schema modelling and Snowflake Schema modelling.
• Experiance on XML stages.like to create or parse XML in datastage.
• Experience in Data Migration Project and Migrated Jobs from One ETL tool to another.
• Implemented Local containers for same job and shared containers for multiple jobs, which have the same business logic.
• Good knowledge in finding the Business logic for different domains in Insurance and Retail.
• Experience on SSIS ,Abinitio , CDS Cogos
Excellent knowledge of different Tools like
Operating System: Windows, Linux
ETL Tools : IBM InfoSphere Datastage 11.7(and older versions),
SSIS, CDS(Cognos Decision Stream), Abinitio
Databases : DB2, SQL SERVER, ORACLE, NETEZZA, TERADATA.
Languages : SQL, JAVA, C,C++
Data Testing Tools : ICEDQ, Effecta
Other Tools : JIRA ,HPQC, Support Works, Base SAS, Advance SAS, SAS D.I
Domains : Insurance, Shipping,Heath Care, FoodChain, Banking, Gaming-casino
Excellent analytical, problem solving, communication and interpersonal skills, with ability to interact with individuals at all levels.
Worked for Banking Department (USAA account and Barclays account) project.
Working on performance tuning for big load ETL processes (LOBs, XMLs, Dependencies) by replacing multiple sources/staging/targets to utilize the environments at fullest and keep server in sync with source and target environments.
Working on the change request and defect resolution for the same project.
Handling multiple roles like migration of projects, roles, server handling, etc.
Responsibilities include requirement gathering from Business Functional Analysts and creating mapping document and Data modelling, ETL development, Data sanity testing, Deployment.
Tools used for ETL are IBM Datastage, Abinitio.
Databases used – Oracle database.
Developed ETL to bring data from source system Oracle into Data Mart.
Deployment to the ETL to production.
Production Database Maintenance, Support API team with performance issues.
Working in Agile methodology also leading the scrum on weekly basis.
American Bureau of Shipping(Freedom Project):
Responsibilities include team managing, delegation of tasks, requirement gathering from Subject matter experts, ETL designing, testing and deploying.
Worked on Sprint plans with JIRA tracking tool.
Reverse engineering of an application designed in JAVA in legacy system to meet requirements of new system.
Datastage to MAXIMO integration.
ETL execution optimization using partitioning techniques.
Worked on different file formats in Datastage.
Worked on Structured as well as semi structured format files.
Documented test plans, test cases, test scripts based on design specification.
Handled a sub project named DRA to analyze Java code and perform reverse engineering on it.
Boyd Gaming Project:
Handled leading casino entertainment industry’s Domain Data.
Responsibilities include Requirement gathering, team managing, delegating tasks, Datastage and SSIS ETL designing, SQL scripts development, delivery tracking, data testing.
Preparing Mapping Documents from the requirements.
Converted SSIS ETL logic to Datastage ETL.
Exposure to Gaming industries SME for Business requirements Testing.
AXA Bank Data Migration Project:
Migrated several Parallel Jobs, Server Jobs & Sequences Jobs from Ascential datastage 7.5 and Datastage 8.7 to Datastage 11.5.
Extensively worked with various stages of Parallel Extender like Sequential file, Dataset, lookup, peek, transformer, Merge, Aggregator, row generator and many more to design jobs and load the data in to Fact and Dimension tables.
Extensively used Hashed File stage to use same Hashed data to perform lookup/Join in different jobs.
Implemented Master level sequencers which used to call various other child level sequencers.
Also scheduled the sequencers
Ace Micromatic Group Datawarehouse project:
Involved in Datastage development for a datawarehouse project.
Recreating Datastage jobs from Cognos Decision stream.
Production Support for ETL.
Developed Server routines.
Involved in testing phase of the data and ETL.
Involved in Production Support for the project.
ETL replication from CDS (Cognos Decision Stream) to IBM Datastage.
Schedule datastage jobs using Web Console tool.
Fetched data from different data source like Flat files, xml files and data sources such as Oracle, MSSQL, AS400.
Integrated the data from cross data platforms to load the data into Netezza Datawarehouse.
Developed more than 20 SCD type 2 jobs in Datastage.
Converted PLSQL logics and integrated into Datastage jobs.
USA Bank Migration Project:
Involved in setting install of Cognos Data Manager 10.2.1 to Client locations.
Developed database builds and job streams using Cognos Data Manager and IBM Infosphere.
Datastage like real time data loading and exception handling techniques and experience in scheduling jobs and report.
Closely worked with ETL team to design data marts by understanding user requirements and increasing the reporting efficiency.
Coordination with onshore team members in understanding the requirement from the client/business user, creating the project change request for the team and regarding any technical issues in Software development during the initial analysis phase till complete cycle.
Developing jobs using ETL tools (Extraction Transformation and Load) in Parallel Jobs, Server Jobs & Sequencesto integrate the flow for Complex Jobs.
Extraction of Data from various Data sources such as Oracle, DB2, Netezza, Sql Server.
Experience in designing parallel jobs using different processing stages like Transformer,Lookup, Joins, Copy, Change Capture, Remove Duplicate, Row generator, Merge, Sort, Pivot, Funnel and Aggregator.
The AI-first Recruitment Operating System that unifies and automates the entire hiring lifecycle for modern enterprises worldwide.
Dr Job FZ LLC. 2026 © All Rights Reserved
