SUMMARY:

• Around 7 years of IT experience in Data Analysis, Design, Development, Implementation and Testing of Database/Data warehousing/Client/Server/Legacy applications using Data Modeling, Data Extraction, Data Transformation, Data Loading and Data Analysis.
• Expertise in translating business requirements into Data Warehouse and Data Mart design and developing ETL Design based on the requirements using Data Stage.
• Worked with dimensional modeling, Star Schema modeling, and Snowflake modeling, and fact and dimension table design, physical and logical Data modeling
• Extensive experience in loading and maintaining Data Warehouses and Data Marts using DataStage Client Components like Manager, Designer, Director, Administrator
• Worked extensively on different types of stages like ODBC, Aggregator, Transformer, Merge, Join, Lookup, Sort, SAP ABAP stage, XML Input/Output, CFF, Pivot, FTP, Shared Containers (Parallel) for developing jobs.
• Extensively worked on designing, compiling, testing, scheduling DataStage jobs
• Experienced in debugging, validate, schedule, run and monitor jobs using DataStage Director.
• Worked on Control - M, DataStage Director for designing batch jobs for scheduling.
• Experienced in performance tuning and troubleshooting by performing the root cause analysis.
• Highly knowledgeable in Database management systems, UNIX shell scripting, Client/Server application development, Software Testing.
• Knowledge on Agile method of SDLC, Sprint and JIRA
• Experience in integration of various data sources like Oracle, SQL Server and Flat Files using Active/Passive Stages available in Data Stage Tool.
• Strong knowledge of Extraction Transformation and Loading (ETL) processes using UNIX shell scripting, SQL Loader.
• Excellent communication, interpersonal, analytical skills and strong ability to perform as a team

PROFESSIONAL EXPERIENCE:

Confidential

ETL Data Stage Developer

Responsibilities:

• Involved in gathering and analyzing various items from different departments Understanding the core requirements of the Project. Involved in Data Extraction, Staging, Transformation and Loading.
• Develop ETL jobs to generate files & reports transmitted to end customers Involved in Analysis, Design, Development, and Documentation of Functional &Technical specifications. Participated in four complete cycles of ETL development.
• Created Job Sequences to using Job Activity, Notification Variables Activity Used Data Stage Director for monitoring jobs, troubleshooting errors and resetting aborted jobs. Created Datastage sequencer to call Datastage parallel and server jobs and used check points.
• Understand the HL7 messages and Created complex DataStage jobs to meet HL7 layout segments. Created DataStage shared containers to reuse the same logic in multiple jobs. Design DataStage jobs to create HL7 ADT messages. Create Zena schedule jobs to send extracts to HealthShare.

Environment: IBM Datastage 11.5, UNIX, Winscp, SQL server, DB2, Zena scheduling tool, workday, ADO, Service now, Sybase.

Confidential

Data Stage Developer

Responsibilities:

• Involved in analyzing existing schema to identify suitable dimensions and facts for schema and Implemented logic for Slowly Changing Dimensions. Interacted with the Data Modelers while designing data mart and reporting layers.
• Designed and developed mappings between sources systems (external files and databases) to operational staging targets. Used the DataStage Designer to develop processes for extracting, transforming, integrating, and loading data into Data mart
• Developed user defined Routines and Transformations to implement Complex business logic. Used the DataStage Director and its run - time engine to schedule running the solution, testing and debugging its components, and monitoring the resulting executable versions (on an ad hoc or scheduled basis). Involved in Unit Testing and System Testing for various jobs and performed job tuning. Involved in creating reports with Multiple Data Sources, Drill Down, Cross Tab, Slice/Dice and Charts. Involved in production support and on call support

.Environment: DataStage 8.0 (Designer, Director), Oracle 10g, Unix, PL/SQL, DB2, JIRA.

Confidential

Data Warehouse Developer

Responsibilities:

• Designed and developed jobs for extracting, transforming, integrating, and loading data into Oracle AR Module using DataStage Designer. Maintained warehouse metadata, naming standards and warehouse standards for future application development Developed Open Interface to import the Invoices using
• Auto Invoice Master Program. Most of the stages used were the Sequential File, Aggregator, ODBC, and Transformer.
• Extensively used pre built - in Transformations and Functions. Developed user defined Routines for implementing Complex business logic. Used DataStage Manager for importing metadata from repository and creating new job categories and data elements.
• Extensively used DataStage Director to schedule, monitor, analyze performance of individual stages and run multiple instances of a job. Performed the Unit and System testing for each job to ensure that it meets the documented functional requirements. Developed Unix Shell Scripts to validate files, schedule DataStage jobs and data loading procedures.

Environment: Ascential DataStage 7.5 (Designer, Manager, Director), IBM DataStage 8.5, Oracle 10G, UNIX.