datastage developer Archives

Helping team in fixing the issues and understanding the business need of the requirements.
Interacted with Business Analysts to get Functional requirement to build new platform for TMO on Teradata.
Implemented generic solution to read data from fixed width flat files provided by countries like Canada, USA, Mexico, Brazil etc as per their local business rules.
Created Unit and Integration Test Plan documents.
Responsible for DataStage code reviews as per ETL best practices and Company standards.
Design and develop Datastage jobs, sequencers to load the data from source to target systems.
Wrote Mload, Fastload, TPT and Bteq Scripts to load data in to Teradata database.

Interacted with Business Users and Managers in gathering business requirements.
Evaluated the current parts ODS tables and currency tables and recommended redesign to make it CCA SPODS for Global use.
Calculated the capacity requirements for this project.
Used ERWin to design the Data Model.
Used DataSatge Designer, Director and Administrator to develop Parallel, Server and Sequence Jobs as per business rules.
Created Environment variables, Job Parameters.
Created Re-Process logic for any failed jobs.

Involved in meetings with the client for requirements.
Extensively worked with datasets to handle large volumes of data.
Extensively worked with facts and Dimension tables – architecture to produce source to target mappings based upon business specs.
Created Multiple Instance Jobs for code reusability for loading data from source to SPODS.
Job design, technical reviews and troubleshooting of Data stage Jobs.
Used Partition Methods and Collecting Methods for implementing Parallelism.
Designed several jobs using Sequential file, Join, Merge, Lookup, Change Capture, Remove Duplicates, Funnel, Filter, Copy, Peek, Pivot, Aggregator, Modify, and Transformer Stages.

Involved in understanding business processes and coordinated with business analysts to get specific user requirements to build Data Marts as per ETL standards.
Worked on developing Functional design, detailed level designs and Mapping documents.
Improved the performance of the slow SQL queries by implementing proper Index.
Involved in coordinating admins to connect to different source like DB2, Oracle and SQL Server by establishing ODBC connections.
Set various DataStage environment variables and parameters in DataStage administrator and used them in managing the projects.
Created UNIX shell scripts to utilize the DataStage Parallel engine to handle large volumes of data
Developed DataStage jobs to load the data into tables using DB2 Connectors and ODBC connectors to extract data from DB2, Oracle and SQL Server tables and load into Teradata Tables.

Analyzed the source and the target systems to aid the design of the Operational Data Warehouse.
Participated in the high-level design of the ETL system and mapping of business rules.
Interact with business teams to understand requirements and propose and implement solutions.
Conducted performance analysis and optimized the ETL jobs performance.
Oversee the development of low-level design to depict the functionality of each individual system.
Developed written Technical Specifications describing details necessary to build ETL jobs based on logical and physical data models and business functional objectives.
Used Complex Flat Files (CFF) stage to extract Customer data from (CIF) Mainframe files (EBCDIC).

Designed End to End ETL Framework for EDW Extract Load jobs scheduling and logging.
Created Low Level Design documents of each Component of ETL Framework.
ETL Framework designed to control and executes Daily EDW Batch processing.
Designed Robust scheduling solution with flexibility of adding new components by adding static data in Control tables.
Provided low level inputs to team for converting technical design documents ETL mapping and workflows.
Written generic shell scripts and packages to execute EDW Batch Jobs.
Issues to avoid the potential impact for project time lines proactively.

datastage developer