SUMMARY:

• 8+ Years of focused experience in Information Technology with a strong background in Data warehousing and ETL experience using Informatica Power Center 9.5/9.1/8.6.0/8.5.1 /8.1 on RDBMS databases
• Worked as an MDM developer, where projects are analyzed, planned, and developed. Maintained documentation of team’s technical processes. Worked closely with business users, used latest technologies of Oracle database, MS SQL server database, and job scheduler.
• Developed Data Warehouse/Data Mart systems using various RDBMS (Oracle, MS - SQL Server).
• Expertise includes Data Analysis, Data Modeling, Data Cleansing and Transformation, Integration and use of ETL tool Informatica.
• Experienced in working with all Informatica Designer tools and worked extensively with Informatica Workflow manager and Workflow monitor to build and run workflows.
• Expertise in Informatica ETL tool to develop, test and tune mappings, sessions and workflows.
• Extensive experience with analyzing and validating the data, Logical and Physical data modeling using ERWIN, Embarcadero.
• Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.
• Strong experience in Installing and Managing Informatica Power Center, Data Quality(IDQ), Metadata Manager(MM), Test Data Management(TDM).
• Advanced knowledge in Informatica loading, change data capture(CDC) and performance tuning
• Good Experience and understanding of the SDLC in all phases.
• Experienced using RDBMS oracle, Teradata, SQL server, DB2.
• Experience in writing with Pre-Session and Post-Session UNIX scripts.
• Experience in writing stored procedures, triggers, functions in Oracle PL/Sql and also SQL Queries/reports and scripts.
• Experienced in Installing & Configuring Informatica Lifecycle Management(ILM /TDM)& trouble shooting and support.
• Expertise in testing Data warehousing strategies for ETL mechanism developed by Informatica.
• Proven experience and Solid understanding of Data Warehousing, Decision Support Systems (DSS), OLAP and Business Intelligence skills.
• Worked with Informatica Data Quality toolkit, Analysis, data cleansing, data matching, data conversion, exception handling, and reporting and monitoring capabilities of IDQ 9.x.
• Preparation of business and functional specifications, analysis of current and planned systems, workflow and business process documentation, utilization of use case analysis and UML models.
• Experienced in Physical, Logical database implementation, indexing and performance tuning for development, test and production environments.
• Performed the data profiling and analysis making use of Informatica Data Explorer (IDE) and Informatica Data Quality (IDQ).
• Highly proficient in using T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User defined Functions, User profiles, Relational Database Models and Data Integrity, SQL joins, indexing and Query Writing.
• Good knowledge on the Pharmaceutical and Insurance domains.
• Excellent understanding of Software Development Life Cycle and dimensional modeling techniques using Star and Snow-flake Schema Modeling.
• Proven problem solving skills with excellent analytical, communication and interpersonal skills.
• Team player, motivated and dynamic with excellent oral and written communication skills.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.5/9.1/8.6/8.5/8.1/7.1/6.2, Informatica Power Exchange

Reporting Tools: Business Objects 6.0/5.0, Cognos 6.0/7.0

Data Modeling: Erwin 4.1/3.7, ER Studio

Database: Oracle 11g/10g/9i/8i/8.0, MS SQL Server 2012/2008/2006, DB2, Teradata 4.0, MS Access 2000/7.0/6.5

Utilities: SQL Assistant, Query man, TOAD

Operating Systems: Microsoft Windows XP/2003/2000/NT, Windows 2000/2003 Server, UNIX, Sun Solaris 5.8

Programming Languages: SQL, PL/SQL, T-SQL, UNIX Shell Scripting, HTML,SSIS, SSRS

Data Cleansing: Informatica Data Quality 8.6.2/8., Informatica Data Explorer 8.6.1 /8.5

Other Tools: SQL*Plus, SQL Loader, TOAD, MS Visual Studio

Business Domains: Federal Government, Insurance, Health care, Finance

Scheduling Tools: DAC, Tivoli, Zena

PROFESSIONAL EXPERIENCE:

Confidential, Neenah, WI

ETL/ Informatica Developer

Responsibilities:

• Analyzed business requirements with business analyst to develop ETL procedures that are consistent across all systems.
• Involved in data modeling for SQL Server databases to store data retrieved from flat files.
• Normalized and De-normalized flat files and loaded them in SQL server.
• Created mappings/sessions and workflows for using Informatica version 9.5.
• Installed, Configured and Upgraded Informatica PowerCenter TDM /ILM to 10.1 with all EBF's
• Installed and re-configured and upgraded Informatica PowerCenter suite (like IPC, ILM, TDM,
• As part of change control, updated mappings as per functional specifications to in corporate updated logics.
• Used different types of tasks like Decision, Timer and Event Initial/Bulk load process wait and Command to maintain the dependencies between the sessions and load balancing within Informatica Workflow.
• Worked with various transformations like Router, Expression, SQL, Lookup, Normalizer, and Aggregator in building complex mapping.
• Involved in designing the procedures for getting the data from all the source systems to Data Warehousing system.
• Copied subset of secured data from Production databases to development and Testing environments of Test Data Management (TDM).
• Worked on Data cleansing & standardizing by configuring Address doctor component in IDQ tool.
• Installed/configured SAP connectors for Informatica Power Center and Informatica Cloud.
• Coordinate with the DBAs for migrating tables and schema changes to different environments.
• Involved in performance tuning the mappings and sessions to perform optimally.
• Retrieved data from SAP using Informatica Power Exchange.
• Created Unit Test documents and performed Unit Tests on the ETL mappings.
• Actively supported the testing team and involved in defect triage and defect fixing.
• Worked on SQL Server Integration Services (SSIS) to integrate and analyses data from multiple heterogeneous information sources.
• Worked closely with business analysts to understand and document business needs for decision support data.
• Created the ETL performance expectations document based on the source data profile results.
• Captured the data volumes, upserts/truncate and load strategies etc in Integration design document.
• Incorporated the refresh strategy, maintaining the historical data, archiving strategies for the source flat file, Audit balance and Control (ABC) etc in Integration design document.
• Create the Informatica data quality plans, created rules, applied Rules to IDQ plans and incorporated the plans as mapplets in Informatica Power Center.
• Created the technical architecture (Hardware and Software) that will support ETL.
• Configured Informatica Power Center GRID on Linux platform.
• Assigned master and worker nodes to GRID in Informatica platform.
• Created the Informatica data quality plans, created rules, applied Rules to IDQ plans and incorporated the plans as mapplets in Informatica Power Center.
• Worked on data cleansing and standardization using the cleanse functions in Informatica MDM.
• Developed ETL procedures to transform the data in the intermediate tables according to the business rules and functionality requirements.
• Created High Level and Low Level design document and ETL standards document.
• Involved in Extraction, Transformation and Loading (ETL) Process.
• Installed and configured Informatica 9.5.1 HF3 on Red Hat platform.
• Wrote shell script to take repository backup on a weekly basis and archiving the 30 day old files on Red Hat.
• Created the Visio diagram
• Developed various T-SQL stored procedures, functions and packages.
• Developed database objects such as SSIS Packages, Tables, Triggers, and Indexes using T-SQL, SQL Analyzer and Enterprise Manager.
• Worked extensively on Autosys using the CA workload center and JIL Checker.
• Scheduled Informatica jobs using Autosys.
• Created dependencies in Autosys, inserted/updated jobs Autosys on CA Workload Center.
• Perform T-SQL tuning and optimizing queries for Reports which take longer time in execution SQL Server 2008.
• Solved T-SQL performance issues using Query Analyzer.
• Optimized SQL queries, sub queries for SSRS reports.
• Created the SSRS reports with multiple parameters.
• Involved in implementing the Land Process of loading the customer Data Set into Informatica MDM from various source systems.
• Retrieved data from Oracle EBS and loaded into SQL Server data Warehouse.
• Involved in unit testing, Integration testing and User acceptance testing of the mappings.
• Performance tuned Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval
• Developed various T-SQL stored procedures, functions and packages.
• Developed database objects such as SSIS Packages, Tables, Triggers, and Indexes using T-SQL, SQL Analyzer and Enterprise Manager
• Developed SSIS packages and migrated from Dev to Test and then to Production environment.
• Perform T-SQL tuning and optimizing queries for Reports which take longer time in execution SQL Server 2008.
• Optimized the T-SQL queries and converted PL-SQL code to T-SQL.
• Standardized the T-SQL stored procedures per the organizations standards.
• Applied try/catch blocks to the T-SQL procedures.
• Used merge statement in T-SQL for upserts into the target tables.
• Made changes to SSRS financial reports with user’s input.
• Installed/configured Teradata Power Connect for Fast Export for Informatica.
• Customized the proactive monitoring dashboard with the Informatica repository tables like OPB SESS TASK LOG etc.
• Resolved Skewness in Teradata
• Created jobs for Informatica data replication fast clone to get data from oracle and load it into Teradata.
• Wrote BTEQ scripts of Teradata extensively.
• Extracted data from complex XML hierarchical schemas for transformation and load into Teradata and vice versa.
• Performance tuning on sources, targets, mappings and database.
• Worked with the other team such reporting to investigate and fix the data issues coming out of the warehouse environment.
• Worked as production support SME to investigate and troubleshoot data issues coming out of Weekly and Monthly Processes.

Environment: Informatica Power Center 9.6.1/9.5.1 HF3, SSIS, Power Exchange, Informatica MDM 9.5.0, SQL Server 2012, Oracle 11g. Oracle EBS. Microsoft TFS, Vendavo.

Confidential, Richardson, TX

Informatica Developer

Responsibilities:

• Working as an ETL / Data warehouse engineer in the Receipe Data Warehouse (RDW) team focusing on Receipe, Truck activity Dimensional structures and extracting data from various legacy source systems.
• Upgraded all Informatica products(Power Center/Data Quality/Data Explorer) to Informatica 9.1.0
• Created and Maintained the Repositories using Power Center Web Based Administration Console.
• Used the Web Based Administration Console to manage of Data Sources distributed across the Network.
• Installed and Maintain Data Quality server, and Informatica work bench.
• Created data quality plans using data quality work bench and using Informatica developer.
• Created data quality plans to validate the address using Melissa data.(IDQ Content)
• Applied hotfix and service packs to Informatica Products.
• Used the Web Based Administration Console to Create User Accounts Privileges for each user and also to create Database Connections.
• Data governance application for Informatica MDM Hub that enables business users to effectively create, manage, consume, and monitor master data using IDD (Informatica Data Director).
• Worked with teams to build rules using proactive monitoring operations & governance.
• Extensively worked with Informatica to load data from different sources to target database.
• Built the referential integrity (RI) with all constraints in Informatica TDM tool
• Extracted and Processed data from various sources like Flat Files and Relational Databases.
• Deployed the code between DEV, QA and Prod environments.
• Created various Transformations like Expression, Joiner, Lookup, Filter, Stored Procedure and Router for implementing core data validations and business rules.
• Involved in troubleshooting issues related to SQL, SSIS.
• Created data quality plans to validate the address using Melissa data.(IDQ Content)
• Involved in the development of Informatica mappings and also performed tuning for better performance.
• Involved effectively in defining new ETL solutions by analyzing the existing code and on time delivery.
• Involved in the Development of different mappings and tuned for better performance. Experience with Informatica Power Center, Data Quality, Metadata Manager and Major adapters.
• Created various Transformations like Expression, Joiner, Lookup, Filter, Stored Procedure and Router for implementing core data validations and business rules.
• Involved in the development of Informatica mappings and also performed tuning for better performance.
• Involved effectively in defining new ETL solutions by analyzing the existing code and on time delivery.
• Built & Maintain Application UNIX Structure in AIX & LINUX.
• Created ETL mappings, sessions, workflows by extracting data from MDM system, FLASH DC & REM source systems.
• Copied subset of secured data from Production databases to development and Testing environments of Test Data Management (TDM).
• Involved in the Development of different mappings and tuned for better performance.
• Documented Release management process, ETL migration and Database changes.
• Extensively worked on Informatica to extract data from flat files, Oracle, DB2 to load the data into the target database.
• Extensively used Informatica Power center and created mappings using transformations to flag the record using update strategy for populating the desired slowly changing dimension tables.
• Used Informatica Source Analyzer, Mapping Designer, Transformation Developer and Warehouse Designer for Extraction, Transformation and Loading.
• Querying and analyzing multiple databases and handling the errors as per the client specifications.
• Interacted with DBAs to create staging and target tables.
• Participated in team meetings to analyze the requirements and build the mapping design document.

Environment: Informatica Power Center 9.5.1, Informatica Power Exchange 9.5.1, Flat Files, XML, SSIS, MS SQL Server 2012, T-SQL, Oracle 11g, Windows XP, Zena Scheduler, TDM, ETL Version Control Management, SharePoint, Teradata, Microsoft Visual Studio 2013, ER Studio Data Architect 9.5, Power Designer, MS Team Foundation Server.

Confidential, ROCKAWAY, NJ

Informatica Developer

Responsibilities:

• Worked with business analysts to identify appropriate sources for data warehouse and prepared the Business Release Documents, documented business rules, functional and technical designs, test cases, and user guides.
• Experience in integration of various data sources with Multiple Relational Databases like OracleDB2 UDB, SQL Server, MS Access, and XML System. Used Teradata Utilities like Fast Load, Multi Load and Fast Export.
• Actively involved in the Design and development of the Star schema data model.
• Data modeling knowledge of Ralph Kimball’s Dimensional Data Modeling using Star Schema and Snow-Flake Schema.
• Implemented slowly changing and rapidly changing dimension methodologies; created aggregate fact tables for the creation of ad-hoc reports.
• Extensively worked on Connected & Unconnected Lookups, Router, Expressions, Source Qualifier, Aggregator, Filter, Sequence Generator, etc.
• Worked on supporting all the ETL Inbounds and Outbound of TDM in production environment with SOA gateway.
• Created and maintained surrogate keys on the master tables to handle SCD type 2 changes effectively.
• Performed various operations like scheduling, publishing and retrieving reports from corporate documents using the business objects reporting.
• Implemented CDC in Oracle databases to capture latest updates from source to destination using mapping variable and DB table maintaining the last extraction date
• Mentored Informatica developers on project for development, implementation, performance tuning of mappings and code reviews.
• Used SQL tools like TOAD to run SQL queries and validate the data in warehouse and mart.
• Developed Informatica mappings/mapplets, sessions, Workflows for data loads and automated data loads using UNIX shell scripts.
• Profiled customer data and identified various patterns of the phone numbers to be included in IDQ plans.
• Integrated Data Quality routines in the Informatica mappings to standardize and cleanse the name, address, and contact information.
• Created Queries, Query Groups and packages in MDM Hub Console.
• Used various lookup caches like Static, Dynamic, Persistent and Non-Persistent in Lookup transformation.
• Involved in debugging mappings, recovering sessions and developing error-handling methods.
• Successfully migrated objects to the production environment while providing both technical and functional support.
• Worked closely with the OBIEE team in building the RPD and dashboard.
• Developed E-MAIL tasks to send mails to production support and operations.
• Used Session Parameters to increase the efficiency of the sessions in the Workflow Manager.
• Designed and developed UNIX Scripts to automate the tasks.
• Resolved memory related issues like DTM buffer size, cache size to optimize session runs.
• Scheduled the jobs using Data Warehouse Administration Console (DAC).

Environment: Informatica Power Center 9.5.1/9.1.0, Oracle 11g, Erwin - 4.0, TOAD 9.x, Shell Scripting, TDM, Teradata, Oracle SQL *Loader, OBIEE, PL/SQL, SalesForce dot com(SFDC), SSIS and Sun Solaris UNIX, Windows-XP,DAC.

Confidential, FAIRFAX, VA

Informatica Developer

Responsibilities:

• Worked with business analysts to identify appropriate sources for data warehouse and prepared the Business Release Documents, documented business rules, functional and technical designs, test cases, and user guides.
• Developed various T-SQL stored procedures, functions and packages.
• Developed database objects such as Tables, Triggers, and Indexes using T-SQL, SQL Analyzer and Enterprise Manager
• Perform T-SQL tuning and optimizing queries for Reports which take longer time in execution SQL Server 2008.
• Solved T-SQL performance issues using Query Analyzer.
• Carried out a Developer’s role on MS SQL Server 2000, MS Access Databases
• Involved in performance tuning at source, target, mapping and session level.
• Loaded DB tables from XML sources.
• Designed logical and physical folders of OBIEE.
• Integrated Informatica workflows into OBIEE
• Recreated connections for OBIEE
• Supported Integration testing by analyzing and fixing the issues.
• Used push down optimization at the source, target and mapping level for loading data
• Created Unit Test Cases and documented the Unit Test Results.
• Defined Interface parameters in Informatica mappings and sessions to initiate the concurrent programs (Stored Procedures) once the Interface tables are loaded.
• Used Informatica hash partitioning.
• Integrated Data Quality routines in the Informatica mappings to standardize and cleanse the name, address, and contact information.
• Profiled customer data and identified various patterns of the phone numbers to be included in IDQ plans.
• Used Informatica web services to create work requests/work Items for the end user.
• Supported Integration testing by analyzing and fixing the issues.
• Created Unit Test Cases and documented the Unit Test Results.
• Defined Interface parameters in Informatica mappings and sessions to initiate the concurrent programs (Stored Procedures) once the Interface tables are loaded.

Environment: Informatica Power Center 8.6.1, Informatica Power Exchange 8.6.1, Informatica Data Quality 8.6.1Admin Console, Oracle 10g, Oracle 12.0.4/5 eBusiness, Business Objects XI R2, DB2, Teradata 13, Sybase, OBIEE 11g, TOAD for DB2, SAP IDocs, PL/SQL, UNIX, Windows NT4.0, Tivoli.

Confidential

Informatica Developer

Responsibilities:

• Developed Informatica mappings, reusable transformations. Developed and wrote procedures for getting the data from the Source systems to the Staging and to Data Warehouse system.
• Extensively used transformations to implement the business logic such as Sequence Generator, Normalizer, Expression, Filter, Router, Rank, Aggregator, LOOK UP (Target as well as Source), Update Strategy, Source Qualifier and Joiner, Designed complex mappings involving target load order and constraint based loading
• Create/build and run/schedule workflows and worklets using the Workflow Manager.
• Optimizing/Tuning mappings for better performance and efficiency, Creating and Running Batches and Sessions using the Workflow Manager, Extensively used UNIX Shell scripts for conditional execution of the workflows. Optimized the performance of Mappings, Workflows and Sessions by identifying and eliminating bottlenecks
• Performed Unit Testing at development level, Source code migration and documentation
• Performance Tuning of the Informatica Mappings by adopting Explain plans, cutting down query costs using Oracle hints, changing the mapping designs.
• Managed the Metadata associated with the ETL processes used to populate the data warehouse.
• Good knowledge of Business intelligence tools like Business Objects, Cognos BI Suite for warehouses and data marts, OBIEE etc.
• Responsible to tune ETL procedures and STAR schemas to optimize load and query Performance.
• Extensively worked in the performance tuning of the programs, ETL Procedures and processes. Coded database triggers, functions and stored procedures and written many SQL Queries. Helped coding shell scripts for various administration activities for daily backup. Involved in Physical schema implementation, objects like table-space, table rollback segments, Created database structures, objects and their modification as and when needed.

Environment: Informatica PowerCenter8.1.1, Oracle9i, SQLServer 2000/7.0, PL/SQL, Business Objects, UNIX, WindowsNT4.0, Tidal.