SUMMARY

• 10+ Years of IT industry Expertise in Requirement Analysis, Functional Analysis, Design, Development, Implementation, Testing, Debugging, Productions Support, Informatica PowerCenter Administration and Maintenance of various Applications.
• Participate in Agile team activities including daily standups, sprint planning, PSI planning, product demos, etc.
• Highly proficient in ETL using Informatica Power Center 10.1/9.6, 9.5, 9.1/8.x/7.x, Informatica Cloud, Informatica DVO, IDQ, MDM and reporting using OBIEE.
• Extensive experience in Performance tuning of Informatica (sources, mappings, targets and sessions) and tuning the SQL queries.
• Experience in scheduling the Informatica workflows using Cntrl - M and Informatica Scheduler.
• Extensive experience working with databases like IBM UDB DB2, Oracle and MS SQL Server.
• Extensive experience working with Salesforce & Informatica Cloud environment.
• Experience in working with UNIX, LINUX and windows environments.
• Involvement in different phases of the Software Development Life Cycle (SDLC).
• Strong expertise in designing and developing Business Intelligence solutions in staging, populating Operational Data Store (ODS), Enterprise Data Warehouse (EDW), Data Marts / Decision Support Systems using Informatica Power Center 10.x/9.x/8.x/7.x Versions.
• Experience working with onsite-offshore model projects while working closely with clients and team members.
• Extensive experience in Data Warehousing Concepts like Ralph Kimball Methodology, Bill Inmon Methodology, Star Schema, Snow Flake Schema, Fact Table, Dimension Table, and Dimension Data Modeling.
• Domain Experience: Diversified experience in multiple domains like Insurance and Supply Chain.
• Excellent communication skills and analytical skills and ability to Lead & perform as team player.

TECHNICAL SKILLS

ETL, BI Tools: Informatica PowerCenter 10.1/9.5/ 9.1 , 8.x, 7.x Power Exchange and OBIEE 12c Reporting.

Packages/Validation Tools: Informatica DVO, Informatica Power Exchange, SAS DataFlux, Pentaho Data Integration, Pentaho Spoon, IDQ and MS Office Tools.

Languages: SQL, PL/SQL, Shell Programming, Windows Batch Scripting

RDBMS & other Tools: Oracle 11g/10g/9i, Oracle, SQL Server, Teradata, DB2, TOAD, IBM Data Studio, SQL Developer. Etc

PROFESSIONAL EXPERIENCE

Confidential, Hanover, MD

Sr. Data Analyst / Sr. Informatica Lead Developer

Responsibilities:

• Working with customer and Sr Technical Managers for business information and application needs.
• Developed Informatica Cloud tasks and populated EDW from salesforce objects.
• Working on Supply chain Domain.
• Extensively worked on Informatica ETL development and provided files to third party vendors.
• Developed medium to complex level informatica mapping and tuning the mappings and workflows for optimum performance.
• Extensively worked on data analysis, design, ETL development, Unit testing, QA/Production deployments and production support.
• Working with offshore team and provided requirements for ETL development.
• Working with the business analyst team to analyze the final data and fixed the issues if any.
• Extensively worked with Informatica migration team for QA and Production deployments.
• Conduct code walkthroughs and review peer code and documentation.
• Extensively used Informatica Cloud and replicate the objects in oracle from salesforce.
• Used Active Batch for informatica jobs scheduling.
• Provide resolution to the incidents and tickets raised

Confidential, Bloomington, IL

Sr. Informatica Lead Developer/Administrator

Responsibilities:

• Analyze user requirements, Coding, Prepare testing specs, database designing.
• Design and Develop Mappings, sessions and workflows in Informatica for data migration.
• Extensively worked on data analysis, design, ETL development, Unit testing, QA/Production deployments and production support.
• Create Reusable Transformations and Mapplets and used them in various Mappings to reduce the redundant work.
• Extract data from flat files and other heterogeneous sources and load the data into respective tables and files.
• Extensively used Mapping Variables, Mapping Parameters, and Parameter Files for the capturing delta loads.
• Extensively worked with Informatica migration team for QA and Production deployments.
• Conduct code walkthroughs and review peer code and documentation.
• Involve in Data validation, Bug Fix, determining the bottlenecks and fixing the bottlenecks.
• Developed PL/SQL stored procedures, packages and functions.
• Extensively worked on Data Integration and Data Management.
• Discussion with Business Analysts and System Analysts to understand the application.
• Design and Develop UNIX Reusable Scripts to be used across the enterprise for Data Movement Projects under HDM.
• Provide support for HDM Framework Utilities across different Projects.
• Provide Production support on shared platforms for different projects.
• Setup and configure power center domain, GRID and Services.
• Apply Hotfix’s as and when required
• Setup an administer power center security for projects
• Design and Develop UNIX Reusable Scripts to automate installation steps

