SUMMARY

• Around 5 years of professional experience in information technology with extensive experience in development of various projects using Data Warehousing tools like Informatica Power Center, Teradata.
• Hands on Experience using Teradata Fastload, Multiload, Tpump, Fastexport, and Teradata SQL Assistant and BTEQ utilities.
• Knowledge in using Teradata EXPLAIN plans, Collect Stats option, Primary Indexes (PI, NUPI), Secondary Indexes (USI, NUSI), Partition Primary Index (PPI), Join Indexes (JI), Volatile, global temporary, derived tables etc.
• Experience in Integration of various data sources like Oracle, SQL Server, Fixed Width and Delimited Flat Files, DB2 and XML Files.
• Created complex and reusable mappings using Lookup, Joiner, Aggregator, Stored procedure, Update Strategy and various other transformations.
• Excellent background in gathering business requirements and translate them into technical specifications to develop ETL and reporting solutions.
• Developed effectively different type of SCD’s (Slowly Changing Dimensions) based on the specifications.
• Experience in identification of Facts, Measures, Dimensions and hierarchies for OLAP & OLTP models.
• Hands - on expertise in Stored Procedures, PL/SQL, SQL, Packages, Triggers, Functions and Query optimization.
• Capable of managing teams, Onsite/Offshore coordination, Requirement Analysis, Code reviews, implementing standards, Production release management.
• Experience in interacting with Business users in analyzing the Business process requirements and transforming them into documenting, designing, and rolling out the deliverables.
• Excellent organizational skills and ability to prioritize workload.
• Basic knowledge in Data Stage Concepts.
• Eager and interested to learn other ETL technology like Talend.

TECHNICAL SKILLS

• Tools: Informatica Power Center Source Analyzer, Mapping Designer, Workflow ETL Monitor, Workflow Manager, Data Cleansing, Data Quality, Informatica Analyst 9.1, Informatica Developer 9.1, Repository, Metadata, Data Mart, OLAP, OLTP, Web services, Power Mart Informatica Data - Analyzer 9.1, Power Exchange 8.
• Teradata Utilities: BTEQ, Fast Load, Multiload, TPT, TPump, SQL Assistant, Viewpoint, Query Monitor
• RDBMS: Oracle IBM-DB2, MS SQL Server, Teradata, Netezza 6.0.4 MS Access.
• Web Tools: XML, Java Script.
• Other tools & Utilities: SQL* Plus, TOAD, Auto Sys.
• Languages: SQL, C and C++.
• Scripting languages: UNIX Shell Scripting.
• Operating systems: Windows UNIX (Sun Solaris, AIX), LINUX

PROFESSIONAL EXPERIENCE

Confidential, NC

Informatica/Teradata Developer

Responsibilities:

• Interacted with business users, analysts to gather, understand, analyze, program and document the requirements of Data Warehouse.
• Designed the ETL processes using Informatica to load the data from sources like DB2, XML and Flat Files to target Flat Files and from DB2 to DB2 and from Flat Files to Flat Files (Delta process).
• Responsible for Performance Tuning at the Mapping Level, Session Level, Source Level and the Target Level for Slowly Changing Dimensions Type1, Type2 for Data Loads.
• Built various SQL scripts and automated Batch Processes.
• Worked on identifying Mapping Bottlenecks and improved session performance through error handling.
• Worked on Mapplets and created parameter files wherever necessary to facilitate reusability.
• Used Error Handling to capture error data in tables for handling nulls, analysis and error remediation Process.
• Extensively used Informatica Functions LTRIM, RTRIM, DECODE, ISNULL, IIF, INSTR and date functions in Transformations.
• Effectively worked on Mapping Designer, Workflow Manager, and Workflow Monitor.
• Developed complex mappings and SCD Type-I, Type-II and Type-III mappings in Informatica to load the data from various sources using different transformations like Source Qualifier, Lookup (connected and unconnected), Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Rank and Router. Created complex mapplets for reusable purposes.
• Used shortcuts for sources, targets, transformations, Mapplets, and sessions to reuse objects without creating multiple objects in the repository and inherit changes made to the source automatically.
• Used the SQL procedures for Informatica mappings for truncating the data in target tables at run time.
• Tuned and Optimized SQL Queries using Execution Plan and Profiler and re-building indexes and Tables as part of Performance Tuning Exercise. Successfully reduced process time of 20 ETL processes by 50%.
• Created alerts for successful or unsuccessful completion of scheduled jobs. Developed ad-hoc queries for stakeholders and automated batch processes.
• Addressed bugs / tickets raised in production for existing mappings in common folder for new files through versioning (Check in and Check out) on an urgency through support for QA in component unit testing and validation.

Stack: Teradata 14.10, 13.x, Informatica Power Center 9.5.6, UNIX, Enterprise Manager, SQL Profiler, Query Analyzer, SQL Server Management Studio, DTS, SSIS, SSRS, SSAS, SharePoint, SQL Developer.

Confidential - Dallas

Informatica Developer

Responsibilities:

• Collaborate with stakeholders and assess business rules & translate requirements into sustainable and efficient programs and solutions.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Power Center 9.1.
• Interfaced with various members of the technical and business team to translate the business reporting and data maintenance requirements into functional ETL code.
• Created and Configured Workflows, Worklets and Sessions to transport the data to target tables using Informatica Workflow Manager.
• Basic idea on Informatica Admin Console.
• Used Informatica Partitioning to improve session performance.
• Used various transformations like Source Qualifier, Aggregator, Filter, Router, Sequence Generator, and lookup, Rank, Joiner, and Expression to meet business logic in the mappings.
• Created reusable transformations and Mapplets to use in multiple mappings.
• Used mapping parameters and variables.

Environment: Informatica Power Center 9.0.1 (ETL), Teradata 14, Windows XP, Appworx.

Confidential

Informatica Developer

Responsibilities:

• Involved while communicating with business analysts and users to know their requirements.
• Extracted data from different source systems like SQL Server, Flat files.
• Extensively worked with Informatica Power Center tools (Repository Manager, Designer, Workflow Manager, and Workflow Monitor).
• Reduced the execution time by creating Mapplets, Worklets, Reusable Transformations, and Reusable Sessions.
• Used Informatica features to implement Slowly Changing Dimensions.
• Worked on mapping parameters and mapping variables..
• Worked with BTEQ, Fast Load, Multi Load, SQL Assistant, Indices (PI, SI).
• Used various transformations like Expression, Normalizer, Sorter, Aggregator, Joiner, Source Qualifier, Router, Stored Procedure, Lookup, and Filter to develop mappings or Mapplets.
• Involved in Performance tuning at source, target, mappings, sessions, and system levels.
• Analyzed Query using Explain Plan, collect stats to optimize SQL queries.
• Reviewed and analyzed functional requirements, mapping documents, problem solving and trouble shooting.

Environment: Informatica Power Center, SQL Server, Flat Files, Windows, Teradata, MS SQL Server 2014, Management Studio