We provide IT Staff Augmentation Services!

Sr. Teradata Developer Resume

3.00/5 (Submit Your Rating)

Dublin, CA

SUMMARY

  • Around 8 years of IT experience in Data warehousing with emphasis on Business Requirements Analysis, Application Design, Development, coding, testing, implementation and maintenance of client/server Data Warehouse and Data Mart systems.
  • Developed UNIX shell scripts and used BTEQ, Fast Load, Multiload, Tpump, TPT, Data Mover and Fast Export utilities extensively to load to target database.
  • Excellent understanding in depth knowledge of Hadoop architecture and various components such as HDFS, Map Reduce programming and other Ecosystem components.
  • Understanding of Teradata MPP architecture such as Shared Nothing, Nodes, AMPs, BYNET, Partitioning, Primary Indexes etc.
  • Created several BTEQ scripts involving derived tables and volatile/Global temporary tables for ad hoc purpose to extract data for several business users on scheduled basis.
  • Strong knowledge on Teradata indexes like UPI, NUPI, SI, NUSI, PPI.
  • Extensive experience on Teradata SQL, BTEQ, MLOAD, Fast Load, Fast Export scripts.
  • In Depth understanding and usage of TERADATA OLAP functions. Proficient in TERADATA SQL, Stored Procedures, Macros, Views, Indexes (Primary, Secondary, PPI, Join indexes etc.)
  • Expertise in physical modeling with knowledge to use Primary, Secondary, PPI and join Index.
  • Experienced in troubleshooting Teradata scripts, fixing bugs and addressing production issues and performance tuning.
  • Expertise in querying and testing RDBMS such as Oracle, MS SQL Server using SQL for data integrity.
  • Experience in coding Teradata SQL, Stored Procedures, Macros and Triggers. Strong experience in tuning complex SQL queries including joins, correlated sub queries and scalar sub queries.
  • Experience in SQL Server 2000/2005/2008 , SQL, T - SQL, Stored Procedures, Triggers, DTS, SSIS packages, and Oracle 9i/10g, PL/SQL, SQL Plus, Oracle Developer 2000 Forms and Reports.
  • Worked on Data Warehouse design, implementation and support (Oracle, SQL server, MySQL).
  • Strong Experience in CSDC Amanda Folder configurations and of Permits, Professional Licenses using SQL Server and Oracle as databases.
  • Extensive experience in creating database objects such as Tables, Constraints, Indexes, Views, Indexed Views, Stored Procedures, UDFs and Triggers on Microsoft SQL Server
  • Worked on Control-M tool to create jobs and scheduling runtime of jobs.
  • Worked in Data Warehouse and Business Intelligence Projects along with the team of Informatica (ETL).
  • Experienced on major Hadoop ecosystem projects such as PIG, HIVE, SQOOP and HBASE.
  • Experience in Design and Development of ETL methodology for supporting Data Migration, data transformations & processing in a corporate wide ETL Solution using Teradata TD 14.0/13.0/12.0.
  • Worked extensively with Dimensional modeling, Data migration, Data cleansing, ETL Processes for data warehouses.
  • Experience in scheduling Sequence and parallel jobs using Data Stage Director, UNIX scripts and scheduling tools.
  • Expertise in OLTP/OLAP System Study, Analysis and E-R modeling, developing Database Schemas like Star schema and Snowflake schema (Fact Tables, Dimension Tables) used in relational, dimensional and multidimensional modeling.
  • Experience in UNIX shell scripting for processing large volumes of data from varied sources and loading into databases like Teradata and Vertica.
  • Hands on experience in debugging and performance tuning of sources, targets, mappings and sessions.
  • Experience in integration of various data sources definitions like SQL Server, Oracle, Teradata SQL Assistant, MYSQL, Flat Files, XML.
  • Involvement in all phases of SDLC (Systems Development Life Cycle) from analysis and planning to development and deployment.
  • Good understanding of Software Development Life Cycle including the Waterfall and Agile methodology.
  • Working experience with scheduling tools like Mainframe Zeke, Control M Scheduler
  • Writing Unix Shell Scripts as part of the project.
  • Having working Knowledge on Unix / Linux & SQL .
  • Extensive knowledge on Relational Database Management Systems.
  • Giving knowledge transition within the organization.
  • Involved in POC and a member of Teradata CoE .
  • Share good insights on Teradata and DMExpress to team members.
  • Desire to learn new skills, technologies, and adapt to new information demands.

TECHNICAL SKILLS

Tools: SQL Assistant, BTEQ Load & Export, FastLoad, MultiLoad, TPump, TPT, Fast Export, DataMover.

Programming Languages: Java, Scala, SQL, PL/SQL, Linux shell scripts.

Big data/Hadoop Ecosystem: HDFS, Map Reduce, HIVE, PIG, HBase, Sqoop, Flume, Oozie, Spark, Kafka, Impala.

Scheduling Tools: Autosys, Control-M, One Automation

NoSQL Databases: MongoDB, Cassandra, HBase

Database: Oracle 11g/10g, DB2, MS-SQL Server, MySQL, Teradata.

