SUMMARY:

• 4+ years of IT experience in analysis, design and development of data warehouse and ETL related applications.
• 4+ years of experience with ETL tools like IBM Information Sever Datastage 11.5/9.1/8.5/7. x versions.
• Hands on experience in Data Quality Projects with tools - IBM Information Analyzer, Datastage Designer, Datastage Director, Datastage Administrator and Oracle Enterprise Data Quality.
• Implementation experience of complete SDLC process in all projects
• Good Implementation experience and knowledge in Data Warehousing
• Worked with different databases like Oracle, DB2 and SQL Server.
• Proficient in Data analysis, Design and Implementation of Data enrichment process as part of DQ Correction methodologies
• Optimizing the ETL process using performance Tuning Methods and identify RCA for the bottle neck performance issues and then resolve
• Experience as Production Monitor and handle all incidents and provide necessary steps to resolve the tickets rose.
• Experience in performing different roles like System/Business Analyst and responsibilities include - Requirements Gathering, Analysis & Design && Testing for end-to-end IT solution offerings
• Have good understanding of source to target data mappings and Business rules associated with the ETL processes.
• Involved in discussion with Business Users, coordinating onsite and offshore team members, finalizing Technical Specification Designs (TSD) and assigning TSD's to ETL Developers and responsible for Deliverables.
• Strong understanding of the principles of Data Warehousing using Fact Tables, Dimension Tables, star schema and snowflake schema modeling
• Worked on different Scheduling tools like Job Scheduler, Control M and proven track record in troubleshooting of ETL jobs and addressing production issues.
• Experience in managing offshore team, organizing and conducting meetings with the Offshore/Client at onshore for project requirements and status discussions.
• Hands on experience with data warehousing tools, data analysis, unit testing, migration, code reviews, conversions and process documentation.

TECHNOLOGIES:

Operating Systems: Windows, Unix

Tools: DataStage, QualityStage, Oracle SQL Developer, Teradata SQL Assistant client, SQL, HP Quality Centre, Putty, SSH, Mainframe, ODI

Databases: Oracle, DB2, SQL-Server

Scripting Languages: UNIX Shell Scripting

WORK EXPERIENCE:

Confidential, Wilmington, DE

Sr Datastage Developer

Responsibilities:

• Extracted the data from database tables and Flat File data sources, Transformed and Loaded into Target.
• Responsible for interacting with the Business clients and taking part in review of requirements document discussions
• Extracted the data from database tables and Flat File data sources, Transformed and Loaded into Target.
• Responsible for interacting with the Business clients and taking part in review of requirements document discussions
• Also, play the role of a Lead for the development team, which involves, estimation, work allocation to resources, tracking the status, providing the daily and weekly status to Project Manager
• Responsible for interacting with the Business clients and taking part in review of STM's document discussions
• Prepared source to target documents based on profiling results.
• Preparing the low-level design documentation as per the client's specification.
• Key designer for ETL jobs and responsible for code review of ETL deliverables.
• Designing of the ETL Processes using different parallel job stages such as Join, Merge, Lookup, Filter, Dataset, Transformer, sort, and Aggregator
• Created control-m Visio diagrams for job scheduling.
• Responsible for Code check-in, Version management and all the implementation activities
• Provided the support for testing team in SIT phase.
• Provided the Support for UAT on data load.
• Provided the control M set up and same have been implemented in stage and production.
• Involved in implementation work and successfully implemented in stage and production environments and supported for some time.
• Working as L3 support also for any urgent critical issues in prod.
• Key designer for ETL jobs and responsible for code review of ETL deliverables.
• Responsible for driving the status calls and technical calls within team and other dependent teams.

Environment: IBM Information Server 11.3 (DataStage, Quality Stage and Information Analyzer) and DataStage 11.3, Erwin, QualityStage, Unix Shell scripting, TOAD, Oracle 11g, SQL, PL/SQL, Control M, SVN

Confidential, SFO, CA

DataStage Developer

Responsibilities:

• Developed standards for ETL framework for the ease of reusing similar logic across the board
• Analyze requirements, create design and deliver documented solutions that adhere to prescribed Agile development methodology and tools
• Developed mappings to extract data from different sources like DB2, XML files are loaded into Data Mart
• Created complex mappings by using different transformations like Filter, Router, lookups, Stored procedure, Joiner, Update Strategy, Expressions and Aggregator transformations to pipeline data to Data Mart
• Involved in designing Logical/Physical Data Models, reverse engineering for the entire subject across the schema
• Creating Development Standards. This document describes the general guidelines for etl developers, the naming conventions to be used in the Transformations and also development and production environment structures
• Troubleshoot database, Jobs, mappings, source, and target to find out the bottlenecks and improved the performance
• Involved rigorously in Data Cleansing and Data Validation to validate the corrupted data
• Migrated mappings/ Jobs from Development to Test and to production environment.
• Loaded data from Source systems and sent to Message queue for loading in to Target systems using XML Generator and Parsing Transformations
• Worked with DataStage Designer, Director, Administrator, IIS Web Console, Fasttrack.
• Reviewed the design and requirements documents with architects and business analysts to finalize the design
• Used mapping /Parameter set for reuse thereby saving valuable design time and effort
• Created Logical objects and converted into DDL to create database.
• Built common rules for analyst to use in mapping specifications and profiling on tables
• Created Pre/Post session to save the last generated numbers for SK's
• Used SQL Override in Sort, Filter & in Source Qualifier Transformation.

Environment: DataStage 9.5, (Designer, Director, Manager, Parallel Extender), Oracle 10i, SQL Server 2000, DB2, MS-Access, XML files, PL/SQL, Teradata, MQ series, UNIX, Windows