SUMMARY:

• Over 8 years of IT experience in Analysis, Design, Development, Testing, Documentation and Production Support of Business Intelligence - D Confidential warehouse applications.
• Expertise in designing and developing Business Intelligence solutions in staging, Enterprise D Confidential warehouse, Analytical D Confidential warehouse using Informatica Power Center 9.x,8.6 versions, SQL, PL/SQL, Netezza SQL.
• Good exposure to the Agile and Waterfall Software development methodologies.
• Expertise in collecting business requirements & specifications for the d Confidential warehouse design.
• Developed mappings that perform ETL of source d Confidential using various transformations to meet business logic in the mappings.
• Highly proficient in the use of SQL Server, Oracle & PL/SQL in constructing triggers, tables, user functions, views, indexes, relational d Confidential base models and d Confidential integrity, SQL joins and query writing.
• Practical understanding of Entity-Relationship concepts, Facts and dimensions tables, slowly changing dimensions, Dimensional modeling (Star Schema and Snow Flake Schema), Normalization and De-Normalization Concepts.
• Expertise in Dollar universe scheduling tool.
• Work with peers from various functional areas to support their d Confidential warehousing and d Confidential analysis needs and also define IT wide processes like code reviews, performing different kinds of testing, documentation and knowledge sharing.
• Ability to meet deadlines and handle pressures coordinating multiple tasks in project environment.

TECHNICAL SKILLS

D Confidential Warehousing/ETL Tools: Informatica Powercenter 9.x/8.6

D Confidential Modelling: Dimensional D Confidential Modelling, Star SchemaSnow-Flake Modelling

D Confidential Bases: Oracle 11g/10g/9i, SQL Server Netezza appliance

Tools: Toad, SQL Developer, Aginity, Dollar UniversePutty, MS Visio

Operating Systems & packages: MS Windows 8/7/XP, UNIX, MS office

SDLC Methodologies: Agile, waterfall

PROFESSIONAL EXPERIENCE

Confidential

Informatica Developer

Responsibilities:

• Design and develop ETL process using Informatica tool to load d Confidential from wide range of sources such as Flat Files, DB2 and Informix D Confidential bases.
• Responsible for migrating the folders or mappings and sessions from development to test environment and Created Migration Documents to move the code from one Environment to another Environment.
• Based on the Business logic develop various mappings & Mapplets to load d Confidential from various sources using different transformations like Source Qualifier, Filter Expression, Lookup, Router, Update strategy, Sorter, Normalizer, Aggregator, Joiner, SQL transformations, XML Transformation in the mapping.
• Use connected, unconnected lookup, static and dynamic cache to implement business logic and improve the performance.
• Created reusable transformations and Mapplets to reuse while creating ETL mappings.
• Worked on different OLTP d Confidential sources such as SQL Server and Flat files for d Confidential extraction.
• Worked as Secondary/On Call Support during non-office hours.
• Interacted with D Confidential base Administrators to solve the production failures related to d Confidential base (Stale stats, corrupted indexes, table space etc.).
• Configured and used the Debugger to troubleshoot the Informatica mappings.
• Extract d Confidential from DB2 d Confidential base for ETL processing.
• Unit testing and System Testing of Informatica mappings and Workflows.
• Developed ETL code, control files, metad Confidential, and lineage diagrams for ETL programs.
• Created and configured Workflows, Worklets, and Sessions to transport the d Confidential to target using Informatica Workflow Manager.
• Extensively involved in performance tuning at source, target, mapping, session and system levels by analyzing the reject d Confidential .
• Implemented restart strategy and error handling techniques to recover failed sessions.
• Wrote complex SQL Queries involving multiple tables with joins.
• Maintained Development, Test and Production mapping migration using Repository Manager.
• Extensively performed unit testing and system or integration testing.
• Generated PL/SQL scripts and UNIX Shell scripts for automated daily load processes.

Environment: Informatica Power Center 9.6.1/9.1, Netezza, Oracle 11g/10g, PL/SQL, Flat Files, UNIX Shell Scripting, D Confidential Modeling, Mainframes, SQL Query, Autosys, DB2 SQL developer, Windows XP, Unix.

Confidential

Systems Engineer

Responsibilities:

• Translated business processes into Informatica mappings by using Informatica Designer which populated the d Confidential into the Analytical d Confidential warehouse with Netezza.
• Wrote test plans and executed the same at unit testing and also supported for system testing, volume testing and user testing.
• Worked on developing Informatica Mappings, Mapplets, Sessions, Workflows and Worklets for d Confidential loads.
• Extensively worked on Netezza Extract Load and Transformation mechanism by taking d Confidential from various sources and loading it into d Confidential base using NZSQL and NZLOAD utilities.
• Performed various d Confidential cleansing and d Confidential conversion functions in various transformations.
• Developed mapping spreadsheets with source to target d Confidential mapping with physical naming standards, d Confidential types, domain definitions, and meta-d Confidential definitions.
• Created complex stored procedures, functions involving complex joins to integrate multiple sources to build business rules to load the d Confidential .
• Used different cache properties, such as dynamic cache session property to perform the update and insert into the relational table simultaneously using Lookup transformation.
• Configured workflows with Email task, which would send mail with session, log for failure of a sessions and for target failed Rows.
• Tuned performance of Informatica session for large d Confidential files by increasing block size, d Confidential cache size, sequence buffer length and target based on commit interval.
• Assisted the team in the development of design standards and codes for effective ETL procedure development and implementation.
• Prepared the documents required for code migration and was responsible for code deployment to QA and production.

Environment: Informatica Power Center 9.6.1/9.1, Netezza, Oracle 11g/10g, PL/SQL, Flat Files, UNIX Shell Scripting, D Confidential Modeling, SQL Query, Dollar Universe, DB2 SQL developer, Windows XP, Unix.

Confidential

Responsibilities:

• Worked with Business analysts and Architect for requirements gathering, business analysis and designing of the d Confidential warehouse. Translating user inputs into ETL design documents.
• Extensively used Informatica to load d Confidential from multiple source systems and flat files into the target Oracle d Confidential base.
• Developed Informatica workflows and sessions associated with mappings using workflow manager.
• Created test cases for unit testing and coordinated with testing team to make them understand business and transformation rules being used throughout the process.
• Wrote complex SQL scripts involving multiple tables for implementing business rules and transformations.
• Used update strategy and target load plans to load d Confidential into Type-2 /Type-1 Dimensions.
• Used Mapplets and Reusable transformations to prevent redundancy of transformation usage and maintainability.
• Checked sessions and error logs to troubleshoot problems and also used debugger to identify the bottlenecks.
• Work closely with project teams in fixing the d Confidential issues and stay on top of the given timelines.
• Involved in migrating developed components using Informatica Repository through various environments.

Environment: Informatica Power Center 9.6.1/9.1, Netezza, Oracle 11g/10g, PL/SQL, Flat Files, UNIX Shell Scripting, D Confidential Modeling, Mainframes, SQL Query, Autosys, DB2 SQL developer, Windows XP, Unix.

Confidential

Responsibilities:

• Coordinated with source system owners, day-to-day ETL progress monitoring, and d Confidential warehouse target schema design.
• Designed and developed ETL strategies and mappings from source systems to target systems. ETL strategies were designed to cater initial load and incremental load.
• Designed and developed pre-session, post-session routines in the session properties.
• Involved in converting the d Confidential mart from logical design to physical design, defined d Confidential types, constraints, indexes, generated schema in the d Confidential base.
• Developed complex mappings using a range of transformations on the extracted d Confidential according to the business rules and user requirements.
• Used Debugger to validate mappings and also to obtain troubleshooting information about d Confidential . Performance tuning is performed at the mapping level as well as the d Confidential base level to increase the d Confidential throughput.
• Created and configured Workflows, Worklets, and Sessions to transport the d Confidential to target warehouse tables using Informatica Workflow Manager.
• Created Parameter files to run the workflows and performed scheduling of tasks.
• Prepared documentation on all aspects of ETL processes, definitions and mappings.

Environment: Informatica Power Center 9.6.1/9.1, Netezza, Oracle 11g/10g, PL/SQL, Flat Files, UNIX Shell Scripting, D Confidential Modeling, Mainframes, SQL Query, Autosys, DB2 SQL developer, Windows XP, Unix.