Operating System: UNIX, Windows, Mac OS, Red Hat

Methodologies: Agile/Scrum, Rational Unified Process and Waterfall

PROFESSIONAL EXPERIENCE

Confidential, Dublin, CA

Sr. Teradata Developer

Responsibilities:

  • Involved in understanding the Requirements of the End Users/Business Analysts and Developed Strategies for ETL processes.
  • Performed analysis of complex business issues and provided recommendations for possible solutions. Writing SQL queries, reports, and used systems to do analysis based on data metrics and facts to provide recommendations.
  • Used Informatica as ETL tool to pull data from source systems/ files, cleanse, transform and load data into the Teradata using Teradata Utilities.
  • Extracted data from different sources like Flat files ("pipe" delimited or fixed length), excel spreadsheets and Databases.
  • Used Teradata utilities BTEQ, FAST LOAD, MULTI LOAD, TPUMP to load data.
  • Wrote, tested and implemented Teradata Fast load, Multiload and BTEQ scripts, DML and DDL.
  • Managed all development and support efforts for the Data Integration/Data Warehouse team.
  • Wrote Teradata Macros and used various Teradata analytic functions.
  • Involved in migration projects to migrate data from data warehouses on Oracle/DB2 and migrated those to Teradata.
  • Performance tuned and optimized various complex SQL queries.
  • Used BTEQ and SQL Assistant (Query man) front-end tools to issue SQL commands matching the business requirements to Teradata RDBMS.
  • Developed slowly changed dimensions (SCD) Type 2 for loading data into Dimensions and Fact.
  • Provided on call support during the release of the product to low level to high level Production environment.
  • Used Agile methodology for repeated testing.
  • Worked with Control M tool for jobs scheduling.
  • Involved in Unit testing, User Acceptance testing to check whether the data is loading into target, which was extracted from different source systems according to the user requirements.
  • Prepared BTEQ import, export scripts for tables.
  • Written BTEQ, FAST LOAD, MLOAD scripts.

Environment: Teradata R12/R13, Teradata SQL Assistant, SQL, VSS, Putty, MLOAD, TPUMP, FAST LOAD, FAST EXPORT, TDWM, PMON, Informatica Power Center 9.5.1, Informatica BDM, Teradata 14, SQL Assistant, MYSQL, Oracle, Unix, oracle 11/g, TPT, FTP.

Confidential, Owings Mills, MD

ETL/Teradata Developer

Responsibilities:

  • Involved in Complete Software Development Lifecycle Experience (SDLC) from Business Analysis to Development, Testing, Deployment and Documentation.
  • Used Informatica as ETL tool to pull data from source systems/ files, cleanse, transform and load data into the Teradata using Teradata Utilities.
  • Involved in Requirement analysis in support of Data Warehousing efforts along with Business Analyst and working with the QA Team in Waterfall methodology.
  • Loaded data in to the Teradata tables using Teradata Utilities BTEQ, Fast Load, Multiload, and Fast Export and TPT.
  • Extensively worked in the performance tuning of Teradata SQL, ETL and other processes to optimize session performance.
  • Used Teradata utilities fastload, multiload, tpump to load data.
  • Wrote BTEQ scripts to transform data and Wrote Fastexport scripts to export data.
  • Wrote, tested and implemented Teradata Fastload, Multiload and Bteq scripts, DML and DDL.
  • Constructed Korn shell driver routines (write, test and implement UNIX scripts)
  • Wrote views based on user and/or reporting requirements.
  • Wrote Teradata Macros and used various Teradata analytic functions.
  • Involved in migration projects to migrate data from data warehouses on Oracle/DB2 and migrated those to Teradata.
  • Performance tuned and optimized various complex SQL queries.
  • Wrote many UNIX scripts.
  • Gathered system design requirements, design and write system specifications.
  • Agile team interaction.
  • Coordinated with the business analysts and developers to discuss issues in interpreting the requirements

Environment: Oracle, Teradata, Teradata SQL Assistant, SQL, VSS, Outlook, Putty, MLOAD, TPUMP, FAST LOAD, FAST EXPORT, 10.1/9.6.1/9.5.1 , Oracle 11g, DB2, Teradata 15/14, Flat Files, SQL Assistant, TOAD, UNIX, Windows.

Confidential, Boston MA

PL/SQL Developer

Platform: Amanda 6.1.6, Oracle 12c, PL/SQL, Apache Tomcat 7.x/8.x

