PROFESSIONAL SUMMARY:

• Around 6 years of IT industry experience in Analysis, Design, Development, Testing, Implementation and support of Data Warehouses, Database technologies using Extraction Transformation and Load (ETL) tools like Confidential InfosphereDataStage 11.x/9.x/8.x/7.x.
• Extensive experience in client / Server architecture and good knowledge of Software Development Life Cycle.
• Developed industry standard solutions with Datastage ETL jobs based on business requirements using various Datastage stages like Sort, Aggregator, Filter, Funnel, Join, Lookup, Merge, Change Capture, Datasets, Sequential files and Transformer etc.
• Extensive experience in design and implementation of Star Schema, Snowflake Schema and Multi - Dimensional Modeling.
• Experience in Data integration of various data source like DB2, Oracle, TeraData, MS Access and Flat Files into staging area and eventually to warehouse.
• Proficiency in data warehousing techniques for Slowly Changing Dimensions, Surrogate key assignment and Change Data Capture (CDC).
• Thorough understanding of DW principles (Fact Tables, Dimensional Tables, Dimensional Data Modeling - Star Schema and Snow Flake Schema).
• Experienced in developing UNIX shell scripts for file validations, to run the batch processing and summarized report of data load.
• Experience in implementing full lifecycle management to capture and migrate various DataStage ETL metadata including data mapping and other data integration artifacts (such as schedulers, scripts, etc.) across environments including the establishment of standards, guidelines and best practices.
• Experience in Data Warehousing, Application Development and Production Support.
• Experience in conducting design review session with different stake holders and code review sessions with developers.
• Extensively worked with Teradata utilities like BTEQ, Fast Export, Fast Load, Multi Load to export and load data to/from different source systems including flat files.
• Good understanding of ANSI SQL and various Teradata features like Join types, Statistics, Explain, PPI etc.
• Conducted sessions on Datastage technical training at the Business unit level.
• Expertise in creating reusable components such as Shared containers, Local Containers and in creating custom transformations, functions and routines.
• Experienced in Onshore - Off Shore coordination Development and Production Support Team.
• Excellent understanding of the DBA functions including creating tables, table spaces, databases and indices.
• Good knowledge on UNIX Shell Scripting and Windows batch CMD Scripting.
• Worked on Scheduling tools like Control-M, Tivoli and Autosys for automating jobs run.
• Excellent track record as a strong team player with effective communication, analytical and multi-tasking skills and self-motivated.
• Excellent analytical and logical programming skills with a good understanding at the conceptual level and possess excellent presentation, interpersonal skills with a strong desire to achieve specified goals.

TECHNICAL SKILLS:

ETL Tools: Confidential InfosphereDataStage 7.x/8.x/9.x/11.x, File manager, Confidential Debugger, Tortoise SVN, HadoopBigdata

Reporting Tools: SSRS, Oracle BI Business Intelligence (OBIEE 10.1.3.x, Siebel Analytics 7.x.), Business Objects, Cognos 8.4 (Awareness).

Scheduling Tool: OBIEE DAC, Autosys, Tidal, Control M, Puppet, Chef

Operating System: UNIX, WINDOWS & LINUX

Database: Oracle 11g/10g/9i, Netezza,MS SQL Server 2012/2008/2005, DB2, Teradata

Database tools: SQL PLUS, Toad, SQL Developer, SQL Assistant

Languages: Basic, PL/SQL, SQL,SQL* Loader, UNIX shell programming, C, C++,, COBOL

PROFESSIONAL EXPERIENCE:

Confidential, Southbury CT

Sr. ETL Datastage Developer

Responsibilities:

• Interacted with End user to understand the business requirements and in identifying data sources. Helped in preparing the mapping document for source to target.
• Used DataStage stages namely Hash file, Sequential file, Transformer, Aggregate, Sort, Datasets, Join, Lookup, Change Capture, Funnel, Peek, Row Generator stages in accomplishing the ETL Coding.
• Involved in Datastage migration from 9.1 to 11.3 version.
• Developed job sequencer with proper job dependencies, job control stages, triggers.
• Implemented Encryption and Decryption process using External source stage without saving data on disk.
• Excessively used DS Director for monitoring Job logs to resolve issues.
• Documented ETL test 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.
• Used DataStage as an ETL tool to extract data from sources systems, loaded the data into the Oracle database.
• Used Parameter files, User variables and Stage variables in parallel and sequence jobs based on the requirements.
• Used Aggregator stages to sum the key performance indicators used in decision support systems.
• Controlled jobs execution using sequencer, used notification activity to send email alerts.
• Imported table/file definitions into the Datastage repository.
• Participated in weekly status meetings.
• Used Autosys job scheduler for automating the monthly and regular run in both production and UAT environments.

Environment: Confidential Datastage 11.3, DB2, Netezza, Teradata, SSRS, Oracle 11/10g, PL/SQL, Perl Scripting, SSRS, Autosys, TOAD 9.x,Oracle Financials, Shell Scripting, python, Dynamic SQL, Oracle SQL *Loaderand UNIX.

Confidential, Billerica MA

ETL DatastageDeveloper

Responsibilities:

