SUMMARY

• ETL developer with 9 years of proven expertise providing analysis, design, development, and Implementation for client server and Data warehousing projects.
• Excellent Experience in designing and developing jobs using IBM DataStage, Data Stage Designer, Data Stage Manager, and Data Stage Director on Server Engine.
• Designed Server jobs, Job Sequencers, Batch Jobs and Parallel jobs. Handled multiple pieces of a Project.
• Worked on POC for datastage migration from datatage 8.1 from datastage 9.1 version for Data Refresh Project
• Worked on SCD Type2 for maintaining the history.
• Extensive usage of dbeaver and toad for analyzing data and writing SQL scripts for executing queries.
• Experience using IBM Data stage (Ver9.1/8.7/7.5x/7.x), Parallel Extender for Extraction, Transformation and Loading of data from multiple sources into Data warehouse.
• Excellent knowledge of studying the data dependencies using metadata of Data Stage and preparing job sequences for the existing jobs to facilitate scheduling of multiple jobs.
• Designed Parallel jobs using various stages like join, merge, lookup, remove duplicates, filter, dataset, lookup file set, modify, aggregator, Transformer.
• Developed Server jobs using various types of stages like Sequential file, ODBC, Hashed File, Aggregator, Transformer, Sort, Link Partitioner and Link Collector.
• Extensively used SQL coding for overriding the generated SQL in Data stage and also tested the data loaded into the data base.
• Expertise in Relational Database concepts and Entity Relation Diagrams. Experience in Data profiling, standardization, matching and survivorship using Quality Stage. Worked with Information Analyzer for Column Analysis, Primary Key Analysis and Foreign Key Analysis.
• Strong in writing UNIX shell scripts for Data validations, Data cleansing etc.
• Streamlined development/deployment process by building DEV/UAT environment, coming up with standard for deployment plans.
• Strong database skills with Oracle, and SQL Server, Teradata. Worked on Teradata Utilities TPUMP, MLoad.
• Implemented Autosys Scheduling tool to Schedule the jobs and collect the Job Statistics.
• Strong Data modeling skills including Star Schema and Snow - Flake models and E-R modeling.
• Proven track record in troubleshooting of Data Stage jobs and addressing issues like performance tuning and enhancement.
• Automated the data stage jobs and completed the JDI Certification in Data Refresh Project
• Strong interpersonal, written and verbal communication skills. Highly organized professional with strong technical skills.

TECHNICAL SKILLS

ETL: Data stage 9.1/8.X/ 7.5.1/7.0/6.0 Parallel/Server, Teradata Utilities.

Data profiling: IBM Information Analyzer 8.1

Databases: Oracle 10g/9i/8i/8/7.x, DB2, SQL Server 2000, Teradata.

Hardware: Mainframes

Data Modeling: Erwin 4.5/4.0/3.5/3.0 , Star schema, Snowflake schema.

Programming: UNIX Shell Scripting, AIX, C, C++, SQL, PL/SQL, HTML, VB, Perl Scripting

Database Tools: SQL *Loader, SQL*Plus, TOAD, Dbeaver, SQL Developer

Environment: UNIX, MS DOS

PROFESSIONAL EXPERIENCE

Confidential, NewJersey

Data stage Developer

Responsibilities:

• Extensively used DataStage Designer to develop various jobs to extract, cleanse, transform, integrate and load data into target tables.
• Designed various Data stage jobs for creating the report using Lookups, Join, CDC, Transformer, DB2 connector, Oracle, Sort, Aggregator, Sequential file stages.
• Involved in business meetings with the Business Analysts for gathering the business requirements.
• Worked in Analysis, Development, Unit Testing and Performance tuning of the jobs
• Built sequencer jobs and implemented SCD Type2 in order to maintain the history of products
• Proven track record in troubleshooting of Data Stage jobs and involved in creating functional and scope documents.
• Extensive usage SQL developer for executing queries.
• Provide design options, alternatives and recommendations based on experience and best practices for report design

