SUMMARY

• Around 8 years of strong expertise in designing and implementing Data Mart/Data Warehouse applications using ETL tools INFORMATICA Power Center 9.1, 8.6, 8.5, 8.1.2, 8.1.1 (Designer / Workflow Manager), Informatica Power Exchange/IDS/IDQ/MDM.
• Experience in designing and developing complex mappings from varied transformation logic like Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner, also created Mappings and Workflows
• Experience in Debugging and Performance Tuning of targets, sources, mappings and sessions.
• Proficient in using Informatica Workflow manager, Workflow monitor, pmcmd (Informatica command line utility) to create schedule and control Workflows, tasks and sessions.
• Extensively worked on database applications using DB2, Oracle, SQL*Plus, PL/SQL, SQL*Loader.
• Experience in modeling Transactional Databases and Data Warehouses using tools like Erwin.
• Experience in Production support and SLA’s.
• Highly Proficient in using Agile Scrum methodologies, Sprints sessions, Daily Standup, Backlog Grooming, Sprint Retrospective Meetings and BI Planning.
• Experience in incident management, problem management and change management
• Experience in developing Logical and Physical models and implementing them in Oracle.
• Experience designing the entities and ERD of the data warehouse.
• Experience in Integrating data from various sources Oracle, DB2, Sybase using Composite 3.7/5.1
• Experience in creating entity relational & dimensional relational data models with Kimball Methodology (Star schema and Snow flake schema architectures, Fact/dimension tables)
• Documented design procedures, operating instructions test procedures and troubleshooting procedures.
• Knowledge about Pushdown Optimization utility in Informatica.
• Used partitioning in Informatica to improve session performance for very large loads.
• Knowledge in design and development of Business Intelligence reports using OBIEE and experience developing Crystal reports.
• Experienced in Onsite/Offshore Coordination including the documentation of entire delivery.
• Versatile team player with excellent analytical, presentation and interpersonal skills with an aptitude to learn new technologies.
• Solid time management and multitasking skills, which help in conducting project meetings, reviews, walkthroughs, and customer interviews according to the varied needs of the people involved

TECHNICAL SKILLS

DATA WAREHOUSING TOOLS: Informatica 9.6.1/9.1.0/8. x/7.x

DATABASES: Oracle 11g/10g/9i/8i, SQL Server, Sybase, DB2

DATA MODELING TOOLS: Erwin, TOAD

LANGUAGES: C, JAVA, VB, PL/SQL, TSQL

WEB PROGRAMMING: HTML 5, CSS 3

WINDOWS APPLICATIONS: MS Excel, Word, Power Point, Outlook, Visio, Access

ENVIRONMENT: S: Client/Server, Data warehouse

OPERATING SYSTEMS: Windows XP/Vista/7/10, UNIX, LINUX

PROFESSIONAL EXPERIENCE

Confidential - Los Angeles, CA

Sr. Informatica / Data warehouse Developer

Responsibilities:

• Involved from initial phases of planning/design/project scoping
• Designed Informatica workflows for the entire data staging and extraction
• Coordinated with offshore team of developers and testers
• Been a part of Data governance initiative directed towards arriving at a holistic view of the Supply chain platform to facilitate Global scalability
• Been a part of Informatica/Oracle migrations and associated validations.
• Worked with the Enterprise Architects to model the sources for extraction
• Involved in production planning, UAT and analysis with Business and Project Management.
• Create scripts/Jobs needed for the scheduling and file handling.
• Worked along with SME's for Supply chain analytics project aimed to create a central ODS to drive supply/demand planning across the firm.
• Worked with external vendors to analyze the scope and timelines to ensure seamless supply planning.
• Raised change requests, incident Management, analyzed and coordinated resolution of program flaws for the Development environment and hot fixed them in the QA, Pre-Prod and prod environments, during the runs using QA Complete ticketing system.
• Established the production support model for the Control Tower extraction project and helped creation of necessary run books for support team.
• Created Transformations, Mappings, Sessions, and Workflows using Informatica.
• Performed performance optimization on Informatica mappings and workflows.
• Created reusable transformation and mappings.

Environment: Informatica Power Center 9.6.1, Oracle, DB2, Windows Server 2012, Unix, JDA

Confidential - Long Beach, CA

Sr. Informatica / Data warehouse Developer

Responsibilities:

