SUMMARY:

• Informatica Developer with nearly 9 years of total IT experience in all aspects of project development life cycle including Analysis, Design, Development, Implementation, Modeling, Testing, Reconciling, and Supporting for Enterprise Data warehousing, Data marts, Data Conversion, Data Integration, Data management projects.
• 8+ years of extensive experience in Informatica Power Center (9.x/8.x/7.x/6.x) tools such as Designer, Workflow Manager, Workflow Monitor, Repository Manager and Repository Server Administration Console.
• Expertise in Dimensional Data Modeling techniques such as Star and Snowflake schemas using ERWIN 7.x/4.x/3.x.
• Expertise in design and implementation of SCD - Slowly changing dimensions types (1, 2 and 3) and CDC - Change data capture.
• ETL best practices/methodologies (transformation usage, naming conversions, mapping standards, slowly changing dimensions, deployment groups, versioning, etc).
• Extensive experience with Data Extraction, Transformation, and Loading (ETL) from multiple data sources such as Oracle, DB2, SQL Server, Flat files, CSV files, VSAM files, COBOL files and XML files into a Reporting and Analytical Data Model.
• Have very good exposure on Change Data Capture using PowerExchange for Oracle.
• Involved in Performance tuning of Informatica mappings, sessions, source and target.
• Expertise in Database Design, Development of SQL, PL/SQL and Query tuning for better performance.
• Good exposure in writing BTEQ scripts and loading data into Teradata using FASTLOAD, MLOAD and TPUMP utilities.
• Experienced in writing Unix Shell Scripts for the automation of ETL processes and using schedulers like Autosys, Ctrl-M.
• Excellent working knowledge on multiple platforms like HP-UX, Windows XP/200x/98, Unix-AIX, Win NT 4.0, Sun Solaris, Linux.
• Dedicated, self-motivated achiever who is committed to success and adept at handling multiple tasks in a high-pressured environment.
• Excellent communication skills and Ability to work in-groups as well as independently.
• Had experience with data warehouse appliance and enterprise data warehousing solutions.
• Good Hands on experience with Informatica 9.X, Business Objects, Micro strategy.
• Good hands on experience with Oracle Exadata, MySQL, MS Access.
• Hands on experience with SQL, PL/SQL, shell & batch scripting, Java, XML.
• Good Hands on experience with Teradata.
• Good Hands on experience with RDBMS like Oracle 11g/12c and or SQL Server 2008/2012.
• Good Hands on experience with PL/SQL and TSQL development of functions, triggers, stored procedures, and packages.
• Experience with Oracle Gateway and Oracle Data Integrator and experience with data modeling tools such as ER-Studio, Oracle Designer.
• Good Hands on experience with Retail Domain.
• Good Hands on experience with User Acceptance, Integration Testing.
• Used SQL queries extensively to fetch the data from a database and Good hands on experience with SQL.
• Good Hands on experience with Capital Markets and Risk Management.
• Good Hands on experience with life time Insurance domain.
• Good Hands on experience with investment banking.
• Worked extensively on data warehousing life cycle.

TECHNICAL SKILLS

ETL Technologies: Informatica Power Center 9.x/8.x/7. x./6.x, IDQ/IDE 9.x, Power Exchange, Sybase ETL Development, AbInitio (GDE 1.12, Co>Op 2.12)

Databases: Oracle 11g/10g/9i/8x/, SQL Server 2000/2005, DB2, Teradata V2R6, MS Access 2000.

Applications: DELTEK, Tririga, Data Stream, SQL*LIMS (Lab ware), Open Lab, Empower2

Operating Systems: Windows 2000/NT, UNIX, DOS.

DB Tools: SQL plus, SQL Loader, TOAD, Erwin 4.1, Pentaho PDI ETL tool.

Data Modeling: E/R Modeling, Dimensional Modeling (Star, Snowflakes Schema Modeling).

PROFESSIONAL EXPERIENCE

Confidential

Sr. ETL Lead Informatica Developer

Responsibilities:

• Worked as an ETL Architect and participated in requirement analysis, code design and mapping development, testing and data loading from Dev to Prod environment.
• Successfully managed a number of projects simultaneously.
• Designed data models and helped the dev team to convert functional requirements into technical requirements.
• Involved in performance tuning and optimization of Informatica mappings using features like Pipeline and Partition Parallelism and data/index cache to manage very large volume of data.
• Maintained Issue logs, Tracker updates for all the assigned apps, defect tracking and test case management.
• Applied the concept of Change Data Capture (CDC), reusable mapplets and transformations in Informatica and implemented Type2 logic and imported the source from Legacy systems using Informatica Power Exchange (PWX).
• Based on mapping spec document, the data conversion rules were implemented to design the mapping.
• Performance tuning was done to handle huge volume of customers for all the three states.
• Interacted with Verizon stakeholders to discuss about the issues in the files provided by them so that there is no delay in the deliverables.
• Interacted and communicated with business analysts, project managers, developers, internal/external clients and senior management to manage issues throughout the software testing life cycle using Agile/Scrum methodologies.
• Coordinated all aspects of project delivery including defining project scope, specifying deliverables, estimating project duration, effort and cost, managing project budget, creating detailed project plans, schedules and managing change requests
• Used Test Data Management (TDM) for sensitive data discovery and safe use of production data used in test and development environments.
• Scheduled stand-up meetings to run the various jobs twice a week to load the data in PROD once the data validation is done.
• Performed data analysis to make sure the data is loaded as per the mapping spec document. Worked on sending the email notification as soon as the job fails or succeeded.

Environment: Informatica Power Center, CDC, SQL Server 2005, Oracle, Teradata, SQL, PL/SQL, Win SQL, UNIX Shell Scripts

Confidential

Sr. Informatica Developer

Responsibilities:

• Communicated with business team and gathered requirements.
• Incorporated identified factors into Informatica mappings to build Data Mart.
• Incorporated data masking transformation in all the mappings to apply masking technique.
• Used Key/Expression Masking technique for the corresponding attributes.
• Used Alphabet masking for first name, last name and Alpha numeric masking for address fields and Digit masking for phone numbers etc.
• Developed Informatica Mappings/Workflows to refresh data from SQL Server Database into Teradata.
• Good hands on experience with Fast load, multi load and Tpump utilities etc.
• Data extraction and data Transfer Teradata Database using utilities / tools like fast load and multi load.
• Designed Informatica complex Mappings and Workflows to be re-start able after a failure.
• Used Informatica Designer to create complex mappings using different transformations like Filter, Router, Connected & Unconnected lookups, Update Strategy, Expressions and Aggregator transformations to pipeline data to Data Mart.
• Implemented various Performance Tuning techniques on Sources, Targets, Mappings, Sessions, Workflows and database.
• Created a parameter file for each application and incorporated database connection info inside it.
• Created workflows/work let for each application and Refreshed the list of tables.
• Prepared Technical Documents related to design, development and testing as per Data Masking Project.
• Captured source/target data into an excel file and compared target data with source data to verify masking rule.
• Worked extensively on Data Migration.
• Good Hands on experience with Oracle Database.
• Hands on experience with Informatica Identity Resolution.
• Worked on Handling Anomalous Data Entry as part of IIR etc.
• Worked on Identity Resolution and the Market as part of IIR.
• Worked on Informatica MDM etc...
• Worked on Informatica New Version 9.6 and Informatica 9.1 etc.
• Good Hands on experience with expectation logic, Error Handling and Change management process.

Environment: Informatica Power Center 9.6, CDC, SQL Server 2005, Oracle11g, Teradata, SQL, PL/SQL, Win SQL, UNIX Shell Scripts

Confidential, NJ

Sr. Informatica Developer

Responsibilities:

• Gathered application, source and target information details.
• Used Informatica Designer to create complex mappings using different transformations like Filter, Router, Connected & Unconnected lookups, Stored Procedure, SQL Transformation, Joiner, Update Strategy, Expressions and Aggregator transformations to pipeline data to Data Mart.
• Created IDQ plans using different components like RBA, Token Labeler, and Character Labeler for address & data standardization.
• Involved in designing Logical/Physical Data Models (Star Schema), forward/reverse engineering using Erwin.
• Hands on experience with informatica big data edition.
• Extensively worked with Teradata Utilities.
• Used fast load, multi load to load the data into target tables.
• Good Hands on experience with Teradata Store procedures.
• Extensively worked with COBOL copybook etc.
• Hands on experience with Control-M and Unix shell scripting and basic Unix commands.
• Good Hands on experience with Data Masking.
• Extensively worked with Product or Account Centric Approach to Managing Customer Data.
• Extensively worked with Employee Productivity.
• Good Hands on experience with database design.
• Good Hands on experience with Retail domain and Product Data attributes/hierarchy.
• Hands on experience with Project life cycle activities on development and maintenance projects.
• Hands on experience with integrating with Informatica PIM.
• Hands on experience with MS-SSIS etc.
• Good Hands on experience with NIX OS and Bash Scripting and TDM.
• Hands on experience with Autosys, Clear case and ParAccel.
• Worked on IDQ file configuration at user’s machines and resolved the issues.
• Used IDQ to complete initial data profiling and removing duplicate data.
• Worked with different components in IDQ like distance, edit distance, Rule based analyzer, bigram, hamming distance.
• Wrote the SQL queries using analytical functions on source & target data to make sure the data meet the requirements.
• Involved in monitoring of production ETL applications, Production Support through tickets. Executing Scripts / Managing scheduled activities based on business requirements.
• Implemented reusable mappings & sessions for Operational Audit Process.
• Good hands on experience with big data Hadoop.
• Migrating code using deployment groups from development box to test.
• Good Hands on experience with Retail Domain.
• Hands on experience with Oracle, DB2 and Teradata.
• Worked on informatica new version 9.6 etc.

Environment: Informatica Power Center 9.6, IDQ 9.5.1, Teradata V2R6, Oracle11/10g, SQL Server, Flat files, SQL, PL/SQL, BTEQ, TOAD, Erwin, Windows XP, UNIX Shell Scripts.

Confidential, Newport, NJ

Sr. Informatica Developer

Responsibilities:

• Interacted with business community and gathered requirements based on changing needs. Incorporated identified factors into Informatica mappings to build Data Mart.
• Developed Informatica Mappings/Workflows to load domain data from Sybase Database, Flat Files into Db2.
• Worked extensively on Capital Market.
• Hands on experience with Investment banking.
• Extensively worked on Teradata scripts.
• Good hands on experience with Fast load, multi load and Tpump utilities etc.
• Used IDQ to profile the project source data, define or confirm the definition of the metadata, cleanse and accuracy check the project data, check for duplicate or redundant records, and provide information on how to proceed with ETL processes.
• Worked with Informatica Data Quality(IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, exception handling, and reporting and monitoring capabilities of IDQ 9.1.0
• Profiled customer data and identified various patterns of the phone numbers to be included in IDQ plans
• Good Hands on experience with Capital Market.
• Good Hands on experience with Control-M, Unix Shell scripting and Basic UNIX commands.
• Good Hands on experience with integrating with Informatica PIM.
• Data extraction and data Transfer Sybase Database using utilities / tools like BCP, and BULK INSERT.
• Designed Informatica complex Mappings and Workflows to be re-startable after a failure.
• Used Informatica Designer to create complex mappings using different transformations like Filter, Router, Connected & Unconnected lookups, Stored Procedure, SQL Transformation, Joiner, Update Strategy, Expressions and Aggregator transformations to pipeline data to Data Mart.
• Designed tables required for the execution of the ETL processes using Erwin.
• Developed DB2 SQLs for the ETL and for populating run statistics.
• Used scripts to import and export data to from the data base.
• Developed Slowly Changing Dimensions for Type 1 SCD and Type 2 SCD.
• Developed UNIX Shell scripts for File Manipulation, FTP, Executing DB2 SQLs and archiving log files.
• Created DB2 SQLs for Quality Management load that determines the accuracy of data loaded.
• Implemented various Performance Tuning techniques on Sources, Targets, Mappings, Sessions, Workflows and database.
• Involved in designing Logical/Physical Data Models (Star Schema), forward/reverse engineering using Erwin.
• Prepared Technical Documents related to design, development and testing as per CMM
• Implemented reusable mappings & sessions for Operational Audit Process.
• Created mappings to keep historical data (SCD type 2) and load control for ETL extract.
• Prepared the technical specifications using use cases and maintained versioning & deployment groups’ functionality.
• Involved in monitoring of production ETL applications, Production Support through tickets. Executing Scripts / Managing scheduled activities based on business requirements.

Environment: Informatica Power Center 9.6, IDQ 8.6.1, CDC, IBM DB2 UDB 8, Facets 4.51, Sybase, Erwin 4.2, SQL Server 2005, Oracle11g, Excel, Flat files, SQL, PL/SQL, Win SQL, Windows XP, UNIX Shell Scripts, IBM AIX

Confidential, Charlotte, NC

Informatica Developer

Responsibilities:

• Gathered application, source and target information details.
• Prepared data migration approach process and design document templates.
• Prepared source to target matrix templates.
• Design, develop and implement Extract, Transformation and Load (ETL) processes, programs and scripts using structured software development method.
• Performance tuning of sources, targets, mappings and SQL queries in the transformations.
• Analyzing the data to make sure, if the data can be used for reporting purposes.
• Involved in monitoring of production ETL applications, Production Support through tickets. Executing Scripts / Managing scheduled activities based on business requirements.
• Created reports using Business Objects Desktop Intelligence.
• Have very good knowledge LIMS, Empower2 applications.

Environment: Informatica Power Center 8.6.1, Business Objects XI R2, Teradata V2R6, Oracle11g, DB2, Excel, Flat files, SQL, PL/SQL, TOAD, Erwin, Autosys, LabWareLIMS 5.0/6.0,NuGenesis, Windows XP, UNIX Shell Scripts, Linux.

Confidential, Plano, TX

Informatica Developer

Responsibilities:

• Have Good on experience with Risk Application.
• Prepared the Technical Specifications to some extent gathering the requirements from the source systems. Maintained versioning & deployment groups’ functionality.
• Design, develop and implement Extract, Transformation and Load (ETL) processes, and IDQ plans, created dictionaries for IDQ plans.
• Created stand alone IDQ plans using different components like RBA, Token Labeler, Character Labeler and Search Replace.
• Integrated IDQ plans (export as mapplets in PowerCenter) within mappings and implemented pushdown optimization for better performance.
• Performance tuning of sources, targets, mappings and SQL queries in the transformations.
• Migrating code from development box to Production box.
• Analyzing the data to make sure, if the data can be used for reporting purposes.
• Wrote Unix Shell Scripts for the automation of ETL processes and using Control-M scheduler.
• Created queries using analytical functions for reporting purpose and update the results for end users.
• Involved in monitoring of production ETL applications, Production Support through tickets. Executing Scripts / Managing scheduled activities based on business requirements.
• Data Modeling (Star Schema-dimensional fact tables) using Erwin.
• Developing Complex mappings by extensively using Informatica Transformations like Lookup, Filter, Expression, Aggregator, Joiner, Stored Procedure, Router using Power Center designer.
• Developed various ETL transformations and PL/SQL program units.
• Developed Incremental and updateable loading through mappings.
• Designed reusable transformations and shortcuts to share different mappings.
• Created and edited multiple sessions and added them into batch component.
• Debug, and resolve the loading failures by verifying the log files.
• Validate the data in data marts after loading process balancing with source data.
• Resolve the performance issues by using different methods and techniques.
• Created Power Play cubes using Transformer (Power Play).
• Customized data by adding calculations, summaries and functions.
• Created List Reports, Cross Tab Reports and Drill through reports.
• Generated reports using Cognos Impromptu tools querying database.
• Created Filters, Conditions and Prompts in Catalog.
• Developed Impromptu Web Reports (IWR) and published them into Upfront.
• Presenting complex data summary report.
• Created Report and prompts.
• Created summary and detailed filters.