Analytics/teradata Developer Resume
Tampa, FL
SUMMARY
- 3 years of experience in Information Technology withstanding on Data Warehouse/Data Mart development using developing strategies for extraction, transformation and loading ( ETL ) in Informatica Power Center from various database sources.
- Expertise in Teradata Database design, implementation, and maintenance mainly in large - scale Data Warehouse environments.
- Experience working with Teradata Parallel Transporter (TPT), Fast Load, Multiload, BTEQ and Fast-Export, SQL Assistant, DDL and DML commands.
- Expertise in Analysis, developing Database Schemas like Star schema and Snowflake schema (Fact Tables, Dimension Tables) used in relational, dimensional and multidimensional modeling.
- Experience in developing Stored Procedures, Functions, Triggers and Complex SQL queries.
- Experience in Error Handling & Debugging and implemented various Performance Tuning techniques on Sources, Targets, Mappings, and Workflows in Informatica ETL mappings .
- Expertise in Query Analyzing, performance tuning and testing.
- Experience in writing UNIX shell scripts to support and automate the ETL process.
- Experience in ETL Audit Process (ABC - Audit, Balance & Control) to make sure Data Quality & Integrity. Set up email alerts process with threshold if any data loading issues through ETL Process.
- Expertise in testing the applications and creating test cases for Unit Testing, Integration Testing and make sure the data extracted from source is loaded into target properly in the right format.
- Use the Data Masking transformation to change sensitive production data to realistic test data for non-production environments.
- Highly motivated and goal oriented.
- Implemented DWH Projects using Agile & Waterfall Methodologies .
- Strong Understanding of Scrum Process.
- Excellent verbal and communication skills clear understanding of business procedures and ability to work as an individual as well as part of a team.
- Excellent Analytical and Problem - Solving Skills.
TECHNICAL SKILLS
Databases: Teradata 13.x/14.10/15, SQL and Oracle
Informatica Tools: Informatica Power Center 10.0.1/ 9.6.1/9.5.1
Programming Skills: Teradata SQL, Oracle SQL, SQL
Operating Systems: Windows, UNIX, LINUX
Teradata Utilities: BTEQ, SQL Assistant, Database Window, Fast Load, Multiload, Fast Export, TPT
Scheduling tool: Control-M Scheduler
Scripting Languages: UNIX Shell Scripting
PROFESSIONAL EXPERIENCE
Confidential, Tampa, FL
Analytics/Teradata Developer
Responsibilities:
- 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.
- Daily transnational data and reports from source will be available by next day to load into Datawarehouse.
- File check process ( shell script ) will be waiting for this file and kick start the actual load process once files arrives.
- As an initial load process, we will Multiload this file into Teradata staging table and archive the file in to archive folder after Multiload completes successfully.
- This actual load process contains mostly Teradata stored procedures and are scheduled to run every day through scheduling tool (ESPX) .
- After completion of load process, we will run Validation process to validate the data loaded in target tables against source.
- Develop Fast load scripts to load data from host file in to Landing Zone table.
- Involved in writing the ETL specifications and unit test plans for the mappings.
- Apply the business transformation using BTEQ scripts.
- Creating Database Tables, Views, Functions, Procedures, Packages as well as Database Sequences, Triggers and database link.
- Written SQL queries for retrieving the required data from the database.
- Create BTEQ scripts to load the data from staging table in to target table.
- Provided required support in Multiple (SIT, UAT & PROD) stages of the project.
- Prepared BTEQ import, export scripts for tables.
- Written BTEQ, FAST LOAD, MLOAD scripts.
- Involved in unit testing and prepared the test case.
- Validated the target data with the source data.
Environment: Teradata 15, Teradata SQL Assistant, Teradata Manager, UNIX, Scripts, MLOAD, BTEQ, FASTLOAD, CONTROL-M.
Confidential, Atlanta, GA
Analytics/Teradata Developer
Responsibilities:
- 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 into the Teradata tables using Teradata Utilities BTEQ, Fast Load, Multiload , and Fast Export and TPT .
- Worked with Informatica Power Center objects like Mappings, transformations, Mapplet, Workflows and Session Tasks.
- Extensively worked in the performance tuning of Teradata SQL, ETL and other processes to optimize session performance.
- Involved in Initial loads, Incremental loads and Daily loads to ensure that the data is loaded in the tables in a timely and appropriate manner.
- Writing Teradata Macros and used various Teradata analytic functions.
- Created detailed Technical specifications for Data Warehouse and ETL processes.
- Extensively used Pre-SQL and Post-SQL scripts for loading the data into the targets according to the requirement.
- Responsible for Unit Testing, Integration Testing and helped with User Acceptance Testing .
- Worked extensively with different Caches such as Index cache, Data cache and Lookup cache (Static, Dynamic and Persistence) while developing the Mappings.
- Managed enhancements and coordinated with every release with in Informatica objects .
- Provided support for the production department in handling the data warehouse .
Environment: Informatica Power Center 9.6.1/9.5.1 , Oracle 11g, DB2, Teradata 15/14, Flat Files, Sql Assistant, UNIX, Windows.
Confidential, Smithfield, RI
Analytics/Teradata Developer
Responsibilities:
- Created SQL Stored Procedures, Functions, Triggers and Packages for implementing business logic.
- Developed UNIX shell scripts to automatically notify systems and management personnel on status of backups, unsuccessful job runs that needed to be resubmitted and pending database concerns.
- Developed SQL packages using indexes, joins, bulk collects and bulk variables.
- Involved in writing complex queries to generate reports as per client requests as part of production support.
- Developed UNIX shell scripts to run the SQL scripts to generate reports and sending out email.
- Prepared Technical Documentation.
- Performance tuning of SQL queries consisting of many tables with large amount of data.
- Involved in developing test plans and test cases based on high-level and detailed designs.
- Involved in Production Support and troubleshooting data quality and integrity issues.
Environment: Teradata 14, Sql Assistant, UNIX, Windows.