Confidential, Bloomington, IL

Sr. Informatica Lead Developer/ On-Site Coordinator

Responsibilities:

• Analyze user requirements, Coding, Prepare testing specs, database designing.
• Design and Develop Mappings, sessions and workflows in Informatica for data migration.
• Provide support for the implemented code for defects and enhancements.
• Work closely with QA team during the testing phase and fix bugs that were reported.
• Create Reusable Transformations and Mapplets and used them in various Mappings to reduce the redundant work.
• Work with Data / Data Warehouse Architect on logical and physical model designs.
• Perform data validation, reconciliation and error handling in the load process.
• Design and Develop UNIX Reusable Scripts to be used across the enterprise for Data Movement Projects under HDM.
• Provide support for HDM Framework Utilities across different Projects.
• Defect logging and Tracking as per Confidential standard and expectation.
• Unit testing and Integration testing for any issuance changes as per Confidential standard and expectation.
• Communicating day to day status with Project Manager.
• Understanding the business functionality of the application.
• Understand the Business, Technical and Functional Requirements .
• Discussion with Business Analysts and System Analysts to understand the application.
• Discussion with Vendors of the Product to understand the functionality of the Hardware Machine.

Confidential, Bloomington, IL

Sr. Informatica Lead Developer/ On-Site Coordinator

Responsibilities:

• Analysis of the specifications provided by the clients.
• Design of Conversion, Data extraction, transformation and load.
• Testing, validation and implementation of delivered conversion components - with SFI’s active participation.
• Provide support for Integration testing.
• Client Support for Project pilot and rollouts.
• Responsible for overseeing the Quality procedures related to the project.
• Monitoring all the subject areas under all the iterations.
• Developing data naming standards
• Analyzing source systems and creating a Best Practices mapping to the target database schema.
• Defining and implementing the required business transformation rules and logic (ETL development).
• Designing and developing exception handling and data cleansing / standardization procedures.
• Optimizing ETL performance.
• Identifying and managing data quality issues.
• Assessment and recommendation of ETL/other tools.
• Defining a suitable architecture for data integration from multiple, disparate data sources.

Confidential, Bloomington, IL

Sr. Informatica Developer

Responsibilities:

• Analysis of the specifications provided by the clients.
• Design of Conversion, Data extraction, transformation and load.
• Testing, validation and implementation of delivered conversion components - with SFI’s active participation.
• Migration of data from all source system data to target DB2.
• Knowledge transfer to the team on iterations of the project.
• Assigning day to day tasks to the offshore team and reviewing the end product.
• Training on Conversion.
• Provide support for Integration testing.
• Client Support for Project pilot and rollouts.
• Responsible for overseeing the Quality procedures related to the project.
• Monitoring all the subject areas under all the iterations.
• Developing data naming standards
• Analyzing source systems and creating a Best Practices mapping to the target database schema.
• Defining and implementing the required business transformation rules and logic (ETL development).
• Designing and developing exception handling and data cleansing / standardization procedures.
• Optimizing ETL performance.
• Identifying and managing data quality issues.
• Assessment and recommendation of ETL/other tools.
• Defining a suitable architecture for data integration from multiple, disparate data sources.

Confidential, Bloomington, IL

Informatica Developer

Responsibilities:

• Involved in Analysis of source target parent child relationships.
• Conduct data quality analysis on various source data systems.
• Analyzed Informatica data mapping requirements.
• Developed complex queries, UNIX scripts and Informatica mappings to analyze exception data.
• Communicate Requirements, Development and Data related issues to concerned teams.
• Raised defects in Lotus Notes with complete defect descriptions.
• Development of reporting module using Ms Access & Excel reports.
• Tracked each exception defect till its resolution.
• Presentation of Issues and findings to subject matter expert.