SUMMARY:

• 7+ years of experience in the IT industry, coupled with extensive experience in Data Warehousing Teradata (V2R6/12.0/13/14) & UNIX Environment for Decision Support Systems.
• Expertise in Data modeling techniques like Data Modeling - Dimensional/ Star Schema and Snowflake modeling, Slowly Changing Dimensions (SCD Type 1, Type 2, and Type 3).
• Excellent working experience in Waterfall, Agile methodologies.
• Proficient in performance analysis, monitoring and SQL query tuning using EXPLAINPLAN, Collect Statistics, Hints and SQL Trace both in Teradata as well as Oracle.
• Experience in development and design of ETL (Extract, Transform and Loading data) methodology for supporting data transformations and processing, in a corporate wide ETL Solution using Informatica Power Centre.
• Created mappings using Lookup, Aggregator, Joiner, Expression, Filter, Router, Update strategy and Normalizer Transformations. Developed reusable Transformation and Mapplets.
• Strong Experience with shell scripting, understanding of approaches for business intelligence, data warehouse.
• Good Knowledge in UNIX shell scripting and basic PERL scripting with experience in LINUX, AIX platforms.
• Expertise in deploying from DEV to QA, UAT and PROD with both Deployment group and Import/Exports method.
• Designed the ETL processes using Informatica to load data from Oracle, SQL Server, Flat Files, (Fixed Width), XML files and Excel files to target Teradata Database
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Power Center 7.x and 8.x.
• Actively involved in Data Gathering, recognizing, and confirming the data sources/elements
• Extensively used ETL to load data from flat files into Staging area and then to Data warehouse
• Involved heavily in writing complex SQL queries based on the given requirements and used volatile tables, temporary tables, derived tables for breaking up complex queries into simpler queries
• Implemented various Teradata specific features like selection of PI, USI/NUSI, PPI and Compression based on requirements
• Implemented access rights mechanism using restricted views, macros and roles
• Provide ongoing Teradata system performance management using Teradata manager and PMON
• Reviewing and monitoring priority scheduler and TDQM settings
• Gather information from different data warehouse systems and loaded into warehouse using FastLoad, FastExport, Multiload, BTEQ and Unix shell scripts
• Involved in unit testing, systems testing, integrated testing and user acceptance testing.
• Experience in gathering and writing detailed business requirement and translating them into technical specifications and design.
• Expertise in understanding and supporting the client with requirements definition, analysis, design, testing, system documentation and user training.
• Extensive experience in gathering requirements and documenting the same as per the industry best practices.
• Designed the data conversion strategy, development of data mappings, source data profiling and the design of Extraction, Transformation and Load (ETL) routines for migrating data from non-relational or source relational to target relational.
• Strong analytical, logical, Communication and problem-solving skills and ability to quickly adapt to modern technologies by self-learning.

TECHNICAL SKILLS:

ETL/BI tools: Talend Data Integration/ Big Data Integration/ Data Quality 6.1/5.5/5.0, Talend Administrator Console, Informatica Power Center 9.0/8.6

Operating systems: Sun Solaris 25,2.6,8,9,10, AIX 5.1,5.2, Mainframes MVS, Red Hat Linux RHEL2.1, 3.x, 4.x and Windows 95/98/NT/2000/XP.

Teradata Tools & Utilities: BTEQ, Multi Load, Fast Load, Fast Export, TPump, TPT, Teradata Manager, SQL Assistant, Teradata Administrator

Programming Languages:: Teradata SQL, PL/SQL, SQL, C, C++, C#, JAVA.

Bigdata: Hadoop, Hive

Process/Methodologies: Waterfall, Agile Methodology

Scripting languages:: UNIX Shell scripting, Java Scripting.

PROFESSIONAL EXPERIENCE:

Confidential, Costa mesa, CA

ETL/Teradata Developer

