Data Engineer Resume

SUMMARY:

10 years of experience in Teradata, SQL, PL/SQL, UNIX, Mainframes, Business Objects and Tableau.
Extensive Experience on Teradata database, analyzing business needs of clients, developing effective and efficient solutions and ensuring client deliverables with in committed timelines.
Expertise in maintaining data quality, data organization, metadata and data profiling.
Experience in Business Analysis and Data Analysis as well as User Requirement Gathering, User Requirement Analysis, Data Cleansing, Data Transformations, Data Relationships, Source Systems Analysis and Reporting Analysis.
Extensive experience with development, testing, debugging, implementation, documentation and production support.
Efficient in Data Modeling with experience in Schema Design, Dimensional Modeling and Teradata Indexes.
Proficient in creating reports using Business Objects XI R2 functionalities such as Queries, Master/Detail and Formula, Slice and Dice and Drilling
Solid Expertise in Teradata Stored Procedures.
Strong hands on experience using Teradata utilities (SQL, B - TEQ, Fast Load, MultiLoad, FastExport, Tpump, Visual Explain, Query man
), Teradata parallel Transporter and Unix Shell scripting.
Proficient in coding of optimized Teradata batch processing scripts for data transformation, aggregation and load using BTEQ and Stored Procedures.
Strong experience in Creating Database Objects such as Tables, Views, Stored Procedures and Indexes in Teradata.
Created tables and views based on the layout sent by Clients.
Sound Knowledge of Data Warehousing concepts, E-R model and Dimensional modeling (3NF) like Star Schema, Snowflake Schema.
Very well conversant with Oracle 9i/10g and SQL Server 2005/2008, Analytical Functions, Database Design, Query Optimization and Performance tuning.
Worked extensively in Development of large Projects with complete END to END participation in all areas of Software Development Life Cycl e and maintain documentation.
Quick adaptability to new technologies and zeal to improve technical skills.
Good analytical, programming, problem solving and troubleshooting skills.

TECHNICAL SKILLS:

Database: Teradata(V2R5,V2R12,V13,V14,V15,V16), Oracle, Vertica

Languages: SQL, Unix Shell Scripting, JCL, VBA, Java, Python

Operating Systems: Unix, Windows, Linux, Mainframe

ETL Tools: DataStage

Reporting Tools: Business Objects, Tableau

Scheduling Tools: Changeman, TWS, Autosys

PROFESSIONAL EXPERIENCE:

Confidential

Data Engineer

Responsibilities:

Gather functional requirements for new projects and enhancements for Analytics in iTunes.
Design a solution for the gathered requirements.
Data Modeling of the database objects for Teradata data warehouse.
Develop Teradata stored procedures to implement business requirements.
Develop Unix shell scripts to call Teradata stored procedures.
Design the business object universe for reporting purpose.
Create Autosys jobs to schedule data processing runs.
Co-ordinate and work with offshore teams from a technical development standpoint.
Support Integration Testing across multiple teams and conduct User Acceptance Testing with suitable presentations and technical documents as needed.
Plan production deployment activities for the EDW system involving migration of table structures, jobs, stored procedures and all objects involved in the development life cycle.
Prepare / Review technical documentation as a team and present the same to Production Support teams as needed during the hand-over phase

Confidential

Technical Analyst

Technology used: Teradata and Unix.

Responsibilities:

Create low level design based on the Business requirement and High Level Design.
Create UNIX scripts that invoke BTEQ to process and store data on Teradata server.
Design Teradata tables.
Implement business logic using Teradata BTEQ.
Co-ordination between offshore team and client.
Documentation, including Estimation, Unit Test Plan, Unit Test Results, FI-SQA.
Resolve issues during development, ST and End-to-End testing.

Confidential

Teradata Lead Developer/Data Modeler

Technology used: Teradata, Unix, Mainframe and DataStage.

Responsibilities:

Understanding the business needs and the requirements and implement the same for the existing and new data flows.
Involved in preparing Technical Specifications by understanding Functional specs.
Design the process flow.
Develop Teradata BTEQ to implement the business logic.
Create UNIX scripts that invoke Teradata BTEQ to process and store data on Teradata server.
Design Teradata tables.
Work as lead developer with offshore team to implement the design and meet the requirements.
Resolve issues during development, ST and End-to-End testing.
Perform in-depth data analysis based on inputs/issues from Users.
Query optimization and tuning to prevent breach of SLA on production cycle.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship