We provide IT Staff Augmentation Services!

Sr. Datastage Etl Developer Resume

Rockville, Md

PROFESSIONAL SUMMARY:

  • Nineteen plus years of experience in Software Development in Complete Life Cycles of Agile, SDLC, Scrum and RUP methods for different Business Applications. I Worked as Data Architect, Data Modeler, Sr. DataStage ETL Developer, Sr. Oracle Application Developer.
  • Over 6 years of Dynamic career reflecting pioneering experience and high performance in System Analysis, design, development and implementation of Relational Database and Data Warehousing Systems using IBM Data Stage 8.5/ 8.0.1/7.5.3 (Info Sphere Information Server and Ascential DataStage).
  • Excellent Experience in Designing, Developing, Documenting, Testing of ETL jobs and mappings in Server and Parallel jobs using Data Stage to populate tables in Data Warehouse and Data marts.
  • Proficient in developing strategies for Extraction, Transformation and Loading (ETL) mechanism.
  • Expert in designing Parallel jobs using various stages like Join, Merge, Lookup, Remove duplicates, Filter, Dataset, Lookup file set, Complex flat file, Modify, Aggregator, XML.
  • Expert in designing Server jobs using various types of stages like Sequential file, ODBC, Hashed file, Aggregator, Transformer, Sort, Link Partitioner and Link Collector.
  • Experienced in integration of various data sources (DB2 - UDB, SQL Server, PL/SQL, Oracle ) into data staging area.
  • Expert in working with Data Stage Manager, Designer, Administrator, and Director.
  • Experience in analyzing the data generated by the business process, defining the granularity, source to target mapping of the data elements, creating Indexes and Aggregate tables for the data warehouse design and development.
  • Excellent knowledge of studying the data dependencies using metadata stored in the repository and prepared batches for the existing sessions to facilitate scheduling of multiple sessions.
  • Proven track record in troubleshooting of Data Stage jobs and addressing production issues like performance tuning and enhancement.
  • Expert in working on various operating systems like UNIX AIX 5.2/5.1, Sun Solaris V8.0 and Windows 2000/NT.
  • Experienced in Database programming for Data Warehouses (Schemas), proficient in dimensional modeling (Star Schema modeling, and Snowflake modeling).
  • Expertise in UNIX shell scripts using K-shell for the automation of processes and scheduling the Data Stage jobs using wrappers.
  • Experience in using software configuration management tools like Rational Clear case/Clear quest for version control.
  • Experienced in Data Modeling as well as reverse engineering using tools Erwin, ER Studio
  • Expert in unit testing, system integration testing, implementation and maintenance of databases jobs.
  • Effective in cross-functional and global environments to manage multiple tasks and assignments concurrently with effective communication skills.
  • Six plus years worked as Data Architect and Data Modeler.
  • 8 plus Years’ experience in Sr. Oracle Developer as SQL, PL/SQL Forms, Reports, CRYSTAL REPORT 10, APEX, Oracle Batch Processing, COGNOS 8.1, Discoverer, Oracle 10g/11g/12c and OPUS (Open Product Underwriting System)
  • Main Domain Knowledge in BI Application, Medicaid, Medicare Information System, Automobile, Financial services, General Insurance, Health Insurance, HR, Payroll, Time sheet
  • Three years of Experience in UNIX and Shell Scripting and based on the project’s requirement.
  • Got Training on Informatica .
  • Fifteen Months experience in COGNOS Developer.
  • Concept of Netezza database and PostgreSQL .
  • 2 years of experience in Mainframe, COBOL, CICS, DB2, IMS.

TECHNICAL SKILLS:

Operating Systems: MVS/ESA, UNIX, Windows 2010/2000/XP/NT, Windows 7 and MS - DOS

DBMS: Oracle 11g/10g/9i/8i/8/7.3, IMS/DB (Hierarchal DB), DB2 (Relational DB), TOTAL (Networking DB)

Languages: SQL, PL/SQL, COBOL, C, C++, JCL, UNIX, Shell Programming

ETL Tool: Data Stage 8.0.1/7.5.3, Informatica 8.5

Reporting Tool: Cognos 8.1, Oracle Reports 6.0, 8i, 9i, 10g

Tools: Oracle Configurator Developer (11.5.8), Lotus Notes and Domino Editor 6.5.1, Erwin 3.5.2 and Visio 2003

Domain: Automobile, Financial Services Practice, Health care, Insurance, Product Development and Utilities domain knowledge

Client Server Tools: Developer/2000(FORMS 6.0/6i/9i), HTML, MS-FRONT PAGE, REPORTS 2.0/2. 5 and Open Product Underwriting System (OPUS)

Case Tools: TOAD Data Modeler 4.1, ER Studio and Designer 2000

DBA Tools: TOAD, SQL*Loader, external tables, Import & Export

Application Servers: Oracle 9iAS

Other Tools: GITs, Clear Case, Clear Quest, VSS, WINCVS, CHANGEMAN, XPEDITER and ADPAC

Web Tools: APEX 4.0, Java, HTML, Web Logic 6.x

Web Services: SOAP

PROFESSIONAL EXPERIENCE:

Confidential, Rockville, MD

Sr. DataStage ETL Developer

Responsibilities:

  • Managed, designed and implemented managed assets application projects utilizing Erwin and IBM Data Architect.
  • Involved as primary on-site ETL Developer during the analysis, planning, design, development, and implementation stages of projects using IBM Web Sphere software
  • Prepared Data Mapping Documents and Design the ETL jobs based on the DSDD(Detailed System Design Document ) with required Tables in the Dev Environment.
  • Active participation in decision making and QA meetings and regularly interacted with the Business Analysts and 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 DataStage 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(CDC), 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.
  • Used the Data Stage Director and its run-time engine to schedule running the solution, testing and debugging its components, and monitoring the resulting executable versions on ad hoc or scheduled basis.
  • Developed complex store procedures using input/output parameters, cursors, views, triggers and complex queries using temp tables and joins.
  • Converted complex job designs to different job segments and executed through job sequencer for better performance and easy maintenance.
  • Creation of jobs sequences.
  • Maintained Data Warehouse by loading dimensions and facts as part of project. Also worked for different enhancements in FACT tables.
  • Created shell script to run data stage jobs from UNIX and then schedule this script to run data stage jobs through scheduling tool.
  • Coordinate with team members and administer all onsite and offshore work packages.
  • Analyze performance and monitor work with capacity planning.
  • Performed performance tuning of the jobs by interpreting performance statistics of the jobs developed.
  • 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.
  • Developed Test Plan that included the scope of the release, entrance and exit criteria and overall test strategy. Created detailed Test Cases and Test sets and executed them manually.
Confidential, Chevy Chase, Maryland

Oracle Data Architect/DBA

Responsibilities:

  • Involve in Data Model to design the data base as business requirement
  • Working on Data Model tool i.e. Guide Wire to prepare the scripts and compile in Perforce version control
  • Working on performance tuning of SQL and PL/SQL code
  • Create some optimized query as of business requirement in Claim environment
  • Write the SQL code as of the different application team needs for data extraction
  • Involve in New Development, enhancement and bug fixing on Oracle11g for writing SQL and PL/SQL e.g. Packages, Procedure, Functions, Objects, Types, Views
  • Use the Import Guide wire tool for data patch from lower to higher environment
  • Optimizing SQL statements using hints, Indexes, Explain Plan, TKPROF, SQL TRACE or AWR report for performance tuning
  • Fine tune the SQL query by using Oracle Enterprise manager (Oracle Enterprise Manager) with help of DBA
  • Creating or modifying the shell script for the batch job
  • Support the batch job which runs every day mid-night

Environment: Oracle 11g, TOAD, TOAD DATA Modeler 4.1

Confidential, Arlington, VA

Oracle Developer/DBA

