PROFESSIONAL SUMMARY:

• 9 Plus years of IT experience in Analysis, Design, Development, Implementation, Testing and Support of Data Warehousing and Data Integration Solutions using Informatica Power Center 10.1/ 9.6.1/9.5.1 /8.6.1/8.1.1.
• Strong expertise in Full Life Cycle development of Data Warehousing including requirements gathering, design, development, unit testing and documentation.
• Expertise in working with databases Oracle 12c/11g/10g/9i, Teradata 14/12, SQL Server 2008/2012, DB2, My Sql, Sybase.
• Experience in utilizing Teradata utilities like TPT, Fast Load, Multi Load, Fast Export and BTEQ scripts.
• Solid Experience in Informatica and Teradata mix in DWH development.
• Strong experience in Dimensional Modeling using Star and Snow Flake Schema, Identifying Facts and Dimensions, Physical and logical data modeling using Erwin and ER - Studio.
• Experience in working with Informatica Data Quality 9.5.1 (IDQ).
• Extensive experience in developing Stored Procedures, Functions, Views and Triggers, Complex SQL queries using SQL Server, TSQL and Oracle PL/SQL.
• Developed complex mappings using Informatica Power Center Transformations - Lookup Connected & Un Connected, Filter, Expression, Router, Joiner, Update Strategy, Aggregator, Stored Procedure, Sorter, Java, and Sequence Generator.
• Expertise in implementing performance tuning techniques both ETL & Database level.
• Experience in doing Unit testing & Documenting, working with QA for Integration testing also for UAT with Business Users.
• Expertise in implementing ETL Standards & Code Development Procedures.
• Extensive involvement writing UNIX shell scripts for automation.
• Worked extensively with Change Data Capture (CDC) & Slowly Changing Dimensions Types (1 & 2).
• Experience with Supporting Heavy Data warehouse applications.
• Experience working in Waterfall & Agile Methodologies.
• Experience in using different scheduling tools - Control-M, Auto Sys, Maestro/TWS & Cron Job.
• Self-Motivated and Ability to Drive Data warehouse projects independently.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 10.1/ 9.6.1/9.5.1 /8.6.1/8.1.1.

Databases: Oracle 12c/11g/10g/9i/8i, Teradata 15/14/12, DB2, SQL Server 2008/2012/2015, MySQL, Sybase.

Modeling: Dimensional Data Modeling, Star Schema Modeling, Snow - flake Schema Modeling, Erwin, Microsoft Visio, HOLAP, MOLAP, ROLAP.

Operating System: Windows, Unix, Linux

Reporting Tools: Cognos, Business Objects, Micro Strategy, Tableau

Languages: UNIX Shell Scripting, SQL, PL/SQL, T-SQL, Python.

PROFESSIONAL EXPERIENCE:

Confidential, Los Angeles, CA

Sr. Informatica/Teradata Developer

Responsibilities:

• Used Informatica as ETL tool to pull data from source systems/ files, cleanse, transform and also load data into the Teradata using Teradata Utilities.
• Involved in Requirement analysis in support of Data Warehousing efforts along with Business Analyst and working with the QA Team in Waterfall methodology.
• Loaded data in to the Teradata tables using Teradata Utilities BTEQ, Fast Load, Multi Load, and Fast Export and TPT.
• Compliance to SDLC and SOX in all aspect of application development.
• Worked with various Informatica Power Center objects like Mappings, transformations, Mapplet, Workflows and Session Tasks.
• Extensively worked with various Passive transformations like Expression, Lookup, Sequence Generator, Mapplet Input and Mapplet Output transformations.
• Extensively worked in the performance tuning of Teradata SQL, ETL and other processes to optimize session performance.
• Involved in Initial loads, Incremental loads and Daily loads to ensure that the data is loaded in the tables in a timely and appropriate manner.
• Writing scripts in Python for scheduling tasks.
• Writing Teradata Macros and used various Teradata analytic functions.
• Created detailed Technical specifications for Data Warehouse and ETL processes.
• Extensively used Pre-SQL and Post-SQL scripts for loading the data into the targets according to the requirement.
• Developed mappings to load Fact and Dimension tables, SCD Type 1 and SCD Type 2 dimensions and Incremental loading and unit tested the mappings.
• Successfully upgraded Informatica 9.6.1 and to 10.1 and responsible for validating objects in new version of Informatica.
• Responsible for Unit Testing, Integration Testing and helped with User Acceptance Testing.
• Worked extensively with different Caches such as Index cache, Data cache and Lookup cache (Static, Dynamic and Persistence) while developing the Mappings.
• Experience in using SVN as version control for migration.
• Developed Schedules for daily and weekly batches using Maestro/TWS.
• Managed enhancements and coordinated with every release with in Informatica objects.
• Provided support for the production department in handling the data warehouse.

