We provide IT Staff Augmentation Services!

Technical Consultant/datastage Designer Resume

SUMMARY

  • Having 11 years of experience in IT industry with strong focus on developing ETL applications of which around 10 years of relevant experience in Business Intelligence/Data warehousing projects.
  • Hands on experience in datwarehousing tool like IBM Infosphere 11.3/11.5 (Data Stage Designer, Data Stage Manager and Data Stage Director). I have strong design fundamentals with expertise in developing ETL applications using Datastage Enterprise Edition.
  • Expertise in Data Warehouse concepts like dimensional modeling, star schema, snowflake schema, ETL, serial and parallel processes.
  • Experienced in issuing Technical design documents in line with business analysis documents, System Testing, Implementation methodologies. Extensive experience with Data Extraction, Transformation, and Loading from disparate data sources into a common reporting and analytical Data Model using Datastage.
  • Expertise in performance and tuning of Datastage mappings and sessions for better performance and moving the objects from development to production environment.
  • 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.
  • Involved in tuning of the DataStage jobs for optimal performance, and performance tuning of oracle queries.
  • Experience in UNIX shell scripting and SQL Coding.
  • Excellent knowledge in creating and managing Conceptual, Logical and Physical Data Models.
  • Experienced in troubleshooting DataStage jobs, fixing bugs and addressing production issues like performance tuning and enhancements.
  • Highly involved in developing of DataStage parallel jobs. Proficient in data warehousing techniques for data cleansing, dealing with slowly changing dimensions and Surrogate keys.
  • Extensively worked on Hierarchal stage to parse or compose the XML/Json file from/to IGC.
  • Used CURL commands to export and import the data from IGC. Extensively worked in REST - API to upload the metadata & lineage to IGC.
  • Used information analyzer for columns analysis, primary key analysis, foreign key analysis and cross-domain analysis.
  • Participated in an Agile/Scrum methodology to deliver high-quality software releases on periodic basis through sprints.
  • Good in communicating at all levels of management with experience in coordinating various client meetings, seminars, presentations and group discussions.
  • Ability to work in-groups as well as independently with minimum supervision and initiative to learn new technologies and tools quickly.
  • Created JIL files for Datastage jobs entry in Autosys.
  • Entry level experience in Big-Data and Hadoop.

TECHNICAL SKILLS

ETL Tools: IBM Infosphere DataStage 11.3, IBM Infosphere DataStage 11.3 (Parallel & Server), INFOSPHERE Information Governance Catalog, Information Analyzer and Quality Stage.

Database: Oracle 10g/11g, IBM DB2/UDB, Teradata, SQL Server 2003/2005/2008.

Data Warehousing: Star & Snow-Flake Schema Modeling, Fact and Dimensions, Physical and Logical Data Modeling, Erwin

Operating systems: AIX UNIX, LINUX, Windows 7x/NT/XP, MS-DOS, MS Access

Scheduling tools: Autosys, control-M

PROFESSIONAL EXPERIENCE

Confidential

Technical Consultant/Datastage Designer

Responsibilities:

  • Identified business needs, evaluated business and technical alternatives, recommended solutions and participated in their implementation.
  • I am responsible for preparing design documents, which includes Physical data model and business mapping spec.
  • Designed Logical and Physical data model using TOAD modeler.
  • Worked SCDs to populate Type I and Type II slowly changing dimension tables from several operational source files.
  • Generation of Surrogate Keys for the dimensions and fact tables for indexing and faster access of data in Data Warehouse.
  • Generated DDL’s using TOAD Modeler.
  • Extensively worked on Job Sequences to Control the Execution of the job flow using various Activities & Triggers (Conditional and Unconditional) like Job Activity, Wait for file, Email Notification, Sequencer, Exception handler activity and Execute Command.
  • Designed data modeling using TOAD modeler.
  • Also, responsible for coding ETL jobs and perform unit testing (Importing and exporting the data from IGC using RESTAPI and Unix Curl Command).
  • Created JSON SCHEMA file using RESTAPI and uploaded to library in Hierarchal stage.
  • Extensively worked on Hierarchal stage to parse/compose XML/Json files.
  • Automated UNIX shell scripts to pull all the types from IGC.
  • Created new custom assets in IGC and uploaded metadata and lineage data.
  • Written SQL queries to extract the data from different sources. Worked on SQL database tuning activities.
  • Created JIL files for Datastage jobs entry in Autosys.
  • Prepared Unit Test case document for all the TYPE2 scenarios.
  • Participated in all Agile ceremonies.
  • Created tasks in RTC and picked up the tasks on priority basis and raised the impediments if there is any.
  • Created IT checkout documents in UAT and performed sanity check.

Confidential

Technical Consultant/Datastage Designer

Responsibilities:

  • Extensively used DataStage for extracting, transforming and loading databases from sources including Oracle, DB2 and Flat files.
  • Collaborated with EDW team in, High Level design documents for extract, transform, validate and load ETL process data dictionaries, Metadata descriptions, file layouts and flow diagrams.
  • Collaborated with EDW team in, Low Level design document for mapping the files from source to target and implementing business logic.
  • Closely work with the business parties with matching the architecture standard and business strategic scope.
  • Generation of Surrogate Keys for the dimensions and fact tables for indexing and faster access of data in Data Warehouse.
  • Tuned transformations and jobs for Performance Enhancement.
  • Extracted data from flat files and then transformed according to the requirement and Loaded into target tables using various stages like sequential file, Look up, Aggregator, Transformer, Join, Remove Duplicates, Change capture data, Sort, Column generators, Funnel and Oracle Enterprise.
  • Extensively used DataStage Change Data Capture for DB2 and Oracle files and employed change capture stage in parallel jobs.
  • Collaborated in design testing using HP Quality Center.
  • Extensively worked on Job Sequences to Control the Execution of the job flow using various Activities & Triggers (Conditional and Unconditional) like Job Activity, Wait for file, Email Notification, Sequencer, Exception handler activity and Execute Command.
  • Collaborated with BO teams in designing dashboards and scorecards for Analysis and Tracking of key business metrics and goals.
  • Utilized Parallelism through different partition methods to optimize performance in a large database environment.
  • Developed DS jobs to populate the data into staging and Data Mart.
  • Executed jobs through sequencer for better performance and easy maintenance.
  • Performed the Unit testing for jobs developed to ensure that it meets the requirements.
  • Developed UNIX shell scripts to automate file manipulation and data loading procedures.
  • Scheduled the jobs using AutoSys.
  • Responsible for daily verification that all scripts, downloads, and file copies were executed as planned, troubleshooting any steps that failed, and providing both immediate and long-term problem resolution.
  • Provided technical assistance and support to IT analysts and business community.
  • As a Lead, I am responsible for managing a small team of analysts, developers, testers or engineers and drive delivery of a small module within a project (Delivery/Maintenance/Testing).
  • Prepare IT checkout documents in higher environments.
  • Attending the client meeting on regular basis.

Confidential

Technical Consultant

Responsibilities:

  • Gathered technical and functional information for all NON-SAP applications as part of Due-Diligence Worked on Application Scope metrics
  • Created SMTD document for all the applications.
  • Attended workshops and provided secondary support.
  • Responsible of creating Requirement specification document Created HLD and LLD Documents.
  • Managed the implementation activities on time
  • Provided statistical analysis to the clients
  • Works on Improvement areas and provided the POC to the customers

Hire Now