PROFESSIONAL SUMMARY:

• Over 6+ years of experience in Information Technology wif ETL using Informatica PowerCenter9.x/8.x/7.x, Database Development, MasterDataManagement, Quality assurance.
• Excellent Experience wif Informatica Power Center Installing, Upgrading and Administration.
• Expertise in building Enterprise Data warehouse (EDW), Operational data stores (ODS), Data Marts and Decision Support Systems.
• Extensively used Informatica client tools - Repository manager, Designer, Workflow manager and workflow monitor.
• Good noledge of Informatica Power Exchange to support Data integration requirements.
• Sound noledge in using Informatica Power Center 9.6/9.5/9.1/8.6.1/8.11 (Source analyzer, Mapplet Designer, Transformation Designer, star & snowflake schemas using Informatica tool on oracle, Netezza databases).
• Worked wif dimensional data warehouses in star and snowflake schemas and slowly changing dimensions.
• Proficient in extracting and transforming data from various sources (Oracle tables, Flat files, XML) into the data warehouse using ETL tools.
• Expert on Slowly Changing Dimensions Type1, Type 2 and Type 3 for inserting and updating Target tables for maintaining the history.
• Experience in performing ETL procedure to load data from different sources into data marts and data warehouse.
• Good experience in Design, documentation, development and testing of all code components of ETL, database systems.
• Extensively worked on transformations such as Source Qualifier, Expression, Aggregator, Filter, Router, Joiner, Lookup, Sorter, Normalizer, Sequence Generator, Stored Procedure and Update Strategy transformations.
• Experienced in creation of mapping, mapplet, workflows, worklets, tasks and also scheduling of workflows.
• Knowledge in Data Analyzer tools like Informatica Power Exchange (Power connect) to capture the changed data.
• Proficient in working on Informatica web services, UDO and Data quality plug-ins.
• Strong Experience on Workflow Manager Tools - Task Developer, Workflows & Worklet Designer and Managing, Scheduling, and Monitoring of Informatica workflows. Worked on all the transformations like Connected and Unconnected - Remote Lookup, Aggregator, Expression, Filter, Router, Update Strategy, Connected and Remote Stored Procedure and Sequence Generator, Sorter.
• Extensively involved in Performance issues of both informatica and databases.
• Experience in design of logical and physical data modelling and also has expertise in using SQL loader to load data from external files to Oracle database.
• Good proficiency in using databases like Oracle 11g/10g/9i/8i, Netezza.
• Having strong Data warehousing and data modeling skills.
• Wif Metadata Manager, all parts of the organization can collaborated faster and easier to keep data accurate, consistent, and available when and where needed.
• Strong experience in RDBMS concepts, Pl/SQL programming units like procedures, functions and packages in UNIX and WINDOWS environment.
• Highly motivated SQL server developer wif 4 years of IT experience wif database development/Administration ondata design, and business intelligence technologies wif expertise on ETL process, reporting and support using SQL server SSIS and SSRS.Strong experience in Oracle database Performance Tuning
• Strong business analysis skills and anunderstanding of the software development life cycle (SDLC)
• Basic noledge on Informatica Data quality and Informatica Master Data Management (MDM) software products.
• Maintained outstanding relationship wif Business Analyst and Business users to identify information needs as per the business requirement.
• Excellent Experience working wif offshore and onsite co-ordination.
• Extensively designed SCD1, SCD2, SCD3 mappings.
• Import and Export of data Salesforce using informatica .
• Involved in Implementation of DQ Services using Informatica Data Quality. Implementation Included Cleansing and Matching Services.
• Used Address Doctor Transformation for improving data quality and customer house holding purposes.
• Proficient in programming languages like C, C++, Java and .Net.
• Strong hands on experience using Teradata utilities (SQL, Macros, B-TEQ, Fast Load, MLoad, FastExport, Tpump,).
• Loading data from various data sources and legacy systems into Teradata production and development warehouse using BTEQ, FASTEXPORT, MULTI LOAD, FASTLOAD and Informatica.
• Proficient in programming languages like C, C++, Java .
• Created business reports by writing complex SQL queries using views, macros, volatile and global temporary tables and Using Teradata View point utilities to monitor and improve performance.
• Excellent in verbal and communication skills, good in understanding business procedures and has ability to work as an individual or in a team.