• Involved from installation and design analysis phase of the project
• Defined, documented and designed standards, best practices and code review checklists for the Data Team.
• Designed, created and supported mappings, sessions and workflows.
• Worked with QA team to facilitate testing incremental loads and with users for UAT.
• Created reusable transformations and Mapplets by using Lookup, Aggregator, Normalizer, Update strategy, Expression, Joiner, Rank, Router, Filter, and Sequence Generator etc. in the Transformation Developer and Mapplet Designer respectively.
• Implemented SCD Type1, Type2.
• Been a part of architecture team to design the entities and develop ERD and respective dimensions and facts.
• Created re-usable mappings for Audits and data driven Dynamic parameter file creation
• Been a part of Informatica/Oracle migrations and associated testing.
• Worked with the Enterprise Architect to optimize the table structures/Indices/schema as a part of design discussions.
• Utilized Informatica scheduler to schedule workflows.
• Involved in Testing, Debugging, Validation and Performance Tuning of data warehouse. Help develop the optimum solutions for data warehouse deliverables.
• Extensively used pre-session and post-session variable assignment for simulating multithreading scenarios for Load balancing and performance improvement.
• Maintained all team owned databases used in development and SIT environments.
• Involved in production planning and analysis with Business and Project Management.
• Create scripts/Jobs for watch-file functionality, run calendar utilities

Environment: Informatica Power Center 9.6.1 HF3/IDQ/MM/Power Exchange, SQL Server 2012, PL/SQL, Windows Server 2012.

Confidential - Los Angeles, CA

Sr. Informatica / Data warehouse Developer

Responsibilities:

• Involved in project from Requirement gathering, BRD analysis, Design and development of warehouse till reporting.
• Been a part of architecture team to design the entities and develop ERD and respective dimensions and facts.
• Developed Linux scripts to FTP the flat files between vendor and native lockboxes and to pre-process and clean the flat files before staging.
• Worked with business to establish the scope and scalability of the application.
• Implemented Agile in the beginning and scrum methodology towards the end phase of the project.
• Worked with QA team to facilitate testing incremental loads and with users for UAT.
• Created Mapplets with the help of Mapplet Designer and used those Mapplets in the Mappings. Created reusable transformations and Mapplets by using Lookup, Aggregator, Normalizer, Update strategy, Expression, Joiner, Rank, Router, Filter, and Sequence Generator etc. in the Transformation Developer and Mapplet Designer, respectively.
• Implemented SCD Type1, Type2, Type1 with soft deletes and Many-to-Many bridge entity.
• Extensively worked on optimization of mappings for heterogeneous data sources.
• Worked with BI team in the universe design using business objects and creation of templates for canned reporting and development of measures and filters for Ad-hoc reporting.
• Worked with run team for configuration and scheduling of the scripts and workflows using Active Batch 7.
• Maintained all team owned databases used in development, test and UAT environments. These databases are also used for training purposes.
• Raised change requests, incident Management, analyzed and coordinated resolution of program flaws for the Development environment and hot fixed them in the QA, Pre-Prod and prod environments, during the runs using QA Complete ticketing system.
• Involved in Testing, Debugging, Validation and Performance Tuning of data warehouse. Help develop the optimum solutions for data warehouse deliverables.
• Maintained all team owned databases used in development, test and UAT environments.
• Involved in production planning and analysis with Business and Project Management.
• Ensures proper application of the licensing files. Creating Folders and manages user and user group access to objects based on LDAP settings.

Environment: Informatica Power Center 9.0.1, Oracle 11g, Toad 8.6, win SQL, MS Excel/VB, PL/SQL, MS SQL server R2, Linux, Active Batch

Confidential - New York, NY

Sr. Informatica Developer/Data Analyst

Responsibilities:

• Responsible for investigation, characterization, and communication of build and release problems, implementing corrective and preventive actions. Resolved all the issues with JIRA tickets on priority basis.
• Analyzed Change request (CR) as per requests from JIRA. Creating SR to Informatica-related to any Power center product issues.
• As per Change requests (CR) migration of objects in all phases (DEV, QA and PROD) of project and trained developers to maintain system in UAT and production environments.
• Worked on VB Macros in Excel for reporting purposes.
• Ensures proper configuration of the Power Center Domain components. Experience in nodes, Repository services, Integration services, and Reporting Services.
• Created Mapplets with the help of Mapplet Designer and used those Mapplets in the Mappings. Created reusable transformations and mapplets by using Lookup, Aggregator, Normalizer, Update strategy, Expression, Joiner, Rank, Router, Filter, and Sequence Generator etc. in the Transformation Developer and Mapplet Designer respectively.
• Moving the data from source systems to different schemas based on the dimensions and fact tables by using the slowly changing dimensions type two and type one.
• Raised change requests, incident Management, analyzed and coordinated resolution of program flaws for the Development environment and hot fixed them in the QA, Pre-Prod and prod environments, during the runs using JIRA ticketing system.
• Involved in Testing, Debugging, Validation and Performance Tuning of data warehouse. Help develop the optimum solutions for data warehouse deliverables.
• Worked with DBAs on issues related to Production Databases.
• Involved in production planning and analysis with Business.
• Used Autosys to schedule Informatica workflows and UNIX scripts to automate jobs.

