SUMMARY

• Over 6+ years of experience in IT, with proficiency in software development experience in the field of Data Warehousing using the Informatica ETL tool possessing superior analytical skills and the ability to meet deadlines. Enjoy sharing technical expertise and coordinating projects with team members. Also Teradata developer and strong expertise in SQL queries, stored procedures, Teradata Macros.
• Well versed with all stages of Software Development Life Cycle (SDLC) i.e. Requirement(s) gathering & analyzing, Design/redesign, Implementation and Testing.
• Experience in Business Analysis and Data Analysis, User Requirement Gathering, User Requirement Analysis, Data Cleansing, Data Transformations, Data Relationships, Source Systems Analysis and Reporting Analysis.
• Involved in the requirement definition and analysis in support of Data Warehouse efforts.
• Experienced in designing and developing complex mappings from varied transformation logic like Router, Filter, Expression, Aggregator, Joiner, Update Strategy, Unconnected and Connected lookups, etc.
• Proficient in using Informatica Workflow Manager, Workflow Monitor to create, schedule and control Workflows, tasks and Sessions.
• Strong hands on experience usingTeradata utilities (SQL, B - TEQ, Fast Load, MultiLoad, FastExport, Tpump, Visual Explain, Query man), Teradata parallel support and Unix Shell scripting.
• Re-usability, automation of data loads, Performance Tuning in Informatica by identifying Bottlenecks in Source, Targets or database level and De-bugging/Rectification of data load errors.
• Hands on experience using query tools like TOAD, SQL Developer, PL/SQL developer, Teradata SQL Assistant and Query man.
• Experienced In working with various Scheduling tools likes Autosys, Control-M, Informatica Scheduler and Cronjob.
• Experienced at Creating effective Test data and development thorough Unit test cases to ensure successful execution of the data & used pager for notifying the alerts after successful completion
• Strong experience withETL tool Informatica 8.1/7.1/6.2 andDATA STAGE 8.0.1
• Good knowledge in Unix Shell scripting.
• Experienced in analyzing Functional Requirement Specifications (FRS), Business Requirement Document (BRD) and System Design Specifications (SDS).
• Ambitious, self-motivated, ability to work independently as well as in teams, possess multi-tasking skills, results oriented engineering professional.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.x/8.x/7.x(Designer, Workflow Manager, Workflow Monitor, Repository Manager), OLAP, OLTP, ETL, Autosys, Data Analysis, Data Cleansing, Data Profiling.

RDBMS: Teradata R14.1/R13/R12, Oracle 11g/10g/9i, MS SQL Server 2012/2008/2005

Tools: Teradata SQL Assistant, Teradata Manager, PMON, Putty, TOAD, Control M, Autosys, ERWIN 8.2/7.x/4.x.

Teradata Utilities: BTEQ, Fast load, Multi-Load, Fast Export, Teradata Macros, Query Man

Languages: SQL, PL/SQL, Shell scripting

Testing Tools: QTP, Quality Center, Rational Suite (Requisite Pro, Rose, Robot, Test Manager, Clear Quest, Clear Case), Selenium, HP quick Test Pro.

Operating Systems: UNIX (Sun-Solaris, HP/UX), Win XP, Win 7, Win 8, Unix and Linux

PROFESSIONAL EXPERIENCE

Confidential, Washington DC

ETL Informatica/Teradata Developer

Responsibilities:

• Worked closely with the Enterprise Data Warehouse team and Business Intelligence Architecture team to understand repository objects that support the business requirement and process
• Communicated with business users and analysts on business requirements. Gathered and documented technical and business Meta data about the data.
• Worked in the Scaled Agile Environment.
• Proficient in importing/exporting large amounts of data from files to Teradata and vice versa.
• Developed the DW ETL scripts using BTEQ, Stored Procedures, Macros in Teradata
• Development of scripts for loading the data into the base tables in EDW using FastLoad, MultiLoad and BTEQ utilities of Teradata.
• Extensively worked on data extraction, Transformation and loading data from various sources like Oracle, SQL Server and Flat files.
• Extensive experience in ETL design, development and maintenance using Oracle SQL, PL/SQL, SQL Loader, Informatica Power Center.
• Created, launched & scheduled Workflows/sessions. Involved in the Performance Tuning of Mappings and Sessions.
• Experienced in data profiling & data quality rules development using Informatica Data Quality tools
• Worked in extensively testing and performance tuning of the mapping and logic.
• Extensively used Informatica Client tools - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Informatica Workflow Manager.
• Solid Expertise inOracle Stored Procedures, Triggers, Index, Table Partitions and experienced in Loading data likeFlatFiles, XML Files, Oracle, DB2, SQL Serverinto Data Warehouse/Data Marts using Informatica.
• Created numerous scripts with Teradata utilities BTEQ, MLOAD and FLOAD
• Loading staging tables on Teradata and further loading target tables on Teradata via views.
• Used Joins like Inner Join, Outer join while creating tables from multiple tables.
• Developed reports using the Teradata advanced techniques like rank, row number
• Used various Teradata Index techniques to improve the query performance
• Wrote Case Expressions, Data Manipulation Command by using Teradata (BTEQ).
• Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.
• Developed mapping parameters and variables to support SQL override.
• Created a process control framework to capture statistics of all the loads without having an access to the informatica metadata.
• Designed and developed weekly, monthly reports related to the marketing and financial departments using Teradata SQL.

Environment: Informatica Power Center 9.6.1/9.5.1 , Informatica Power Connect / Power Exchange, Data Analyzer, SQL Developer, UNIX, Teradata 14.10/V13, Teradata SQL Assistant Oracle 10g, Control-M, Teradata PMON/Viewpoint, UNIX, SSH secure shell, ERWIN, UNIX, XML, Microsoft Office (Word, Excel, Access).

Confidential, NYC, NY

ETL Informatica Developer

Responsibilities:

• Responsible for preparing the technical specifications from the business requirements.
• Analyzed the requirements and work out with the solution. Develop and maintain the detailed projectdocumentation.
• Dealt extensively with the data from Oracle 11g, SQL Server.
• Used Informatica Power Center for extraction, transformation and load (ETL) of data in the data warehouse.
• Extensively used Informatica Client tools - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Informatica Workflow Manager.
• Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression and Lookup, Update strategy and Sequence generator and Stored Procedure.
• Developed complex mappings in Informatica to load the data from various sources.
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Developed data Mappings between source systems and warehouse components using Mapping Designer.
• Parameterized the mappings and increased the re-usability.
• Used Informatica Power Center Workflow manager to create sessions, workflows and batches to run with the logic embedded in the mappings.
• Designed and populated dimensional models both star and snowflake schemas for a data warehouse and Data marts.
• Provided support in administration of the Informatica repository Manager and assisted in the design and architecture of multiple repositories to support multiple application development and QA environments.
• Configured File for Parallel extender as per number of processors available to process the data by using Informatica Manager
• Used Informatica Designer for developing various jobs to extract, cleansing, transforming, integrating and loading data into Data warehouse
• Generating of unique keys for composite attributes while loading the data into Data warehouse.
• Develop and debug complex SQL's, UNIX scripts and stored procedures to resolve production issues and in the processing of new source feeds.
• Extensively used various Transformations like Source Qualifier, Aggregator, Filter, Joiner, Sorter, Lookup, Update Strategy, Router, Sequence Generator etc. and used transformation language like transformation expression, constants, system variables, data format strings etc.
• Analyzed the session logs, bad files and error tables for Troubleshooting mappings and sessions
• Performance tuning of mappings, transformations and sessions to optimize session performance.
• Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Participates in bug reviews to see that quality criteria are upheld.
• Suggests designs that facilitate testing and looks for opportunities to automate.

Environment: Oracle 10g/11g, Informatica Power Center 9.5.1/9.1.1 , Power Exchange, UNIX (bash), Oracle11g, Control M, Toad, SQL, PL/SQL, Flat files, Unix Shell Scripting and Windows.

Confidential, Frederick, MD

ETL/Teradata Developer

Responsibilities:

• Participated in the design phase of the project
• Created Scripts using Teradata utilities (Fast load, Multi load, Fast export, Tpump, BTEQ)
• Used loader utilities to load flat files into Teradata RDBMS
• Performed high volume maintenance on large Teradata tables using MultiLoad loader utility
• Involved in Datawarehouse development using Teradata, Oracle and Unix
• Participated in Data mapping sessions with the Data modeller
• Developed load scripts from Source to target such as MIDE, MODE,SHUB into a centralized ODS called CMIE
• Analyzed the existing CDC technique used by Oracle to implement using Ab initio
• Used various Teradata Index techniques to improve the query performance
• Created Unix Scripts to run Teradata Scripts
• Performed Data profiling on the source data and created a list of valid values to populate the domain table list.

Environment: Teradata 13.1/12, Teradata SQL Assistant, MVS, DB2, JCL, File aid, Control-M, Teradata PMON/Viewpoint, UNIX, SSH secure shell

Confidential, Ohio

ETL/Teradata developer

Responsibilities:

• Involved in analysis, requirements gathering, function/technical specifications, development, deploying and testing.
• Used the Informatica Power Center Designer to develop the required mapping based on the ETL spreadsheet.
• Coordinated with BSA, Development and QA teams during System Integration and User Acceptance Testing to accurately resolve the issues.
• Created various transformations like Filter, Router, Lookups, Stored Procedure, Joiner, Update Strategy, Expressions and Aggregator to pipeline data to Data Warehouse/Data Marts and monitored the Daily and Weekly Loads.
• Written Teradata Bteq scripts to implement the business logic.
• Coded Mload and Fload scripts to load the data files into Teradata.
• Extracted data from existing data source and performed ad-hoc queries using SQL.
• Worked on tables (Like Set, Multiset, Derived, Volatile, Global Temporary), views, using SQL scripts
• Involved in query Performance Tuning for accessing the data fast.
• Exported data into flat files in .csv, tab fixed delimiters and etc. formats.
• Used various Informatica Error Handling techniques to debug failed session.
• Helped Production Support team during monthly runs and crisis.
• Performed bulk data loads from multiple data sources to Teradata Warehouse using BTEQ, Fastload, Multiload and Tpump.

Environment: Informatica Power Center 8.1.1, Teradata 12, SQL Assist Oracle 10g, SQL, PL SQL, MS Excel, PowerPoint, Windows XP.