Swetha Golkonda

- Participated in requirements discussion with Clients, Business Analysts, UAT Users. - Involved in working with Membership, Claims, RX data on FACETS and DB2 database. - Attended the Daily Stand up calls in an Agile environment - Used JIRA for creating User stories, subtasks and log hours. - Designed, Implemented, Compiled, Unit tested the DataStage jobs using Designer. - Developed DataStage Parallel jobs using various stages like Join, Merge, Lookup, Remove duplicates, Filter, Funnel, Dataset, Sequential file, Sort, Transformer, XML, Oracle connector, Unstructured Data. - Developed DataStage Sequence jobs using stages like Sequencer, Nested Condition, Terminator Activity, Exceptional Handler, Notification Activity, Job Activity and Execute Command - Designed Batch Jobs with Job Sequences, developed Zena jobs for automation and schedule the DataStage jobs using DataStage Director and Zena - Executed the Mock runs, SIT/UAT runs and Production Renewals using Zena. - Troubleshooted DataStage Jobs and addressed production issues such as error handling, root cause analysis and performance tuning. - Created Change requests, Code review and Deployment Documents to Deploy using GIT and Azure Devops. - Performed Data Cleansing, Data Validation, Data Conversion, Data Migrations, and Data Analysis - Reviewed the Code, Design and Documentation of team members - Suggested New designs, enhancements to the existing design - Documented unit-test cases, scripts, and validations based on design specifications. - Performed Effort estimate and ensured timely technical deliverables. - Prioritized and handled multiple assignments in a fast-paced environment. - Provided guidance and training to technical team members, coordinated and handled both onsite and offshore teams Environment: DataStage 11.5 (Manager, Designer, Director), Sybase, DB2, UNIX, WinScp, Shell scripting, Production Support.

Responsibilities: -Involved in meetings with Business for Requirement gathering and UAT sign off by users. -Created the Mapping, Business Requirement, Technical Design Document and SCM Documents. -Worked closely with Data Modeler to accommodate the Requirements. -Updated status on Daily Stand up calls in an Agile environment -Involved in Logical and Physical Design, Backup, Restore, Data Integration, Data Transformation Services and creating Database objects (tables, triggers, views) -Involved in data conversions on the DB2 and SAP HANA databases -Developed DataStage Parallel jobs using various stages like Join, Merge, Lookup, Remove duplicates, Filter, Funnel, Dataset, Sequential file, Sort, CDC, Transformer, XML, ODBC, Unstructured Data and SAP stages -Developed DataStage Sequence jobs using stages like Sequencer, Nested Condition, Terminator Activity, Exceptional Handler, Notification Activity, Job Activity and Execute Command -Developed DataStage parallel jobs to create a Max key, Surrogate key and Delta history table -Developed the shell scripts, Wrapper scripts, ABAP code for ETL processes -Used DataStage Director to debug, validate, schedule, run and monitor DataStage jobs -Troubleshooted DataStage Jobs and addressed production issues such as error handling and performance tuning -Wrote ABAP Programs to extract, transform and load data using SAP stage -Developed archive scripts for archiving source data in the form of .tar and .gzip files on the Unix -Designed Batch Jobs with Job Sequences, developed and scheduled DataStage jobs using IBM Enterprise Staging Platform -Created Test Plans, Test Cases, Test data and performed Test runs using HPQC -Documented unit-test cases, scripts, and validations -Prioritized and handled multiple assignments in a fast-paced environment Environment: Infosphere DataStage 11.5 (DataStage Manager, Designer, Director, Administrator), DB2, SAP, ABAP Program, IBM Data Studio, Brio, WinScp, Putty, sftp, ESP, HPQC.