PROFESSIONAL SUMMARY:

• Having 8+ Years of IT Experience as Sr software engineer, which includes Development, Enhancement, Production Support and Migration projects
• Experience on different versions of the data stage like 7.5 Parallel Extender version, IBM Infosphere Information Server 8.5 & 11.5.
• Extensively worked on Parallel Jobs for splitting bulk data into subsets and to dynamically distribute to all available processors to achieve job performance.
• Exposed in creating reusable components like Shared Containers and Local Containers.
• Good expertise working on SAP Packs like ABAP Extract stage.
• Good understanding the principles of Data Warehouse and Good communication skills.
• Well versed with implementation of SCD (type1, type2).
• Having knowledge in UNIX commands And Shell Scripting.
• Strong working exp on data extraction, transformation and loading of data using various stages.
• Ability to rapidly learn new concepts together with excellent interpersonal skills.
• Experience in integration of various data sources like Oracle, IBM DB2, SAP System, Flat files.
• Having good experience in Hadoop technologies Hive.
• Ability to rapidly learn new concepts together with excellent interpersonal skills.
• Good exposure to Relational databases like Oracle 10g/11g, IBM DB2 and Teradata 13.4.
• Involved in Performance Tuning of the Data Stage job designs.

TECHNICAL SKILLS:

• IBM Data stage (Infosphere Information Server) 8.5 & 11.5.
• Oracle 11g.
• IBM DB2.
• Teradata.
• UNIX.
• Talend big data
• Hadoop, Hive

PROFESSIONAL EXPERIENCE:

Confidential

Sr software engineer

Environment: IBM Info Sphere Information Server 11.5, Hive, Hadoop, LINUX, HP Quality Center.

Responsibilities:

• Resource planning and time allocation for implementation.
• Involved in requirement gathering and Project Design.
• Understanding the business model and customer requirements.
• Creating technical design documents based on requirements.
• Involved in design and development of parallel jobs using DataStage to apply business rules.
• Used the stages like Copy, Lookup, Transformer, change capture, Funnel, Join,
• Walk through of existing code and identification of performance issues, documented flow of identified process.
• Involved in Planning for developing common code for implementation globally across different markets, using single code for all countries to process data.
• Participated in discussions with Team leader, Group Members and Technical Manager regarding any Technical and Business Requirement issues.
• High end support(L3) for already rolled out countries.
• Worked on the code fixes and on the tickets raised due to the job failures.
• Supporting unit, integration, and end user testing by resolving identified defects.
• Used the Datastage Designer to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.
• Created new Generic table to collect reject information at the different levels in Job’s Flow with Audit columns information like Create and Update timestamp.
• Developed new Reject Parallel Jobs &Created Shared Containers for reusability of the code.
• Need to customize the UNIX scripts for Reject table Implementation.
• Reviewed the code and Peer Review in order to avoid the Defects at later stage.
• Created and executed Unit Test Plans for each module from End to End.
• Will Migrate the Code to SIT Stream after Data validation for all possible scenarios from DEV environment.
• After Successful completion of UAT we have to Follow Release Management activities.

Confidential

Sr software engineer

Environment: IBM Info Sphere Information Server 11.5, Hive, Hadoop, LINUX, HP Quality Center.

Responsibilities:

• Understanding the business model and customer requirements.
• Creating technical design documents based on requirements.
• Involved in design and development of parallel jobs using DataStage to apply business rules.
• Used the stages like Copy, Lookup, Transformer, change capture, Funnel, Join, Dataset, Sequential file etc. for developing the jobs.
• Developed the sequence jobs based on requirement.
• Created control m jobs to perform batch run.
• Worked in critical deadline situations.
• Implemented performance - tuning techniques along various stages of the ETL process.
• Error tracking and Error Monitoring using DS director
• Testing the Jobs according to Unit Test Cases.

Confidential

Sr software engineer

Environment: IBM Info Sphere Information Server v8.5, Oracle 11g, HP Quality Center.

Responsibilities:

• Understanding the business model and customer requirements.
• Creating technical design documents based on requirements.
• Involved in design and development of parallel jobs using DataStage to apply business rules.
• Used the stages like Copy, Lookup, Transformer, change capture, Funnel, Join, Dataset, Sequential file etc for developing the jobs.
• Developed the sequence jobs based on requirement.
• Created control m jobs to perform batch run.
• Implemented performance-tuning techniques along various stages of the ETL process.
• Testing the Jobs according to Unit Test Cases.

Confidential

ETL-Developer

Environment: IBM Info Sphere Information Server v8.5, Tera data, HP Quality Center.

Responsibilities:

• Used Datastage Designer to develop processes for Extracting, cleansing, transforming, integrating and loading into Teradata data warehouse.
• To load data from source flat files and RDBMS tables to target tables.
• Developing the mapping to load the data in slowly changing dimension.
• Improving various Sources and Tables, created Transformations using Data Stage.
• Used Sequential file, RDBMS, Joiner, lookup, transformer, Remove Duplicate,
• Funnel, Datasets, Switch, Row Generator and Filter Stage for designing the jobs in the Data stage Designer.
• Error tracking and Error Monitoring using DS director.
• Testing the Jobs according to Unit Test cases .

Confidential

Environment: IBM Info Sphere Information Server v8.5, Teradata.

Responsibilities:

• Analyze & understand the business rule requirement and delivering the reports as per the customer expectations.
• Developing of PX jobs with the processing and file stages like Sequential File, Lookup, Join Stage, Aggregator Stage, Transformer, Remove Duplicate Stage, Funnel Stage, Copy Stage and Sort Stage.
• Developing the Sequencers by using the different sequencer activities like Execute command activity, Job Activity, Sequencer Activity and User Variability Activity.
• Developing the mapping to load the data in slowly changing dimension.
• Used different database plug-ins like ODBC Enterprise, DB2 connector and oracle connector stages for extracting the data from Legacy Systems like Mainframe DB2 and Oracle.
• Performance Tuning & Error handling process in the jobs.
• Testing the interfaces during Mock, Full Dress Rehearsal (FDR) testing cycles and Execute data loads during the production cutovers for few facilities.