We provide IT Staff Augmentation Services!

Data Modeler, Datastage Developer Resume

CAREER OBJECTIVE:

To excel in the professional career as a good Software professional with constant learning, contributing and growing along with the organization.

SUMMARY:

  • 8 years of working experience
  • Thorough knowledge and work experience in Telecom domain
  • Data Modeler experience with strong Conceptual and Logical Data Modeling skills, creating data mapping documents, writing functional specifications and complex SQL queries.
  • Experience in Dimensional Data modeling for creating Logical and Physical Design of Database and ER Diagrams using data modeling tool ERWIN.
  • Extensive experience in writing functional specifications, translating business requirements to technical specifications
  • Onsite experience at client site - Telstra, Australia
  • Experience in analyzing the business requirements and performing pre-feasibility analysis and initial analysis.
  • Proficient in Development, Implementation and Support of ETL processes for Large-scale Data warehouses using Datastage and Teradata.
  • Extensive knowledge in all areas of Project Life Cycle including requirements analysis, system analysis, design, development, documentation, implementation and maintenance.
  • Effective communications/presentation skills for technical and non-technical audiences.

PROFESSIONAL SKILLS:

  • 8 years of extensive experience in Telecom Domain
  • 7+ Years of experience in Data Modelling
  • 6+ Years of experience in Teradata
  • 3+ Years of experience in Datastage
  • Trained in R
  • Trained in Hadoop technologies (Hive and Pig)

PROFESSIONAL EXPERIENCE:

Confidential

Data Modeler, Datastage Developer

Responsibilities:

  • Involved in the PDM and LDM team as a Data Modeler.
  • Involved in discussions with business stakeholders to understand their requirement.
  • Responsible for analyzing business requirements and performing pre-feasibility analysis and impact analysis for a future change request.
  • Involved in designing logical data model based on analysis of the requirement and feasibility analysis
  • Design the physical data model based on logical data model, query performance and source data size.
  • Design and create new tables and views based on requirements provided.
  • Analyze and profile the source data flowing into these tables for making the design decisions.
  • Design the ETL specifications sheet based on the rules in the data model.
  • Analyze root cause and data loaded in the data warehouse, and provide solution to issues with the data loaded/to-be loaded
  • Involved as a Datastage developer
  • Create/modify jobs as per the requirements for critical interfaces.
  • Create/modify Mload and Bteqs to help load data as per ETL specifications.

Confidential

Data Modeler

Responsibilities:

  • Involved in the design team as a Data Modeler
  • Discuss with all stakeholders and business analyst to understand existing process
  • Design conceptual and logical data models based on the requirement
  • Design and create tables and/or views in the physical data model by analyzing different access and join criteria.
  • Analyze and profile the source data flowing into these tables for making the design decisions.
  • Design the ETL specifications sheet based on the rules in the data model.
  • Reviewing of physical data model design deliverables and ETL specifications sheet.
  • Analyze root cause and data loaded in the data warehouse, and provide solution to issues with the data loaded/to-be loaded

Confidential

Data Modeler and Business Analyst

Responsibilities:

  • Involved in the team as a Data Modeler and also a business analyst
  • Involved in analyzing existing mapping documents and recreating them for new Hadoop platform
  • Comparing existing datatypes and finding the appropriate datatypes in Hive
  • Analyze loaded data and identify the root causes of issues if any

Confidential

Data Modeler

Responsibilities:

  • Involved in the PDM team as a Data Modeler
  • Design enhancements in the physical data model based on logical data model
  • Design and create tables and/or views in the physical data model by analyzing different access and join criteria.
  • Analyze and profile the source data flowing into these tables for making the design decisions.
  • Design the ETL specifications sheet based on the rules in the data model.
  • Reviewing of physical data model design deliverables and ETL specifications sheet.
  • Analyze root cause and data loaded in the data warehouse, and provide solution to issues with the data loaded/to-be loaded
  • Involved as a Datastage developer
  • Create/modify jobs as per the requirements specified in ETL specifications sheet.
  • Troubleshoot these jobs in case of any issues like jobs failing, or loading wrong data etc.

Hire Now