SUMMARY

• Sound ETL Informatica Developer with over 5 years of experience in Business Intelligence, Data Warehousing Implementation, Project management, system development.
• Experienced in all phases of Software Development Life Cycle (SDLC) from Planning, Requirement Gathering, Analysis, Designing, Implementation, Testing and maintenance of completed project using SDLC methodologies, like Waterfall, Agile (Scrum)
• Solid experience with ETL process and Data Warehousing.
• Experienced creating source definitions using Informatica power center source analyzer
• Created numerous target definitions within Informatica power center target designer
• Expertise in designing and developing complex mappings and transformations in Informatica Power Center mapping designer.
• Developed several reusable and non - reusable sessions within Informatica Power Center Workflow Manager. created simple to complex SQL and PL/SQL queries in Oracle SQL developer
• Solid experience in developing various Data Warehouse concepts, data marts, schemas
• Good communication and presentation skills, I am a self-motivated individual and excellent team player.

TECHNICAL SKILLS

Operating Systems: LINUX/UNIX, Windows, Windows server, Mac.

Project Methodologies: Waterfall, Agile (Scrum)

Modelling Tools: Axure, MS Visio, Balsamiq.

MS office tools: Microsoft Visio, Microsoft Project, Microsoft SharePoint, Microsoft Excel, Microsoft Outlook.

Project Tracking Tool: JIRA, HP ALM

Database: MS Access, Oracle Database, MS SQL Server, Teradata, DB2

Integration and Reporting tool: Informatica, Talend, SAS, R, SSIS, SSAS, SSRS, OBIEE.

Testing Application/Tools: HP Application Lifecycle Management (ALM), HP Quality Centre (QC)

PROFESSIONAL EXPERIENCE

Confidential

ETL Informatica developer

Responsibilities:

• Manages Data Migration, Data Integration, Cleansing, Extraction, Transformation and Loading process for data of disparate data sources to ensure High level of data integrity is maintained.
• Modifies existing target definition and created target table to meet project requirements.
• Uses source analyzer to define and input source definition to satisfy business needs.
• Adheres to Informatica naming convention in all object definitions and ensured Informatica standards are maintained.
• Performs complex mapping with several numbers of transformation or by taking SQL override code and translating it using Informatica utility tools and achieved high performance of workflow.
• Perform extract, transform, and load (ETL) solutions for data warehousing using SQL server integration services. (SSIS) and Informatica
• Performs performance tuning by clearing cache
• Update records using the Slowly Changing Dimension TYPE 1 and 2, and ensured all records within the data warehouse are up-to-date and important history is maintained.
• Develop complex mappings using various transformations like aggregator, union, joiner, router, connected/unconnected lookups, stored procedure, expression, filter, sorter and update strategy, to satisfy business requirements and managed errors when necessary
• Filters rows in Informatica using the Filter Transformation and Source Qualifier Transformation.
• Implements complex business rules in Informatica by creating re-usable transformations and Mapplets
• Improves the performance of Aggregator Transformation by sorting the records before passing to the Aggregator.
• Update records in target tables without using the update strategy by defining the key in the target table and then connecting it to the field to be updated in the mapping target.
• Utilizes the debugging option to identify whether mapping is correct or not without connecting sessions.
• Participates in JAD sessions with subject matter experts, users and other stakeholders to refine functional requirements.
• Frequently used SQL queries to filter data within the Oracle database and created data profiling document.
• Provides technical assistance in identifying, evaluating, and developing systems and procedures that were cost effective and met business requirements.

Confidential

Business Data Analyst Consultant

Responsibilities:

• Gathered user and business requirements through interviews with open-ended discussions, brainstorming sessions and other requirement gathering strategies
• Planned and defined Use Cases created Use Case diagrams, Scenarios and Use Case Narratives using the UML methodologies.
• Tracked change requests and monitored workload and schedule.
• Facilitated JAD sessions with management, development team, users and other stakeholders to refine functional requirements.
• Performed Data mapping, logical data modeling, created class diagrams Activity Diagrams, Sequence Diagrams and ER Diagrams.
• Frequently used SQL queries to filter data within the Oracle database and created data profiling document.
• Scheduled meetings with developers, System Analysts and testers to collaborate resource allocation and project completion.
• Managed workload, schedules and coordinated status review meetings with project managers, business managers and team members to ensure that project deadlines are met at all times.
• Authored progress and completion reports which were then submitted to project management on a weekly basis in MS project.
• Created the Data Mapping Document to specify the Data mapping from various data sources to the target database
• Experienced in performing System Reengineering/Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements.
• Strong experience creating Test Plan and Test Cases and participated in User Acceptance Testing (UAT).
• Experienced creating and modifying Informatica workflow and Worklets
• Experienced in Data migration, Data extraction, Data cleansing, Data profiling and Data quality and Data Mining.
• Supported reporting and analysis requirements from various stakeholders within the organization.
• Carried out complex data analysis in support of management requirements.