SUMMARY

• Around 6 years of IT experience with special emphasis on System Analysis, Design, Development, Testing and implementation of Data Warehousing, Data Integration and Data Migration using IBM Info sphere Data Stage (IIS) v11.5, 11.3 or 9.1 or 8.5.3 (Parallel), and its foundation tools such as Oracle 11g, PL/SQL.
• Experience using IBM Infosphere DataStage 11.5, 11.3, 9.1, 8.5, IBM Infosphere DataStage 8.1 and Ascential DataStage 7.5.
• Extensive experience in developing strategies for Extraction, Transformation, loading (ETL) data from various sources into Data Warehouse and Data Marts using Accentual Data Stage client tools like Data Stage Designer, Data Stage Director and Data Stage Administrator, Quality Stage, Information server and Parallel Extender.
• Good noledge of Maintenance, enhance, and optimizing Data Stage jobs.
• Experience in Software Development Life Cycle (SDLC) including System Analysis, Design, Data Modeling, Dimensional Modeling, Requirements Gathering, Decision Support and Implementation of various applications in OLTP and Data Warehousing.
• Experienced in designing teh Conceptual, Logical and Physical data modeling using ER win and ER Studio Data modeling tools.
• Experienced in writing complex SQL scripts, Stored Procedures, Views and Triggers using, PL/SQL.
• Experience with ETL design and development of Data marts /Enterprise wide Data Warehouses / Operational Data Stores.
• Good noledge on NO - SQL databases like HBASE, CASSANDRA.
• Experience in Data warehousing and Data migration.
• Experience in integration of various data sources like Flat files, Oracle, Teradata into staging area and tan into DataMart’s / EDW.
• Wide Experience in implementing Data Warehousing solutions to large corporate clients.
• Frequently used Peek, Row Generator and Column Generator stages to debug.
• Capture Metadata, Capacity Plan and Performance metrics for all teh Teradata queries being created.
• Extensive noledge and experience in various Parallel stages (Sort, Merge, Aggregator, and Transformer, Funnel, Filter, Look-up, Surrogate Key, Remove Duplicate, Transformer, Column/Row Generator and Peek) and Mainframe stages (Aggregator, Join, Look-up, Fixed Width Flat File).
• Extensively worked on Datastage Parallel Extender and Server Edition.
• Extensively Worked on IBM InfoSphere Classic Federation Server.
• Expertise in Data Modeling, OLAP/ OLTP Systems, generation of Surrogate Keys, Data Modeling experience using Ralph-Kimball methodology and Bill-Inmon methodology, implementing Star Schema, Snowflake Schema, using Data Modeling tool Erwin.
• Hands on experience in migration and upgrade ETL environments from Infosphere lower versions to higher versions like from 8.5 to 11.3 and 11.3 to 11.5.1.
• Experience in Integration of various data sources like Oracle, Sybase, Teradata, DB2, Microsoft SQL Server into ODS and DWH areas.
• Developed job sequencer with proper job dependencies, job control stages, triggers.
• Successfully implemented pipeline and partitioning parallelism techniques and ensured load balancing of data.

TECHNICAL SKILLS

ETL Tools: IBM InfoSphere / WebSphere DataStage 11.5/11.3/9.1/8.7/8.5/8.0/7.5.2 (Designer, Director, Administrator and Manager), oracle data integrator, Informatica.

Reporting Tools: MicroStrategy, Business Objects and Tableau, Cognos

Database: Teradata, Oracle 11g/12c, MS SQL Server, DB2, MS Access, CASSANDRA, Sybase

Languages: SQL, PL/SQL, UNIX Shell Script, XML, Perl

Data Modeling Tools: Erwin 4.0/3.5, TOAD, Win SQL, Autosys, SQL Plus

Operating Systems: Windows 7/Vista/2000/NT/XP, MS-DOS, UNIX. HP-UX, Sun Solaris

PROFESSIONAL EXPERIENCE

Confidential, Portland, OR

Sr. ETL Datastage Developer

Responsibilities:

• Involved with Application and Database Support Teams to maintain system and database which supports current data scenarios and easily adapts to changing business needs.
• Working in Recruiting Management (RM) Application development project on Data migrations activities using teh IBM Datastage 11.5 version
• Dynamic career reflecting pioneering experience and high performance in System Analysis, design, development and implementation of Relational Database and Data Warehousing Systems using IBM Data Stage (Info Sphere Information Server, Web Sphere, Ascential Data Stage).
• Created conceptual & logical models, logical entities and defined their attributes, and relationships between teh various data objects.
• Used different Parallel job stages like Sequential File, XML Stage, Dataset Stage, Join, Merge, Lookup, Filter, Col and Row generator, Transformer, Change Data Capture, Modify, Aggregator, Remove Dup, Source and Target Stages, Oracle and ODBC Stages etc.
• Used Information Analyzer for profiling data, check teh data content and structure, analyze various source system data according to business need.
• Responsible for all pre-ETL tasks upon which teh Data Warehouse depends, including managing and collection of various existing data sources.
• Experience inmigrationof Data from Excel, Flat file, Sybase, Oracle to MS SQL Server by using Replication, BCP, DTS, Bulk Insert and SSIS utility.
• Expert in designing Server jobs using various types of stages like Sequential file, ODBC, Hashed file, Aggregator, Transformer, Sort, Link Partitioner and Link Collector.
• Develop code using Teradata BTEQ Scripts, Informatica mappings, workflows and sessions as per ETL specifications and implemented CDC (Change Data Capture) scripts wherever required Involved in debugging of teh mappings and in preparation of test cases.
• Extensively used InfoSphere Quality Stages - Investigate Stage, Standardized Stage, Match and Survive Stage for generating reports, keeping teh data clean and structured according to business.
• Generated teh Pattern report and Token report as requested by teh Business in identifying teh Data patterns and inconsistency in teh source data using InfoSphere Quality Stage.
• Effectively used Standardized stage in standardizing teh source data by using teh existed rule sets like name, address and area etc. for multiple countries and generated teh valid and invalid data reports.
• Involved in teh design of Match Templates suggestions made by teh Business and validated teh results to identify teh duplicates coming from teh source depending on different Match types using Match Stage - InfoSphere Quality Stage.
• Used Parallel Extender extensively by using Processing, Development/Debug, File and Real Time Stages.
• Designed teh ETL jobs using IBM Info sphere Data Stage 9.1 to Extract, Transform and load teh data into staging, ODS and EDW.
• Involved in creating UNIX shell scripts for database connectivity and executing queries in parallel job execution.
• Developed Datastage jobs using Lookup stage for Range Lookup.
• Extensively used Flat File Stage, Hashed File Stage, DB2 UDB Stage, FTP Plug-in Stage and Aggregator Stage during ETL development.
• Documented teh Data Warehouse development process and performed noledge transfer to Business Intelligence Developer.
• Performed performance tuning of teh jobs by interpreting performance statistics of teh jobs developed.
• Performed unit testing for jobs and scripts to validate teh data and prepared jobs checklists to validate teh user requirements.

Environment: IBM Info Sphere Datastage 8.5/9.1/11.3/11.5, Mainframe, DB2, Sybase, SQL Server 2016, Oracle 11g, Informix 16, MS Excel, MS Visio 2010,Flat Files, UNIX scripting, Windows 2007, Netezza.

Confidential, Houston, TX

ETL Datastage Developer

Responsibilities:

• Designed teh ETL jobs using IBM Info sphere Data Stage 9.1 to Extract, Transform and load teh data into staging, ODS and EDW.
• Extensively used Ascential Datastage to Extract, Transform and Load teh data from Flat files, XML to teh Data ware house involving different stages like Transformer, OraOCI, hash, Oracle PACK, Aggregator, Sort, merge, link collectors and Partitions and variety of integration techniques.
• Designed various jobs using Server functionalities.
• Extensively dealt with change capture techniques for implementing slowly changing dimensions process.
• Analyzing, designing, developing, implementing and maintaining ETL jobs using IBM Infosphere Datastage.
• Used teh ETL Datastage Designer to develop processes for extracting, cleansing, transforms, integrating and loading data into data warehouse database.
• Involved in Data Modeling using Dimensional Data modeling, Star Schema/Snow flake schema, Fact & Dimensions tables, Physical & logical data modeling.
• Extensively used ETL to load data using Datastage Designer from heterogeneous source systems from Oracle and DB2 to target Oracle Database.
• Logical and physical Sybase database design in Erwin for data warehouse used by a securities lending application.
• Worked on teh Stages like Lookup, Transformer, Join, Switch, Filter, Stored procedure and Pivot.
• Integration of IBM InfoSphere CDD with IBM InfoSphere Information Server.
• Experience on doing teh Cluster system setup and configuration on windows.
• Experience in ETL Testing.
• Extensively used Change Data Capture, Transformer, Modify, Copy, Join, Funnel, Aggregator, Lookup Stages and development stages to develop teh parallel jobs.
• Created documentation for teh jobs. Analyzed and documented all teh requirements and checked for user level compliance. Documented for variety of user community both technical and business perspective.
• Involved in JAD's and meetings for Business Analysis and requirements gathering.

