SUMMARY:

• Around 5 years of experience in ETL, Data Integration and Data Warehousing using Informatica, Teradata and Oracle technologies.
• Worked in complete Software Development Life Cycle (SDLC), starting from requirement gathering, analysis, design, testing, debugging, implementation, post implementation support and maintenance.
• Experience in writing sql queries and good knowledge in pl/sql programming and writing stored procedures.
• Knowledge working with Talend ETL tool to load source files into target databases.
• Good experience in Data warehousing applications, responsible for Extraction, cleansing, Transformation and Loading of data from various sources to the data warehouse.
• Strong experience with Informatica tools - Mapping designer, Mapplet Designer, Transformations Developer, Informatica Repository Manager, Workflow Manager and Workflow Monitor.
• Designed Informatica mappings/sessions using Transformations like Lookup, Joiner, Filter, Expression, Update strategy,SQL transformation,Normalizer etc.
• Create mappings using reusable components like worklets, mapplets using other reusable transformations.
• Experience in Integration of various data sources like Oracle, SQL Server, Fixed Width and Delimited Flat Files, DB2 and XML Files.
• Developed comprehensive models for managing and communicating the relationships between Base Objects and Performed the ETL process for loading the data into hub.
• Comfortable with both technical and functional applications of RDBMS, Data Mapping, Data Management, Data transportation and Data Staging.
• Good knowledge of Full Life Cycle Design and development for building data warehouse.
• Experience working with Teradata Parallel Transporter (TPT), BTEQ, Fast load, Multiload, TPT, SQL Assistant, DDL and DML commands.
• Proficient in Teradata EXPLAIN plans, Collect Stats option, Primary Indexes (PI, NUPI), Secondary Indexes (USI, NUSI), Partition Primary Index (PPI), Join Indexes (JI), Volatile, global temporary and derived tables.
• Working Knowledge of Data warehousing concepts like Star Schema and Snowflake Schema, Data Marts, Kimball Methodology used in Relational, Dimensional and Multidimensional data modelling.
• Extensively used different features of Teradata such as BTEQ, Fast load, Multiload, SQL Assistant, DDL and DML commands. Very good understanding of Teradata UPI and NUPI, secondary indexes and join indexes.
• Involved creating the tables in Teradata and setting up the various environments like DEV and PROD.
• Having experience in working with both 3NF and dimensional models for data warehouse and good understanding of OLAP/OLTP systems.
• Ability to work with limited resources, capable of multi-tasking, planning works around concurrent and time sensitive deliveries
• Strong analytical skills with ability to quickly understand business needs.
• Excellent Documentation and Process Management skills with an ability to TEMPeffectively understand the business requirements to develop a quality product within deadlines.

TECHNICAL SKILLS:

Languages: SQL, PL/SQL,Teradata SQL, Oracle SQL, UNIX Shell Scripting, BTEQ

Databases: Teradata 15.10/14.X/13.X/12.X, Oracle 12c,11g/10g,8i,SQL Server.

Data Modeling: Erwin 4.0/3.5, Logical/Physical/Dimensional/3NF, Star/ ETL

ETL Tools: Informatica Power Center 9.5x/9.x/8.x/7.x (Designer, Workflow Manager, Workflow Monitor, Repository Manager) and Informatica Data Quality (IDQ).

Teradata Utilities: BTEQ, Fastload, Multiload,Fast Export, TPT, TPump, SQL Assistant, Viewpoint, Query Monitor, Stored procedures.

Tools: /Utilities: PLSQL Developer, TOAD, SQL Developer, Erwin, Microsoft Visio, Talend.

Operating Systems: Windows, UNIX, LINUX

PROFESSIONAL EXPERIENCE:

Confidential

Informatica/Teradata Developer

Responsibilities:

• Involved in Complete Software Development Lifecycle Experience (SDLC) from Business Analysis to Development, Testing, Deployment and Documentation.
• Designed, Developed and Build Informatica Power Center Mappings and workflows using Teradata External Loaders.
• Extensively used transformations to implement the business logic such as Sequence Generator, Normalizer, Expression, Filter, Router, Rank, Aggregator, Look Up (Target as well as Source), Update Strategy, Source Qualifier and Joiner.
• Extracted data from various source systems like Oracle, SQL Server and flat files as per the requirements.
• Responsible to tune ETL procedures to optimize load and query Performance.
• Automating the workflows were ever required on daily basis.
• Working with the support team for any functional problems raised.
• Performance Tuning of the Informatica Mappings by adopting Explain plans, cutting down query costs by changing the mapping designs.
• Worked on data audit tables to check for any updated or inserts required.
• Designed the Unique key combination using various fields and join the tables for Reporting purposes to the BI team.
• Created tables, views in Teradata according to the requirements in all environments to provide data to the BI team.
• Worked on Teradata EXPLAIN plans, Collect Stats option, Primary Indexes (PI, NUPI), Secondary Indexes (USI, NUSI), Partition Primary Index (PPI), Join Indexes (JI), Volatile, global temporary and derived tables.
• Worked in the conversion of SQL server functions into the Teradata Store procedure for confirming the data.
• Involved in writing UNIX Shell scripts for conditional execution of the workflows and various administration activities for daily backup.
• Worked on Production support tickets and fixed the issues.
• Involved in full life cycle development including Design, ETL strategy, troubleshooting Reporting, and Identifying facts and dimensions.
• Involved in unit test plans and running tests in local before finalizing the data to the production.
• Estimates and planning of development work using Agile Software Development.
• Migrated the data through DEV/UAT/PROD.
• Answering client calls and working on requests raised by them on day to day basis.
• Environment:Teradata 15.10,14.10, Informatica Power Center 9.6.2, Workflow Manager, Workflow Monitor, Warehouse Designer, Source Analyzer, Transformation developer, Map let Designer, Mapping Designer, Repository manager, Informatica Data Quality (IDQ), Oracle 12c, UNIX, SSH (secure shell), Putty.

Confidential

Informatica/Teradata Developer

Responsibilities:

• Responsible for requirements gathering for an enhancement requested by client. Involved in analysis and implementation.
• WroteTeradata Macrosand used various Teradataanalytic functions.
• Used SQL to query the databases and do as much crunching as possible in Teradata, using very complicated SQL Query optimization (explains plans, collect statistics, data distribution across AMPS, primary and secondary indexes, locking, etc.) to achieve better performance.
• Developed the Teradata Macros, Stored Procedures to load data into Incremental/Staging tables and tan move data from staging to Journal tan move data from Journal into Base tables.
• Designed, Developed and Build Informatica Power Center Mappings and Workflows using Teradata External Loaders.
• Extensively used the Teradata utilities like BTEQ, Fastload, Multiload, DDL Commands and DML Commands (SQL).
• Involved in the Data warehouse data modeling based on the client requirements.
• Generated queries using SQL to check for consistency of the data in the tables and to update the tables as per the requirements.
• Developed code to load the data from Flat File to stage and stage to DWH.
• Development & Implementation of a data warehousing project and also production support for enhancements and maintenance.
• Created Primary Indexes (PI) for both planned access of data and even distribution of data across all the available AMPS.
• Created appropriate Teradata NUPI for smooth (fast and easy) access of data.
• Involved in Performance tuning for sources, targets, mappings and sessions.
• Worked on Informatic Power Center tools - Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Involved in full life cycle development including Design, ETL strategy, troubleshooting Reporting, and Identifying facts and dimensions.

Environment: Teradata 14.10/13.x/12.x, Informatica Power Center 9.5.1, BTEQ, TPT, Fast load, Mload, SQL Server 2012/2008, UNIX, Flat Files Oracle 11g, Toad.

Confidential

Informatica/Teradata Developer

Responsibilities:

• Worked closely with client in understanding the Business requirements, data analysis and deliver the client expectation.
• Extensively worked in data Extraction, Transformation and Loading from source to target system using power center of Informatica.
• Created Informatica Workflows as per the business rules to load data into OLTP databases
• Parameterized the mappings and increased the re-usability.
• Created complex mappings in Powercenter Designer using Aggregator, Expression, Filter, Sequence Generator, Update Strategy, Union, Lookup, Joiner, Source Qualifier and Stored procedure transformations.
• Worked on Teradata RDBMS using Fast load, Multiload, Tpump, Fastexport, Multiload Export, Teradata SQL And BTEQ Teradata utilities.
• Development and testing of mappings at Informatica level.
• Involved in Performance Tuning at various levels including Target, Source, Mapping, and Session for large data files.
• UsedInformaticaPower Center Workflow manager to create sessions, batches to run with the logic embedded in the mappings. Developed error handling & data quality checks. inInformaticamappings.
• Extracted data from various source systems likeOracle,SQL Serverand flat files as per the requirements.
• Worked on Informatica Power Center tools - Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Performed tuning and optimization of complexSQL queriesusingTeradataExplain.
• Migrated mappings, sessions, and workflows from development to testing and tan to Production environments.
• Created and Monitor the sessions using workflow manager and workflow monitor.
• Migrated the code from DEV/SIT/UAT to production environments
• Created Test Plans and Test Scripts to support the testing team.
• Conducting unit testing.

Environment: Teradata 14.10/13.x, Informatica Power Center 8.6, Oracle 10g, Windows XP, UNIX.