SUMMARY

• Over 9 years of experience in the IT industry in Design, Development and Implementation of data warehouse technologies using IBMDataStage(Designer, Director & Administrator).
• Strong experience in loading and maintaining Data Warehouses and Data Marts using IBMDataStageETLprocesses.
• WidespreadETLexperience in System Analysis, Migration, Deployment, Quality Assurance (QA) Testing, User Acceptance Testing (UAT), Production Support, Maintenance and Change Control process.
• Involved in software requirement gathering, production roll out and enhancements.
• Experienced in writing system specifications, translating user requirements to technical specifications,ETLSource - Target mapping document.
• OptimizedDataStagejobs utilizing parallelism, partitioning and pipelining features of Parallel Extender.
• Experience in loading high volume data, troubleshooting ofDataStagejobs and addressing production issues like performance tuning and fixing data issues.
• Broad experience with different parallel and partition techniques.
• Experienced in loader utilities including SQL Loader.
• Strong experience in developing jobs using different stages inDataStageparallel extender like join, merge, lookup, sort, funnel, row generator, remove duplicates, filter, dataset, modify, aggregator, XML input/output and change data capture.
• Excellent work experience in Agile project methodology and experience in all phases of SDLC.
• Experience in extracting data from various data sources like Flat files, XML files, Sequential files and from operational sources like Oracle, SQL Server, IBM DB2, Netezza and loading into an Enterprise Data Warehouse.
• Experience in Using XML and Web Services Packages in DataStage Integration.
• Extensive experience as Production Support Personal in various multiple Data warehouse Projects and extensively worked with offshore team.

TECHNICAL SKILLS

ETL Tools: DataStage 11.7,11.5, 8.5v, 8.1v, DataStage 7.5

Relational Databases: Oracle 8i/9i/10g/11g, DB2 9

Development/Productivity Tools: Control-M, HP Quality Center, Unix Shell scripts, Robot

Languages: SQL*PLUS 8.x/9.x, PL/SQL 8.x/9.x.

Operating Systems: Linux/UNIX, Windows 95/98/NT/2000

Tools: Toad, SQLDeveloper, SQL*Plus, SQL*Loader, SQL Server Management Studio, AutoSys Scheduler, Pycharm, Tivoli Work Schedule, GIT, Urban Code Deploy, Qtest, JIRA

PROFESSIONAL EXPERIENCE

Confidential, Coppell, TX

Sr. ETL Developer/DataStage Developer

Responsibilities:

• Designing ETL jobs incorporating complex transform methodologies using Data Stage tool resulting in development of efficient interfaces between source and target systems.
• Developed ETL jobs to load data from VSAM, GDG, IMS, DB2 databases, Flat files, CSV files to target and experience with high volume databases on Mainframes.
• Worked with stages like Complex Flat File, Transformer, Aggregator, Sort, Join, Lookup, and Data masking pack.
• Co-coordinating with client managers, business architects and data architects for various sign offs on data models, ETL design docs, testing docs, migrations and end user review specs.
• Primarily involved in Job Design, Technical Reviews and Troubleshooting of jobs.
• Extensively involved in different Team review meetings and conferences with remote team.
• Participated in requirements gathering and created Source to Target mappings for development.
• Extensively designed, developed and implemented Parallel Extender jobs using Parallel Processing (Pipeline and partition) techniques to improve job performance while working with bulk data sources.
• Created and used DataStage Shared Containers, Local Containers for DS jobs.
• Extensively Worked on Job Sequences to Control the Execution of the job flow using various Triggers (Conditional and Unconditional) and Activities like Job Activity, Email Notification, Sequencer, Routine activity and Exec Command Activities.
• Designed Star schema (identification of facts, measures and dimensions) and Snowflake.
• Tuning the jobs for optimum performance.
• Used Datastage Director to validate, run and monitor the Data Stage jobs.
• Experience in generating and interpreting mapping documentation and translating into detailed design specifications using ETL code.
• Performed the Unit testing for jobs developed to ensure that it meets the requirements.
• Extensively involved with business team for analyzing the source systems data and building the design documents
• Extensively worked with architects and proposed solutions in building a common design approach for building the Job control and error recording tables.
• Prepared integration test case plans and test scenarios along with testing.
• Extensively used the advanced DataStage Data warehousing capabilities of almost all Processing stages like Change capture stage, Lookup/Join/Filter/Funnel/Surrogate Key Stages

Environment: DataStage (11.5/11.7), Unix/Linux, Control-M, Beyond Compare, Oracle SQL Developer, SQL Server, Putty, WinSCP, Gitlab, Urban Code Deploy, Pycharm, Netezza, Q-Test, JIRA, DPF, BOX and Slack.

Sr. ETL Developer/DataStage Developer

