We provide IT Staff Augmentation Services!

Informatica Resume

Tampa, FL

PROFILE SUMMARY

  • More than 7 years of experience in design, develop, test and maintain various software and BI applications using tools and technologies such as Informatica Power Center, Power Exchange, Metadata Manager, IDQ, IDE, Oracle, SQL, PL/SQL, SQL Server, DB2, Netezza, Business Objects, UNIX, etc.
  • Experience in major sectors such as Healthcare, E-commerce, Finance, Telecom, Banking and Insurance.
  • Proficient in interacting with Business Analysts, Users and Business executives to understand the requirements and come up with innovative and efficient solutions by working with the data modelers and architects.
  • Expertise in the ETL Tool Informatica which includes components such as Power Center, Power Mart, Power Connect, Designer, Workflow Manager, Workflow Monitor, Repository Manager, Metadata Manager, Repository Server Administration Console, Informatica Data Quality (IDQ), Informatica Data Explorer (IDE).
  • Experience with basic Informatica administration such as creating folders, users, assigning privileges, configuring environment variables, optimizing server setting for maximum performance, deployment groups, etc.
  • Worked with various databases such as Oracle, DB2 UDB, Microsoft SQL Server, Sybase, Teradata, DB2, Netezza and database clients such as SQL Server Management Studio and SQL Developer, SQL Navigator, TOAD.
  • Integrated various data sources like Oracle, Sybase, Teradata, DB2, SQL Server, Flat files, MS Excel, XML files, and COBOL files.
  • Strong knowledge in RDBMS concepts and expertise in creating and maintaining database objects such as tables, indexes, views, materialized views, triggers, synonyms, partitioning techniques at the table and database level, stored Procedures, functions, etc.
  • Expertise in SQL and PL/SQL programming.
  • Expertise in performance tuning ETL code, mapping, session and Database.
  • Expertise on integration mappings including dynamic cache lookup, shared, and persistent cache for mappings of Type I, Type II, and Type III Slowly Changing Dimensions and implementing update strategies, incremental loads, and change data capture.
  • Performed troubleshooting on unsuccessful mappings and errors with Informatica Debugger by working on the ETL Transformations and fixing test and production issues.
  • Working knowledge of other integration tools such as SSIS, Datastage, and Abinitio.
  • Worked on UNIX shell scripts to automate small tasks.
  • Worked on creating reports using Oracle Analytic functions, Business Objects, COGNOS.
  • Data Modeling experience using Dimensional Data Modeling and Relational Data Modeling using Star Join Schema/Snowflake modeling, FACT & Dimensions tables,
  • Hard working individual and a quick learner with strong analytical and communication skills. Experienced in Client interaction and understanding Business applications.

TECHNICAL PROFICIENCY

ETL Tools : Informatica Power Center 9.x/8.x/7.x
Databases : Oracle11g/10g/9i/8i, SQL Server 2008/2005/2000,
Sybase, Teradata, DB2, Netezza
Languages : SQL, T-SQL, PL/SQL, C, Perl, UNIX Shell Scripting
Operating Systems : Windows 7/Vista/XP/2003/2000/98, Linux, UNIX, Macintosh
DB Tools : TOAD, SQL *Plus, SQL Developer, SQL server Management Studio
Other Tools : Qlik View, COGNOS, Tidal, Control-M, Autosys

WORK EXPERIENCE

Confidential,Tampa, FL November 2010 – Present
Sr. Informatica Developer

Confidential,provides managed care services targeted to government-sponsored health care programs, focusing on Medicaid and Medicare. The aim of the project at WellCare is to build consumers data mart, which will have all the consumers’ data, claims and policies data for data analysis purpose.

Responsibilities:

  • Analyzed existing process flows and business functionalities and prepared ETL process flow document for Predictive analysis.
  • Involved in designing Conceptual, Logical and Physical model for Staging and Target data base.
  • Created complex mappings which involved Slowly Changing Dimensions, implementation of Business Logic and capturing the deleted records in the source systems.
  • Extensively involved in process for capturing the incremental changes in the source systems for updating in the staging area and data warehouse respectively.
  • Extensively worked on tuning of Informatica mappings and sessions for better performance.
  • Performance tuned ETL processes at the database level.
  • Developed PL/SQL stored procedures and functions to accomplish small unit of work or tasks.
  • Involved in basic Informatica administration such as creating users and privileges, folders, optimizing server settings, deployment groups etc.
  • Analyzed and fixed production and test issues on a daily basis.
  • Created tasks, work flows and schedule nightly loads using Tidal software.
  • Worked on different tasks in workflows like sessions, event raise, event wait, decision, e-mail, command, worklets, assignment, timer and scheduling of the workflow.

Environment: Informatica 9.1/8.6.1, Teradata v2r6, Teradata Utilities (BTEQ, MLoad, FastLoad), DB2 UDB 9.0/8.0, SQL Server 2005/2008, Oracle 11g, SQL Developer, XML, Windows 2000-2003, AS400, UNIX.

