Post Project
  • Search
    • Buyers can
    • Search offers to buy now
    • Search freelancers to request a proposal
    • Freelancers can
    • Search projects to quote on
  • How it works
  • Log in
  • Sign up
  • Freelancer?
Browse by Category
    Technology & ProgrammingWriting & TranslationDesignDigital MarketingVideo, Photo & ImageBusinessMusic & AudioMarketing, Branding & SalesSocial Media
    Amit Singh

    Amit Singh

    DATAWAREHOUSE EXPERT and DATASTAGE certified

    Kolkata, India

    Extensively involved in the development of Datastage ETL process for extracting data from different data sources, data transformation and loading the data into data warehouse from...Read moreExtensively involved in the development of Datastage ETL process for extracting data from different data sources, data transformation and loading the data into data warehouse from data mart operations.
    Extensively worked on Datastage 7.5.1/7.5.2/7.0/8.0
    Excellent knowledge and experience in Data Warehouse development life cycle, dimensional modeling, repository management and administration, implementation of Star, Snowflake schemas and slowly changing dimensions.
    Expertise in designing Parallel and server jobs jobs using various stages like HASH,LINK COLLECTOR ,SORT,LINK PARTITIONER,ROW SPLITTER,DB2 STAGE ,TERADATA FAST LAOD,TERADATA API, AggregatorExpertise in
    Ascential Data Stage EE/Parallel Extender as an ETL to extract data from sources like DB2, XML and flat files and loaded to target tables.
    Demonstrated strong technical writing skills, Proven ability to quickly learn new technologies
    Experience in Data Modeling and involved in creation of Star Schema and Snowflake dimensional data marts.
    Experience in writing, testing and implementation of the triggers, Procedures, functions Database level.
    Extensive experience in Best Practice of Data Stage.
    Experience in Client/Server Technology and RDBMS.
    Used built in transforms, created custom transforms and Table Definitions in Datastage Manager.
    Strong Knowledge in Software Development Lifecycle
    Effective in cross-functional and global environments to manage multiple tasks and assignments concurrently with effective communication skills.
    Experience in design and implementation of Server and Parallel jobs including Batches and Job Sequencers.
    Excellent Communication and Interpersonal skills .Versatile team player with proven problem solving skills.
    Have conducted Datastage training for IBM internal resources


    Extensively involved in the development of Datastage ETL process for extracting data from different data sources, data transformation and loading the data into data warehouse from data mart operations.
    Extensively worked on Datastage 7.5.1/7.5.2/7.0/8.0
    Excellent knowledge and experience in Data Warehouse development life cycle, dimensional modeling, repository management and administration, implementation of Star, Snowflake schemas and slowly changing dimensions.
    Expertise in designing Parallel and server jobs jobs using various stages like HASH,LINK COLLECTOR ,SORT,LINK PARTITIONER,ROW SPLITTER,DB2 STAGE ,TERADATA FAST LAOD,TERADATA API, AggregatorExpertise in
    Ascential Data Stage EE/Parallel Extender as an ETL to extract data from sources like DB2, XML and flat files and loaded to target tables.
    Demonstrated strong technical writing skills, Proven ability to quickly learn new technologies
    Experience in Data Modeling and involved in creation of Star Schema and Snowflake dimensional data marts.
    Experience in writing, testing and implementation of the triggers, Procedures, functions Database level.
    Extensive experience in Best Practice of Data Stage.
    Experience in Client/Server Technology and RDBMS.
    Used built in transforms, created custom transforms and Table Definitions in Datastage Manager.
    Strong Knowledge in Software Development Lifecycle
    Effective in cross-functional and global environments to manage multiple tasks and assignments concurrently with effective communication skills.
    Experience in design and implementation of Server and Parallel jobs including Batches and Job Sequencers.
    Excellent Communication and Interpersonal skills .Versatile team player with proven problem solving skills.
    Have conducted Datastage training for MNC internal resources


    Area Covered: anywhere
    Work Experience Summary: Project Experience
    Client:AP Moller Maersk Group,
    Charlotte, North Carolina
    March 2010 - Present
    Role: Data stage Developer,Datastage Administrator
    Ap Moller Maersk is a Shipping company which is used to maintain data warehouse of all the container shipment and related activities. Our client developed a package that supports server application which runs on 4 nodes. Data governance team used the package to maintain the complete historical data of the enterprise to do analysis and reporting.
    Maersk Line is one of the leading liner shipping companies in the world, serving customers all over the globe. Maersk has activities in a variety of business sectors, primarily within the transportation and energy sectors. It is the largest container ship operator and supply vessel operator in the world. Maersk is based in Copenhagen, Denmark, with subsidiaries and offices in more than 135 countries worldwide and around 120,000 employees. It ranked 106 on the Fortune Global 500 list for 2009.
    Responsibilities:
    • Extensively used Ascential DataStage Manager, Designer, and Director for creating and implementing jobs.
    • Migrated jobs from DB2 to Teradata and Oracle to Teradata.
    • Worked with Onshore/Offshore Development Teams to resolve DataStage performance tuning and Job abort issues.
    • Developed various jobs using stages Sequential files, Sort, Link Collector, DB2 UDB API, Oracle OCI and Teradata
    • Involved in Extracting, transforming, loading and testing data from DB2, Oracle OCI and Teradata API using Datastage
    • Creating and setting up Data Stage Projects in Dev, Test and Prod Environments.
    • Migration of jobs from Development to Test Environment using DataStage Manager.
    • Created, optimized, and Executed Teradata SQL test queries to validate in target mappings/source views, and to verify data in target tables
    • Analyzed existing SQL and Datastage jobs for better performance
    • Importing Table definitions and Metadata using DataStage Manager.
    • Created user defined environmental variables using DataStage Administrator.
    • Involved in Administration and support of ETL Platform.
    • Scheduling DataStage jobs in DataStage Director and cron.
    • Monitoring DataStage Jobs and clearing the salves of the job which are created while developing jobs and unlocking jobs from Datastge Administrator and Linux
    • Developed Shell scripts for running Datastage Jobs.
    • Performed Unit testing for jobs developed to ensure that it meets the requirements.
    Technology: IBM Websphere Information Server V7.5.2, DB2, Oracle11g, Aqua data studio, Teradata V2R6, Cron, UNIX, Linux, Windows 2003.

    Title: Larsen and Toubro
    Client: a leading Engineering company
    Duration: may 2008 • aug 2009
    Description: enterprise datawarehouse receive data from various sources such as BAAN,SAP.Data is then loaded to different table through SSIS.Once table is loaded report is generated fetching values from different table.

    Role: datawarehouse architecture,data model designer using Erwin.

    Responsibilities:


     Designed SSIS jobs using mysql2005
     Extract, cleanse, transform, integrate, and load data into the data mart using SSIS

     Used MYSQL 2005 to schedule, run, and monitor the SSIS jobs.
     involved in Developing ETL jobs using SSIS supporting all facets of the ETL process such as implementing Source to target mapping.
     Heterogeneous Sources are Oracle, DB2, Informix and Teradata,BAAN
     Developed ETL jobs in SSIS using different stages
     Fine-tuned SSIS jobs for optimal performance.
     Involved in unit, integration and regression testing of ssis jobs.
     Involved in the Production Support of ssis jobs Break fixing of pl/sql Scripts.
     Production support to report generated in cognos

    Technology: SSIS,SSAS ,oracle,BAAN






    Title: FREESCALE
    Client: a leading semiconductor company
    Duration: May 2008 • Dec 2008
    Description: enterprise datawarehouse receive data from various sources such as Legacy,SAP.Data is then loaded to different table through Datastage job.Once table is loaded report is generated fetching values from different table.We use third party MAESTRO to schedule our job.

    Role: OPS(operational production support) Team Member ,Developer

    Responsibilities:


     Designed server jobs using datastage designer
     Extract, cleanse, transform, integrate, and load data into the data mart using DataStage Designer
     Used DataStage Manager for importing & creating metadata definitions from repository, view and edit the contents of the repository.
     Used DataStage Director to schedule, run, and monitor the datastage jobs.
     nvolved in Developing ETL jobs using Data stage Parallel Extender, supporting all facets of the ETL process such as implementing Source to target mapping.
     Heterogeneous Sources are Oracle, DB2, Informix and Teradata.
     Developed ETL jobs in Parallel Extender environment using different stages like Oracle Enterprise, Dataset, Transformer, Funnel, Filter, join, lookup, peak etc.
     Used Datastage sequencer jobs extensively to control datastage jobs.
     Extensively tested datastage jobs for data integrity.
     Fine-tuned datastage jobs for optimal performance.
     Involved in unit, integration and regression testing of datastage jobs.
     Involved in the Production Support of ETL jobs Break fixing of UNIX Scripts/Data stage Jobs by monitoring in the Datastage Director.
     Production support to report generated in Hyperion 9.3.1

    Technology: IBM DataStage 8.0 , teradata,Oracle



    Title: Material Master Creation
    Client: Centralised Material Department

    Duration: October 2007 • April 2008

    Description: Creating a centralized master from multiple copies spread across multiple channels, divisions, disparate applications on heterogeneous technology environment, geographies & lines of business. These services include the aggregation, organization and cleansing of data. These data cleansing/scrubbing and enrichment services can ensure that your databases-part and material files, product catalog files and item information etc.-are current, accurate and complete. The Scope of project was to:-

    • Identify duplicate codes of all kinds such as ERP Codes, item/Vendor Codes with the help of de-duplication algorithm.
    • Develop a module to collect and consolidate data from various units of CMD.
    • Develop a module to compare the consolidate data with the recommended data and provide a report of differences.
    • Identify unused or dead ERP Codes that are not used by current ERP application.
    • Identify duplicate item names, vendor names.

    Team Size: 4
    Role: ETL Developer

    Responsibilities:




    o Interacted with end users and other resources in understanding the requirements
    o Created mappings using informatica designer to load the data from various sources using different transformations.
    o Developed task and workflows using informatica workflows managers and monitor transformation processing using workflows monitor
    o Developed tasks and workflows using informatica workflow managers and monitor transformation processing using workflow monitor.
    o Performed the Tasks of Validating, and Scheduling the sessions and batches.
    o Organized sessions in batch to run the sessions in a batch in sequential order or start them concurrently by the server.
    o Done performance tuning in Informatica
    o Done Error Handling and debugging using Informatica debugger.


    Technology: Informatica 7.2 , Oracle 9i

    Education Summary: • B.Tech in Information Technology From West Bengal university Of technology

    • £7
      /hr
    Contact

    Skills

    data warehousing

    Insights

    Freelancer Buyer
    Projects listed
    0
    Freelancers worked with
    0
    Last active
    May 01 2011
    Response time
    instantly

    Insights

    Freelancer Buyer
    Projects worked on
    0
    Buyers worked with
    0
    Last active
    May 01 2011
    Response time
    instantly

    Skills

    data warehousing

    Insights

    Freelancer Buyer
    Projects listed
    0
    Freelancers worked with
    0
    Last active
    May 01 2011
    Response time
    instantly

    Insights

    Freelancer Buyer
    Projects worked on
    0
    Buyers worked with
    0
    Last active
    May 01 2011
    Response time
    instantly
    Skills Insights

    Insights

    Freelancer Buyer
    Projects listed
    0
    Freelancers worked with
    0
    Last active
    May 01 2011
    Response time
    instantly

    Insights

    Freelancer Buyer
    Projects worked on
    0
    Buyers worked with
    0
    Last active
    May 01 2011
    Response time
    instantly
    Skills Insights
    data warehousing
    • Reviews
    • Purchases
    • Endorsements
    Hide feedback
    The user has no activity as a Freelancer

    Product

    • About
    • Team
    • Careers

    Support

    • How it works
    • Trust & Safety
    • Help Centre

    Discover

    • GuidesStoriesNews

    Resources

    • Customer Stories
    • Business Cost Calculator
    • Startup Cities

    Browse

    • Freelance Services
    • Freelance Services By Country
    • Freelance Skills
    • Terms
    • Privacy
    • Sitemap
    • Company Details
    • © 2023 People Per Hour Ltd
    We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
    Cookie Settings
    Accept All Cookies