Environment: Informatica Power Center 10.2/ 9.6.1/9.5.1, Oracle 12c/11g, DB2, Teradata 15/14, Flat Files, Erwin 4.1.2, TWS, Sql Assistant, TOAD, UNIX, Windows, SVN.

Confidential, Pleasanton, CA

Sr. Informatica/Teradata Developer

Responsibilities:

• Loading data from various data sources and legacy systems into Teradata production and development warehouse using BTEQ, FASTEXPORT, MULTI LOAD, FASTLOAD and Informatica.
• Providing periodic update to customer on the coding, unit testing, release and act as Coordinator between development and business team.
• Created mapping documents to outline data flow from sources to targets. Parsed high-level design specification to simple ETL coding and mapping standards.
• Used Metadata manager for validating, promoting, importing and exporting repositories from development environment to testing environment.
• Hands on experience in Informatica cloud in migrating data from Informatica cloud to Informatica Power Center.
• Developed Schedules for daily and weekly batches using Maestro.
• Creating and modifying MULTI LOADS for Informatica using UNIX and Loading data into IDW.
• Involved in production support when required.
• Performed Proof of Concept for Informatica Data Quality (IDQ).
• Performed data quality analysis, gathered information to determine data sources, data targets, data definitions, data relationships, and documented business rules.
• Worked on loading Flat Files in to Data warehouse.

Environment: Informatica 9.6.1/9.5.1, Informatica Data Quality 9.5.1 (IDQ), Teradata 14, Informatica Cloud, DB2, Oracle, Flat Files, Maestro, Sql Assistant, UNIX, Windows.

Confidential

Sr. Informatica Developer

Responsibilities:

• Worked on Informatica - Source Analyzer, Warehouse Designer, Mapping Designer & Mapplet, and Transformations
• Developed Informatica mappings & tuning them for better performance
• Created Informatica mappings with PL/SQL procedures/functions to build business rules to load data. Used most of the transformations such as the Source qualifier, Aggregators, Connected & Unconnected Lookups, Filters & Sequence Generator.
• Provided 24 X 7 supports to all the applications.
• Fixing invalid Mappings, testing of Stored Procedures and Functions, Unit and Integration Testing of Informatica Sessions, Batches and Target Data.
• Work with System/business analysis to eliminate various manual processes and permanent fix for various productions.
• Created the reports for different regions and demands for future forecasting
• Extracted data from various sources like relational databases Oracle, flat files.
• Designed and created Fact tables and Dimensions
• Scheduled and monitored automated daily, weekly, monthly jobs.
• Optimized Query Performance, Session Performance and Reliability.
• Responsible for Unit Testing, Integration Testing and helped with User Acceptance Testing.
• Tuned the performance of mappings by following Informatica best practices and also applied several methods to get best performance by decreasing the run time of workflows.
• Worked extensively on Informatica Partitioning when dealing with huge volumes of data and also partitioned the tables in Teradata for optimal performance.
• Scheduling Informatica jobs and implementing dependencies if necessary using Autosys.

Environment: Informatica Power Center 9.1.1, Flat Files, Oracle 11g, Teradata 12/13, SQL, PL/SQL, TOAD, SQL Assistant, Windows XP, Unix, Perl, Maestro.

Confidential

ETL Developer

Responsibilities:

• Developed mappings using Mapping Designer and worked with Aggregator, Lookup (connected and unconnected), Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, Sorter and Sequence Generator transformations.
• Worked on all phases of SDLC from requirement gathering, design, development, testing and support for production environment.
• Extensively used Informatica Client tools like Informatica Repository Manager, Informatica Designer, Informatica Workflow Manager and Informatica Workflow Monitor.
• Used Teradata utilities FASTLOAD, MULTILOAD, TPUMP to load data.
• Involved in migration projects to migrate data from data warehouses on Oracle/DB2 and migrated those to Teradata.
• Provided 24x7 supports for Production environment for Extraction, Loading and transformation of data by remote monitoring.
• Created Sources, Targets in shared folder and developed re-usable transformations, mapplets and user defined function (UDF) to re-use these objects in mappings to save the development time.
• Created mappings which involved Slowly Changing Dimensions Type 1 and Type 2 to implement business logic and capturing the deleted records in the source systems.
• Involved in migration projects to migrate data from data warehouses on Oracle/DB2 and migrated those to Teradata.
• Experience with high volume datasets from various sources like Oracle, Text Files and Teradata Tables and XML targets.
• Used debugger extensively to identify the bottlenecks in the mappings.
• Modified PL/SQL stored procedures for Informatica mappings.
• Created Sessions and Workflows to load data from the SQL server, flat file and Oracle sources that exist on servers located at various locations all over the country.
• Configured the session properties i.e. high value for commit intervals to increase the performance.
• Involved in unit testing, Integration testing and User acceptance testing of the mappings.
• Involved in Migrating the Informatica objects using Unix SVN from Dev to QA Repository.
• Worked on developing workflows and sessions and monitoring them to ensure data is properly loaded on to the target tables.
• Responsible for scheduling workflows, error checking, production support, maintenance and testing of ETL procedures using Informatica session logs.
• Performance tuning on sources, targets mappings and SQL (Optimization) tuning.

Environment: Informatica Power Center 8.6.1/9.1.1 (Power Center Designer, workflow manager, workflow monitor), Oracle 10g, SQL Server 2008, Erwin, UNIX, Windows 2000, TOAD

Confidential

ETL Developer

Responsibilities:

• Extensively used ETL to load data from Flat Files, XML, and Oracle to oracle.
• Project Analysis and documenting the requirements.
• Involved in Designing of Data Modeling for the Data warehouse.
• Involved in Requirement Gathering and Business Analysis.
• Developed data Mappings between source systems and warehouse components using Mapping Designer.
• Worked extensively on different types of transformations like source qualifier, expression, filter, aggregator, rank, update strategy, lookup, stored procedure, sequence generator, joiner, XML.
• Involved in the performance tuning of the Informatica mappings and stored procedures and the sequel queries inside the source qualifier.
• Created, launched & scheduled sessions.
• Involved in the Performance Tuning of Database and Informatica.
• Improved performance by identifying and rectifying the performance bottle necks.
• Wrote PL/SQL Packages and Stored procedures to implement business rules and validations.
• Analyze, design, build, test and document complex data conversion and integration solutions
• Performed Unit testing and maintained test logs and test cases for all the mapping
• Work with business groups to develop and implement business rules to be used for ETL processes

Environment: Informatica Power Center 8.6.1/9.1.1, Oracle 10g, UNIX, Windows, UNIX Shell Programming, PL/SQL, TOAD Quest Software

Confidential

ETL Informatica Developer

Responsibilities:

• Used ETL to extract and load data from Oracle, Flat Files to Oracle DWH.
• Developed Informatica Mappings to capture data changes from the operational sources systems into data warehouse and data marts (SCD mappings).
• Created Various Complex Transformations such as Update Strategy, Look Up, Filter and Router Transformations.
• Created basic and aggregate levels of Fact Table mapping and optimized them for incremental Extraction and Aggregation using Parameters and variables to pass values during workflow execution.
• Created and Monitored Work Flows using Workflow Manager and Work Flow Monitor.
• Involved in the development and implementation of the Enterprise Data Warehousing (EDW) process and Data Warehouse.
• Created Workflows / Worklets and scheduled them using workflow manager.
• Developed Mapping to load data in Slowly Changing Dimensions.
• Ensuring proper Dependencies and Proper running of loads (Incremental and Complete loads).
• Performed Unit testing and maintained test logs and test cases for all the mapping
• Perform data validation tests using complex SQL statements.
• Perform Tuning of Sessions and Mappings.

Environment: Informatica Power Center 8.6.1, Oracle 10 g, UNIX, Windows.