Previous Job
Previous
Teradata Developer
Ref No.: 17-02855
Location: Charlotte, North Carolina
Job Description:
Teradata Developer - Charlotte, NC
  • Analyse business requirement and data mapping for new enhancements and new project requirements of Large Corporate Syndicate Credit (LCSC).
  • Identify any gaps in data mapping and Business Requirement Document and review with business team and close the gaps
  • Create Functional Specification Document (FSD), Review the FSD with technology team and business team. Incorporate feedback and route the FSD for Project Management Office (PMO) approval
  • Develop the overall technical approach to design the solution and review with the team to identify any risk
  • Assist in developing the logical and physical data model. Review the data model and revise based on the feedback from the team
  • Develop the Teradata Tables, Stored Procedures, ETL Views, Functions and Triggers using the Teradata SQL Assistant. Develop data load programs using the MLoad and TPump utilities of teradata
  • Develop the Autosys jobs using the scheduling tool to schedule the batch process
  • Create unix scripts to execute the batch process and test using the autosys jobs
  • Perform Unit Testing of the developed code and batch process
  • Create the Deployment and backout gameplan for code deployment to the higher environments like SIT (System Integration Testing), UAT (User Acceptance Testing) and Production environments
  • Maintain the code base using the configuration tool TFS for deployments and code versioning.
  • Prepare the test plan and test case documents for testing the code and functionality
  • Deploy the code into SIT/UAT environment and support SIT/UAT testing. Capture any defects raised into the defect log, Fix the issue, re-test and deploy
  • Working with Business Analyst team to support UAT testing and obtain sign off.
  • Create Client 2000 change request to deploy the code into production environment
  • Support production deployments, validate the code deployments, work with operation team to kick off the autosys job and validate the data
  • Participate in the daily touch point meetings, set up review meetings, prepare status updates on periodic basis