• Involved as primary on-site ETL Developer during the analysis, planning, design, development, and implementation stages of projects using Confidential InfosphereDatastage software.
• Prepared Data Mapping Documents and Design the ETL jobs based on the DMD with required Tables in the Dev Environment.
• Involved creating mapping documents and technical specification documents.
• Active participation in decision making and QA meetings and regularly interacted with the Business Analysts &development team to gain a better understanding of the Business Process, Requirements & Design.
• Used DataStage as an ETL tool to extract data from sources systems, loaded the data into the ORACLE database.
• Designed and Developed Data stage Jobs to Extract data from heterogeneous sources, Applied transform logics to extracted data and Loaded into Data Warehouse Databases.
• Created Datastage jobs using different stages like Transformer, Aggregator, Sort, Join, Merge, Lookup, Data Set, Funnel, Remove Duplicates, Copy, Modify, Filter, Change Data Capture, Change Apply, Sample, Surrogate Key, Column Generator, Row Generator, Etc.
• Extensively worked with Join, Look up (Normal and Sparse) and Merge stages. Extensively worked with sequential file, dataset, file set and look up file set stages.
• Extensively used Parallel Stages like Row Generator, Column Generator, Head, and Peek for development and de-bugging purposes.
• Extensively used ETL to load data from Sybase database, XML & Flat files Source to oracle database Server.
• Used the DataStage Director and its run-time engine to running the solution, testing and debugging its components, and monitoring the resulting executable versions on an ad hoc basis.
• Used TWS for scheduling the Jobs.
• Created and Modified UNIX shell script to run Job sequencer.

Environment: Confidential Info Sphere DataStage 8.7 (Designer, Director, Manager), Microsoft Visio, Confidential AIX 4.2/4.1 Confidential DB2 Database, PL/SQL Server, Confidential DB2,Teradata, ORACLE 11G, DB visualizer, Unix, Windows.

Confidential, Houston, TX

ETL Developer

Responsibilities:

• Worked closely with Business analysts and Business users to understand the requirements and to build technical specifications.
• Involved in all business meetings to understand the existing logic, different member information and agency data to come up with the best IT solution.
• Responsible to create Source to Target (STT) mappings.Involved in day to day production support activities.
• Worked on various defects raised by concerned business teams from various entities.
• Developed and supported the Extraction, Transformation and Load process (ETL) for a data warehouse from various data sources using DataStage Designer and to load the target tables using the DataStage Designer.
• Worked on various stages like Transformer, Join, Lookup, Sort, Filter, Change Capture and Apply stages.
• Coding using BTEQ SQL of TERADATA, write UNIX scripts to validate, format and execute the SQL's on UNIX environment.
• Developed parallel jobs using various Development/debug stages (Peek stage, Row generator stage, Column generator stage, Sample Stage) and processing stages (Aggregator, Change Capture, Change Apply, Filter, Sort & Merge, Funnel, Remove Duplicate Stage)
• Designed job sequencer to run multiple jobs with dependency and email notifications. Involved in Unit Testing, SIT and UAT Worked with the users in data validations.
• Extensively worked in improving performance of the jobs by avoiding as many transforms as we can.
• Prepared documentation for unit, integration and final end - to - end testing.
• Optimized/Tuned DS jobs for better performance and efficiency
• Responded to customer needs; self-starter and customer service oriented.
• Worked within the team to make appropriate, effective decisions related to project responsibilities and to initiate and follow-up on assigned tasks without supervision.
• Provided support and guidance by creating Release, Deployment & Operation guide documents.
• Involved in Performance tuning of complex queries.
• Interacted with Teradata DBA team for creation of primary and secondary indexes on Data Warehouse tables.
• Develop Universe model as per the business requirements to use for Webi rich client.

Environment: Confidential InfoSphereDataStage 8.5 (Designer, Director, Administrator), Teradata, Oracle 10g, Sequential files and Mainframe files, COBOL and UNIX Shell Scripting.

Confidential

ETL Developer

Responsibilities:

• Implemented full lifecycle management to capture and migrate various DataStage ETL metadata including data mapping and other data integration artifacts (such as schedulers, scripts, etc.,) across environments including the establishment of standards, guidelines and best practices.
• Responded to customer needs; self-starter and customer service oriented.
• ETL Unit and Integration Test creation and verification.
• Provided support and guidance by creating Release, Deployment & Operation guide documents.
• Worked on various stages like Transformer, Join, Lookup, Sort, Filter, Change Capture and Apply stages.
• Involved in Unit Testing, SIT and UAT Worked with the users in data validations.
• Extensively worked in improving performance of the jobs by avoiding as many transforms as possible.
• Prepared documentation for unit, integration and final end - to - end testing.
• Helped in preparing the mapping document from source to target.
• Designed and developed ETL processes using DataStage designer to load data from Mainframe flat files, DB2 UDB, Sequential Files (Fixed Width) to staging database and from staging to target Data Warehouse database.
• Developed job sequencer with proper job dependencies, job control stages, triggers, and used notification activity to send email alerts.
• Excessively used DS Director for monitoring Job logs to resolve issues.
• Documented ETL test 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.
• Worked closely with QA Testers for the resolution of the data defects identified by them through the Application Lifecycle Management.
• Participated in discussion with Project Manager, Business Analysts and Team Members on any technical and/or Business Requirement issues in weekly status meetings.

Environment: Confidential InfoSphereDataStage7.5, Oracle 10g, Sequential files and Mainframe files, Control-M, UNIX Shell Scripting.