• Designed the ETL processes using Informatica to load data from Oracle, SQL Server, Flat Files, (Fixed Width), XML files and Excel files to target Teradata Database
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Power Center 7.x and 8.x.
• Actively involved in Data Gathering, recognizing, and confirming the data sources/elements
• Extensively used ETL to load data from flat files into Staging area and then to Data warehouse
• Involved heavily in writing complex SQL queries based on the given requirements and used volatile tables, temporary tables, derived tables for breaking up complex queries into simpler queries
• Implemented various Teradata specific features like selection of PI, USI/NUSI, PPI and Compression based on requirements
• Implemented access rights mechanism using restricted views, macros and roles
• Provide ongoing Teradata system performance management using Teradata manager and PMON
• Reviewing and monitoring priority scheduler and TDQM settings
• Gather information from different data warehouse systems and loaded into warehouse using FastLoad, FastExport, Multiload, BTEQ and Unix shell scripts
• Involved in unit testing, systems testing, integrated testing and user acceptance testing.

Environment: Teradata v13, Netezza, ETL tool, Informatica Powercenter 7.x/8.x, SQL Server, Oracle, Teradata Manager, BTEQ, Fast Export, Fast Load, Multi Load, Shell Scripting.

Confidential, Columbia, MD

ETL/Teradata Developer

Responsibilities:

• Migrated data from Informatica Powercenter Designer and using transformations like Source Qualifier, Expression, Filter, Router, Joiner, Sequence developer, Update Strategy, Lookup, Sorter, Aggregator, Normalizer, XML Source Qualifier, Stored Procedure etc. for extraction, transformation and loading of data
• Worked on Netezza as relational Source data base which is dimensional model to generate the existing BO reports
• Assisted in support functions and maintenance of Netezza data warehousing applications as per program requirements
• Created complex jobs and implemented Slowly Changing Dimensions (Type 1, Type 2 and Type 3) for data loads
• Extensively used Erwin for Logical and Physical data modeling and designed Star Schemas
• Extensively Used Environment SQL commands in workflows prior to extracting the data in the ETL tool
• Worked with Teradata utilities like BTEQ, Fast Export, Fast Load, Multi Load to export and load data to/from different source data base Netezza
• Created databases, tables, triggers, macros, views, stored procedures, functions, Packages, joins and hash indexes in Teradata database
• Expertise using ERWIN for Data modeling and Database design
• Experience working with Informatica Power Exchange for Netezza and migrating the data using Talend Studio into Teradata.
• Hands on Experience Business Intelligence experience using Business Objects.
• Migrated reports from Business Objects to Tableau.
• Experience in Informatica providing Data warehouse solutions using Power Center and data modeling with ERWIN tool.
• Used Erwin tool for physical and logical data modeling.
• Used Informatica power center to Extract, Transform and Load data into Netezza Data Warehouse from various sources like Oracle and flat files.
• Used Talend extensively for profiling the data and accessing the data quality of the source data.
• Created and Configured Workflows, Worklets, and Sessions to transport the data to target warehouse Netezza tables using Informatica Workflow Manager.
• Migrated Informatica folders, mappings from one environment to another and in the process of change control using Talend and yaml files.
• Created jobs in Talend Studio in the development environment and tested in QA and moved into Production environment as well.
• Created and used volatile tables for testing purposes.
• Involved in Code Reviews & Unit Testing for the ETL code developed.

Environment: Teradata v13/v14, Netezza, ERWIN, ETL tool, Informatica, Tableau, Oracle, Informatica Workflow Manager, BTEQ, Fast Export, Fast Load, Multi Load

Confidential, Orlando, FL

Teradata/ETL Developer

Responsibilities:

• Designed the ETL processes using Informatica to load data from Oracle, SQL Server, Flat Files, (Fixed Width), XML files and Excel files to target Teradata Database
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Power Center 7.x and 8.x.
• Actively involved in Data Gathering, recognizing, and confirming the data sources/elements
• Extensively used ETL to load data from flat files into Staging area and then to Data warehouse
• Involved heavily in writing complex SQL queries based on the given requirements and used volatile tables, temporary tables, derived tables for breaking up complex queries into simpler queries
• Implemented various Teradata specific features like selection of PI, USI/NUSI, PPI and Compression based on requirements
• Implemented access rights mechanism using restricted views, macros and roles
• Provide ongoing Teradata system performance management using Teradata manager and PMON
• Reviewing and monitoring priority scheduler and TDQM settings
• Gather information from different data warehouse systems and loaded into warehouse using FastLoad, FastExport, Multiload, BTEQ and Unix shell scripts
• Involved in unit testing, systems testing, integrated testing and user acceptance testing.

