SUMMARY:

• Over 6 Years of Experience in Information Technology including Data Warehouse/Data Mart development using Informatica Power Center across various industries such as Healthcare, Banking and Retail.
• Strong work experience in ETL life cycle development - Analysis, Design, development, Deployment, Monitoring & Supporting.
• Good working knowledge of various Informatica transformations like Source Qualifier, Dynamic, Static, connected and Unconnected lookups, Expression, Filter, Router, Joiner, Normalizer and Update Strategy transformation.
• Expert-level mastery in designing and developing complex mappings to extract data from diverse sources including flat files, RDBMS tables, legacy system, XML files, Applications.
• Technical and Functional experience in Data warehouse implementations ETL methodology using Informatica Power Center 10.1/9.6.1/9.5.1 / 9.1.1/8.6.1 .
• Strong experience in Data Cleansing, Data profiling and Data Analysis.
• Proficient in implementing Complex business rules by creating re-usable transformations, workflows/worklets and Mappings/Mapplets.
• Experience in Performance Tuning of mappings and sessions at Informatica level by identifying bottlenecks.
• Thorough knowledge of database management concepts like conceptual, logical and physical data modeling and data definition, population and manipulation.
• Experience in Data Migration projects from DB2 and Oracle to Teradata.
• Extensively used Teradata Utilities like Tpump, Fast-Load, Multi-Load, BTEQ and Fast-Export for Teradata loads.
• Involved in Teradata performance Tuning.
• Highly proficient in writing, testing and implementation of triggers, stored procedures, functions, packages, Cursors using PL/SQL.
• Experience of working with Type1, Type2 methodologies for Slowly Changing Dimensions (SCD) management.
• Experience in Task Automation using UNIX Scripts.
• Extensively used Autosys, CA - WA and Control-M for Job Scheduling and monitoring along with Production on call support.
• Strong experience in doing Unit Testing and communicating with QA team on Integration Testing.
• Experience in working with end users for DWH data issues using Trouble Ticket Tools.
• Experience in Agile & Waterfall Methodology. Having strong experience with Scrum Process
• Ability to meet deadlines and handle pressures coordinating multiple tasks in project environment, excellent communication, interpersonal, analytical skills.

TECHNICAL SKILLS:

Data Warehousing/ ETL: Informatica Power Center 10.2/ 10.1/9.6.1/9.5.1 / 9.1.1/8.6.1

Modeling: Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, Erwin, Microsoft Visio.

Databases & Tools: Oracle 11g/10g/9i/8i, Teradata 15/14/12, DB2, SQL Server, My Sql, DB2, Sybase TOAD, SQL Assistant.

QA Tools: Quality Center Autosys, CA WA, and Control

Reporting Tools: Cognos, Hyperion, Business Objects

Programming Languages: Unix Shell Scripting, SQL, PL/SQL.

Environment: Unix, Linux, Windows.

PROFESSIONAL EXPERIENCE:

Confidential, Walnut Creek

ETL Informatica/ Teradata Developer

RESPONSIBILITIES:

• Extensively worked on different phases of SDLC from requirement gathering, analysis, design, development, testing production migration, and supporting.
• Proactively work with other Data Warehouse team members and with the members of other teams (business customers, analysts, developers, and DBA's and technical support staff) to create innovative analytical solutions.
• Developed Conceptual, normalized Logical and Physical data models to design OTLP and Data warehouse environments.
• Involved in Informatica Upgrade process.
• Extensively Used Informatica Workflow Manager to create, schedule, execute and monitor sessions, Work lets and workflows.
• Involved in the development of Informatica mappings and sessions and also tuned their performance for Optimum performance.
• Extensively used all the Transformations like source qualifier, aggregator, filter, joiner, Update Strategy, Unconnected and connected Lookups, Router, Sequence Generator etc.
• Extracted data from various source systems like Oracle, Teradata, SQL Server, flat files and XML files as per the requirements. Designing the ETL process flows to load the data into Oracle Database from Heterogeneous sources.
• Worked with pre and post sessions and extracted data from transaction system into staging area along with knowledge of identifying fact and dimension tables.
• Tuned sources, targets, mappings and sessions to improve the performance of data load. Worked on dimensional models like Star schema and Snowflake schema.
• Experience in production support, ETL executions and resolving root causes.
• Worked on requirements to implement the Change Data Capture (CDC) to record the latest changes in data from the source system.
• Written complex SQL queries for data validation by querying data from different database tables as per the requirement.
• Extensively used UNIX commands for fetching and checking the Log files.
• Worked with Teradata Utilities - BTEQ, M-Load, F-Load, F-Export both Informatica & Scripting level.
• Involved in Tuning both Informatica & DB queries.
• Involved in project status report updates/creation of issue items for reviews/updates oftechnical and transformation files on timely basis.

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

Confidential, OR

ETL Informatica/Teradata Developer

RESPONSIBILITIES:

• Responsible for designing ETL strategy for both Initial and Incremental loads.
• Worked with DAs for understanding the design specifications & requirements.
• Created Business-Crucial Stored Procedures and functions with best execution plan to support efficient data storage and manipulation.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables and optimized the procedures and triggers to be used in production.
• Worked with exception handling in stored procedures.
• Created User Defined Functions (UDF) to encapsulate frequently and commonly used business logic making the system more modular, secured and extensible.
• Writing complex sqls for creating Datasets for reports and dashboards.
• Performed DBA Tasks like backup, restoration of tables and stored procedures and refreshing databases on weekly basis as part of support.
• Incorporated identified factors into Informatica mappings to build the Data Mart.
• Used Informatica Designer to create complex mappings using Source Qualifier, Filter, Connected & Unconnected Lookup, Sorter, Aggregator and Router transformations to pipeline data to Data Mart.
• Used Informatica Workflow Manager to create, schedule, execute and monitor sessions, Work lets and workflows.
• Create Functions, Packages and Triggers in Oracle to implement business rules.
• Responsible to tune ETL procedures and STAR schemas to optimize load and query Performance.
• Experience in using SVN as version control for migration.
• Written Unit test scripts to test the developed interfaces.
• Worked under Agile methodology and used JIRA to track the tasks.
• Performed tuning of SQL queries and Stored Procedure for speedy extraction of data to resolve and troubleshoot issues in OLTP environment.
• Troubleshoot long running sessions and fixing the issues related to it.
• Worked with Teradata Utilities - BTEQ, M-Load, F-Load, F-Export both Informatica & Scripting level.
• Involved in Tuning both Informatica & DB queries.
• Involved in project status report updates/creation of issue items for reviews/updates of technical and transformation files on timely basis.

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

Confidential

ETL Informatica Developer

Responsibilities:

• Collaborated with Business analysts for requirements gathering, business analysis and designing of the Enterprise Data warehouse.
• Involved in requirement analysis, ETL design and development for extracting data from various source systems like MS SQL Server, Oracle, flat files, XML files and loading into Staging and Data Warehouse Star Schema.
• Involved in massive data cleansing prior to data staging and loaded data to Teradata.
• Maintained warehouse metadata, naming standards and warehouse standards for future code development.
• Designed and developed the logic for handling Slowly Changing Dimension Table Type 1/ Type 2.
• Design and Development of ETL Mappings using Joiner, Expression, Aggregator, XML, Rank, Mapplet, connected and unconnected stored procedures and Lookups.
• Extensively used SQL Overrides in Lookups, Source filter and Source Qualifiers.
• Data flow management into multiple targets using Routers was extensively done.
• Converted MS SQL Server DTS Packages logic into Informatica Mappings.
• Created Mappings with shared objects/Reusable Transformations/Mapplet using Mapping/Mapplet Parameters/Variables.
• Analyzed the mortgage and lending data for the reporting needs.
• Created Workflow, Worklets and Tasks to schedule the loads at required frequency using Workflow Manager.
• Configured workflows with Email Task, which would send mail with session log file for Failure of a sessions and for Target Failed Rows.
• Worked with UNIX shell scripts for job execution and automation. Scheduled Informatica workflows using Control M to run at regular intervals.
• Used SQL tools like Query Analyzer and TOAD to run SQL queries and validate the data.
• Tuning the Mappings for Optimum Performance, Dependencies and Batch Design.
• Documented ETL test plans, test cases, test scripts, test procedures, assumptions, and validations based on design specifications for unit testing, system testing, expected results, preparing test data and loading for testing, error handling and analysis.
• Involved in Unit testing, System testing, Integrated testing and User Acceptance Testing to check whether the data was loading into target, which was extracted from different source systems as per the business requirements.
• Involved in jobs scheduling, monitoring and production support activities.

Environment: Informatica Power Center 9.1.1/8.6.1, Control M, Cognos, Oracle 10g/11g, MS SQLServer, Sybase, DB2, Teradata 12, SQL, PL/SQL, TOAD, Sql Assistant, Erwin, Unix, Windows XP.