SUMMARY:

• Nine years of experience in IT industry that includes Design, Development and Implementation of Data Warehousing applications using Informatica/Teradata.
• Extensive experience in extraction, transformation and loading of data directly from different heterogeneous source systems like Flat files, Oracle, SQL Server. Extensively worked on Informatica Designer Components - Source Analyzer, Warehousing Designer, Transformations Developer, and Mapping Designer
• Gathered business requirements, established functional specifications, translated them to design specifications.
• Proven track record in planning, building, and managing successful large-scale Data Warehouse and decision support systems. Comfortable with both technical and functional applications of RDBMS, Data Mapping, Data management, Data transportation and Data Staging
• Expertise in providing business intelligence solution using Informatica and Teradata in data warehousing systems.
• Experience in all aspects of SDLC including analysis, design, build, testing, deployment and production support.
• Proficient in understanding business processes/requirements and translating them into technical requirements.
• Worked on Teradata Utilities BTEQ, Fast load, Multi Load, T Pump, INMOD, and writing of Teradata SQL code.
• Trouble shooting of the runtime problems, worked on different types of transformation in creating mappings in Informatica. Trouble shooting of mappings bad files, log files etc.
• Performed all phases of development including Extraction, Transformation, Loading (ETL) data from Heterogeneous sources into Data Warehouses and Data Marts using Power Center (Designer, Workflow Manager, and Workflow Monitor) and Teradata Utilities.
• Knowledge of dimensional modeling/data modeling (star schema and snowflake schema) and Teradata specific LDM's
• Good knowledge of Teradata Financial Services Logical Data Model (Knowledge of Foundation, Banking) did analysis for PI and SI Extended Logical Data Model and Physical Data Model.
• Experienced as Teradata DBA and used Teradata Performance Monitor, Viewpoint.
• Involved in preparing test plans and cases for unit testing based on requirements.
• Experience in Onshore-Offshore Model.

TECHNICAL SKILLS:

• Database: Teradata, Oracle, Green Plum,SQL Server
• Operating System: UNIX, LINUX, Windows
• BI Tools & Utilities: Informatica 8,9 Informatica MDM
• Languages: Teradata SQL, Shell scripting

PROFESSIONAL EXPERIENCE:

Confidential

Teradata Developer

Roles and Responsibilities:

• Designed and developed complex mappings by using Lookup, Expression, Update, Sequence generator, Aggregator, Router, Stored Procedure, etc., transformations to implement complex logics while coding a mapping.
• Worked with Informatica power center Designer, Workflow Manager, Workflow Monitor and Repository Manager.
• Developed and maintained ETL (Extract, Transformation and Loading) mappings to extract the data from multiple source systems like Oracle, SQL server and Flat files and loaded into Teradata.
• Developed Informatica Workflows and sessions associated with the mappings using Workflow Manager.
• Involved in creating new table structures and modifying existing tables and fit into the existing Data Model.
• Prepare a high level design and low level design document.
• Part of design review board where the design of all projects are reviewed.
• Understanding BRD, Data required document and mapping documents of present system.
• Co-ordinate with offshore to resolve any business/technical issues.
• Keep track of the project deadlines.
• Prepare the required documents.
• Raise RFC (Request for Change) for promoting code to QA and Production.
• Worked closely with the business analyst/solution architect and Datawarehouse architect to understand the source data and need of the Warehouse.

Confidential

Teradata developer

Roles and Responsibilities:

• Designing the ETLs and conducting review meets.
• Involvement in implementation of BTEQ and Bulk load jobs
• Developed processes on both Teradata and Oracle using shell scripting and RDBMS utilities such as Multi Load, Fast Load, Fast Export, BTEQ (Teradata).
• Providing solution to the team members in Design and Technical part.
• Define standards for different environment.
• Doing impact analysis for requirements.
• Prepare a high level design and low level design document.
• Co-ordinate with offshore to resolve any business/technical issues.
• Assign work to team members.
• Help team members with technical issues.
• Keep track of the project deadlines.
• Prepare the required documents.

Confidential

Informatica/Teradata developer

Roles and Responsibilities:

• Validation of specifications/Requirements.
• Developed scripts for business rules like cleaning, triming and data validations.
• Monitoring the logs in power center workflow monitor tool and and rectify and failures if any.
• Schedule and run workflows as and when required.
• Extensively worked on BTEQ scripts to load data into tables.
• Populate or refresh Teradata tables using Fast load, Multi load & Fast export utilities for user acceptance testing and loading history data into Teradata.
• Used SQL Assistence to write and execute querires.
• Involved creating Test Scenarios and Test cases and upload them in Test Plan and Test Lab.
• Map the requirments with Test Cases.
• Duties included coordination, attending meetings, and the review of requirements, infrastructure setup, task assignments and code reviews.

Confidential

Teradata developer

Responsibilities:

• Understanding the complete architecture and internals of the application
• Take up production calls as the Second level support analyst.
• Troubleshoot production problems and implement fixes in production.
• Participate in Status meetings and weekly team meetings
• Creating and maintaining the necessary quality documents keeping the clients methodologies in mind.

Confidential

Teradata developer

Responsibilities:

• Getting the requirements from the business analyst and analyze the same.
• Design and Development.
• Coding all the Teradata SQL part of the project.
• Perform Unit testing of the developed modules.
• Co-ordinate with the tester to do the Integration testing.
• Responsible for overseeing the Quality procedures related to the project.

Confidential

Teradata developer

Responsibilities:

• Getting the requirements from the business analyst and analyze the same.
• Design and Development.
• Coding all the Teradata SQL part of the project.
• Perform Unit testing of the developed modules.
• Co-ordinate with the tester to do the Integration testing.
• Responsible for overseeing the Quality procedures related to the project.

Confidential

Teradata developer

Responsibilities:

• Design and Development of the flow of data.
• Writing the scripts for various jobs in Teradata Tools and Utilities.
• Writing stored procedures, SQL queries.
• Done performance optimization in SQL code.

Confidential

Teradata developer

Responsibilities:

• Coding Teradata SQL part of the project.
• Perform Unit testing of the developed modules.
• Co-ordinate with the tester to do the Integration testing.
• Responsible for overseeing the Quality procedures related to the project.)