Responsibilities:

  • Involve the business requirement to understand the business process.
  • Design the dimensional modeling STAR and SNOW FLEX schema as of business requirement.
  • Prepare the program spec
  • Developed the code in Pl/SQL and do unit test.
  • Create Packages, Procedure, Functions, DB Triggers., Objects, Types, Views, Materialized views
  • Optimizing SQL statements using hints, Indexes, Explain Plan
  • Used TKPROF, Hints for SQL tuning
  • Fine tune the SQL query by using Oracle Enterprise manager(OEM)
  • ETL Tool Data Services
  • Worked on reporting tool as Business Objects

Environment: IBM Web Sphere DataStage 8.1 Parallel Extender, Web Services, Quality Stage 8.1, (Designer, Director, Manager), ORACLE 11G, Query man, Unix, Windows, TOAD

Confidential, Herndon, VA

Sr. Oracle PL/SQL ETL Developer

Responsibilities:

  • Involve the business requirement stage to understand the business process.
  • Used the DataStage Designer to develop processes for extracting, cleansing, transforming, integrating and loading data into staging tables.
  • Extensively used ETL to load data from Oracle database and Flat files Source to Oracle Database Server.
  • Involved in analysis, planning, design, development, and implementation phages of projects using IBM Web Sphere software (Quality Stage v8.0.1).
  • Developed complex jobs using various stages like Lookup, Join, Transformer, Dataset, Row Generator, Column Generator, Datasets, Sequential File, Aggregator and Modify Stages.
  • Created queries using join and case statement to validate data in different databases.
  • Created queries to compare data between two databases to make sure data is matched.
  • 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.
  • Monitoring the Datastage job on daily basis by running the UNIX shell script and made a force start whenever job fails.
  • Created and modified batch scripts to ftp files from different server to data stage server.
  • Extensively used slowly changing dimension Type 2 approach to maintain history in database.
  • Created Job Sequencers to automate the job.
  • Create parameter set to assign a value to job at run time.
  • Used Parallel Extender for Parallel Processing for improving performance when extracting the data from the sources.
  • Worked with Metadata Definitions, Import and Export of Datastage jobs using Data stage Manager.
  • Implemented PL/SQL scripts in accordance with the necessary Business rules and procedures .
  • Developed PL/SQL procedures & functions to support the reports by retrieving the data from the data warehousing application.
  • Used PL/SQL programming to develop Stored Procedures/Functions and Database triggers.

Environment: IBM / Ascential Data Stage 7.5(Manager, Designer, Director), Quality Stage 7.5 Data Stage BASIC language Expressions, Sequential files, .csv files, Oracle 10g, TOAD, ER studio

Confidential, Falls Church, VA

Sr. Oracle Pl/SQL ETL Developer with Data Model

Responsibilities:

  • Design the system by understanding the business requirements.
  • Design the Process flow and ER diagram
  • Prepare the program spec
  • Developed the PL/SQL Package
  • Worked on CRYSTAL REPORT
  • Responsible for New Development, enhancement and bug fixing on Oracle11g for writing SQL and PL/SQL e.g. Packages, Procedure, Functions, DB Triggers., Objects, Types, Views
  • Developed and maintain APEX forms in Oracle Application Express
  • Optimizing SQL statements using hints, Indexes, Explain Plan
  • Used TKPROF, Hints for SQL tuning
  • Load the bulk data from external files(.csv) to oracle Staging area by SQL*Loader.
  • Worked on APEX Application

Environment: Oracle 10g, TOAD, ER studio

Confidential, Gaithersburg, MD

Sr. Oracle PL/SQL ETL Developer

Responsibilities:

  • Co-ordination with Modeling team and business analysts for requirement study and system analysis
  • Developed the PL/SQL Package to generate all the source flat files from OLTP system with help of UTL File
  • FTP to all the source flat files to target location through shell scripts
  • Developed some other PL/SQL packages for interface system
  • Responsible for New Development, enhancement and bug fixing on Oracle10g for writing SQL and PL/SQL e.g Packages, Procedure, Functions, DB Triggers
  • Optimizing SQL statements using hints, Indexes, Explain Plan
  • Developed ETL Jobs in DATA STAGE v 7.5.3/8.1
  • The ETL jobs are developed based all types
  • Extensively used CDC stage, Remove Duplicates Stage, Sequential file, Data sets, Transformer, funnel, Lookup, join. Worked on the mapping documents for ETL transformations.
  • Developed Cross tab, tabular reports in COGNOS 8.1.4
  • Worked on Frame Work Manager of COGNOS to publish all the Database objects like Views, tables
  • Scheduled Jobs in COGNOS
  • Used TKPROF, Hints for SQL tuning. To write UNIX shell script to run some CRON jobs

