PROFESSIONAL SUMMARY

• 13+ years of experience in IT Industry followed all phases of standard SDLC and Agile methodologies including Design, Development, Testing, and Quality Assurance Support, implementation support and maintenance in Communication and Media, Supply Chain & Sales, Investment Management (Financial Services) and Health care industries.
• me has been responsible for designing and developing ETL solutions based on specific requirements and in collaboration with the technical and project teams.
• Authoring detailed designs in accordance with Solution Architecture, Enterprise and Technology principles and standards.
• Use Informatica to code components of significant complexity based on project requirements and assigned technical design.
• Participate in and contribute to technical requirements, operational support documentation, collaborative design discussions and peer review.
• Review project deliverables and providing input to solution Architects on an appropriate development strategy.
• Proactively provide timely task and project updates to peer, team leader / Manager, as appropriate.
• Use judgement and analytical skills through experience and proactively asking the relevant questions to clarify work instructions or to analyze an issue.
• Vast experience in designing and developing complex mappings from varied transformation logic like Unconnected and Connected lookups, Source Qualifier, Router, Filter, Expression, Sorter, Aggregator, Joiner, Update Strategy, Transaction Control, XML Generators, Sequence, Normalizer, SQL Transformation, Stored Procedure Transformation, UNION, etc.
• Involved in debugging and Performance tuning of mappings and sessions
• Extensive experience in data virtualization tool like Informatica Data Services (IDS).
• Having extensive debugging skills in ETL Tools like Informatica Powercenter and databases like Oracle, Microsoft SQL server, Sybase.
• Good working experience on scheduling ETL using Control - M, Maestro and Tidal.
• Two Plus years of reporting tool experience using Business Objects, Hyperion.
• Good noledge of Data warehouse concepts and principles - Star Schema, Snowflake, SCD, Surrogate keys, Normalization/De normalization.
• Experience in integration of various data sources with Multiple Relational Databases like Oracle, SQL Server and Worked on integrating data from flat files like fixed width and delimited.
• Prepared the High-level Design Specifications for ETL Coding and mapping standards.
• Excellent interpersonal and learning skills to adapt the rapid changing technologies and implementing the same at work.
• Performed Team Lead/Project Lead activities both at Onsite and Offshore and mentoring of team mates.

TECHNICAL SKILLS

ETL Tools: Informatica PowerCenter 10, Informatica Data Services (IDS), Sagent (Pitney Bowes Software), Informatica Power Exchange

RDBMS: Oracle, Sybase, EMC Greenplum, SQL Server, Salesforce

Database Languages: SQL, PL/SQL

Data Modeling: Star Schema, Snow Flake Schema, Fact Tables, Dimension Tables, Dimensional Modeling, Normalization and De normalization

Operating Systems: Windows 10, UNIX

PROFESSIONAL EXPERIENCE

Sr. Informatica Developer

Confidential

Responsibilities:

• As part of the Supply Chain Team, me was supporting the forecasting and replenishment tool JDA / Blue Yonder within supply chain systems and halping with upgrades & adding modules.
• Responsible for designing and developing ETL solutions based on specific requirements and in collaboration with the business and other project teams.
• Use Informatica, UNIX and Control - M to code components of significant complexity based on project requirements and assigned technical design.
• Follow all phases of standard SDLC and Agile methodologies including Design, Development, Testing, and Quality Assurance Support.
• Participate in and contributing to technical requirements, operational support documentation, collaborative design discussions and peer review.
• Review project deliverables and providing input to solution Architects on an appropriate development strategy.

Informatica Power

Confidential, Watertown, MA

Responsibilities:

• Responsible for designing and developing ETL solutions based on specific requirements and in collaboration with the technical and project teams.
• Authoring detailed designs in accordance with Solution Architecture, Enterprise and Technology principles and standards.
• Use Informatica to code components of significant complexity based on project requirements and assigned technical design.
• Follow all phases of standard SDLC and Agile methodologies including Design, Development, Testing, and Quality Assurance Support.
• Participate in and contributing to technical requirements, operational support documentation, collaborative design discussions and peer review.
• Review project deliverables and providing input to solution Architects on an appropriate development strategy.
• Proactively provide timely task and project updates to peer, team leader / Manager, as appropriate.
• Use judgement and analytical skills through experience and proactively asking the relevant questions to clarify work instructions or to analyze an issue.