Environment: Informatica Power Center 9.0.1, 8.6.0, Business Objects XI R3, Crystal Reports 10, Sybase, DB2, Composite 3.7/4.1/5.1, Oracle 10g, Toad 8.6, win SQL, MS Excel/VB, PL/SQL

Confidential - Atlanta, GA

Informatica Developer

Responsibilities:

• Involved in business requirements, created data mapping documents.
• Build ETL mappings to pull data from Oracle, flat files to target sql server database
• Designed and developed mappings with optimal performance using Aggregator,Java, Joiner, Normalizer, Rank, Sequence Generator, SQL, Transaction Control, Un-Cached & various kinds of Cached Lookup, Connected-Unconnected-Source Target pre and post load Stored Procedure Transformations, Update Strategy, Union, XML Transformations, etc.
• Created sessions and workflows to help schedule nightly loads and process data from all source terminal Data Collection points.
• Used pre-session and post-session variable assignment to transport variable (flags and counters) values across sessions and work-lets.
• Used Constraint Based loading & target load ordering to efficiently load tables with PK-FK relation in the same mapping.
• Edited different kinds of Partition points and Created partitions to improve performance by activating multiple Transformation Threads for optimal use of system resources.
• Executed stored procedures from source qualifiers and SQL transformations and used the return data set in the mapping.
• Used Normalizer Transformation to normalize data from COBOL sources and used Aggregators to De-normalize records to create one record.
• Implemented SCD methodology including Type 1, Type 2 changes to keep track of historical data.
• Wrote shell scripts and Stored Procedures for regular Maintenance and Production Support to load the warehouse in regular intervals and to perform Pre/Post Session Actions.
• Used reusable look-up transformations, across the folders.
• Used Incremental Aggregation technique to load data into Aggregation tables for improved performance.
• Wrote the PL/SQL procedures for data extraction, transformation and loading.
• Extensively used Parameter file to override mapping parameter, mapping Variables, Workflow Variables, Session Parameters, Ftp Session Parameters and Source-Target Application Connection parameters.
• Involved in scheduling the workflows through Autosys and Job scheduler using UNIX scripts.
• Monitored the jobs daily and involved in production support.

Environment: Informatica Power Center 8.6/8.1, Power exchange, DB2, Sybase, Oracle, UNIX, DB Artisan, PUTTY.

Confidential

Informatica Developer

Responsibilities:

• Gathering requirements, conducting a design overview, detailing ETL specifications, data analysis/troubleshooting, implementation tasks, and general mentoring.
• Involved in enhancements and maintenance activities of the data warehouse including performance tuning, rewriting of stored procedures for code enhancements.
• Providing in-depth technical consultation to ensure development of efficient application systems by utilizing standard methodologies and best practices.
• Writing program specifications and developing mappings.
• Responsible for mentoring Developers and Code Review of Mappings developed by other developers.
• Provide technical leadership to other support team members and resolution of technical issues.
• Creating Informatica Mappings to implement complex business rules by using mapplets, reusable transformations and mapping parameters.
• Designing and Developing Mapping specifications, Physical Flow diagrams and build documents.
• Developing reusable mappings to process real time files/admin systems extracts, error handling and notification processes.
• Experience with high volume datasets from various sources like Oracle, DB2, SQL Server, Text Files, XML files and Netezza Relational Tables.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Power Center.
• Parsing high-level design specs to simple ETL coding and mapping standards. Designed mapping document, which is a guideline to ETL Coding.
• Developing mappings, workflows and schedules that reflect ETL methodology standards
• With Power Exchange (CDC option), captured the database inserts, updates, and deletes in the available data. Transformed and cleansed the data continuously without staging tables.
• Created test data using Power Center Data Masking Options (Key Masking, Random masking, Expression masking, Substitution) in mappings.
• Involved in the technical analysis of data profiling, mappings, formats, data types, and development of data movement programs using Power Exchange and Informatica.
• Designing and implementing schemas for reference data, Change Data Capture, process control and audit balancing.
• Performed Reverse Engineering of the legacy application using DDL scripts in Erwin, and developed Logical and Physical data models for Central Model consolidation.
• Developing mappings/mapplets, and utilizing dynamic parameter files.
• Using transformations like Normalizer, Lookup, Aggregator, Expression, Sequence Generator, Router, Filter, Joiner and Union Transformations.
• Creating partitions to improve the Session Performance.
• Migrating projects between multiple environments (Development, QA, UAT and Production).

Environment: Informatica Power Center 8.6.1, Power exchange, Oracle 10g, SQL Server 2005, Control-M, Erwin, Windows, UNIX, Metadata manager.