SUMMARY

• 7+ Years of IT experience in Data warehousing projects, primarily as specialist in performing Analysis, Design, Development, Testing, Implementation, Migration, Deployment, Enhancement and Maintenance of Informatica, Oracle, DB2, Sybase and SQL Server environments.
• Undergone Informatica Training in Informatica MDM 9.x administration and Configuration of MDM multi domain edition 9.x
• Extensive knowledge on the SDLC process and agile methodologies.
• Involved in different phases starting from Requirement Gathering, Design, and Development to Production Deployments and production Support.
• Have extensively worked in developing ETL for supporting Data Extraction, transformations and loading Data using Informatica Power Center.
• Extensive experience with Informatica Power Center 9.x, 8.x and 7.x hosted on UNIX, Linux and Windows platforms.
• Good Knowledge on Informatica MDM Hub components such as Informatica MDM Hub Console, Hub Server, Cleanse Match Server & Data Modeling.
• Good Knowledge on MDM Hub configurations - Data modeling, Mappings, Data validation, Systems and Trust, Match and Merge rules, Hierarchy Manager and Batch group Utility.
• Defining and configuring landing tables, staging tables, base objects, hierarchies, foreign-key relationships, lookups, query groups, queries/custom queries and packages.
• Experienced in other ETL tools like AB-initio, SSIS packages.
• Extensively worked on Data migration, Data cleansing and Data Staging of operational sources using ETL processes and providing data mining features for data warehouses.
• Experience in implementing update strategies, incremental loads and Change Data Capture (CDC)
• Hands on experience in defining Technical Requirements for ETL processes and developing Complex Mappings to load data into enterprise data warehouse and data marts.
• Experience working with various heterogeneous source systems such as Oracle, DB2, MS SQL server, XML files, flat files, Teradata and MS SQL server.
• Expertise in trouble-shooting production issues by root cause analysis to identify the problem, impact analysis to determine the dependencies and providing the resolution.
• Extensive knowledge of various Performance Tuning Techniques on Sources, Targets, Mappings and Workflows using Partitions/Parallelization and eliminating Cache Intensive Transformations.
• Very strong understanding in data warehousing concepts star and snow flake methodologies, slowly changing dimensions.
• Excellent interpersonal and communication skills, customer skills, documentation skills and desire to work in dynamic and challenging environments.

TECHNICAL SKILLS

Primary skills: Informatica Power Center9.6.1, 9.6.0, 9.5.1, 9.1.0, 9.0.1, 8.6.1, IDQ, MDM, and Reporting Dashboard services, Metadata Manger, Test Data Manager and Proactive Monitoring.

Secondary skills: MS SQL server 2012/2008/2005/2000 , Oracle 11G,10g/9i/8i, IBM DB2, Unix Shell and PERL Scripts.

Data Modeling Tool: Erwin 6.0/4.0,OracleDesigner

Office Tools: OFFICE, Excel, MS Project, Visio, Power point, Word Perfect, Corel draw.

Reporting Tools: Data Integration Scheduler, Control M, Oracle Business Intelligence, Business Objects, MSBI (SSIS and SSRS)Environment My SQL, Azure Cloud Services, SQL Server 2012 & 2014. VM servers, UNIX (Sun Solaris 8/9/10, HP-UX 10.20/9. 0, IBM AIX 4.3/4.2), Windows 2012/2008/2007/ XP/98

PROFESSIONAL EXPERIENCE

Confidential - Houston, TX

Sr. 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.
• Involved in data design and modeling by specifying the physical infrastructure, system study, design, and development.
• 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.
• 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.
• Written Unit test scripts to test the developed interfaces.
• 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, Jersey City - NJ

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
• Worked with various Informatica Power Center 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
• 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 8.5 / 8.6.1, Oracle 9i, SQL Server, Sybase, SQL, PL/SQL, Cognos, Unix AIX and windows XP.

Confidential, MN

Informatica Developer

Responsibilities:

• Extensively involved in almost all the phases of Project life cycle right from Requirements Gathering, Design, Development, Testing and Production deployment.
• Actively involved in production support. XML/Deployment-group Migration to UAT and PROD environments.
• Monitoring Production system, performed complex defect fixes in various environments like UAT, SIT etc.
• Identified bottlenecks in ETL objects and resolved them by implementing better logic and/or database object/query optimization.
• Involved in performance tuning and optimization of Informatica mappings and sessions using features like partitions and data/index cache to manage very large volumes of data.
• Worked with various transformations to solve the Slowly Changing Dimensional Problems using Informatica Power Center
• Developed and scheduled Workflows using task developer, worklet designer, and workflow designer in Workflow manager and monitored the results in Workflow monitor.
• Parameterized the mappings and increased the re-usability
• Experience in using Debugger in Informatica Designer tool to test and fix errors in the mappings
• Responsible for creating shared and reusable objects in Informatica shared folder and update the objects with the new requirements and changes.
• Evaluate the Change Data Design, including slowly changing dimensions and Operational Data Store Design.
• Prepared time estimates and tracked each task against the estimated task and assisted in keeping project delivery deadline.
• Document all ETL related work per company's methodology.
• Created UNIX shell scripts to handle file processing and manipulation.
• Co-ordinate with Off-Shore team.

Environment: Informatica Power Center 9.5.1, Oracle 11g, Linux, SQL developer, Informatica scheduler.

Confidential, Fort Worth, TX

Informatica Developer

Responsibilities:

• Involved in almost all the phases of Project life cycle right from Requirements Gathering, Design and Development, Testing, integration and Production deployment.
• Created reusable UNIX shell scripts to handle file processing and manipulation, scheduling the Informatica jobs, script to perform end to end Historic load without manual intervention.
• Created reusable mapplets to perform functionalities which were used in many mappings.
• Customized the mappings in such a way it could perform the required functionality for different source system which was cost and time effective.
• Extensively worked in mappings to Extract, transform and load large volume of records of Equities and intraday market data.
• Worked with various transformations to solve the Slowly Changing Dimensional Problems using Informatica Power Center.
• Have good knowledge on Oracle exchange partition and exchange sub-partition method in Oracle and Exadata.
• Actively involved in technical production support in analyzing and resolving the issues that popup in production in quick turnaround time without affecting the Business.
• Monitoring Production system, performed complex defect fixes in various environments like UAT, SIT etc.
• Identified bottlenecks in ETL objects and resolved them by implementing better logic and/or database object/query optimization.
• Involved in performance tuning and optimization of Informatica mappings and sessions using features like partitions and data/index cache to manage very large volumes of data.
• Created and maintained the project specs, High level design, Low level design and Unit test plan documents up to date throughout my project duration.
• Worked in version control using SVN (Unix based version control tool)
• Co-ordinate with big team both onshore and offshore to accomplish the project deliverables well on time.

Environment: Informatica Power Center 8.X, Informatica 9.x, Oracle, UNIX, Autosys, SVN, Oracle Exadata.

Confidential

ETL Engineer

Responsibilities:

• Worked with business analysts to identify appropriate sources for data warehouse and to document business needs for decision support for data.
• Develop and deploy ETL job workflow with reliable error/exception handling and rollback framework
• Involved in Installation and Configuration of Informatica Power Center, Power Mart, Informatica Client, and Informatica Server. Installed Informatica server on windows
• Worked with CDC option is captures database changes, forwarding them to Power Center for further processing.
• Done Security & User Management in Informatica environment.
• Managed multiple Informatica environments which involved maintaining users with specific roles and privileges on appropriate Folder permissions.
• Configure the Pushdown Option, Cleansing option using Informatica 8.1.1 Version and Improve the system performance.
• Participate in the design, development and deployment of the ETL and data management processes
• Worked on Power Mart/Power Center client tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformations Developer.
• Creating and managing Informatica Local and Global Repository.
• Identifying and loading sources and targets metadata into repository.
• Created, launched & scheduled sessions. Configured email notification.
• Setting up Batches and sessions to schedule the loads at required frequency using Power Center Server manager.
• Backing up repository Migrations/deployment of mappings, sessions, workflows.
• Performance Tuning Informatica application.
• Debugging and resolving issues encountered by developers
• Creating User Groups, Users, folders and assigning permissions.
• Developed standard and re-usable mappings and mapplets using various transformations like expression, aggregator, joiner, source qualifier, lookup, and Router.

Environment: Informatica Power Center 8.1.1/7.1.3 , Business Objects 8.x, Control-M, Oracle 10g,SQL Server 2005,T SQL, PL/SQL