Technology/Software

Confidential

Responsibilities:

• Perform Team Lead/Project Lead activities both at Onsite and Offshore and mentoring of team mates.
• Participate in all phases of SDLC including business requirements collection, analysis, design, development, testing and deployment.
• Requirement Analysis and Impact Analysis for the Enhancements coming in for various Applications being supported.
• Design of the enhancement / new processes in Informatica (Power center & Informatica Data Services) according to client requirements.
• Analysis for the requests raised by the Client regarding the existing applications.
• Develop or enhance the ETL mappings to extract data from the various Sources and load them into the various targets as required.
• Test the mappings and check the quality of the deliverables.
• Prepare the required unit test cases for assigned modules.
• Self-review of Unit test cases, Integration test cases of all the assigned modules.
• Define Test Plan and Test Strategy
• Performance tuning and define standards
• Mentoring and training resources and issue resolution.
• Bridging the gap between Client and Offshore team.
• Experience in working with Agile Methodology for Project execution.
• Production implementation and Production Support.
• Defect analysis and fix, and enhancement support.
• Provide QA and UAT support, Conducted UAT with the end users before production release.
• Provide noledge transfer to new team members, groom new team members.
• Status reports.
• Worked closely with Business Analyst and involved in Data Analysis to identify the business rules.

UNIX

Confidential

Responsibilities:

• Participate in all phases of SDLC including requirements analysis, design, development, testing, and Production Support activities.
• Requirement Analysis and Impact Analysis for the Enhancements coming in for various Applications being supported.
• Design of the enhancement / new processes in Informatica (Power center & Informatica Data Services) according to client requirements.
• Analysis for the requests raised by the Client regarding the existing applications.
• Develop or enhance the ETL mappings to extract data from the various Sources and load them into the various targets as required.
• Test the mappings and check the quality of the deliverables.
• Prepare the required unit test cases for assigned modules.
• Self-review of Unit test cases, Integration test cases of all the assigned modules.
• We monitored Informatica, Hyperion Brio, Kallido and UNIX jobs on a single screen Control- M (Scheduling tool).
• Analysis of Hyperion Reports for Query Optimization.
• Test the mappings and check the quality of the deliverables.
• Project Management related activities including Metrics reporting, Quarterly Business Review, Continuous Improvement Plan, etc.
• Client Interfacing, Requirement gathering and analysis, ETL design and development.
• Leading the offshore team.
• Production implementation and Production Support.
• Defect analysis and fix, and enhancement support.
• Mentoring and training resources and issue resolution.
• Root-cause analysis, fixing the problem if case of any ETL job abend, always ensure and manage the abends to meet SLA.
• Requirement Analysis in case of enhancements (new/existing process), creating technical design doc, High level ETL design doc, ETL mapping doc, unit test cases, Integration test cases etc.
• Code reviews.
• Production bug fixing.
• Provide noledge transfer to new team members, groom new team members.
• Status reports.

Confidential

Developer

Responsibilities:

• Requirement Analysis and Impact Analysis for the Enhancements coming in for various Applications being supported.
• Design of the enhancement / new processes in Informatica according to client requirements.
• Analysis for the requests raised by the Client regarding the existing applications.
• Analysis of Business Objects Reports for Query Optimization.
• Develop or enhance the ETL mappings to extract data from the various Sources and load it into the Oracle databases or Flat files as required.
• Error validation of the data moving from various sources to targets.
• Test the mappings and check the quality of the deliverables.
• Add new fields as business requirement and issues in existing table structure of database and modify the BO universe accordingly.
• Test the Business Objects universe for its integrity and check if reports are fetching correct data in such cases.
• Prepare the required unit test cases for assigned modules.
• Self-Review of Unit test cases, Integration test cases of all the assigned modules.
• Do the detailed unit/integration testing
• Peer to Peer Review of Test Cases
• Has been certified as a Dream Team Member twice in a row.
• BO (Business Objects) RTS (Run Time Support) handling.
• Implementation of new applications in Informatica and Business Objects
• Designing new reports, and ETL jobs
• Peer review of the work performed by team members.
• Unit testing and QA Support.
• Impact analysis for major change request.
• Production support.