Contributions:

  • Wrote reusable functions and stored procedures.
  • Suggested best practices for Informatica development.
  • Performance tuned existing ETL process during System Integration Phase.

Confidential,Eden Prairie, MN January 2010– October 2010
Sr. Informatica Developer

Responsibilities:

Designed the ETL mapping documents for development team members for their implementations.
Gathered requirement from business analysts, report writers and business users and created a low level technical design and mapping document using high level design document.
Migrated Informatica mappings from development to test to production environments using XML export/import and deployment groups.
Used Informatica 8.6.1 to extract, transform and load data from different sources like flat files, COBOL files, XML files and Oracle 10g/11g database.

  • Performance tuned existing ETL code, SQL, mappings, sessions, database, etc.
  • Created and executed PL/SQL procedures, pre-session and post-session scripts (in Informatica).
  • Worked extensively on urgent ad-hoc ETL and data management requests through ticket system to solve big production issues.
  • Worked with production support in finalizing scheduling of workflows and database scripts using Control M tool.
  • Completed designing ETL processes and finished documentation in a period of three months to help start a new data management team.
  • Wrote data fix scripts as a fix to post production issues.
  • Suggested indexes, views, materialized views, SQL hints etc., to improve the database resource utilization and make the process efficient.

Environment: Informatica Power Center 8.6.1, Flat files, DB2 UDB 8.0/7.0, Teradata v2r6, Teradata Utilities (BTEQ, MLoad, FastLoad), TOAD, Oracle 11g/10g, Netezza, SQL Server 2005/2008, Win XP, UNIX

Confidential,San Jose, CA March 2008 – November 2009 Informatica Developer

Confidential,is an American multinational corporation and a technology company specializing in data and storage networking products. My project included creation of a Data Warehouse by utilizing Teradata’s RDBMS. It included extraction and transformation of data from various sources such as Flat Files, MS SQL Server, Teradata and loading them into a star schema with fact & dimension tables.

Responsibilities:
  • Worked on Power Center client tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformations Developer.
  • Imported data from various sources like Oracle, SQL server, salesforce.com and transformed it and loaded into Data Warehouse targets (Teradata) using Informatica.
  • The Salesforce Cloud was used to provide customer service and representatives with a complete customer profile, account details and history.
  • Involved in identifying the source tables and defining the extraction criteria. Complex SQL queries were written as per specifications and extensively wrote Fast Export scripts for data extraction from Teradata.
  • Extracted order transaction data using power connect from salesforce.com systems to load to target tables.
  • Loaded Salesforce data to the database for reporting needs.
  • Developed Informatica mappings to load data from various sources into Salesforce.
  • Used shortcuts to reuse objects without creating multiple objects in the repository and inherit changes made to the source automatically.
  • Optimized query performance, session performance.

Environment: Informatica Power Center 8.1.1, Oracle 9i, TOAD, SQL Server 2005, TERADATA v12, Windows 2000

Confidential,Boston, MA May 2007 – February 2008 Informatica Developer

Confidential,more commonly known by the name of its primary line of businessLiberty Mutual, is a diversified global insurer and the third largest property and casualty insurer in theUnited States. In this project after Data Discovery and Data Cleansing of legacy data, the master data was moved to an interim database. ETL tools were used to transform legacy data into required formats. Then the master data was loaded to the productive systems and the reports were updated.

Responsibilities:
Prepared work plan such as list of task to perform and effort estimation for Project Manager.
CreatedTechnical System Designdocument,Source to Target mappingdocument.
Developed number of Complex Informatica Mappings and Reusable Transformations to facilitate one time, daily, monthly and yearly loading of data.
Developed Mappings for the Category, Specification, Code, Type areas.
Responsible for implementing high performance ETL designplans for ODS to staging, staging to Data Mart, Data Mart to submission (Flat file to table, Table to Table, table to Flat file).
Designedaudit tablefor ETL, anderror handling processdesign for Bureau submission.
Handled performance tuning the Informatica code (mappings, sessions).
Responsible for code migration, code review, test plans, test scenarios, test cases as part ofUnit/Integrations testing, UAT testing.

Environment: Informatica Power Center 8.6.1/8.1.1, Oracle 9i/10g, SQL Server2005, Windows 2K, TOAD, UNIX.

Confidential,INDIA June 2006 – April 2007
Database/Informatica Developer

Confidential,is the largest private sector general insurance company in India and was among the first companies to make their insurance products available online in India. The goal was to move data from the OLTP system where the sources were flat files to centralized database. The data with errors was fixed using data scrubbing and cleansing and finally it is loaded into dimension tables and fact tables.

Environment: Informatica Power Center 7.1, TOAD, Oracle 8i, Flat Files, Windows 2000, UNIX.

Confidential,INDIA August 2004 – May 2006
PL/SQL Developer

Confidential,is one of the major banks in India. The IOB-EDW is one of the projects under ‘Change Program II’, an IT Initiative taken by the bank to make it more competitive and customer focused.

Environment: Oracle 8i, PL/SQL, SQL Plus, UNIX Shell Scripting.

EDUCATION: Bachelor of Technology

Hire Now