SUMMARY:

• Around 7 years of total IT experience and technical proficiency in the Data Warehousing involving Business Requirement Analysis, Application Design, Data Modeling, Development, Testing and Documentation.
• Proficient in Teradata Database design, implementation, and maintenance mainly in large - scale Data Warehouse environments
• Hands on experience in Teradata RDBMS using FastLoad, MultiLoad, Tpump, FastExport, TeradataSQL Assistant, Teradata Administrator and BTEQ experience.
• Involved in Data Migration projects from DB2 and Oracle to Teradata.
• Created automated scripts to do the migration using UNIX shell scripting, Oracle/TD SQL.
• Expert in Coding Teradata SQL, Teradata Stored Procedures, Macros and Triggers.
• Experienced in writing UNIX korn shell scripts to support and automate the ETL process.
• Expert in tuning Complex Teradata SQL Queries including Joins, correlated sub queries and Scalar Sub queries.
• Strong knowledge of Teradata RDBMS Architecture (AMP, Parsing Engine, BYNET and Data distribution).
• Development Implementation and Testing Data Warehouse and Database applications for Health care, Telecommunications Services, Retail, Commercial and Financial Services using Informatica, Oracle PL/SQL, Teradata and My SQL.
• Technical expertise in ETL methodologies, Informatica Power Center, Power Mart, Client tools - Mapping Designer, Workflow Manager/Monitor and Server tools - Informatica Server Manager, Repository Server Manager, and Power Exchange.
• Experienced in design and developing the ETL objects using Informatica Power center with various Transformations like Joiner, Aggregate, Expression, SQL, Lookup, Filter, Update Strategy, Stored Procedures, Router, Rank, Normalizer transformations etc.
• Hands on experience in monitoring and managing varying mixed workload of an active data warehouse using various tools like Teradata Workload Analyzer, Teradata Dynamic Workload Manager and Teradata Manager.
• Involved in full lifecycle of various projects, including requirement gathering, system designing, application development, enhancement, deployment, maintenance and support.
• Expertize 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.
• Experience working with clients of all sizes in the Financial, Healthcare, Retail and Manufacturing industries.
• Good understanding of Reporting tools like Cognos, Tableau and Business Objects.
• Experienced in using Bug Tracking tools like JIRA and HP Quality center and Issue Tracking tools like Remedy etc.,

TECHNICAL SKILLS:

Data Warehousing: Informatica Power Center 9.x, Informatica Designer, Workflow Manager, Work flow Monitor, Talend, Ab- Initio Datamart, OLAP, OLTP, Mapplet, Worklet, Transformations, Ab Initio Graphs.

Shell, Bash, SQL, PL: SQL.

Tracking Tools: Remedy, JIRA, IBM Clear Quest, HP Quality center

Version Control Tools: Subversion(SVN), GIT.

Control: M, Tivoli.

Database System: Teradata 13.10/14.00/14.10 , SQL Server, Oracle 9i/10g/11g/12c, DB2.

AWS: EC2, S3, Glacier, ELB, RDS, SNS, SWF, VPC, IAM and EBS.

Configuration Management Tools: Chef, Ansible, Jenkins.

Linux Distributions: Centos 6.5, 7, Ubuntu, Red Hat.

SDLC: Agile, Waterfall, Scrum.

PROFESSIONAL EXPERIENCE:

Confidential, Plantation, FL

Teradata Developer

• Involved in full Software Development Life Cycle (SDLC) - Business Requirements Analysis, preparation of Technical Design documents, Data Analysis, Logical and Physical database design, Coding, Testing, Implementing, and deploying to business users.
• Involved in gathering business requirements, logical modelling, physical database design, data sourcing and data transformation, data loading, SQL and performance tuning.
• Expertise in writing scripts for Data Extraction, Transformation and Loading of data from legacy systems to target data warehouse using BTEQ, FastLoad, MultiLoad, and Tpump.
• Defined the schema, staging tables, and landing zone tables, configuring base objects, foreign-key relationships, complex joins, and building efficient views.
• Performed Query Optimization with the help of explain plans, collect statistics, Primary and Secondary indexes.
• Used volatile table and derived queries for breaking up complex queries into simpler queries. Streamlined the Teradata scripts and shell scripts migration process on the UNIX box.
• Developed Teradata BTEQ scripts to implement the business logic and work on exporting data using Teradata FastExport.
• Extensively used Parameter file to override Mapping parameter, Mapping Variables, Workflow Variables, Session Parameters, FTP Session Parameters and Source-Target Application Connection parameters
• Used Constraint Based loading & Target load ordering to efficiently load tables with PK-FK relation in the same mapping.
• Architected and developed FastLoad and MultiLoad scripts developed Macros and Stored procedures to extract data, BTEQ scripts to take the date range from the database to extract data.
• Performed reverse engineering of physical data models from databases and SQL scripts.
• Provided database implementation and database administrative support for custom application development efforts.
• Prepared technical specifications to develop Informatica ETL mappings to load data into various tables confirming to the business rules.
• Developed OLAP reports and Dashboards using the Business intelligence tool - OBIEE.
• Provided database implementation and database administrative support for custom application development efforts.
• Involved in comprehensive end-to-end testing- Unit Testing, System Integration Testing, User Acceptance Testing and Regression.
• Wrote Shell scripts and Stored Procedures for regular Maintenance and Production Support to load the warehouse in regular intervals and to perform Pre/Post Session Actions.
• Provided 24/7 On-call Production Support for various applications and provided resolution for nighttime production job abends, attend conference calls with business operations, system managers for resolution of issues.

Environment: Informatica 9.6(Designer, Repository Manager, Workflow Manager, Workflow Monitor), Oracle 10G/11G, Teradata 14, UNIX, Citrix, Toad, Putty.

Confidential, Cleveland, OH

Teradata / ETL Developer

• Analyze the existing stored procedure in DB2 and translate to Teradata Stored Procedures and BTEQ scripts, TPT Scripts.
• Analyze the existing Informatica code in DB2 and converting the mappings and sessions to the Teradata Database.
• Expert in building Red hat Linux physical and virtual servers, upgraded Linux servers from one OS release to another.
• Good Experience in bulk data integration and transformation, real time data integration and replication and data quality and governance by using Oracle Data Integration (ODI).
• Experience in implementation and maintenance of VMware, DNS, DHCP, NIS, NFS and SMTP.
• Develop framework for the Data Loads, Audits and Controls.
• Used Teradata Utility tool TARDIS for ETL works from different sources to Teradata.
• Used Teradata utilities FastLoad, Multiload, Tpump to load data from various source systems.
• Created Control-M Jobs for scheduling ETL jobs.
• Utilized Informatica Data Quality (IDQ) for data profiling and matching/removing duplicate data, fixing the bad data, fixing NULL values.
• Responsible to tune ETL procedures and STAR schemas to optimize load and query performance.
• Extracted data from Flat files and Oracle database and loaded them into Teradata.
• Worked on deployment process to push code to other environments used Jenkins, Stash, BOB, Perforce.
• Designed, developed, and implemented optimal ETL solutions for automation of client information transformation and movement, using Talend.
• Developed technical Best practices for ETL related activities, including client data movement, quality, and cleansing using Talend.
• Worked on Hive no SQL to transform data to load into Teradata.
• Worked with Informatica IDQ with various data profiling techniques to cleanse, match/remove duplicate data by using IBM Info sphere.
• Provided support in migration of existing ETL framework to Elastic Map Reduce and Hive (Cloud) technology to improve scaling and performance.
• Work closely with DBAs, application, database and ETL developers, change control management for migrating developed mappings to PROD.

Environment: Informatica Power center 9.5/ 9.6, Teradata 15, Informatica IDQ, SQL Server, DB2, Control-M, Hadoop-hive, Business Objects, UNIX, JIRA.

Confidential, Jersey City, NJ

Teradata / Informatica Developer

• Involved in analysis of source systems, business requirements and identification of business rule and responsible for developing, support and maintenance for the ETL process using Informatica.
• Extracted data from heterogeneous sources like Oracle, DB2, XML, Flat File and perform the data validation and cleansing in staging area then loaded in to Data Warehouse Teradata using Teradata Utilities & Informatica.
• Created Informatica mapplets, mappings, tasks, worklets, workflows using Power Center to load the data from source to stage and stage to core/base.
• Made use of various Power Center Designer transformations like Source Qualifier, Connected and Unconnected Lookups, Expression, Filter, Router, Sorter, Aggregator, Joiner, Rank, Router, Sequence generator, Union and Update Strategy transformations while creating mapplets/mappings.
• Implemented various loads like daily loads, weekly loads, and quarterly loads and on demand load using Incremental loading strategy and concepts of Change Data Capture (CDC).
• Identified performance issues in existing sources, targets and mappings by analyzing the data flow, evaluating transformations and tuned accordingly for better performance.
• Executed the DB Scripts (DML and DDL) which have dependencies on the code on Oracle DB.
• Performed unit of MDM testing in all stages and ETL from where data releases.
• Created mappings for Type1, Type2 slowly changing dimensions (SCD) / complete refresh mappings.
• Extensively used various Data Cleansing and Data Conversion functions like LTRIM, RTRIM, TO DATE, Decode, and IIF functions in Expression Transformation.
• Extensively used the Workflow Manager tasks like Session, Event-Wait, Timer, Command, Decision, Control and E-mail while creating worklets/workflows.
• Use the Data Masking transformation to change sensitive production data to realistic test data for non-production environments.
• Worked with PMCMD command line program to communicate with the Informatica server to start, stop and schedule workflows.
• During the project, participated in multiple meetings with the client and data architect / ETL architect to propose better strategies for performance improvement and gathered new requirements.

Environment: Informatica Power center, Teradata, Informatica IDQ, SQL Server, DB2, Business Objects, UNIX.

Confidential

ETL Developer

• Performed major role in understanding the business requirements and designing and loading the data into data warehouse (ETL).
• Used ETL (Informatica) to load data from source to Teradata DW.
• Used Teradata utilities (FLOAD, MLOAD, FastExport) for loading staging tables and exporting data for Target systems.
• Participated in Performance Tuning of ETL maps at Mapping, Session, Source and Target level as well as writing complex SQL Queries from ABSTRACT Data model.
• Used techniques like source query tuning, single pass reading and caching lookups to achieve optimized performance in the existing sessions.
• Used Informatica Workflow Manager and Workflow Monitor to schedule and monitor session status.
• Used Informatica Data Migration to decrease the risk and minimize the errors.
• Created complex Informatica mappings, reusable objects of Mapplets depending on client requirements.
• Responsible for performance tuning for several ETL mappings, Mapplets, workflow session executions.
• Used UNIX Shell scripting for automation of the process, invoking PL/SQL procedures, and Informatica sessions and FTP the files from other systems to Informatica server.
• Implemented performance tuning logic on Targets, Sources, mappings, sessions to provide maximum efficiency and performance.
• Worked on migrating the data from Ab Initio graphs to Informatica mapping through reverse engineering process.
• Performed Smoke testing, Regression testing, Functional testing, Data validation using SQL.
• Analyzed the Test plan, which includes the testing scope, strategy, test requirements and required resources.
• Served as mentoring role for team members and participated in team project planning.
• Assisted the development team and reviewed the required maintenance tasks.

Environment: Informatica PowerCenter 9.0.1, Oracle 10g/11g, SQL, PL/SQL, DB2, Teradata, Unix, Windows.

Confidential

Informatica / Teradata Developer

• Involved in designing the process for getting the data from all systems to Data Warehousing system.
• Performed major role in understanding the business requirements and designing and loading data into data warehouse (ETL).
• Imported various Application Sources, created Targets and Transformations using Informatica PowerCenter Designer (Source analyzer, Transformation developer, Mapplet designer, and Mapping designer).
• Utilized of Informatica IDQ to complete initial data profiling and matching/removing duplicate data.
• Collection of data source information from all the legacy systems and existing data stores.
• Involved in Data Extraction, Transformation and Loading from source systems to ODS.
• Developed complex mappings using multiple sources and targets in different databases, flat files and loading them in to Teradata.
• Used various transformations like Unconnected /Connected Lookup, Aggregator, Expression Joiner, Sequence Generator, Router etc.
• Responsible in the development of Informatica mappings and tuned for better performance.
• Developed and scheduled Workflows using task developer, worklet designer, and workflow designer in Workflow manager and monitored the results in Workflow monitor.
• Worked with Reporting team which utilizes Business Object tools for objects and to address their need from ETL point of view.
• Utilized BTEQ, Mload and FastLoad utility of the Teradata to load data in the Teradata Enterprise Data Warehouse (EDW).
• Experienced and involved in doing Performance tuning for BTEQ and Teradata queries.

Environment: Informatica PowerCenter, IDQ, Oracle 10g/11g, PL/SQL, DB2, Teradata, Toad, Erwin, Unix, Windows.