Environment: IBM Datastage designer, Datastage director, Oracle, WinSCP & SQL Developer.

Confidential, FL

Data stage Developer

Responsibilities:

• Extensively used DataStage Designer to develop various jobs to extract, cleanse, transform, integrate and load data into target tables.
• Designed various Data stage jobs for loading the EDW staging layer using Lookups, Join, CDC, Transformer, DB2 connector, Sort, Aggregator, Sequential file stages.
• Prepared Technical Design Specification Documentation for Data Extraction, Data Transformation, and Data Loading in to Enterprise Data warehouse (EDW).
• Proven track record in troubleshooting of Data Stage jobs and involved in creating functional and scope documents.
• Involved in Analysis, Development, Unit Testing and Performance tuning of the jobs
• Extensive usage of dbeaver and toad for analyzing data and writing SQL scripts for executing queries.
• Created Source to Target Mapping Documents for the ETL process developed to load EDW.
• Maintain an ongoing knowledge of both the technical data model and the business strategic needs.

Environment: IBM Datastage designer, Datastage director, Dbeaver, Toad and Unix

Confidential, TX

Data stage Developer

Responsibilities:

• Experienced in using DataStage (9.1, 8.1) Tools like IBM Info sphere DataStage Designer, Info sphere DataStage Director for developing jobs and to view log files for execution errors.
• Worked on POC for datastage migration from datastage 8.5 to 9.1
• Worked as the module lead for sanitization.
• Performed ETL coding using Sequential file, Transformer, ODBC, Peek, Aggregator, Filter, Funnel, Copy, Change Capture, Merge, Look up, Join, Sort, Complex Flat File, Data masking pack compiled, debugged and tested
• Worked with complex flat files in the process of extraction of data.
• Involved in performance tuning of the jobs and in unit performance and integration testing of Data Stage jobs.
• Enhanced the Datastage jobs which results in Zlinux space utilization and reduce cycle time.
• Used Partition methods and collecting methods for implementing parallel processing.
• Implemented Autosys Scheduling tool to Schedule the jobs and collect the Job Statistics.
• Identified areas where the process can be automated to save cost and to improve efficiency.
• Automated the subset process by building skeleton JCL’s which reduced the human errors and saved the time.
• Used appropriate JCL’s to downsize the Mainframes files like Flat files, VSAM files, GDG files.
• Built skeleton JCL’s according to the requirement in the files.

Environment: IBM DataStage 9.1/8.7, Complex Flat files, UNIX, DB2, Autosys, Mainframes

Confidential, NJ

Data stage Developer

Responsibilities:

• Worked with the Business analysts and the DBA for requirements gathering, business analysis, testing, and project coordination.
• Involved in creating functional and scope documents for ETL processes.
• Identified and documented data sources and transformation rules required to populate and maintain data warehouse.
• Used Information Analyzer for column analysis, primary key analysis and foreign key analysis.
• Used Quality stage for data profiling, standardization, matching and survivorship.
• 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 the DataStage jobs.
• Analyzed and enhanced the performance of the jobs and project using standard techniques.
• Developed Unix FTP Scripts to automate the movement of flat files between servers.
• Extensive usage of Toad for analyzing data and writing SQL, PL/SQL scripts performing DDL operations.

Environment: IBM Web Sphere Datastage 8.0, Oracle 10g, Autosys, Toad, SQL plus, MS Visio, Erwin 7.3, Pl/SQL, SQL Server 2005.

Confidential - Dallas, TX

Datastage developer

Responsibilities:

