We provide IT Staff Augmentation Services!

Teradata Developer Resume

VirginiA

SUMMARY

  • 9+ years of experience in IT Industry that involves Software Analysis, Design, Development, Maintenance and testing in various enterprise applications.
  • Experienced in Development and Implementation of various applications in big data environment using TERADATA, TPT, BTEQ, TDLOAD, Hive, Sqoop, Oozie, Yarn, Pig, AWS, S3, EC2 and Shell Scripts.
  • Experienced in reengineering, building and implementing big data solutions.
  • Worked on data quality check automation using big data tools.
  • Have hands on experience in Spark with Scala and aware of the concepts of Java, Python.
  • Proficient in application migration from Teradata based systems to big data environment.
  • Experienced in Development and Implementation of various applications in LINUX environment using various database like Teradata, Greenplum (PostgreSQL), SAP HANA, Netezza, ORACLE, AZURE SQL SERVER, INFORMIX.
  • Have experience in development using tools like Teradata SQL Assistant, AWS, Super Putty, Celery Flower, Node visor, SNOW, Ninja, Aginity Workbench for Netezza
  • Have experience in developing Teradata based applications using SQL Assistance, BTEQ, FASTLOAD, MULTILOAD, FASTEXPORT, TPUMP and Tera copy.
  • Have hands on experience to work in Snowflake.
  • Strong experience on Database, Query Optimizations and Performance tuning for better response.
  • Focused is in extensive coding, design, Architecture level changes, implementation, testing, and deployment of enterprise level applications
  • Have adhered to application support life cycle and ALM management process and worked on integrated tools, having experience on problem/incident and Change management process.

TECHNICAL SKILLS

Big Data: Hadoop, Hive, HDFS, Oozie, TPT, Scoop, Spark with python, Java (Basic)

Scripting Language: Unix shell scripting, C/C++, Python

Database: Teradata, Hadoop (Hive), Greenplum (PostgreSQL), SAP HANA, Azure SQL SERVER, INFORMIX, ORACLE, Netezza, Snowflake

Tools: Informatica, AWS, SNOW, BMC Remedy, Jira, Trivoli, Ninja, crontab, resource manager, Super Putty, Kerberos System, CA WA Workstation, SLACK

Teradata: SQL Assistance, BTEQ, FASTLOAD, MULTILOAD, FASTEXPORT, TPUMP, Tera copy.

Others DB tools: pgAdmin - 3, SAP HANA Studio, SQL Server 2014 Management Studio, SQL Developer Kit, Aginity for Hadoop, Aginity for Netezza.

PROFESSIONAL EXPERIENCE

Confidential, Virginia

Teradata Developer

Responsibilities:

  • Common source of all applications reducing reconciliation items between applications
  • More robust/detailed information available for business solutions
  • Provide data analytics tools for adhoc reporting capabilities
  • Increased data history availability
  • Performed design, application development and deployment within the TERADATA, BIG DATA based on programming guidelines/standards.
  • Responsible for writing and building code in Unix, Teradata, Informatica, IBM Big SQL, Hive.
  • Analysed how can we pull the data from various sources and dump according to business logic in HADOOP, HIVE, TERADATA, INFORMATICA
  • Responsible for designing Database Table structure, procedure, Functions and Query Optimizations.
  • Designed the data models in Teradata to store data from different sources which includes Confidential data best fitting the requirement need.
  • Involved in performing ETL using TPT, BTEQ, Informatica and UNIX Scripting.
  • Involved in performance optimization of the applications and long running SQL queries.
  • Experienced in performing testing, scheduling for the application to satisfy all the business cases provided.
  • Involved in data quality check to ensure the correctness of huge amount of data, data sensitivity.
  • Performed activities for knowledge transition to support teams for the applications developed.
  • Responsible for translating business requirements into systems qualities and Involved in requirement gathering, interaction with clients, managing offshore developments

Environment: Teradata SQL Assistance, BTEQ, FASTLOAD, MULTILOAD, FASTEXPORT, TPUMP, Teracopy, Hadoop, Hive, Sqoop, Oozie, Pig, TPT, TDCH, Unix, Shell Scripts, JIRA, SLACK, CA WA Workstation.

Confidential, Maryland

Developer and support Analyst

Responsibilities:

  • Current project in Confidential responsible to develop an application on IBM BIG SQL,Netezza, Beeline (hive),AWS ( s3 bucket), AWS (EC2)
  • Performed design spark-scala script to put the business logic,gpg encrypting in spark sql and load the output files to s3 container for reltio to use the data.
  • Performed design, application development and deployment with shell scripting and python programming guidelines/standards.
  • Responsible for writing and building code in Unix, python and Oracle.
  • Responsible for designing Database Table structure, procedure, Functions and Query Optimizations.
  • Involved in data quality check to ensure the correctness of huge amount of data.
  • Involved in automation process for data quality check between Oracle and Netezza data.
  • Experienced in performing testing for the application to satisfy all the business cases provided.
  • Performed activities for knowledge transition to support teams for the applications developed.
  • Responsible for translating business requirements into systems qualities and Involved in requirement gathering, interaction with clients, managing offshore developments.

