PROFESSIONAL SUMMARY:

• 5 Plus Years of specialized IT experience in building Enterprise Data Warehouse, Data Marts, Operational data stores in major industry sectors using Informatica Power Center 10.x, 9.x, 8.x.
• Strong Focus on Software Development Life Cycle (SDLC) with design, concept, architecture, planning, modeling, coding, development, testing, implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP.
• Expertise in working with relational databases such as Oracle 12c/11g/10g/9i, Teradata 15/14/13/12, SQL Server 2008/2015/2017 , DB2, My Sql, Sybase.
• Strong experience working with Business Analyst & Modelers to understand the requirements, Model.
• Expertise in working with various transformations using Aggregator, lookup, update strategy, joiner, filter, sequence generator, normalizer, sorter, router in Informatica power center designer.
• Proficiency in data warehousing techniques for data cleansing, slowly changing dimension phenomenon (SCD - Type 1& Type 2), surrogate key assignment, change data capture (CDC).
• Hands on experience with Teradata utilities like BTEQ, Fast Export, Fast Load, and Multi Load to export and load data to/from different source systems including flat files.
• Expertise in creating Databases, Users, Tables, Macros, Views, Joins and Hash Indexes in Teradata Database.
• Proficient knowledge in different phases of testing like Unit, Integration testing and Regression testing.
• Excellent communication and interpersonal skills.
• Experience in Business Requirement document and Functional Requirement document (BRD & FSD).
• Extensive experience in writing UNIX shell scripts and automation of the ETL processes using UNIX shell scripting. Worked with PMCMD to interact with Informatica Server from command mode.
• Expertise in OLTP/OLAP System Study, Understanding E-R modeling and Dimensional Models using Star schema and Snowflake schema techniques, Identifying Facts and Dimensions.
• Experienced in fast paced Agile Development Environment with JIRA as a ticketing tool and methodologies including Scrum.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 10.2/ 9.6.1/9.5.1 /8.6.1 , Datastage

Modeling: Dimensional Data Modeling, Star Schema Modeling, Snow - flake Schema Modeling, E-R Modeling.

RDBMS: Oracle 12c/11g/10g, Teradata 15/14/13/12, DB2, SQL Server, MySQL, Sybase

Reporting Tools: Cognos, Business Objects, Tableau

Scheduling Tools: Control M, Autosys, Maestro, Cron Job

Languages: XML, UNIX Shell Scripting, SQL, PL/SQL, TSQL

Operating Systems: Windows, Unix, Linux

PROFESSIONAL EXPERIENCE:

Confidential, Woodland Hills, CA

Sr. ETL Informatica Developer

Responsibilities:

• 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 Power Center Designer (Source Analyzer, Warehouse developer, Transformation developer, Mapplet designer, and Mapping designer).
• 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 tuning 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.
• Extensively used Dynamic lookup to implement the type 2 changes.
• Implemented various loads like Daily Loads, Weekly Loads, and Quarterly Loads using Incremental Loading Strategy using the concepts of Change Data Capture (CDC).
• Utilized BTEQ , Mload and FastLoad utility of the Teradata to load data in the Teradata Enterprise Data warehouse (EDW ).
• Used PMCMD commands of Informatica in UNIX scripts to schedule workflows and jobs.
• Used Maestro to schedule jobs.
• Performed unit testing & Integration testing.
• Involved in code migration activities and deployments.
• Implemented organization level Informatica best Standards & Procedures.
• Involved in solving various trouble tickets raised by Business users as part of application support team.

Environment : Informatica Power Center 10.2/9.6.1, Oracle 12c/11g, DB2, Teradata 15/14, Sql Assistant, Toad, Erwin, Business Object, Unix, Windows.

Confidential, Eden Prairie, MN

ETL Informatica Developer

Responsibilities:

• Developed internal and external Interfaces to send the data in regular intervals to Data warehouse systems.
• Extensively used Power Center to design multiple mappings with embedded business logic.
• Involved in discussion of user and business requirements with business team.
• Performed data migration in different sites on regular basis.
• Involved in upgrade of Informatica from 9.1 to 9.5.
• Created complex mappings using Unconnected Lookup, Sorter, and Aggregator and Router transformations for populating target tables in efficient manner.
• Attended the meetings with business integrators to discuss in-depth analysis of design level issues.
• Extensively involved in performance tuning of the Informatica ETL mappings by using the caches and overriding the SQL queries and also by using Parameter files.
• Developed complex SQL queries to develop the Interfaces to extract the data in regular intervals to meet the business requirements and extensively used Teradata Utilities like M - load, F- Load, TPT, BTEQ and Fast Export.
• Analyzed session log files in session failures to resolve errors in mapping or session configuration.
• Written various UNIX shell Scripts for scheduling various data cleansing scripts, loading process and automating the execution of maps.
• Created transformations like Expression, Lookup, Joiner, Rank, Update Strategy and Source Qualifier transformation using the Informatica designer.
• Created mapplet and used them in different mappings.
• Worked on Flat Files and XML, DB2, Oracle as sources.
• Written PL/SQL Procedures and functions and involved in change data capture (CDC) ETL process.
• Implemented Slowly Changing Dimension Type II for different Dimensions.
• Involved in Informatica, Teradata and oracle upgrade process and testing the environment while up gradation.
• Worked with Informatica version Control excessively.
• Experience in using SVN as version control for migration.
• Managed enhancements and coordinated with every release with in Informatica objects.
• Provided support for the production department in handling the data warehouse.
• Worked under Agile methodology and used Rally tool one to track the tasks.
• Written thorough design docs, unit test documentation, Installation and configuration guide documents.
• Performed bulk data imports and created stored procedures, functions, views and queries.

