SUMMARY

• 8 Plus years of experience in Information Technology with building & supporting Data Warehouse/Data Mart using Informatica Power Center 10.2/9.6.1/ 9.5.1/9.1.1 /8.6.1 /8.1.1
• Strong work experience in Data Warehouse lifecycle process.
• Involved in understanding of Business Processes, grain identification, identification of dimensions and measures (Facts).
• Extensive knowledge on Understanding Data Modeling(ER & Dimensional Modeling), doing Data Integration and Data Migration.
• Extensive experience in working with different RDBMS Oracle, Teradata, My Sql, SQL Server, DB2, Sybase and also with File base system - Flat Files & XML Files.
• Extensive experience in designing and developing complex mappings using transformations lookups (Connected & Un Connected), Normalizer, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, java and Update Strategy.
• Expert on implementing Slowly Changing Dimensions Type 1, Type 2 and Type 3 for inserting and updating Target tables for maintaining the history.
• Expert on Implementing Change Data Capture (CDC) for handling Incremental loads.
• Experience on Mapping Debugger to validate the mappings and gain troubleshooting information about data and error conditions.
• Experience on post-session and pre-session shell scripts for tasks like merging flat files after Creating, deleting temporary files, changing the file name to reflect the file generated date etc.
• Extensively used Informatica Mapping Parameters and variables.
• Extensively worked with Informatica performance tuning involving Identifying and eliminating bottlenecks.
• Experience with Integrating Informatica with Teradata and using Teradata features.
• Extensive experience with Teradata utilities like BTEQ, Fast Export, Fast Load, Multi Load & Tpump also with TPT.
• Proficient in 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.
• Expertise in performance tuning and query optimization of the Teradata SQLs.
• Experience with Unit Testing, working with QA team on System testing also involved in UAT.
• Experience with ETL Migrations & Code deployments also involved with Post production validations.
• Solid experience in writing SQL queries, Stored Procedures.
• Experience in working with UNIX Shell Scripts for automatically running sessions, aborting sessions and creating adhoc parameter files. Written number of shell scripts to run various batch jobs.
• Involved in supporting Heavy DWH production system in rotational process.
• Experienced being on top of head in fixing production failures without effecting business and dependencies.
• Experienced working with Business Users as part of supporting DWH data issues through ticketing system raised by users.
• Implemented Data Warehouse projects both in Agile and Water Fall Methodologies and good understanding on Scrum process.
• Excellent interpersonal and communication skills, capable of driving the DWH projects independently.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 10.2/9.6.1/ 9.5.1/9.1.1 /8.6.1

Databases: Teradata15/14/13/12, Oracle, MS SQL Server, My Sql, DB2

Reporting: Cognos, Business Objects, Dashboard Reporting

Tools: Toad, SQL developer, Sql Assistant

Languages: Unix shell Script, SQL, PL/SQL, Java, Perl

Process/Methodologies: Waterfall Methodology, Agile Methodology (Rally/Jira)

Operating Systems: Windows, Unix & Linux

PROFESSIONAL EXPERIENCE

Confidential, Hartford, CT

Senior ETL Informatica Specialist

Responsibilities:

• Perform requirement analysis through coordination with business analysts and define business and functional specifications.
• As a team conducted gap analysis and Discussions with subject matter experts to gather requirements, emphasize on problem areas and define deliverables.
• Logical and Physical data modeling was done using Erwin for data warehouse database in STAR SCHEMA.
• Using Informatica Power Center Designer analyzed the source data to Extract & Transform from various source systems (oracle 11g, DB2, SQL server and flat files) by incorporating business rules using different objects and functions that the tool supports.
• Using Informatica Power Center created mappings and mapplets to transform the data according to the business rules.
• Designed the ETL mappings between sources to operational staging targets, then to the data warehouse using Power center Designer.
• Involved in Design, analysis, Implementation, Testing and support of ETL processes for Stage, ODS and Mart.
• Documented Informatica mappings in Excel spread sheet.
• Developed mappings/Reusable Objects/Transformation/mapplets by using mapping designer, transformation developer and mapplet designer in Informatica Power Center.
• Worked with Informatica power center Designer, Workflow Manager, Workflow Monitor and Repository Manager.
• Used Informatica Power Center to migrate the data from different source systems.
• Extensively used Autosys for Scheduling and monitoring.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Power Center 9.5 by using various transformations like Expression, Source Qualifier, Filter, Router, Sorter, Aggregator, Update Strategy, Connected and unconnected look up etc.
• Extensively used various Performance tuning Techniques to improve the session performance.
• Developed and maintained ETL (Extract, Transformation and Loading) mappings to extract the data from multiple source systems like Oracle, SQL server and Flat files and loaded into Oracle.
• Created business rules in Informatica Developer and imported them to Informatica Power center to load the standardized and good format of data to staging tables.
• Involved in creating new table structures and modifying existing tables and fit into the existing Data Model.
• Designed and Created data cleansing, validation and loading scripts for warehouse using Informatica Power Center 9.1.1/8.6.
• Worked with offshore team to Develop and deliver the ETL tasks.
• Monitored workflows and session using Power Center workflows monitor
• Used Informatica Scheduler for scheduling the workflows
• Developed the ETL jobs to automate the Data validation process across the systems (Web trends and In house) using Informatica and notifying the variances to stakeholders.
• Extensively used Informatica client tools - Source Analyzer, Mapping designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Informatica Server Manager.
• Created workflows and worklets for designed mappings.
• Provide documentation of ETL design and technical specifications, high level and low level design specifications.
• Design and build reconciliation process.

