We provide IT Staff Augmentation Services!

Sr. Informatica Developer Resume

PROFESSIONAL SUMMARY:

  • 6+ years of IT experience and technical proficiency in the field of Data Warehousing teamed with Data Analysis, Data Modeling, Business Requirements Analysis, Application Design, Development & testing and full life cycle Implementation of Data Warehouse.
  • Strong Data Warehousing experience in Application development & Quality Assurance testing using Informatica Power Center (Designer, Workflow Manager, Workflow Monitor, Repository Manager)
  • Experience in creating complex Informatica Mappings using Source Qualifier, Expression, Router, Aggregator, Lookup and other transformations in Informatica and well versed in debugging an Informatica mapping.
  • Knowledge in OLTP/OLAP System Study and E - R modeling, developing Database Schemas like Star schema and Snowflake schema used in relational, dimensional and multidimensional modeling.
  • Strong at Object Oriented Analysis and Design, programming technical skills along with ability to learn new emerging technologies and adapt quickly.
  • Strong SQL experience in Coding and Query tuning. Well versed with Oracle SQL tools like TOAD, SQL developer and SQL Plus.
  • Hands on experience in Shell scripting and UNIX.
  • Experience in writing PLSQL stored procedures to integrate and achieve business functionality.
  • Experience in creating efficient and effective BRD (Business requirement document), TAD (Technical Architecture document), MDD (Mapping Design Document) and TDD (Technical design document) involving data mappings.
  • Actively participated in Informatica upgrade activities (from Version 8.x to 9.1) and configured domains, nodes, Integration Services and Repository Services.
  • Hands on experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings, and sessions.
  • Good expertise to communicate with Informatica Vendor for configuration/application related errors and complexities.
  • Knowledge of Migration, backup, recovery, tuning, tracing and troubleshooting.
  • Ability to work on Informatica Administrator (Admin Console) and Repository Manager Clients.
  • Ability to work in teams as well as individually, quick learner and able to meet deadlines.
  • Under gone training on MSTR, OFSAA, OBIEE and gained knowledge on the same.
  • Informatica Certified Developer and Administrator in the year 2011.
  • Completed Hadoop and Map Reduce Udacity training.

TECHNICAL SKILLS:

Operating Systems: Windows, Unix

Databases: Oracle 8i, 10g & 11g, SQL, Teradata, DB2,Exadata

Languages: SQL, Shell Scripting, PL-SQL

ETL Tools: Informatica 9.1,8.x - Workflow Monitor, Workflow Manager, Repository Manager, Designer, Metadata Manager, Rule Point, Informatica Administrator, DVO

Data Modeling: Erwin 4.x

Tools: /Utilities: Edit Plus, SQL Plus, Toad, SQL Developer, Putty, BO 6.5, Cognos, OBIEE, MSTR,OFSAA

Packages: MS Office (MS Access, MS Excel, MS Outlook, MS Power point, MS Work)

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Informatica Developer

Responsibilities:

  • Work closely with business, architects and BSAs, participate in analyze sessions.
  • Understanding business requirements and creating design documents by analysing current environment and standards.
  • Code as per the requirements and design, perform UT.
  • Serve as a core member of agile teams that drives user story analysis and elaboration
  • Fixing the defects during UAT phase and coordinating with testing team during SIT.
  • Handling code migration process by creating RFCs, gathering necessary approvals and coordinating with multiple teams.
  • Defect handling after code migration to production.
  • Work with testing and quality, production support teams to meet implementation dates and allow smooth transition throughout the development life-cycle.
  • Creation of ETL logic for Error Handling and calculation of load statistics in ETL process along with building Informatica mappings, sessions, workflows, and other various reusable Informatica objects (Mapplets & reusable transformations).
  • Monitor the jobs in production during warranty period, providing KT to support team and prepare necessary documentation.

Environment: Informatica 9.1/9.6, Oracle, UNIX, SQL Developer, Putty, WinScp, Toad, AutoSYS

Confidential

Tech Lead/ Sr. Informatica Developer