• Designed the jobs in Data stage 8.1 Parallel Extender. Provided hands-on participation, technical guidance and leadership to support existing Data warehouse applications, involving Data stage, Quality Stage. Using IBM Information Analyzer, done column Analysis
• Used Multi load stage using Teradata Utilities(TPUMP, MultiLoad) to load into Teradata DB
• Worked on Change data capture (CDC) for updating target. Developed reusable jobs using Dynamic Meta data using run column propagation.
• Developed in writing transforms using stage variables for jobs and code for batch jobs to run jobs in parallel.
• Performing export and import of Datastage components, table definitions and routines.
• Developed Job Sequences and implemented logic for job sequence loops, recovery and restart.
• Used Data stage Director to clear the job logs, job resources and status files.
• Experience in complete life cycle of Design, Development, Maintenance and Documentation of Conversion Process. Worked with Datasets, Lookup, Merge, Joiner, Funnel, Transformer
• Profiled vendor supplied raw data using Information Analyzer.
• Prepared technical design, tests (Unit/System), and supported user acceptance testing.
• Involved in setting up the ETL standards and helped the client to use ETL best practices.
• Extensively used Perl Scripting for Transforming Raw data to the standard format.
• Identified performance bottle-necks and suggested improvements. Used Maestro tool as third party tool for scheduling ETL jobs and notifications.

Environment: Data stage 8.1 Parallel Extender using IBM Information Analyzer and Quality stage, Erwin 4.2, Oracle 9i/10g, Teradadata12, Flat files, UNIX- AIX, Windows XP, MS Word, Excel, Maestro Tool for scheduling jobs

Confidential -Columbus, Ohio

Datastage Lead Developer

Responsibilities:

• Worked on Teradata connector and oracle connector stage to connect and extract the data
• Developed in writing transformations using stage variables for jobs and code for batch jobs to run jobs in parallel.
• Performing export and import of Datastage components, table definitions and routines.
• Developed Job Sequences, job activities, execute commands, user variable activity and implemented logic for job sequence loops, recovery and restart.
• Used Data stage Director to clear the job logs, job resources and status files.
• Experience in complete life cycle of Design, Development, Maintenance and Documentation of Conversion Process. Worked with Datasets, Lookup, Merge, Joiner, Funnel, Transformer
• Prepared technical design, tests (Unit/System), and supported user acceptance testing.
• Involved in setting up the ETL standards and helped the client to use ETL best practices.
• Extensively used shell scripting for FTP to K-drive and GPO server
• Identified performance bottle-necks and suggested improvements.

Environment: Data stage 8.1 Parallel, Oracle 9i/10g, Teradadata12, Flat files, UNIX- AIX, MS Word, Excel, and Maestro Tool for scheduling jobs.

Confidential

Datastage developer

Responsibilities:

• Involved in reviewing Business/System requirements and other deliverables.
• Designed the jobs in Data stage 8.1 Parallel Extender.
• Developed in ETL jobs using Data stage, supporting all ETL process such as implementing Source to target mapping.
• Involved in System testing strategies preparation. Designed Test Cases
• Expertise in resolving performance tuning issues. Expertise in UAT, IT test cases, UT Results.
• Used Autosys tool for scheduling ETL Jobs
• Worked extensively on different types of stages like Aggregator, Merge Join, Lookup, Remove Duplicates, Transformer, Copy, Filter, Modify, Sorter, Investigate, Standardize, match frequency, Survive.
• Used Data stage Parallel Extender for splitting the data into subsets and to load data, utilized the available processors to achieve job performance, configuration management of system resources in Orchestrate environment.
• Created user defined transforms and routines for handling special cases
• Worked on XML input stage to read the XML file. Worked on DB2 Enterprises stage to read tables in DB2 RDBMS
• Extensively used SQL and PL/SQL coding in Datastage jobs for processing data. Develop UNIX shell scripts and schedule the jobs.
• Developed batches and sequencers in designer to run and control set of jobs.
• Used the Datastage Director and its run-time engine to schedule running the job.

Environment: Datastage7.5, Parallel Extender, DB2, oracle, XML files, UNIX, Shell Scripting and Autosys tool.