Environment: Informatica Power Center 10.0/9.1.1, Teradata 14/12, Oracle 11g, My SQL, XML, Flat Files, SQL Assistant, Autosys, Toad, PL/SQL, Erwin, Unix shell scripting, Cognos, Unix, Windows

Confidential - Los Angeles, CA

ETL Informatica Power Center

Responsibilities:

• Experience in Financial Asset load to CRD using ETL batch via Informatica PowerCenter 9.6 x and Oracle Database.
• Implemented complex financial data design mapping for creating new Asset or updates to existing assets.
• Maintained mapping transparency as possible to handle pricing file and cash flow systems. E.g: ASM and Bloomberg
• Emphasized on Design Partitioning and reusability of PowerCenter Mapping to improve performance and timing.
• Worked on multiple implementations of Data warehouse Designs as per client requirements.
• Implemented approaches for current state mapping logics of security attributes and security types.
• Designed PowerCenter mappings, using Informatica transformations (Active and passive transformations) and PL/SQL Procedures using cursors, functions and triggers.
• Expertise in handling and furnishing various financial data of Fixed Income, Bloomberg, Morning Star, Security Lists, Custodian Accounts and Swaps.
• Specialized in Requirement analysis, Gap analysis, Incident management, Problem management, Troubleshooting Methodologies and in-depth knowledge of all stages of software development life cycle (SDLC).
• Created migration shell scripts for file move and file transfer and also Perl Scripts for file watcher.
• Worked closely with Architect on design issues and suggested solutions for better performance.
• Extensively used Pre-SQL and Post-SQL scripts for loading the data into the targets according to the requirement.
• Designed approaches for Dimensional Data Modeling, Slowly Changing Dimensions Type I, II & III, ODS, Star/flake Schema modeling, Fact & Dimension tables, OLAP & OLTP Systems.
• Hands on experience is code migration using Perforce, Atlassian products like Bamboo, Bitbucket and Autosys for Job creation for Nightly Batch and Real-Time Batch.
• Used dofeeds.pl to implement CRD extensions of event on load and event on finish.
• Created batch reports on Tableau using Tab CMD and Dashboard connecting to Oracle Database.
• Involved in build, implementation, testing and maintenance, as well as guide and lead the team to meet the quality and schedule.
• Working closely with team members in Agile Methodologies and Onsite/Offshore Implementation.

Environment: Charles River IMS 9.8, Oracle Database, Tableau, UNIX Shell Scripting /Platform: Informatica PowerCenter

Confidential - Plano,TX

ETL Informatica developer

Responsibilities:

• Involved in business requirement analysis and prepared functional requirement document.
• Involved in the ETL technical design discussions and prepared ETL high level technical design document.
• Involved in migrating the Legacy data in to Data Bases Using Snap Logic.
• Involved in the analysis of source to target mapping provided by data analysts and prepared function and technical design documents.
• Extracted data from Flat files, high volume of data sets from data files, Oracle using Informatica ETL mappings/SQL PLSQL scripts and loaded to Data Store Area.
• Created complex Informatica mappings using Unconnected Lookup, joiner, Rank, Source Qualifier, Sorter, Aggregator, newly changed dynamic Lookup and Router transformations to extract, transform and loaded data mart area.
• Created re-usable transformations/mapplets and used across various mappings.
• Developed Informatica workflows/worklets/sessions associated with the mappings using Workflow Manager.
• Wrote Unit Test cases and executed unit test scripts successfully.
• Involved in performance tuning of Informatica code using standard Informatica tuning steps.
• Involved in the performance tuning of SQL/PLSQL scripts based on explain plan.
• Supported during QA/UAT/PROD deployments and bug fixes.
• Schedule daily backup of Informatica environment, restore Informatica environment when required.
• Administer projects, roles, user, and privileges across all three environments, Configure and setup LDAP security integration with Informatica, Load balancing of the ETL services.
• Involved in code Reviews as per ETL/Informatica standards and best practices.

