Previous Job
Previous
Teradata Developers : 17-04416
Ref No.: 17-04416
Location: Las Vegas, Nevada
Primary Skills : ETL, Informatica, Teradata, Datastage, SQL
Duration: 6-12 months
Contract Type: W2 or C2C
 
Responsibilities:
  • Analyzed the business requirement document provided by BA, interacted with business users and BA to understand the scope of project.
  • Designed Technical Spec Document which details about the how the build work will be applied.
  • Designed flow diagrams which explain the process flow of data from source to target.
  • Coordinated with data modeling team and ETL team(Informatica) to make sure all of us are on same page as per the work to be done based upon the requirements of  project.
  • Created work tables, global temporary tables, volatile tables as part of developing the script/code.
  • Developed complex Teradata SQL code in BTEQ script using OLAP and Aggregate functions to name few.
  • Worked on Control M tool to create jobs and scheduling runtime of jobs.
  • Worked on Subversion tool to save the version of BTEQ script.
  • Performed UNIT testing and documented artifacts including unit test plans and ensured that the output is as per the given specifications.
  • Worked on `Go Live` activities as per the implementation plan and successfully deployed multiple projects into production.
  • Involved in space saving activity by implementing compression on existing production tables.
  • Responsible for cleaning databases by dropping unwanted tables such a way saved space.
  • Converted stored procedures to BTEQ scripts.
  • Worked on creating documents that explains how to work on a specific tool that were being used and also created a document that details the life cycle of the semantic work right from project initiation till the deployment such a way I was able to help the team to keep it as a reference.
  • Involved in migration projects to migrate data from old data model to enhanced version of data model on Teradata.
  • Used Fast Load (FLOAD), Multi Load (MLOAD), FastExport utilities to load/export data.
  • Performance tuned and optimized various complex SQL queries.
  • Used MS Access to browse data that’s existing on staging area i.e. on SQL Server.
  • Worked in a test driven development mode by using DBFit (Fitnesse tool) for QA.
  • Used Jenkins for job scheduling.
  • Involved in production support activities such as monitoring the scheduled job runs, troubleshooting production issues, escalating to dev team through a ticketing system etc.
 Required Skills :
  • 10+ years of extensive IT experience in the areas of Data Warehousing technology and Data Integration Support Systems using IBM Information Server 7.x/8.x/11.3 IBM DataStage with various clients in several business domain such as Insurance, Telecom, Airlines, Retail, Railroad & Health Care.
  • Strong experience in developing strategies for Extraction, Transformation and Loading from various data sources like Legacy Systems, Oracle, SQL Server, DB2 databases and Flat files systems into Data warehouse and Data Marts by using IBM Data Stage.
  • Extensive experience in the areas of analysis, design, development, testing and Implementation of ETL & Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, BI, UNIX & OLAP.
  • Rich experience in Requirement gathering, Requirement  analysis, Development, Coding, System Testing, Integration Testing, Unit Testing ,Validation ,Defect analysis, bug fixing, documentation and suggested process improvement.
  • Extensively worked on Data Stage job design, development, scheduling, execution, testing and defect fixing.
  • Extensive experience in RDBMS technologies like Oracle, DB2 Informix, Teradata and Vertica
  • Involved in very large scale data migration solution and Data Analysis, Data mapping, Data Quality and integration of disparate source systems.
  • Expertise in Designing Parallel jobs using various stages and extensively worked on Job Sequences to control the execution of jobs flow using various activities.
  • Involved in creating the logical and physical design of the Data Warehouse (Fact and Dimension tables) using Star Schema and Snow Flake schema approach
 
Please apply directly with your updated resume or call Subhajit/Aman at: 408-512-2364 or 408-907-3219