TECHNICAL SKILLS:

Data Warehousing Tools: Informatica 9.6/9.5/9.1/8.6.1/8.1.1, Informatica power Exchange, Oracle BI Data Warehouse Administration Console 11g (DAC).

Data Modelling: Logical data modelling, Erwin, physical data modelling, Relational modelling, Dimensional modelling (star and snowflake schemas, fact and dimensions), Entities, Attributes.

Databases: Oracle 11g/10g/9i/, Netezza, Teradata, MS SQL Server 2008/2012, MS Access, DB2.

Database Tools: PL/SQL developer, SQL Plus, SQL*Loader.

Programming: SQL, T-SQL PL/SQL, HTML, UNIX, XML, C, C++, Core JAVA.

Reporting: Cognos 8.2/8.4, OBIEE.

Other Tools: HP Quality Center 10.0.

Operating Systems: MS Windows 8/7/XP/, UNIX, MS-DOS and Linux.

PROFESSIONAL EXPERIENCE:

Confidential, MD

Informatica Developer

Responsibilities:

• Understanding Business Processes and coordinating wif Business-users to get specific requirements.
• Extracting and loading of data from DB2 (IBM mainframes), Oracle sources to Oracle database using Informatica mappings.
• Widely used transformations such as XML Generator, Unstructured data Option, SQL transformation, Transaction control and stored procedure.
• Experience working wif databases like Netezza (Appliance) as Target database, SQL Server, DB2 as source systems and used client tools like Aginity Workbench, Winsql to connect to the databases.
• Writing data extracts to Excel files so that Business-users can analyze the data extracts in spreadsheets. These data extracts are also used for high-level Business users reporting purposes.
• Worked pre and post sessions, and extracted data from transaction system into staging area along wif noledge of identifying fact and dimensional tables.
• Created Complex mappings, Reusable transformations, Shortcuts, mapplets and testing the data extract to check if they conform to the business rules and taking repository backups regularly.
• Involved in creating staging Tables, Indexes, Sequences, Views and performance tuning like using SQL Loader/Parallel loads into tables, analyzing tables, proper indexing and dropping, tuning the mappings.
• Worked in both OLTP and OLAP applications for multiple projects to create entity relationship diagrams and multidimensional data models.
• Developed UNIX shell scripts to automate the data transfer (FTP) process to and from the Source systems.
• Developed conceptual, normalized logical and physical data models to design OLTP and Data warehouse environments.
• Used ETL to load data from multiple sources to staging area (Microsoft SQL server 2012) using Informatica power center 9.6.1.
• Extensively used Stored Procedures, Functions and Packages using PL/SQL scripting for creating Connected and Unconnected Stored Procedure Transformations.
• Experience in analyzing the reporting requirement.
• Participated in Dimensional data modeling.
• Used Type1 SCD and Type2 SCD mappings to update slowly changing dimension tables.
• Tuned sources, targets, mappings and sessions to improve the performance of data load.
• Worked on requirements to implement the change Data capture (CDC) to record the latest changes in data from the source system.
• Strong in batch processing by vreating multiple sessions and tasks .
• Scheduled Sessions and Batches on the Informatica Server using Informatica Server Manager/Workflow Manager
• Tested several UNIX shell scripting for File validation and also PL/SQL programming
• Involved in the development of Informatica mappings and sessions and also tuned their performance for optimum performance.
• Used Informatica Power center 9.6 wif all its features in migrating data from OLTP to Enterprise Data warehouse.
• Involved wif the Business analysts in requirements gathering, business analysis, testing, and project coordination.
• Created and Documented ETL Test Plans, Test Cases, Expected Results, Assumptions and Validations.

