SUMMARY:

• Informatica professional with over 6 years of experience in complete System Development Life Cycle with specialization in Business Intelligence.
• Extensive experience in various technical areas like Data analysis, implementation of ETL/ELT processes, Enterprise reporting including dashboard development and database performance tuning.
• Worked in different roles as Data analyst, Technical lead developer and Onsite / Offshore developer lead in various business verticals including Banking, Insurance and Retail domains.
• Expertise in analyzing data and creating Application Implementation Methodology (AIM) documents for development of the project.
• Experience in configuring Informatica PWX CDC to achieve near real time data.
• Working experience in Informatica IDQ
• Expertise in Data Analysis
• Know how to prioritize requirements and create conceptual prototypes and mock - ups
• Savvy to provide on-call support to business and end-users to resolve any data related issues.
• Strong experience in coding UNIX shell scripts. Automating ETL processes and batch processing disparate applications.
• Expertise in multiple Relational Database Management Systems (RDBMS) like DB2, Oracle, Netezza, Teradata.
• Strong experience in coding SQL queries to obtain maximum performance and tuning database parameters like indexes to improve performance.
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema modeling, Snowflakes modeling, fact and dimension tables.
• Committed team player with multitasking capabilities, excellent interpersonal and human relations skills.
• Strong verbal and written communication skills, with an ability to express complex business concepts in technical terms.

SKILL:

ETL (5 years), EXTRACT, TRANSFORM, AND LOAD (5 years), INFORMATICA (5 years), EXCHANGE (4 years), ACCESS (Less than 1 year)

TECHNICAL SKILLS:

ETL Tools: Informatica 9, 10, Power Exchange (PWX), PowerCenter, IDQ, ODI 11g, 12c

Reporting Tool: OBIEE 11g, 12c

Operating Systems: SOLARIS, Win XP, 7, 10, MSDOS

Packages: MS Office (Word, Excel, Access, PowerPoint)

Domain Knowledge: Financials, Insurance, Health Care.

WORK EXPERIENCE:

Sr. Informatica Developer

Confidential, Herndon, VA

Responsibilities:

• Involved in the full SDLC of the project including Design, Development and Testing.
• Performing one - time history loads in different layers for all Business Units.
• Involved in extensive performance tuning by determining bottlenecks at various points like sources, targets, mappings and sessions.
• Extensively created reusable objects such as Mapplets, Shared Lookup and User defined functions to use in different mappings.
• Implement SCD Type1, Type2 mappings to capture data changes into target table.
• Prepare Business requirement document and technical design document.
• Configure PWX CDC on the source tables and load near real time data
• Migrate power exchange and verify PWX CDC migration
• Scheduled workflows using Autosys and dependencies between jobs.
• Performed incremental loads post history data loads across all the Business Units.
• Developed ETL process control table to store audit information of ETL job run.
• Worked with SQL Server to run SQL statements for storing, retrieving, and manipulating data in a relational database
• Involved in Performance/ Query tuning. Generation /interpretation of explain plans and tuning SQL to improve performance. Experience in debugging mappings. Identified bugs in existing mappings by analyzing the data flow and evaluating transformations.
• Developed shell scripts to create parameter file and to kick off informatica jobs.
• Worked with UAT team for defect fixes across UAT and PROD environments.
• Performed ETL Unit Testing to validate the data after loading.
• Collaborated with source systems data stewards and technical personnel for data governance and to resolve any data quality or technical issues related to data ingestion.
• Document all changes for code hand over to business.
• Co-ordinate with business, system analyst, product owner to Facilitate business requirements meetings and influence decisions

Environment: Informatica 10.1.0, PWX, IDQ, Oracle, Toad, UNIX, Autosys, Jenkins, SVN

Informatica Developer

Confidential, Richmond, VA

Responsibilities:

• Design/Development/Implement/Testing of Teradata DWH/Data Marts
• Lead the Data Warehouse Implementation, operational and strategic planning projects, organizing and allocation of resources..
• Create custom mappings for loading Organization data to populate end - point reports
• Develop Extract, Transform and Load Data.
• Good experience with Data Cleansing, Data Analysis, Netezza Data Profiling and necessary Test plans to ensure successful execution of the data loading processes
• Extract data from multiple Source Systems (Eg. CS90, ACES, FACETS, etc.) and load data into EDW.
• Create UNIX shell scripts to pre-process source files for file validation, create list files for indirect data load and execute work flows from Control-M.
• Work with business team to gather business requirements
• Creating Application Implementation Methodology document and provide to onsite and off-shore team and monitoring development activities
• Perform testing and document test scripts for validation
• Develop Business User Acceptance test cases and data sets
• Facilitate business requirements meetings and influence decisions
• Document all changes done during the process of implementing and migrating code and make code ready for production deployment
• Identify bottleneck with existing Data Quality Review Process, Negotiate and Resolve the conflicts in the process.

Environment: Informatica 10.1.0, Teradata, AIX UNIX, Control-M, WLM, Clear Case

Informatica Developer

Confidential

Responsibilities:

• ETL designs from Legacy to data warehouse through different layers like Landing, Staging and data marts.
• Analyze and understand the Customer's Business, their databases and their functionality.
• Extensively used ETL methodology for Data Extraction, Transformation and Loading, in a corporate - wide-ETL Solution.
• Implementation of CDC
• Developed several reusable transformations and mapplets that were used in other mappings.
• Created UNIX shell scripts to pre-process source files before loading and to execute work flows from the command line
• Created detailed design and unit test documentation for the code and dimension tables as assigned.
• Assisted in performing Initial Loads of the Datamart after application was deployed to production.
• Used Power Exchange to source copybook definition
• Used Informatica Power Exchange for loading/retrieving data from mainframe system
• Involved in development of enhancements to the Datamart table such as adding new columns to the existing dimensions, updating transformation logic of existing columns, etc.
• Creating Parameter File
• Creating Unix Scripts (Wrapper Proc Scripts) to run workflow using Unix command line interface.

Environment: Informatica 9.6.1, Netezza, UNIX, Autosys

Informatica Developer

Confidential

Responsibilities:

• Deliver new and complex high quality solutions as EPM, Bank - ETL Data marts to clients in response to varying business requirements.
• Designed and developed test cases and supporting documents for packages based on BRDs
• Execution of jobs from Control - M, Working on Power Center Workflow Monitor to see the status and statistics of the jobs and log files.
• Developed the scripts to validate data conversion rules, business rules.
• Tested the complex code of ETL Informatica, DB2 and Unix scripts
• Data validation for the atomic load, Dimension and Fact Load.
• Module Integration testing using Control-M tool.
• Written test cases for all the complex data conversion functions.
• Reviewing test cases prepared by team members.
• Finding data gaps for the purpose of integration testing.
• Raising defects and sharing analysis knowledge with the onsite team.
• Executing Control-M jobs by understanding job/stream flow, dependencies.
• Involved in integration testing by writing complex queries for calculation methods like Sum, Rolling Ratio and Ratio Methods.
• Prepared test data and test scenarios for MTD, QTD and YTD balances.
• Detail scenario level analysis & Testing of the On-Request & Build Budget Modules

Environment: Informatica 9.5.1, DB2, Oracle, UNIX, Ctrl-M