SUMMARY

• Overall 9+ years of experience in software design and development, Project Implementation.
• Expert in using Informatica Power Center 9.x, 8.x, 7.x, SQL, UNIX, Shell scripting.
• Worked on all the Transformations like Lookup, Aggregator, Expression, Filter, Update Strategy (Implemented slowly changing dimensions Type1 and Type2), and stored procedure, Sequence Generator, Sorter, Rank and Router.
• Having knowledge in full life cycle development of Data Warehousing Project.
• Experienced in the Requirement Gathering/Analysis, Data Analysis, Application Design, Application Development, Implementations and Testing of Applications in Data warehouse Projects.
• Extensively worked with Informatica components such as Designer, Repository Manager, Workflow Manager, Workflow Monitor.
• Strong knowledge of Dimensional Data Modeling concepts, Star/Snowflake Schema Modeling, Entity - Relationship Modeling, FACT & Dimension table's Physical & logical designs, etc.
• Good hands on experience on creating Informatica Mapping, Transformations, Sessions and Workflows.
• Have extensively worked in developing ETL program for supporting Data Extraction, transformations and loading using Informatica Power Center.
• Experienced in Reusable components which include Reusable Transformations, Mapplets, Reusable Tasks and Worklets.
• Very strong experience in Oracle Development (Functions, Procedure, Packages, Views, Materialized views, Triggers using cursors (static/dynamic) and exceptional handling etc.
• Experienced in PL/SQL object orientation like Records, PL/SQL Table by using bulk command etc., and LOBS (BLOB/CLOB/NLOB).
• Database Management activities like Performance Tuning, Backup and Recoveries, Schema Analyses, setting alerts, Troubleshooting etc.
• Extensively involved in End to End solution design involving design of end to end extract, transform and load processes with data coming from heterogeneous source systems to target systems.
• Ensuring Informatica best practices based on velocity guidelines.
• Experienced in writing SQL queries for analyzing data from large relational database.
• Performance Tuning of SQL and PL/SQL code using techniques like Bulk Collection, Merge Statement, inline views, parallelization, using Hints etc.
• Very good experience in heterogeneous data sources and integrating their data in target data warehouse layers.
• Worked extensively in team oriented environment with strong analytical, interpersonal and communication skills.

TECHNICAL SKILLS

Platform: Windows, UNIX.

Languages: PL/SQL, SQL, COBOL, UNIX Scripting, Excel VB Scripting, JCL, CICS, XML, WSDL, EasyTrieve. Database DB2, Oracle 10g, Teradata, SQL server.

ETL tool: Informatica Power center 9.x/8.x/7.x, Data stage.

Database Access Tools: TOAD, Teradata SQL Assistant, T-SQL, Quality Center.

Database Utilities: Oracle PL/SQL developer, BTEQ, FTP, fastload, Multiload, FastExport, TPump, SQLPlus, CA-7, Business Objects.

Business Area: Banking, Health, and Energ

PROFESSIONAL EXPERIENCE

ETL Informatica developer

Confidential, New York City, NY

Responsibilities:

• Analyze reported data issues and inconsistencies.
• Streamline the current system design where possible.
• Evaluates data mining request requirements and help develop the queries for the requests.
• Write complex SQL queries to pull and analyze data from large relational databases.
• Identifying Fact and dimension tables and Primary key foreign key constraints on the basis of data profiling.
• Figuring out various error handling strategies to be adopted during cross system data migration.
• Working on Informatica - Repository Manager, Designer, Workflow Manager & Workflow Monitor.
• Developed mappings to load Fact and Dimension tables, SCD Type 1 and SCD Type 2 dimensions and Incremental loading and unit tested the mappings.
• Extensively worked in the performance tuning of SQL, ETL and other processes to optimize session performance.
• Worked extensively with different Caches such as Index cache, Data cache, Lookup cache (Static, Dynamic and Persistence) and Join cache while developing the Mappings.
• Maintain, improve and support current ETL and data integration processes.
• Analyzing the source data and working with the business users and developers to develop a plan.
• Respond in a timely manner to data requests to ensure daily, weekly and monthly deadlines and goals are met.
• Analyze data and create detailed reports utilizing proprietary tools and third party technologies to identify and resolve data quality issues to ensure quality assurance and drive data quality initiatives.
• Impact analysis of scheduled source and target changes on the Data warehouse components. Formulating tactical and strategic solutions to accommodate these changes.
• Formulating exhaustive Informatica metadata queries to establish data lineage across various layers of data warehouse.
• Use SQL, PL/SQL to validate the Data going in to the Data Ware House.
• Creating complex data analysis queries to troubleshoot issues reported by users.
• Working with various project managers and business users to sort out any potential impact of scheduled changes in business logic on the system from data acquisition to downstream views and reports.

Environment: Sun Solaris 32-bit, Oracle 9i, Informatica Power Center 9.1, Informatica Metadata managerInformatica Developer

Confidential - Pittsburgh, PA

Responsibilities:

• Worked to transform requirements into technical design.
• Overall responsibility for requirements analysis, estimation, architecture, design and implementation of the ETL processes include defining the data quality.
• Designing and developing highly scalable and maintainable ETL. (high level, low level)
• Conversion of Business functionalities to Informatica flows.
• Guide and help development team with performance and other technology issues. Competency building, mentoring and providing training within the team.
• Developed mappings to load Fact and Dimension tables, SCD Type 1 and SCD Type 2 dimensions and Incre
• Worked with team on designing the mappings, sessions, work lets and workflows in Informatica.
• Extensively involved in performance tuning of the Informatica Mappings and workflows.
• Created Data Breakpoints and Error Breakpoints for debugging the mappings using Debugger Wizard.
• Responsible for identifying, analyzing and translating business requirements into conceptual, logical and physical data models in complex, multi-application environments.
• Automated infromatica jobs using UNIX shell scripting.
• Experience in figuring out various error handling strategies to be adopted during cross system data migration.
• Fine tuning the ETL code for performance gain.
• Using best practices like push down optimization, avoiding memory and CPU intensive transformation like Aggregator and Ranker for performance enhancing.
• Developed Re-org (Table space move, index rebuilding and table analyze) script to gain the performance improvement of DB and scheduled them as per volume of data by writing unix script.
• Supported the migration of Informatica components from Development to environment to QA and Production.
• Developed test plans to conduct the Unit, QA, Integration, acceptance and load testing.

Environment: Informatica Power center 9.x, Oracle, UNIX.

MDM Informatica developer

Confidential, Jersey City, NJ

Responsibilities:

• Interacted with business user in the analysis and development phase and was involved in requirement gathering, prepared various documents like Technical design documents, Integration test plan, unit test plan and resolved business related issues.
• Designed and developed complex ETL mappings making use of transformations like Source Qualifier, Joiner, Update Strategy, Lookup, Sorter, Expression, Router, Filter, Aggregator and Sequence Generator.
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance
• Extensively used Informatica debugger to figure out the problems in mapping. Also involved in troubleshooting existing ETL bugs.
• Creating Users, Groups, Folders, assigned permissions using Repository Manager and Informatica Administration console.
• As an Administrator, monitoring Informatica repository health through Informatica admin console.
• Involved in day to day deploy objects from lower environments to higher environments. worked on DR Exercises and tested failover of the major ETL business batch jobs
• Involved in the process of informatica upgrade from version 9.0.1 to 9.5.1.
• Supported the Infrastructure planned maintenance and outages.
• Installed the third party Ssh keys into Informatica based on requests.
• Submitted the Firewall request to network admins based on the project requests and tested the connectivity from Informatica environment, if opens the firewall.
• Worked on refreshing TEST/Dev/Prod environments on regular basis as per the project needs.
• Expertise in taking backups, recovery of workflows, sessions and mappings from repositories.
• Scheduled batch jobs using Informatica job scheduling and TWS.
• Have used BTEQ, FEXP, FLOAD, MLOAD Teradata utilities to export and load data to/from Flat files.
• Written the shell scripts to take a repository backup and domain backup on daily basis.
• Providing Tools support on various tools like Informatica, TWS, Teradata, Vertica etc.
• Managing TWS workstation and agents services, providing access and resetting production plan.
• Extensively worked in the performance tuning of SQL, ETL and other processes to optimize session performance.
• Worked extensively on transformations like Lookups, Aggregator, Update Strategy, Stored Procedure, Sequence generator, Joiner transformations.
• Worked extensively with different Caches such as Index cache, Data cache, Lookup cache (Static, Dynamic and Persistence) and Join cache while developing the Mappings.
• Created Reusable transformations, Mapplets, Worklets using Transformation Developer, Mapplet Designer and Worklet Designer.
• Worked with Pre and Post Session SQL commands to drop and recreate theindexes on data warehouse using Source Qualifier Transformation of Informatica Power center.
• Informatica Data Explorer (IDE) and Informatica Data Quality (IDQ 8.6.1) are the tools are used here. IDE is used for data profiling over metadata and IDQ 8.6.1 for data quality measurement.
• Configured SFTP (password less) and connect Direct (NDM) installation and setup.

Environment: Informatica Power Center 8.6.1/9.0.1/9.5.1 , IDQ, Oracle 11g/10g, PL/SQL, TOAD, SQL Server 2008, TWS Scheduler, Control-M, Crontab, Clear Case, Red Hat Linux, Unix Shell scripting, Teradata V13, Teradata utilities (TPT &TTU)

Senior informatica developer

Confidential

Responsibilities:

• Responsible for Business Analysis and Requirements Collection and translated requirements into business rules & made recommendations for innovative IT solution
• Analysis of star schema in dimensional modeling and Identifying suitable dimensions and facts for schema.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Used transformations like Joiner, Expression, Connected and Unconnected lookups, Filter, Aggregator, Store Procedure, Rank, Update Strategy, Router and Sequence generator.
• Developed, documented and executed unit test plans for the components
• Collected performance data for sessions and performance tuned by adjusting Informatica session parameters.
• Extensively worked on the.
• Created Workflows containing command, email, session, decision and a wide variety of tasks.
• Scheduled batch and sessions within Informatica Designer, Repository Manager, Repository Server, Workflow Manager/Server Manager and Workflow Monitor Informatica using Informatica scheduler and also wrote shell scripts for job scheduling.
• Employed performance tuning to improve the performance of the entire system.
• Performed Pipeline partitioning to speed up mapping execution time.
• Creating the design and technical specifications for the ETL process of the project.
• Used Informatica as an ETL tool to create source/target definitions, mappings and sessions to extract, transfor Involved in enhancements and maintenance activities of the data warehouse including performance tuning.
• Created test cases and run the cases using Quality Center.

Environment: Informatica Power Center 9.1/8.6, DB2, Oracle 10gR2, SQL, TeraData, PL/SQL, Toad 9.1