Environment: Informatica Power center 8.6/9.6, Netezza, DB2, MS SQL Server 2012/2008R2, PL/SQL, Windows, UNIX.

Confidential

Informatica Developer

Responsibilities:

• Analyzed the functional specs provided by the data architect and created technical specs documents for all the mappings.
• Extensively used transformations like aggregator, router, joiner, expression, lookup, update strategy, and sequence generator.
• Responsible for extracting data from various sources like Oracle, SQL Server, flat files.
• Create users, roles, startup/shutdown services using Informatica Administrator web tool.
• Analyzed system requirements, coding the routines, developed test plans, test cases.
• Involved in Source System Analysis to understand the incoming data into Data Warehouse and their Sources.
• Worked in the performance tuning of ETL mappings and sessions.
• Written PL/SQL stored procedures and functions for stored procedure transformation.
• Created UNIX shell scripts for Informatica jobs.
• Designed and created anautosysjob plan to schedule our processes.
• Involved in creating simple to complex mappings using transformations like aggregator, Source Qualifier, Router, expression, look-up, joiner transformation.
• Work on EBCDIC files as source.
• Developed data modeling like star and snow flake schemas using Erwin.
• Experience in performance tuning of Informatica Sources, Targets, Mappings, and Transformations & Sessions, developed batch processes and ETL tools to update the accounts.
• Involved in testing the upgrade of Informatica from version 8.5 to 9.1.0.
• Worked wif command line program pmcmd to interact wif the server to start and stop workflow sessions, to start/stop the Informatica servers.
• Participated in all phases of Development life cycle wif extensive involvement in the definition and design meetings, functional and technical walkthroughs.
• Designed and built ETL mappings and workflows to load data from different sources Oracle, Sybase, SQL server and fixed width as well Delimetered flat files.
• Created mapplets, Reusable transformations, worklets and used them in different mappings and workflows.
• The Teradata EXPLAIN facility, which describes to end-users how the database system will perform any request.
• Analysis of the specifications provided by the clients.
• Worked wif various system interfaces to gather requirements for migration and implementation.
• Coding using BTEQ SQL of TERADATA, writes UNIX scripts to validate, format and execute the SQL’s on UNIX environment. creating and modifying MLoads for informatica using UNIX and Loading data into IDW
• Created procedures to truncate data in the target before the session run.
• Implemented variables and parameters in mappings.
• Developed stored procedures to automate the testing process to ease QA efforts and also reduced the test timelines for data comparison on 5000 tables.
• Enterprise in documenting Mapping documents, Unit test plans, test results and Deployment plans.
• Analyzed change requests and performed impact analysis and estimated level of efforts.
• Worked on advanced concepts like concurrent running of workflows, Session level partitioning techniques and push down optimization.
• Scheduled workflow using PMCMD and UNIX shell scripts using CRON Tab and Control-M for daily and monthly loads.
• Involved in scheduling the UNIX shell scripts which runs Informaticaworkflows usingAutosys
• Involved in production deployment activities, creation of the deployment guide for migration of the code to production, also prepared production run books.
• Coordinated offshore and onsite teams efficiently for multiple projects.

Environment: Informatica Power Center 9.x/8.5, Netezza, Teradata 13.10/14, Teradata SQL Assistant, Oracle 11g/10g/9i, DV2, Windows, Cron tab, UNIX, BTEQ, SQL Server 2008R2.

Confidential

ETL developer

Responsibilities:

• Worked closely wif the client in understanding the business requirements, prepared data analysis and provided the code deliverable to the client.
• Implemented ETL and dimension prototype wif complex mappings and mapplets for faster and TEMPeffective means of reporting.
• Made substantial contribution in simplifying the development and maintenance of ETL by creating re-usable sources, Target, Mapplets and Transformation objects.
• The data in Legacy systems is extracted, transformed and loaded into Data mart using ETL tool Informatica.
• Prototyped Dimension model and ETL process by matching the business requirements and core technical requirements from the reporting team.
• Worked on dimensional models like start schema and snowflake schema.
• Handled slowly changing dimensions - Type1, Type2, Type 3 based on the business requirement.
• Setting up Batches and sessions to schedule the loads at required frequency using Power Center Workflow manager
• Created complex joins, Transformations of all types to pass data through ETL maps.
• Maintaining warehouse Meta data, naming conventions and warehouse standards for future application development.
• Development of the UNIX script, bteq script, Fast export script and Informatica Mapping as per the design documents/communication.
• Involved in design, enhancement, and development of applications forOLTP, OLAP, and DSSusingdimension modellingwifTeradata and Oracle
• Created and managed daily, weekly and monthly data operations, workflows and scheduling processes.
• Migrated mappings, sessions and common objects from Development to Test and Production.
• Development of Universes and reports using User module and web intelligence based on user requirements.
• Development is designed to take away ongoing maintenance of tables or views creation as fiscal year changes and to support User - friendly ad-hoc querying.

Environment: Informatica 7.1, DB2, Oracle 9i, XML, MS-Access, PL/SQL, WINDOWS 7/XP.

Confidential

ETL /Pl/sql Developer

Responsibilities:

• Preparation of technical specification for the development of Informatica Extraction, Transformation and Loading (ETL) mappings data into various tables in Data marts and defining ETL standards.
• Developed various mapplets, Transformations and validated the fine-tuned the ETL logic coded into mappings.
• Used Workflow Monitor to monitor the jobs, reviewed error logs that were generated for each session in the session log file, rectified the cause of failure and restarted them.
• Participated in all phases of development life-cycle wif extensive involvement in the definition and design meetings, functional and technical walkthroughs
• Created test cases for the mappings developed and then created integration testing Document.
• Created ETL exception reports and validation reports after the data is loaded into warehouse database.
• Worked extensively wif different cache memory in informatica such as Index cache, Data cache and Lookup cache (static, dynamic, persistence and shared)
• Ownership of ETL code wif UAT testing and production deployment.
• Created stored procedures, which involves complex sql queries.
• Analyzed change requests and performed impact analysis and estimated level of efforts.
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.

Environment: Informatica Power center, Oracle 11g/10g, Sql server, Pl/SQL, UNIX scripting.

Company:

Confidential

Informatica Developer/SQL developer.

Responsibilities:

• Designed and developed ETL strategy for new mappings.
• Analyzed and checked feasibility of new requirements.
• Reviewed Business Requirement Document (BRD) for accuracy and completeness of business requirements.
• Tuned high complex ETL sessions to reduce the overall refresh time by more TEMPthan 40%.
• Developed PL/SQL, UNIX scripts for scheduling sessions in informatica.
• Created test data and configured testing of the informatica code using the Debugger option to identify issues related to any particular set of data.
• Provided reliable, timely support of integration, performance and user acceptance testing (UAT) processes.
• Worked along wif DBA to resolve performance and tuning issues.
• Involved in creation of Folders, Users, Repositories and Deployment Groups using Repository Manager.
• Monitored ETL jobs running in Production environment and fixed bugs and documented the same to avoid similar future occurrences.
• Modified the existing SQL Server SSIS packages to meet the changes specified by the users
• Coordinated wif my team members to identify and resolve problems based on Informatica and other database related issues.
• SSIS Packages are created to export and import data from CSV files,Text files and Excel Spreadsheets.
• Use SQL Loader to load huge flat files into Oracle database.
• Performed the role of SQL developer by Developing stored procedures, packages .
• Worked extensively wif cursors to fetch multiple rows from database

Environment: Informatica Power center, Cognos, PL/SQL Developer, DB2, Oracle 10g/9i, SQL Loader, MS Sql server,UNIX.