Environment: IBM Web Sphere Datastage 9.1/8.7(Designer, Manager, Administrator),Sybase, Oracle 11/10g, Business Objects XI, Erwin 4.1, Windows NT, UNIX, CRMS Application.

Confidential - Kansas City, MO

ETL Datastage Developer

Responsibilities:

• Gathered and analyzed requirements from teh end users and converted functional specifications to technical specifications documents.
• Reverse-Engineered numerous existing database schemas to get an understanding of existing database architecture.
• Created Data Model from scratch which involved a complete life cycle implementation that encompassed business requirement gathering, analyzing their source systems and tan building financial data mart to provide functionality for their reporting purposes.
• Enhanced teh reusability of teh jobs by making and deploying shared containers and multiple instances of teh jobs.
• Used IBM Info Sphere DataStage 8.5 to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse.
• Imported and exported Repositories across Data stage projects.
• Automatedthe processes to reduce teh manual efforts.
• Involved in data profiling and data model.
• Developed a complex SQL code to use in teh common code approach to avoid writing several SQL scripts for different source table/file formats.
• Preparation of technical specification for teh development of Extraction, Transformation and Loading (ETL) jobs to load data into various tables in Data marts.
• Worked with Data Stage server stages like OCI, ODBC, Transformer, Hash file, Sequential file, Aggregator, Sort, Merge, Link Practitioner, Link collector, IPC and other stages.
• Implemented and hardcoded high-performance Data Stage routines.
• Imported teh required Metadata from heterogeneous sources at teh project level.
• Used Parallel stages like Lookup, Join and Merge stages for joining various information and used Parallel Transformer, Column Generator, Funnel, Filter, Switch, Modify, Pivot, Row Generator.
• Used Parallel Extender Development/Debugging stages like Row generator, Column Generator, Head, Tail and Peek for debugging of teh jobs.
• Created conceptual, logical & physical data models with Erwin and did design review meetings with other team members to finalize teh model.
• Implemented advanced modeling concepts like Bus Matrix Architecture, Resolving Multi Valued dimensions, and Conform dimensions, Junk dimensions, Degenerate dimensions in designing multi-dimensional model.
• Used IBM Info Sphere Datastage software, extracting data from DB2, Oracle and Flat File and Load to target tables.
• Divided model into subject areas for reflecting understandable view to business as well as data model reviewers.

Environment: Windows2008, IBM Datastage 8.5 Server/parallel/ 8.1/8.0/7.5/7.0 (Administrator Client, Manager, Designer Client, Director Client), Parallel Extender, Information Analyzer (IA), Oracle 11g, SQL Server 2008R2, SQL, and AIX/UNIX.

Confidential

ETL Data stage Developer

Responsibilities:

• Designed and developed jobs for extracting, transforming, integrating, and loading data into data mart using Datastage Designer.
• Developed, executed, monitored and validated teh ETL Datastage jobs in teh Datastage designer and Director Components.
• Migrated fromIBM InfoSphereDatastage 8.5 to 8.7 version.
• Imported Metadata from Oracle database. Imported metadata definitions into teh repository. Exported and imported Datastage components.
• Involved in teh preparation of ETL documentation by following teh business rule, procedures and naming conventions.
• Frequent usage of Clear Case version control.
• Worked with Datastage Director to schedule, monitor, analyze performance of individual stages and run Datastage jobs.
• Developed user defined Routines and Transformations for implementing Complex business logic.
• Developed Job Sequencer and batches and has edited teh job control to has jobs run in sequence.
• Used Version Control for data stage to track teh changes made to teh data stage project components and for protecting jobs by making read only.
• Monitoring all data loads and fixing teh errors.

Environment: IBM Info Sphere Datastage 8.7/8.5 (Parallel Extender, Quality Stage), PVCS Version Controller, Citrix, Mercury Test Director, Control-M Scheduling, Oracle, Teradata and UNIX.