We provide IT Staff Augmentation Services!

Datastage Lead Developer Resume

0/5 (Submit Your Rating)

Dearborn, MI

SUMMARY:

  • Over 8+ years of work experience in Data Warehousing, Data integration and conversion processes, and Reporting including Architecture, Design and Development.
  • Hands - on experience in leading and designing Data Integration and migration for Data Warehouses including Microsoft SSIS /IBM Web Sphere/Ascential Datastage (Ver 8.1/8.0/7.5x2/7.x)Server Edition, Enterprise Edition (Data Stage Manager, DataStage Designer, DataStage Director, DataStage Administrator, Parallel Extender).
  • Working knowledge of SCRUM agile methodologies with sprint developing of all the backlog requirements.
  • Worked in various business domains including Retail, Financial/Banking and Telecom industries.
  • Expert in designing Parallel jobs using various types of stages like Sequential files, Datasets, DB stages, Joins, Lookups, Aggregator, Transformer, Sort, Modify, Row Generator, Column Generator, Peek.
  • Expert in designing Server Jobs using various types of stages including Sequential Files, Hashed Files, Aggregator, Sort, Transformer, Link Collector and Link Partitioner.
  • Experience in data warehouse architecture and designing star and snowflake schemas, Fact and Dimensional tables, Physical and Logical Data modeling using Erwin and ERStudio.
  • Excellent experience in writing and implementing testing and development processes at database level using SQL.
  • Experience in handling .txt files, binaries, and data types with DataStage.
  • Excellent experience in Relational database (RDBMS), Oracle 11g/10g/9i, MS SQL Server 2008, 2005, 2000, DB2 UDB, Informix IDS XPS, Teradata, and MS Access.
  • Expert in designing reports and dashboards with Microstrategy 9.2.1m using Desktop and Web applications for distinct BI projects.

TECHNICAL SKILLS:

Languages: SQL, PL/SQL,UNIX Shell scripting,C,C#,HTML

Database Tools: SQL Loader, TOAD, SQL Plus, Aquastudio, DBVisualizer

InfoSphereProducts: QualityStage, IBM Information Server Console & Server Manage, DataStage

ETL Tools: IBM Infosphere 8.1 Datastage, Ascential DataStage 7.5.2, Microsoft SSIS

BI Tools: SQLServerAnalysisServices, SQLServerReport ServicesMicroStrategy 8, MicroStrategy 9

Databases: Oracle7i, 8i, 9i, 10gand 11g SQLServer 2000, 2005 and 2008, DB2Informix, PostgreSQL, MySQL,Progress

Data Modeling: CA Erwin, ERStudio

Operating Systems: Windows Vista/2003/XP/2000/NT, Linux Ubuntu and Kubuntu,Solaris, AIX, UNIX

Other Skills: SCRUM, Version Control, Development ofVirtual Environments, Networksand Protocols, Quality Management, Economic Engineering,ProjectManagement, CMMI, WebServices

PROFESSIONAL EXPERIENCE:

Confidential, Dearborn, MI

Datastage Lead Developer

Responsibilities:

  • Used Shared Container to obtain the last sequence number from the ACF table and later wrote a routine activity to update the incremented sequence number into the ACF table. Sequence number is added to the header of the VIN Summary file that is FTP to the mainframe for loading the warehouse.
  • Extensively used Datastage Administrator, Manager, Designer and Director for creating and implementing jobs.
  • Developed number of Datastage ETL jobs based on business requirements using various Datastage Component as Copy, Modify, Aggregator, Filter, Funnel, Join, Lookup, Merge, CDC (Change Data Capture), Datasets, Sequential files and Transformer etc.
  • Used all the parallel stages which also include quality stage, CFF (Complex Flat File), Slowly Changing Dimensions Stage and Lookup stage which supports range lookups.
  • Used IBM PC Workstation V5.0 for Windows for connecting to a mainframe server and browsed through the VSAM database existing on the mainframe server.
  • Involved in Unit Testing and developed Test Cases for various complex scenarios.
  • Prepared detailed design documents with Business rules and assumptions involved in the project.
  • Worked with databases like DB2, Sybase and Teradata.
  • Involved in creating Designing documents and mapping documents for Datastage jobs.
  • Performed automation of file manipulation and for different procedures involving data cleansing Using Shell scripts.
  • Implementing performance-tuning techniques along various stages of the ETL process