Environment: Oracle 10g, TOAD, UNIX Shell Scripts, Data Stage

Confidential, Covansys, MI

Senior Oracle Developer/ DBA

Responsibilities:

  • Co-ordination with client and business analysts for requirement study and system analysis
  • Co-ordinate to Offshore resources and provide technical and Business guidance regarding project and manage project issues in new Development phase.
  • Responsible for New Development on Oracle9i for writing SQL and PL/SQL e.g. Packages, Procedure, Functions, DB Triggers
  • Optimizing SQL statements using hints, Indexes, Explain Plan
  • Performed exports, imports with the help of DBA
  • Used TKPROF for SQL tuning at the beginning and
  • Coding, Unit Testing, Issue Resolution, Integration and System Testing manually
  • To arrange meeting with PM, Business Analyst to update progress, Issues, Clarifications
  • To Maintain all tickets thru eRoom System
  • To write UNIX shell script to run some CRON jobs

Environment: Oracle 9i, TOAD, UNIX, Java, XML, CSS, XML-FO, XSLT

Confidential, Covansys, MI

Senior Oracle Developer

Responsibilities:

  • Installations Oracle 8i Enterprise Edition on Windows Professional 2000
  • Coordinating with client and business analysts for requirement study and system analysis
  • Mentor to Offshore resources and provide technical guidance regarding project and architectural standards and manage project issues
  • Creation of Database, Schema, users granted and revoked resources and other various kinds f DB objects
  • Analyzing the existing system to understand the process work flow
  • Responsible for Development on Oracle8i for Responsible for writing SQL, PL/SQL, Packages, Procedure, Functions, DB Triggers, Web Logic
  • Up Gradations, Patch depends on the requirements
  • Optimizing SQL statements using hints, Indexes
  • Performed exports, imports
  • Used TKPROF for SQL tuning at the beginning and then installed Oracle Enterprise Manager and SQL Lab to analyze the SQL statements that took most of the CPU. Analyzed SQL results from Lab and helped to tune those queries
  • Coding, Unit Testing, Issue Resolution, Integration and System Testing manually
  • To attend SWAT CALL of Severity - 1, Escalated Severity - 2 Issue
  • To Maintain all tickets through TEAM TRACK and later it is migrated to EARS System
  • To work on Oracle Configurator Developer (OCD 11.5.8)
  • To maintain and develop UNIX shell script to run some CRON jobs
  • To attend SWAT CALL of Severity - 1, Escalated Severity - 2 Issue
  • To maintain all tickets through TEAM TRACK and later it is migrated to EARS System
  • To create users by using Oracle Apps Concurrent Manager 11i
  • To Register the concurrent jobs and schedule in the PRODUCTION environment by using concurrent manager and monitor the jobs

Environment: Oracle Forms 6i, Oracle 8i databases, Oracle Apps 11i

Confidential, Carson, NV

Senior Oracle Developer

Responsibilities:

  • Analyzing the existing system to understand the process workflow
  • Designing application changes, Preparing Design specifications along with technical specification (SOD)
  • Coding, Unit Testing, Issue Resolution, Integration and System Testing
  • Coordinating with client for requirement study and system analysis
  • Created Packages, Procedure, Functions, Triggers
  • Optimizing SQL statements using hints, Set Trace on and TKPROF Utilities
  • Copying Data one schema to another schema by Using DB links
  • Created Couple of Procedure and function to validate the data in LOS (Loan Origination System)
  • Created some customized new forms and reports as of business requirements
  • Created some SQL and PL/SQL scripts to build the Patch
  • To develop UNIX shell script to run some batch jobs

Environment: Oracle Forms 10g, Oracle Reports 10g and Oracle 10g databases, UNIX, Shell Script

Hire Now