Environment: Informatica Power Center 9.6.1/9.5.1 , Teradata 14/12, Oracle 10g, DB2, XML, Flat Files, Sql Assistant, Toad, PL/SQL, Unix shell scripting, Cognos, SVN, Windows 7.

Confidential

Informatica ETL Developer

Responsibilities:

• Involved in Requirement analysis in support of Data Warehousing efforts
• Maintain Data Flow Diagrams (DFD’s) and ETL Technical Specs or lower level design documents for all the source applications
• Worked with source databases like Oracle, SQL Server and Flat Files
• Extensively worked with various Active transformations like Filter, Sorter, Aggregator, Router and Joiner transformations
• Extensively worked with various Passive transformations like Expression, Lookup, Sequence Generator, Mapplet Input and Mapplet Output transformations
• Created complex mappings using Unconnected and Connected lookup Transformations
• Implemented Slowly changing dimension Type 1 and Type 2 for change data capture
• Worked with various look up cache like Dynamic Cache, Static Cache, Persistent Cache, Re Cache from database and Shared Cache
• Responsible for definition, development and testing of processes/programs necessary to extract data from client's operational databases, transform, cleanse data and load it into data marts
• Worked with various Informatica PowerCenter objects like Mappings, transformations, Mapplet, Workflows and Session Tasks
• Responsible for the performance tuning of the ETL process at source level, target level, mapping level and session level
• Worked extensively with update strategy transformation for implementing inserts and updates
• Extensively used the tasks like email task to deliver the generated reports to the mailboxes and command tasks to write post session and pre session commands
• Extensively used debugger to test the logic implemented in the mappings
• Performed error handing using session logs
• Tuned performance of Informatica session for large data files by increasing block size, data cache size and target based commit interval
• As per business we implemented Auditing and Balancing on the transactional sources so that every record read is either captured in the maintenance tables or wrote to Target tables
• Auditing is captured in the audit table and EOD snapshot of daily entry is sent to the distributed list to analyze if anything is abnormal
• Monitored workflows and session using Power Center workflows monitor
• Used Informatica Scheduler for scheduling the workflows

Environment: Informatica Power Center 9.6.1, Oracle, Sql Server, SQL, PL/SQL, Cognos, Unix and windows XP.

Confidential

Jr. Informatica ETL Developer

Responsibilities:

• Maintain Data Flow Diagrams (DFD’s) and ETL Technical Specs or lower level design documents for all the source applications.
• Extensively worked with various Active transformations like Filter, Sorter, Aggregator, Router and Joiner transformations.
• Extensively worked with various Passive transformations like Expression, Lookup, Sequence Generator, Mapplet Input and Mapplet Output transformations.
• Worked with source databases like Oracle, SQL Server and Flat Files.
• Responsible for definition, development and testing of processes/programs necessary to extract data from client's operational databases, transform, cleanse data and load it into data marts.
• Created complex mappings using Unconnected and Connected lookup Transformations.
• Responsible for the performance tuning of the ETL process at source level, target level, mapping level and session level.
• Implemented SCD Type 1 and Type 2 for change data capture.
• Worked with various look up cache like Dynamic Cache, Static Cache, Persistent Cache, Re Cache from database and Shared Cache.
• Worked extensively with update strategy transformation for implementing inserts and updates.
• Worked with various Informatica Power Center objects like Mappings, transformations, Mapplet, Workflows and Session Tasks.
• Auditing is captured in the audit table and EOD snapshot of daily entry is sent to the distributed list to analyze if there are any abnormalities.
• As per business we implemented Auditing and Balancing on the transactional sources so that every record read is either captured in the maintenance tables or wrote to Target tables.
• Tuned performance of Informatica session for large data files by increasing block size, data cache size and target based commit interval.
• Monitored workflows and session using Power Center workflows monitor.
• Used Informatica Scheduler for scheduling the workflows.
• Monitoring the Extraction and loading processes of data and Involved in writing UNIX shell scripting for automating the jobs.

Environment: Informatica Power Center 9.6.1/9.5.1 , Oracle, Sql server, My Sql, Flat Files, Teradata 12/13, Cognos, Unix and Windows XP.

Confidential

Jr. Informatica ETL Developer

Responsibilities:

• Understanding the Business requirements based on Functional specification to design the ETL methodology in technical specifications.
• Consolidation, standardization, matching Trillium for the unstructured flat file data.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Power Center 8.5
• Worked on integration of heterogeneous data sources like Oracle, DB2, SQL Server and Flat Files (Fixed & delimited) into Staging Area
• Wrote SQL-Overrides and used filter conditions in source qualifier thereby improving the performance of the mapping.
• Designed and developed mappings using Source Qualifier, Expression, Lookup, Router, Aggregator, Filter, Sequence Generator, Stored Procedure, Update Strategy, Joiner and Rank transformations.
• Managed the Metadata associated with the ETL processes used to populate the Data Warehouse.
• Implemented complex business rules in Informatica Power Center by creating re-usable transformations, and robust Mapplets.
• Implemented performance tuning of Sources, Targets, Mappings and Sessions by identifying bottlenecks and used Debugger to debug the complex mappings and fix them.
• Improved session Performance by enabling property incremental aggregation to load incremental data into target table.
• Worked with Functional team to make sure required data has been extracted and loaded and performed the Unit Testing and fixed the errors to meet the requirements.
• Copied/Exported/Imported the mappings/sessions/ worklets /workflows from development to Test Repository and promoted to Production.
• Used Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows based on changing variable values.