Environment: IBM Information Server Datastage 8.1, (Designer, Director), Windows Server 2003, AIX5.2, UNIX Shell Scripts, Oracle10g/9i, SQL Loader, PL/SQL, IBM DB2 UDB, Teradata, Web Sphere, XML.

Confidential, Charlotte, NC

Datastage Lead Developer

Responsibilities:

  • Participated in the design review meetings to come up with the proper methodology that is to be followed uniformly across the development.
  • Involved in technical architecture designs which support a robust solution, taking into account the user requirements, technical requirements, etc
  • Collaborated with project team members in providing design and development guidance, mentoring, best practices
  • Sequential file stage to read ASCII Source file.
  • Implemented data extraction and load processes in a parallel framework
  • Created the Schema file to dynamically pass the metadata in Sequential file stage.
  • Created Shared Container to encapsulate the logic that is commonly used across the project.
  • Used Teradata Enterprise Stage to load the data in Teradata Database.
  • Created the multi-instance Generic Load Parallel Job that is called in the Job Sequence to load the data into the Teradata Database.
  • Used Column Generator Stage, Modify Stage, Aggregator Stage and Compare Stage in a job for validating.
  • Participated in the Design review of normalized and de-normalized data repositories
  • Provided the necessary details to the Testing Team for them to create their test cases for UAT.
  • Carried out unit testing, system testing and integration testing.
  • Provided the necessary support in terms of information required by the DataStage Administrator in order to solve the performance related issues.
  • Provided Standard Documentation, Best practice, Common ETL Project Templates. Fine Tune jobs/Process to higher performances & debug critical/complex job

Environment: IBM Information Server (DataStage) 8.1.2/8.1, Information Analyzer, QualityStage, Teradata V2R5, IBM DB2 9.7, PL/SQL, ERWIN 8, Win XP.

Confidential, FL

Datastage Developer

Responsibilities:

  • Involved in developing job naming standards and modifying ETL mapping document according to the requirements.
  • Developed Datastage jobs to parse the CDS dump file to create individual source files for the subsequent jobs.
  • Developed parameter driven ETL jobs and defined lookups and joins, aggregations, defined constraints and derivations to populate final tables in the target.
  • Developed delete record jobs to delete the processed records from the database based on the time comparison.
  • Created master level controlling sequencer for loading and deleting jobs using the Datastage job sequencer.
  • Involved in performance tuning of the jobs by carefully monitoring visual performance statistics and new monitor in the director.
  • Created effective test data by modifying source file and involved in unit testing and end to end testing of the design.
  • Developed the Datastage repository by importing source file schemas and the target database schemas using Datastage Manager and created new job categories in the project.
  • Extensively used Director to validate and run the jobs by specifying run time parameters and carefully analyzed job log to fix the defects.
  • Worked with Administrator client component to create project, users and to grant user rights.

Environment: Ascential Datastage v 7.5.2, Oracle 9i, Erwin 7.1, Windows XP, Solaris, Putty, SQL Plus. Batch Scripting, Shell Scripting.

Confidential, NJ

Datastage Senior Developer

Responsibilities:

  • Generate snowflake and star schema dimension modeling.
  • Created physical and logical models using Erwin.
  • Involved in the creation of mapping documents from sourceto data marts.
  • Worked closely with data warehouse architect and business intelligence analyst in developing solutions.
  • Created DataStage jobs to extract data from sequential files, flat files, MS Access and Oracle.
  • Used DataStage Manager for importing Metadata fromrepositoryand for creatingnew job categoriesanddata elements.
  • Used Parallel Extender for parallel processing of data extraction and transformation.
  • Written functions, transforms, beforejob routine and after job routines using DataStage basic.
  • UsedDataStage debuggerto troubleshoot the designed jobs.
  • Tuned DataStage transformations and jobs to enhance their performance.
  • Implementation of business rules.