Responsibilities:

  • Understand current code, go through the design documents and understand process flow.
  • Work closely with business, architects and BSAs and participate in analyze sessions.
  • Understanding business requirements and creating design documents by analysing current environment and standards.
  • Work with offshore to explain the design and support during build phase.
  • Code as per the requirements and design, perform code verification and UT.
  • Serve as a core member of agile teams that drives user story analysis and elaboration
  • Fixing the defects during UAT phase and coordinating with testing team during SIT.
  • Ensure modifications to the documents to ensure that those are up to date as per the functionality in the system.
  • Enhancements on current code as per user requirements.
  • Handling code migration process by creating RFCs, gathering necessary approvals and coordinating with multiple teams.
  • Defect handling after code migration to production.
  • Work with testing and quality, production support teams to meet implementation dates and allow smooth transition throughout the development life-cycle.
  • Providing support to offshore team on creation of ETL logic for Error Handling and calculation of load statistics in ETL process along with building Informatica mappings, sessions, workflows, and other various reusable Informatica objects (Mapplets & reusable transformations).
  • Work for ODS- migration team to deploy the code and migrate the components to various environments.
  • Scheduling jobs in ctrl-M and create dependencies.
  • Monitor the jobs in production during warranty period, providing KT to support team and prepare necessary documentation.
  • Work on MSTR requirements to modify existing reports and create new reports as per requirements.

Environment: Informatica 9.1/9.6, Oracle, UNIX, SQL Developer, Putty, WinScp, MSTR, Toad, ctrl M

Confidential

Sr. Informatica Developer

Responsibilities:

  • Understand PL\SQL code, go through the design documents and understand process flow that has to be followed in Informatica.
  • Creation of Mapping Documents for SOURCE feeds to STG and STG to TGT.
  • Review & Understand the schematic diagrams for depicting the pseudo mapping logic, and workflow logic.
  • Creation of Unit test cases for each component in workflow and for other tasks as part of ETL process.
  • Serve as a core member of agile teams that drives user story analysis and elaboration.
  • Build the Informatica mappings, sessions, workflows, and other various reusable Informatica objects (Mapplets & reusable transformations) as per the defined logic in Design Documents.
  • Unit testing the ETL workflow & mappings - fixing the defects which came out of unit testing and if needed, make modifications to the documents to ensure that those are up to date as per the functionality in the system.
  • Extensively worked with History and Incremental Loading using Parameter Files, Mapping Variables and Mapping Parameters.
  • Performance tuning on sources, targets, mappings and SQL queries in the transformations.
  • Extensively used DVO tool for Unit Testing before pushing code to QA.
  • Worked on UNIX shell scripts. Developed UNIX shell scripts to run the pmcmd functionality to start and stop sessions.
  • Hands on crontab scheduling to run jobs as per requirements.
  • Work in Production Support for all the applications which are currently running using PLSQL/Infrmatica code.
  • 24*7 on call support for production issues.
  • Monitor all processes running in PROD and reply to users for any business/technical questions.
  • Enhancements on current code as per user requirements or based on current situations.
  • POC on Proactive Monitoring.

Environment: Informatica 9.1, 9.5 and Oracle 11g, UNIX, Toad, Putty, WinScp, WinMerge

Confidential

Informatica Architect

Responsibilities:

  • Creation of UNIX Level folders for installing latest versions.
  • Installing, testing, analyzing on the latest versions.
  • Assigning properties to Integration Service and Repository Services as per the environment.
  • Creating/joining domains, nodes and grids.
  • Understanding new features by working with Informatica Vendor.
  • Work with Informatica Vendor and participate in resolving configuration and environmental issues.
  • Sharing knowledge to Developers, Administrators on the latest Informatica versions and make them understand the tasks to be performed in understanding and working on new versions.
  • Design reviews of new code developed in various projects.
  • Make sure that any new development should follow TSG standards.
  • Helping developers in resolving any issues they face during the development of new mappings or during enhancements.
  • Supporting Informatica Administrators in resolving complex tickets/break downs.
  • Resolving the tickets raised with Informatica Design teams on design/configuration issues.
  • Involved in process of migration to new Teradata versions and made them work with new Informatica versions.
  • Documentation & Presentation of the project and new architectures.
  • Deciding best properties of various components for maximum performance.

Environment: Oracle 11g, Unix, Informatica 9.1, 8.x, Edit plus, Putty, SQL plus, Toad, Teradata

Confidential

ETL Developer

