SUMMARY

• 3+ years of solid experience in building data warehouse/Data marts especially with ETL tools like IBM Information Server Datastage 11.5/11.3/9.1/8.5/ 8.1 x/8.0.x/7.5
• Extensive knowledge of Software Development Life Cycle (SDLC), having thorough understanding of various phases like Requirements, Analysis/Design, Development and Deployment.
• Expertise as a Data Warehousing Developer using ETL Tool DataStage (Manager, Designer, Administrator, Director) Parallel Extender, QualityStage.
• Installation, configuration, setup and administration of Datastage Server.
• Experience in Database programming Load Data Warehouses (Star Schemas). Developed Strategies for Extraction Transformation Loading (ETL) mechanism
• Performed Debugging, Troubleshooting and performance tuning of Datastage Jobs.
• Used complex flat file stage in complex logic handling from the mainframe data source.
• Worked extensively with Data migration, Data Cleansing, ETL Processes.
• Experience in designing and working with Oracle 8i/9i/10g and writing SQL queries and PL/SQL Procedures, Functions, Packages, Database Triggers, Exception Handlers, Ref Cursors, Database Objects using PL/SQL. Proficient in writing Unix Shell scripts.
• Expertise in Testing phase planning, preparation and execution.
• Have the knowledge of install and configuration in Datastage.
• Practical experience in Quality Assurance - designing and execution of test cases, test scripts and test procedures
• Hands on experience in tuning mappings, identify and resolve performance bottlenecks in various levels like source, target, mappings
• Experience in creating schema objects, Performance Tuning of SQL statements
• Excellent Microsoft Office skills used for documenting the analysis and work done.
• Strengths include excellent communication skills and interpersonal skills, good analytical skills and logical approach to problem solving.
• Hands-on with GitLab. Cloned the code form the Master branch, changed the code according to business requirement and pushed the code to master branch.
• Hands on with creating a branch, cloning the code, raising the pull request.
• Worked on the migration project, Moved the entire code from Datastage 11.3 to Datastage 11.5.
• Worked on migrating the parameter files, modifying the configuration files, changing the shell scripts accordingly to trigger the Datastage jobs from the ControlM.
• Designed the new ControlM jobs and added the prerequisites.
• Hands on with looking the output logs in the ControlM and identifying whether the Datastage job is triggered or not.

TECHNICAL SKILLS

• ETL Tools: IBM InfoSphere Information Server DataStage 11.5/11.3/9.1/8.5/8.1/7.5.2 (Manager, Administrator, Designer, Director) Parallel Extender
• Dimensional Data Modeling: Star Schema Modeling, Snow - Flake Modeling, FACT and Dimensions tables, physical and logical data modeling, Erwin 4.1.2/3.x and Oracle Designer
• Reporting Tools: Data Reports
• Databases: Microsoft SQL Server 2005/2000/7.0/6.5, Oracle 11g/10g/9i/8i/8.0/7.3, PL/SQL, DB2 UDB, Teradata, Sybase SQL Server 11.0 and Access 2000, Netezza
• UNIX Tools: Shell Scripts
• GUI: Visual Basic 6.0/5.0/4.0, Excel, Power Point, Visual Interdev 6.5/6.0 and Visual Age 3.5
• Version Control tools: GIT

PROFESSIONAL EXPERIENCE

Confidential, Plano, TX

ETL Datastage Developer

Responsibilities:

• Involved in analysis, requirements gathering, function/technical specifications, development, deploying and testing.
• Created Shared Containers for reusable calculations in various strings.
• Extensively used Data Stage Designer stages such as ODBC, Aggregator, Transformer, Join, Pivot, FTP and Merge.
• Extensively used Email Notification, Nested Condition, Sequencer and Terminator activities in Job Sequences.
• Developed Routines for Error handling and also developed before/after job subroutine.
• Used the Data Stage Administrator to assign privileges to users or user groups (to control which Data Stage client application or jobs they see or run), move, rename or delete projects and manage or publish jobs from development to production status.
• Performed through data profiling by using the Investigate stage of QualityStage and also by writing PL/SQL queries to identify and analyze data anomalies, patterns, inconsistencies etc.
• Used QualityStage (Integrity Stage) for quality checking and error detection process.
• Used Director for executing, analyzing logs and scheduling the jobs.
• Developed Hash files for performance improvement by reducing the reference lookup time.
• Knowledge on Store procedures, Functions and packages in PL/SQL for Data ETL.
• Written SQL scripts to create and drop the indexes those are passes as parameters in the pre & post sessions.
• Involved in investigating & solving the data integrity issues.
• Worked on scheduling tool control M for monitoring and scheduling jobs.
• Wrote UNIX shell Scripts for file validation and scheduling DataStage jobs.

Environment: IBM Information Server 11.5/11.3 (DataStage, Quality Stage and Information Analyzer), Erwin 4.1, Windows 7, Unix Shell scripting, Oracle 10G, Control-M, TFS

Confidential, Chicago IL

ETL Datastage Developer

Responsibilities:

• Involved in understanding business processes and coordinated with business analysts and users to get specific requirements to build Data Marts as per ETL standards.
• Involved in low level design and developed various jobs and performed data loads and transformations using different stages of Datastage and pre-built routines and functions.
• Multiple project experiences with DataStage with the ability to communicate design considering using a combination of DataStage, databases, and UNIX scripting where required.
• Responsible for GAP Analysis to help identify current and proposed structure of customer data integration.
• Documented existing and to-be business processes and work flows for legacy data sources as well as downstream consuming systems.
• Adopted existing UNIX directories and scripts and modified as per required data process and for better performance enhancements.
• Developed Datastage jobs to extract, cleanse, transform, integrate and load data into data warehouse using DataStage designer versions 8.7/11.3.
• Designed and implemented efficient ETL code to populate data integration layers to support business requirements.
• Designed Parallel jobs involving complex business logic, update strategies, transformations, filters, lookups and necessary source-to-target data mappings to load the target using DataStage designer.

Environment: IBM Information Server (DataStage, Quality Stage and Information Analyzer), Erwin 4.1, Windows XP, SQL Server, DB2, Unix Shell Script, MS Access, Oracle 11g, HP ALM, GitLab