Environment: Ascential DataStage 7.5.2 (Designer, Director, Manager, Administrator), Quality Stage, Oracle 9i, Sybase, DB2, UNIX Shell Scripting, PL/SQL, MS Access, Erwin, Windows NT, Metadata.

Confidential

BI Architect Developer

Responsibilities:

  • Analyze the Reporting Services project for doing reverse engineering
  • Analyze the Integration Services project for doing reverse engineering
  • Physical and Logical modeling of the snowflake schemas
  • Design of the ETL process for passing from the staging area database to the Dimensional Model
  • Used Datastage Designer for developing the different processes involving Parallel and Sequence Jobs.
  • Construction forthe Due Diligence project for version 2 of the project

Environment: SQL Server 2000, Microstrategy 8, DBVisualizer, Ascential Datastage 7

Confidential

BI Lead Developer

Responsibilities:

  • Design and Architecture of the Dashboards involved in all the projects
  • Generation of large flat files required by the client using SQL Loader
  • Developed several SQL queries that were called by batch files to load tables and generate views
  • Microstrategy Architect for creation of attributes, facts and public objects.
  • Report development on Desktop
  • Dashboard development on Web
  • I performed thedesign, modelingand construction forvarioussolutions within the MicroStrategy toolbankfordata miningand dashboardsin HTML,Flash development andalso made specificchargesforexpresscustomerrequirementsbetween projects stand, are: Cars, DragFlow,Regulatory, Segmentation,Credit Bureau, IDA Accounting, States andMunicipalities.

Environment: Oracle 8i, Microstrategy 8, DBVisualizer, HTML, Scripting, SP, Informix, SQL Server 2005SQL Server Integration Services 2005, SQL Server Analysis Services 2005, Windows XP

Confidential

Datastage Developer

Responsibilities:

  • Design the schemas involved for the Analytical Models.
  • Design and architecture of the ETL processes for all the projects in which I was involved.
  • Used Datastage Designer for developing the different processes involving Parallel, Server and Sequence Jobs.
  • Direct contact with the client for analyzing the requirements needed for the ETL processes.
  • Designand construction,was made to redesignVessel TrafficSchedule, I also made buildand testing for TaxAccount,and finallymade the design,construction and testing oftheNullityTrialandAdministrative Appealsin additionto actingas the owner ofODSfor the part ofLawproject in the SAT account getting positive feedbackfrom the userand delivertothecomprehensivetestingperformed by the user.The roleplayed was thearchitect,specifierand developerof solutions using Datastage ETL tool.

Environment: Erwin 4.1, Ascential Datastage 7,Oracle 7i, Informix XPS and IDS, DBVisualizer 4, Batch Scripting, Windows Server 2003, Soky FTP Transfer.

Confidential

BI Developer

Responsibilities:

  • Design the schemas involved for the Analytical Models.
  • Design and architecture of the ETL processes for all the projects in which I was involved.
  • Used Datastage Designer for developing the different processes involving Parallel, Server and Sequence Jobs.
  • Used SQL SSIS for developing the different processes
  • Direct contact with the client for analyzing the requirements needed for the ETL processes.
  • Microstrategy Architect for creation of attributes, facts and public objects.
  • Report development on Desktop
  • Dashboard development on Web
  • Positive results were obtainedin the twoareas involved instandardsbased oncustomer satisfactionin both theSupport CenterandProductCenter, the development of versionsof the productfor marketing IBM-INFO MART were made, obtainingaccreditation of InformationonDemand, RetailIntegration Framework.
  • Additionally,positive results were obtainedwhen opening accountswith clients such as Devlynpresentingproduct demonstrations.

Environment: Erwin, Datastage 7, Oracle 8i, Informix XPS and IDS, SQL Server 2000, DB2, TOAD, SQL Analysis Servcies 2000, SQL Integration Services 2000, DTS, Crystal Reports, Microstrategy 7.5, Windows Server 2003

We'd love your feedback!