Environment: Teradata v13, Netezza, ETL tool, Informatica Powercenter 7.x/8.x, SQL Server, Oracle, Teradata Manager, BTEQ, Fast Export, Fast Load, Multi Load, Shell Scripting.

Confidential, Malvern, PA

Teradata Developer/Informatica/ETL Developer

• Migrated data from Informatica Powercenter Designer and using transformations like Source Qualifier, Expression, Filter, Router, Joiner, Sequence developer, Update Strategy, Lookup, Sorter, Aggregator, Normalizer, XML Source Qualifier, Stored Procedure etc. for extraction, transformation and loading of data
• To consolidate the AR Details for Clinical systems as per the Global Chart of Accounts. The AR Details Data will be extracted from PROD-ERP and GLPROD.
• To make enhancements to the global clinical systems account receivables reporting solution for measuring Gross AR, Aging/Past dues, Credits/Collections, Unapplied Cash consistent with P&L Structure. Make Get Paid Application data available to the end users.
• Involved in Design Part of the Project by Creating FSD & Business mapping documents.
• Requirement study and understanding business logic and prepared low level Source to Target mapping documents.
• Write BTEQ scripts for validation & data integrity between source and target databases and for report generation.
• Capture Metadata, Capacity Plan and Performance metrics for all the queries being created and Define archival strategy and provide guidance for performance tuning.
• Created and Imported/Exported various Sources, Targets, and Transformations using Informatica Power Center 8.6.
• Worked on Power Center Designer client tools like Source Analyzer, Warehouse Designer, Mapping Designer and Mapplet Designer.
• Created reusable transformations and mapplets by using Lookup, Aggregator, Normalizer, Update strategy, Expression, Joiner, Rank, Router, Filter, and Sequence Generator etc. in the Transformation Developer, and Mapplet Designer, respectively.
• Schedule jobs for ETL batch processing using Cronacle Scheduler.
• Extensively worked with the data conversions, standardizing, correcting, error tracking and enhancing the data.
• Implemented the process for capturing incremental data from source systems and move the data warehouse area.
• Involved in onsite offshore coordination and performance tuning with Informatica and database.
• Involved in Migration of objects from DEV and QA and worked with DBA to create schema instances and tables in DEV, QA & PROD.
• Created updated and maintained ETL technical documentation.
• Used to interact with third party teams like DBA and Migration teams for Migrating the code to QA and PROD.
• Involved in Design, Development &Testing Phases and in scheduling of jobs using cronacle tool.

Confidential

Informatica/ETL Developer

Responsibilities:

• Present the IT solutions implementation approach as dictated by the Business
• Requirements Documents requirements classification and methodology
• Present the risks, dependencies, and outstanding items that require attention from the project stakeholders
• Responsible for designing, developing and unit testing of the mappings.
• Developed mappings using Informatica Power Center Designer to load data from various source systems to target database as per the business rules.
• Used various transformations like Source Qualifier, Aggregators, Connected & unconnected lookups, Filters, Sequence generators, Routers, Update Strategy, Expression, etc.
• Involved in developing test cases for the Informatica mappings and update processes.
• Responsible for monitoring all the sessions that are running, scheduled, completed and failed. Debugged the mapping of the failed session.
• Mapplets and Reusable Transformations were used to prevent redundancy of transformation usage and maintainability.
• Performed the unit, system and integration testing for the jobs.
• Validated the test results by executing the queries using the Toad software.
• Prepared test plans for both unit and system tests.
• Responsible to design, develop and unit test the mappings.
• Developed re-usable transformations, re-usable mapplets.
• Wrote design documentation for the ETL process and Informatica mappings.
• Unit tested the mappings by running SQL queries and comparing the data in source and target databases.
• Worked with source teams to resolve data quality issues raised by end users
• Created TIDAL jobs and schedules based on demand, run on time (Daily, Weekly, Monthly), run only once and Ad-Hoc.
• Involved in writing Pre-session and Post-session korn shell scripts for dropping & creating indexes for tables, Created shell scripts which will substitute all the user and schema information in the SQL queries,

Environment: Informatica Power Center 8.6, Oracle 10g, SQL Server 2008, Business Objects XI R2, TIDAL