Environment: Informatica 9.6.1(Repository Manager, Admin Console, Designer, Workflow Manager Workflow Monitor), Toad, Oracle 10g, UNIX, Snap Logic, AWS, Windows.

Confidential, Austin, TX

Data Integration Engineer

Responsibilities:

• Analyzed the Business Requirement Documents (BRD) and laid out the steps for the data extraction, business logic implementation & loading into targets.
• Created detailed Technical specifications for Data Warehouse and ETL processes.
• Developed Source to Target Mappings using Informatica Power Center Designer from Oracle, Flat files sources to Teradata database, implementing the business rules
• Modified BTEQ scripts to load data from Teradata Staging area to Teradata Ware House.
• Requirement gathering and discussion with Architect for design plan.
• Created series of Macros for various applications in Teradata SQL Assistant
• Working closely with Architects and Lead for the applications assessment to all the Data Masking Team on Proxy server and proving support on the databases and applications.
• Extensively used Pre-SQL and Post-SQL scripts for loading the data into the targets according to the requirements.
• Extracted, transformed data from various sources such as Flat files, Oracle 11g and transferred data to the target data warehouse Teradata
• Responsible for building Teradata temporary tables, indexes, macros and BTEQ Scripts for loading/transforming data.
• Developed scripts for loading the data into the base tables in EDW using FastLoad, MultiLoad and BTEQ utilities of Teradata
• Tested raw data and executed performance scripts.
• Successfully upgraded Informatica 9.1 and to 9.5 and responsible for validating objects in new version of Informatica.
• Managed postproduction issues and delivered all assignments/projects within specified time lines.
• 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.
• Supported QA for each region testing using Health Rules and Health Answers. Assisted for QA.
• Written Technical design document and application workbook and handover applications to production team.
• Worked in Production support team.

Environment: Informatica Power Center 9.5.1/9.1.1 , Oracle 11g, DB2, Teradata 14.0, Flat Files, Teradata SQL Assistant, Toad, Winscp, Putty, Tivoli Workload Scheduler, UNIX.

Confidential, Chicago, IL

ETL Informatica Developer

Responsibilities:

• Extensively Worked with Data Modeler, Data Analysts and Business Users to gather, verify and validate various business requirements.
• Identified various source systems, connectivity, tables to ensure data availability to start the ETL process.
• Created Design Documents for source to target mappings
• Created Workflows, Tasks, database connections, FTP connections using Workflow Manager.
• Developed mappings to get the SAP source data
• Extensively developed various Mappings using different Transformations like Source Qualifier, Expression, Lookup (connected and unconnected), Update Strategy, Aggregator, Filter, Router, Joiner etc
• Used Workflow Manager for Creating, Validating, Testing and running the workflows, sessions and scheduling them to run at specified time.
• Created pre-session and post-session shell commands for performing various operations like sending an email to the business notifying them about any new dealer branches.
• Providing the Architecture/Domain knowledge to Report developer for the creation of Dashboards and Reports.
• Performed Fine tuning of SQL overrides for performance enhancements and tuned Informatica mappings and sessions for optimum performance.
• Extensively worked with Look up Caches like Shared Cache, Persistent Cache, Static Cache and Dynamic Cache to improve the performance of the lookup transformations.
• Created Source definitions and Flat File Target definitions using the Informatica
• Used UNIX commands (Vi Editor) to perform the DB2 load operations.
• Created detail Unit test plans and performed error checking and testing of the ETL procedures using SQL queries, filtering out the missing rows into flat files at the mapping level.
• Scheduled the ETLs using ESP scheduler.

Environment: Informatica Power Center 8.6.1/8.1.1 , Oracle 11g, TOAD, SAP BOBJ 4.0,4.1, Tableau 9.2, UNIX, Autosys, SQL*Loader, PowerCenter Mapping Architect for Visio, Sybase Power Designer, IBM DB2, Flat files, SQL, putty, UltraEdit-32, shell Programming, Toad, Quest Central