Environment: Shell Scripting, Python, Oracle, Netezza, Teradata, Ninja, Node advisor.

Confidential, Bentonville AR

Developer

Responsibilities:

  • Performed design, application development and deployment within the SAP HANA, HADOOP based on programming guidelines/standards.
  • Responsible for writing and building code in Unix, Hive QL, Sqoop, Teradata, PostgreSQL, Informix.
  • Analysed how can we pull the data from various sources and dump according to business logic in HADOOP, HIVE, SAP HANA, POSTGRESQL.
  • Reengineered the same flow using Hadoop based environment.
  • Responsible for designing Database Table structure, procedure, Functions and Query Optimizations.
  • Designed the data models in SAP HANA database to store data from different sources which includes Walmart sales data best fitting the requirement need.
  • Involved in performing ETL using TPT.
  • Involved in performance optimization of the applications and long running SQL queries.
  • Experienced in performing testing for the application to satisfy all the business cases provided.
  • Involved in data quality check to ensure the correctness of huge amount of data produced by the reengineered applications.
  • Created CA7-Oozie handshake mechanism which can send back job status back to CA7 and Oozie poling mechanism to monitor the status of a job at equal interval of time.
  • Performed activities for knowledge transition to support teams for the applications developed.
  • Responsible for translating business requirements into systems qualities and Involved in requirement gathering, interaction with clients, managing offshore developments

Environment: Teradata, PostgreSQL, SQL Assistance, BTEQ, FASTLOAD, MULTILOAD, FASTEXPORT, TPUMP, Teracopy, Hadoop, Hive, Sqoop, Oozie, Pig, TPT, TDCH, Unix, Shell Scripts, Azure SQL Server, SAP HANA, Jera, Lean kit, BMC Remedy.

Confidential, Bentonville AR

Developer

Responsibilities:

  • Performed design, application development and deployment within the PostgreSQL and Teradata architecture based on programming guidelines/standards.
  • Built extensive analysis procedures for impact analysis to mitigate risk.
  • Prepared software requirement documents, test plans, high level design document, technical design document and support document.
  • Worked with DBA for the database changes to be performed without any business impact.
  • Involved in requirement gathering, effort estimation, client interaction and managing offshore developments.
  • Involved in maintenance of existing modules, incident resolution, root cause analysis, problem management and implementation using Remedy.
  • Providing/proposing optimum solutions based on the problem statement.
  • Developed Teradata solutions using SQL Assistance, BTEQ, FASTLOAD, MULTILOAD, FASTEXPORT, TPUMP and Teracopy.
  • Involved in writing SQL Queries for data quality check and query optimization for long running query.
  • Developed greenplum solution using PostgreSQL queries.
  • Worked on web services which interacted with java as front end.
  • Prepared systematic phase wise implementation plan for large applications.
  • Involved in code review, integration testing, regression testing, user acceptance testing, implementation and post production support.
  • Performed activities for knowledge transition to support teams for the applications.

Environment: TPT, Teradata, SQL Assistance, BTEQ, FASTLOAD, MULTILOAD, FASTEXPORT, TPUMP, Teracopy, PostgreSQL, BMC Remedy.

Confidential, Bentonville AR

Team Member

Responsibilities:

  • Performed design, application development and deployment within the Teradata architecture based on programming guidelines/standards.
  • Prepared software requirement documents, test plans, high level design document, technical design document and support document.
  • Worked with DBA for the database changes to be performed without any business impact.
  • Involved in requirement gathering, effort estimation, client interaction and managing offshore developments.
  • Involved in maintenance of existing modules, incident resolution, root cause analysis, problem management and implementation using Remedy.
  • Providing/proposing optimum solutions based on the problem statement.
  • Developed Teradata solutions using SQL Assistance, BTEQ, FASTLOAD, MULTILOAD, FASTEXPORT, TPUMP and Teracopy.
  • Involved in writing SQL Queries for data quality check and query optimization for long running query.
  • Worked on web services which interacted with java as front end for promotions and marketing programs.
  • Prepared result set to feed BI systems to create various dash board for the business users.
  • Worked in critical reports such as top300, email capture, PMP, dss report.
  • Prepared systematic phase wise implementation plan for large applications.
  • Involved in code review, integration testing, regression testing, user acceptance testing, implementation and post production support.
  • Performed activities for knowledge transition to support teams for the applications developed.

Environment: Teradata, SQL Assistance, BTEQ, FASTLOAD, MULTILOAD, FASTEXPORT, TPUMP, Teracopy, BMC Remedy.

Hire Now