Responsibilities:

  • Extensively used all the features of Informatica 8.6 including Designer, Workflow manager and Repository Manager, Workflow monitor.
  • Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica power center.
  • Implemented various workflows using transformations such as Normalizer, look up, aggregator, stored procedure and scheduled jobs for different sessions.
  • Working closely with Source System teams to analyze source data and resolve source data issues.
  • Interacting with other project teams for seamless integration.
  • Understanding existing business model and customer requirements with the Functional team.
  • Attending the technical review meetings for Data Modeling.
  • Understanding Data warehouse concepts to implement helpful techniques in the project.
  • Analyzing data model to document the requirements and to document the pseudo code.
  • Responsible for creating Technical specification and Mapping design documents.
  • Designing technical specification documents for all the developed mappings
  • Ensure business rules are translated and documented from business to technical requirements for developers
  • Development of ~50 Informatica mappings to build business rules to load data.
  • Used Informatica power center to extract, transform and load data from multiple input sources like relational sources, legacy sources and flat files to load the target systems.
  • Created mappings using Filter, Expression, Look up, Source Qualifier and Sequence Generator Transformations.
  • Coordinate multiple architects responsible for development, integration, administration, and evolution of the data warehouse
  • Created medium to complex PL/SQL stored procedures for integration with Informatica using Oracle 10g.
  • Automation of job processing, establish automatic email notification to the concerned persons.
  • Involved in unit testing and system integration testing and preparing Unit Test Plan (UTP) and System Test Plan (STP) documents.
  • Worked on HPSD Change Requests (CR) while integration testing and UAT are in progress.
  • Provided 24 *7 production support during all the production release weeks.
  • Worked with Informatica Design and Administrator team for code migration and participated in project Go-live.
  • Extensively worked with Reports Development Team to make them understand the DW to generate required reports using BO and Cognos tools.
  • Transferred knowledge to maintenance team after production go-live.

Environment: Informatica 8.1, Windows XP and Oracle 9i, 11g, UNIX, Erwin 4x, SQL Developer, BO 6.5, Cognos

Confidential

ETL Developer

Responsibilities:

  • Primary responsibility comprised of getting the requirements from the client and then making a transition of the requirement details to the various teams across the project.
  • Attending the technical review meetings for Data Modeling.
  • Performed major role in understanding the business requirements to design and load data into data warehouse.
  • Extensively worked on Informatica Designer, Work Flow Manager, Work Flow Monitor and Repository Manager.
  • Simplification of the existing logic to load the Operational Fact and Financial Fact tables
  • Analyzed the existing logic for loading the Operational fact and Financial Fact tables.
  • Redesigned the ETL Load strategy and created the Informatica mapping designs documents
  • Creating Informatica mappings, Sessions, Workflows and Worklets
  • Worked closely with the ETL Admin team in the promotion of Informatica ETL Objects from Development to QA
  • Developed complex mappings using heterogeneous sources and targets in different Relational Databases and flat files.
  • Optimized/Tuned queries, stored procedures and mappings for better performance and efficiency.
  • Created Project related documents, defined project milestones, schedules, monitoring progress using MS - Project and updating plans as required.
  • Wrote test plans and executed it at UNIT testing and also supported for system testing, volume testing and USER testing.
  • Adapt ETL processes to accommodate change in source systems and new business user requirements
  • Work with Project Manager to identify tasks and timelines for projects.

Environment: Oracle 8i, Informatica 8.x, TOAD, Erwin, Edit plus, Putty

Confidential

Informatica Administrator

Responsibilities:

  • Administration of Informatica Server.
  • User Administration.
  • Creation of Informatica Folders and assigning privileges.
  • Creation of UNIX Level folders.
  • Migration among different environments (Mappings & Data Marts).
  • Load Monitoring.
  • Catering to Ad-hoc Load Requests.
  • Setting up Screen Door Process for Data marts.
  • Session/Batch Scheduling using Informatica Server Manager & Crontab.
  • Maintaining all level of securities for all Repositories.
  • Automation of job processing, establish automatic email notification to the concerned persons.
  • Documentation & Presentation of the project.

Environment: Oracle 8i, Informatica 8.x, Business Objects 6.5.1, TOAD, Edit Plus, Putty

Hire Now