Responsibilities:

• Participated in discussions with Project Manager, Business Analysts and Team members on different Business Requirement issues.
• Worked on the existing documents and developed the required technical specification as per the business needs.
• Worked on extracting data from Flat files, Sequential files and Oracle database.
• DesignedETLjobs by identifying various source files and applying transformations andETLlogic to them.
• Used Aginity Workbench extensively for creating and editing database objects such as tables, views, indexes, constraints etc.,
• Developed various jobs using stages like Transformer, Lookup, Datasets, Funnel, Change Capture stage, Change Apply stage, XML, Sort, Copy& Job Activity Stages etc.
• Mapped Data Items from Source Systems to the Target System.
• Validation of all the metrics is done well in advance, before migrating it into production environment.
• Used theDataStageDirector and its run-time engine to schedule running the solution, testing and debugging its components, and monitoring the resulting executable versions.
• Extensively used UNIX Shell Scripts to trigger the DS jobs through a Master Sequencer.
• Developed UNIX shell scripts to automate data loading in batch mode.
• Used AutoSys to schedule the jobs based on prerequisites in and dependencies out of the jobs.
• Performed the Unit testing for jobs developed to ensure that it meets the requirements.

Environment: IBM InfoSphereDataStage11.5, Aginity Workbench, Erwin, Oracle 11g, SQL, PL/SQL, Flat files, Toad, UNIX, Shell Scripts, Autosys.

Confidential, Birmingham AL

Datastage Developer

Responsibilities:

• Involved in understanding of business processes and coordinated with business analysts to get specific user requirements.
• UsedDataStagestages namely Sequential file, Transformer, Aggregate, Sort, Join, Lookup, Remove Duplicates, Copy, Funnel, Dataset, Hashed File, Funnel, Peek, Row Generator stages in accomplishing theETLCoding.
• Developed job sequencer with proper job dependencies, job control stages, triggers.
• Extracted mainframe files of different formats and loaded into datasets in according with changes in copybooks using CFF stage.
• Used SFTP to move data from MVS Mainframe System to Development server in case of any permission issues.
• Used IBM data stage on a DEV server to extract, build and maintain a series of master files and files of financial credit card transaction changes and used the Data from the Bacardi system (DB2) into files in the AFI processing circle.
• Processed daily and monthly Jobs in IBM Data stage programs into master and information files that will allow Canadian credit card transactions to be processed, history kept, and creates daily and monthly transactions into SAP "event transactions".
• Involved in debugging process in case of unexpected results for daily and month end run.
• DocumentedETLtest plans, test cases, test scripts, and validations based on design specifications for unit testing, system testing, functional testing, prepared test data for testing, error handling and analysis.
• Developed UNIX shell scripts to automate the Data Load processes.
• Used Autosys job scheduler for automating the daily and monthly regular run of AFI Processing cycle in both production and UAT environments.
• Provide on-call support to production system to resolve any issues.

Environment: IBM InfoSphereDataStage8.5, IBM AIX, Shell scripting, Oracle 10g, DB2, Toad, Autosys, PL/SQL, SQL*Loader, BO XI.

Confidential, CA

Software Engineer/Datastage Developer

Responsibilities:

• Interacted with business analysts and data modelers for better understanding of differentSource and target systems.
• Reviewed and updated technical specification documents forETLprocess.
• Designed job templates to specify high-level framework approach.
• Developed standardETLprocesses to execute pre-ETLand post-ETLprocesses to ensure smooth transfer of data from heterogeneous source systems to a homogenous target system.
• Worked in the implementation of DW Incremental (pull and load) that constitutes different subject areas for different Source Systems.
• Involved in developing server and parallel jobs for Source to Stage, Stage to ADS (Atomic Data Store) and ADS to Datamarts.
• Used FTP to retrieve data from the mainframe.
• Performed the Unit testing for jobs developed to ensure that it meets the requirements.
• Designed and developed lots of Data Stage jobs to load into Dimension and Fact Tables of different Data Marts from extracting data from Data Warehouse tables.
• Developed routines in BASIC for monitoring the pre-and postETLprocesses.
• Used Quality Stage to coordinate the delivery, consistency, removing data anomalies and spelling errors of the source information.
• Applied validation rules, constraints using data stage variables and transformations.
• Used several stages like Sequential file, Hash file, Aggregator, Funnel, Change Capture, Change Apply, Row Generator (debugging stage), Peek, Remove Duplicates, Copy, Lookup and RDBMS during the development process of theDataStagejobs.

Environment: IBM WebSphereDataStage8.0.1, HP-UX, DB2, Oracle 9i, SQLDeveloper, Tivoli Work Scheduler, Toad, SQL Server, SSRS, Cognos, BTEQ, Multi Load.