Responsibilities:

  • Analyze the requirements from functional specification document and use the document as the basis for software development and unit testing. Report back to the Business Analyst and Subject Matter Expert in case of any contradictions or deviations in the document.
  • Participate in discussions and analysis of requirements (including fit-gap), from the functional specification document and provide inputs for design and development of software programs.
  • Prepare Technical Design document based on the functional specifications document.
  • Identify key data or components that fit within the business system/process and document the gaps that need solutions.
  • Participate in peer-reviews, including, but not limited to design and development (coding).
  • Understand the database structure/schema of Legacy and Target DBs and write Scripts to Extract, as well as Transform and Load the data from Legacy database to new systems.
  • Involved in creating various Database Objects - Tables, Indexes, Store Procedure, Trigger, Views and functions. Improved Performance by creating Clustered and Non-Clustered Indexes and by optimizing the T-SQL statements using SQL profiler.
  • Program using T-SQL in SQL Server, PL/SQL in Oracle, Microsoft SSRS and Crystal Reports, configure permits and licenses for individuals, properties and businesses in CSDC Amanda Application suite.
  • Migrate and deploy new developments in the project from one environment to another (DEV(Development), UAT (User Acceptance Testing), PROD(Production)) in Amanda Application.
  • Created complex Freeform’ s at Folder and Property level for data entry and maintenance.
  • Used Teradata utilities to load data in to BI Layer for reporting.
  • Configure/customize all Amanda back office changes
  • Monitoring Daily Batch jobs in Amanda Application by writing procedures, triggers in T-SQL or PL/SQL as per client database environment.
  • Create Merge documents and Reports using word Document and Crystal Reports tool in Amanda application to generate certificates and financial reports.
  • Documented ETL processes and prepared project status report updates/audit reports/ list of issue items that need to be reviewed.
  • Undertake other software development project related tasks which may be reasonably expected.
  • Work closely with the Team Members to understand the flowcharts, database schemas and various tools used during Software development life cycle.
  • Participate and present status updates in each of the Stand-Up meetings on a regular basis.
  • Coordinate with other team members and the development team to provide regular updates to the client.
  • Plan and prioritize work to meet tight deadlines.
  • Adapt quickly and effectively to change.
  • Solve complex problems in a time bound manner. Document issues and fixes for easy system maintenance

Confidential, Des Moines, IA

SQL Server Developer

Platform: Amanda 6.1.2, SQL Server 2005, Apache Tomcat 6.x/7.x

Responsibilities:

  • Perform the role as a backup SQL Server DBA under the supervision of the primary DBA. Activities include but are not limited to SQL Server (2005/2008/2010 ) database administration activities, upgrade database and tools, maintain system security, monitor and optimize database performance, plan for backup and recovery, and trouble shoot issues reported by other team members.
  • Involved in Requirement analysis for implementing Amanda for Radiological facility in Iowa Department of Health
  • Involved in Requirement analysis for creating new folders for Iowa Department of Health.
  • Configured and Developed new folder for Radiological facility.
  • Written complex batch jobs and procedures for Importing and Exporting data.
  • Created SQL jobs and validating the data in the PROD.
  • Validated data between the PROD UI and the Report source file (CSV).
  • Created batch files to execute all SQL commands in sequence.
  • Experience in configuring and deploying SSRS reports onto Microsoft Office SharePoint Server.
  • Created complex Freeform’ s at Folder and Property level for data entry and maintenance.
  • Develop Amanda batch jobs, write SQL stored procedures, database functions, database triggers.
  • Develop word merge documents to generate from Amanda application to the license.
  • Develop SAP crystal reports according to business requirement.
  • Configure/customize all Amanda back office changes
  • Configure/customize all Public Portal changes
  • Involved in Agile scrum development environment.
  • Work closely with Clients to understand business needs and implement solutions and Client servicing for all project-related matters, i.e. data analysis, summary writing and presentation of study results
  • Working on new functions to parse through merged commands for update, insert & delete operations on transactions.
  • Provide Weekly status report to Client
  • Attending daily scrum calls and providing day to day development updates
  • Working with Testing team and providing clarification for their questions and walk through developed features.

Confidential

SQL Server Developer

Responsibilities:

  • Involved in gathering user requirements, draft specifications, design and create Database objects for performance tuning.
  • Gathered requirements to identify and create database objects such as tables, views, triggers and indexes.
  • Involved in Normalization of the database and bringing it to 3NF.
  • Involved in creating the constraints, rules, defaults and triggers to maintain the data and referential integrity.
  • Created ER diagrams using Visio.
  • Created Non-Clustered indexes to improve query performance and query optimization.
  • Involved in the performance tuning and optimization of T-SQL queries.
  • Responsible for Data migration from SQL Server 7.0 to SQL Server 2000 Databases.
  • Developed user requested reports using Crystal Reports and Excel.
  • Created Drill down and Drill through reports using Crystal Reports.
  • Developed complex Stored Procedures, triggers, tables, views and other SQL joins and statements for applications using SQL server 2005.
  • Involved in creating, deploying and configuring reports according the requirements.
  • Involved in writing scripts for the client’s requirements for generating reports.
  • Developed and deployed data transfers packages using SSIS, also maintained the jobs running on Servers.
  • Involved in creating, deploying and configuring reports according the requirements.
  • Developed and deployed data transfers packages using SSIS, also maintained the jobs running on Servers.
  • Fixed reports and bugs in stored procedures.
  • Managed the security of the servers (Logins and users).
  • Installed and Configured SQL Server 2005, Integration Services (SSIS) and Reporting services (SSRS) for Dev and QA environments.
  • Documented the flow of the project.

Environment: Microsoft SQL Server 2008, SQL Server Integration Services, SQL Server Reporting Server, T-SQL, SQL Profiler

We'd love your feedback!