We provide IT Staff Augmentation Services!

Lead Informatica Developer/administrator Resume

SUMMARY:

  • Around 8 years of experience in designing, developing, maintaining and building large business applications such as data migration, integration, conversion, data warehouse and Testing.
  • 7+ years of experience in Informatica Developer/Administration
  • 2+ years of experience in IDQ and Metadata Manager.
  • Expert in all phases of Software development life cycle - Project Analysis, Requirements, Design Documentation, Development, Unit Testing, User Acceptance Testing, Implementation, Post Implementation Support and Maintenance.
  • Business Requirements review, assessment, gap identification, defining business process, deliver project roadmap including documentation, initial source data definition, mapping, detailed ETL development specifications and operations documentation.
  • Expertise in data warehousing, ETL architecture, Data Profiling.
  • Experience in working with various versions of Informatica Powercenter 10.x,9.x,8.x-Client and Server tools.
  • Expertise in tuning the performance of mappings and sessions in Informatica and determining the performance bottlenecks.
  • Experience in creating pre-session and post-session scripts to ensure timely, accurate processing and ensuring balancing of job runs.
  • Experience in integration of various data sources like SQL Server, Oracle, Tera Data, Flat files, DB2 Mainframes.
  • Strong experience in complex PL/SQL packages, functions, cursors, triggers, views, materialized views, T-SQL, DTS.
  • Expert in troubleshooting/debugging and improving performance at different stages like database, workflows, mapping.
  • Involved in writing Unit test cases for complex scenarios.
  • Experience in creating UNIX shell scripts and Perl scripts.
  • Knowledge in design and development of Business Intelligence reports using BI tools Business Objects, Cognos and knowledge in microstrategy.
  • Knowledge in Installation and configuration of Informatica server with sql server, oracle and able to handle the Informatica administrator tasks like Configuring DSN, creating Connection Strings, copying & moving mappings, workflows, creating folders etc.

TECHNICAL SKILLS:

ETL tools: Power Center 10.x/ 9.x, 8.x, SSIS, TDM, Tableau (Desktop/Server)

BI and Scheduler tools: IBM Cognos 10.x/8.x, SQL Developer, Control-M, SSRS.

Databases: Oracle 12.x/11g/10g/9i, MS SQL Server, Netezza, SQL Assistant.

Programming: SQL, SQL*Plus, Python,C, UNIX shell scripting.

Web Development: HTML, XML.

Operating Systems: Red Hat LINUX, IBM AIX, Windows XP/Vista/7, UNIX.

WORK EXPERIENCE:

Confidential

Lead Informatica Developer/Administrator

Responsibilities:

  • Experienced with Informatica administration on Unix and Linux platform
  • Informatica upgrade and performing end - to-end tasks
  • Handled repository backups, restoration, failover Created the Analyst Service,DataIntegrationService,ModelRepositroy
  • Installed and configured the following IDQ 9.6 components on Linux Servers
  • Migration of Informatica Mappings/Sessions/Workflows from Dev, QA to Prod environments.
  • Configured Master Node and Backup nodes under High Availability environment.
  • Creating Relational Connection in Informatica Workflow Manager level
  • Administration of Repository services and Integration services, Web services on Nodes with Grid concept.
  • Created various Informatica connections to connect to the sources and targets.
  • Creation and maintenance of Informatica users and privileges.
  • Created Native Groups, Native Users, roles, and privileges and assigned them to each user group.
  • Created Informatica Folders and assigning the permissions to the Folders.
  • Migration of Informatica Mappings/Sessions/Workflows from Dev to Test and Test to Stage and Stage to Prod environments.
  • Handled outages when there is any maintenance in UNIX and DATA BASE.
  • Collaboratively worked with Application Support Team, Network, Database Teams, and UNIX teams.
  • Experience in DR planning and setup
  • Provide support to team in performance tuning, troubleshooting, best practices and standards
  • Informatica SCM(Folder Level migration/Object Level Migration)
  • Informatica object Migration using Repository Manager
  • Informatica Administration activity(by using Admin console)
  • Hotfix Implementation
  • Performance tuning of Informatica application
  • Code review of mappings of various application across plant

Environment: : Informatica PowerCenter 10.x/9.x and 8.x, IDQ, Metadata Manager, Power Exchange, Oracle 11g and 10g, SQL, IBM AIX, UNIX Shell Scripts, Remedy, Control-M, Toad, MS Visual Source

Confidential

Informatica Developer/Administrator

Responsibilities:

  • Involved in the Requirements gathering, Analysis and support of Data Warehousing efforts.
  • Designed various mappings using Informatica Designer to load Dimensions and Facts.
  • Installed Informatica 9.x
  • Upgraded Informatica 9.0.1 to 9.1.0, 9.1.0 to 9.5 and 9.5 to 9.5.1
  • Handling the issues in the Informatica level
  • Creation of folders/user permissions.
  • Handling other Informatica administration activities.
  • Created mapplets to use them in different mappings.
  • Used existing ETL standards to develop these mappings.
  • Created various Workflows, worklets and Sessions for the mappings to run.
  • Used various transformations like Aggregator, Joiner, Expression, Filter and Router, Lookup, Update Statergy, Sequence Generator to transform the data.
  • Modified existing mappings for enhancements of new business requirements.
  • Worked with the DB team to put database changes in place for the mappings to run.
  • Used the ETL standard’s to load the Dimension and Fact tables daily by scheduling the workflow using informatica scheduler.
  • Extensively worked as production support developer to identify and fix data problems.
  • Created technical support documentation for the team for production support.
  • Worked on the three-tier model (DEV, TEST, and PRODUCTION).
  • Followed standard procedures to migrate the mappings from Development to Test and Production environments.
  • Used the email task in the Production to keep the team posted when session’s fail.
  • Created store procedures to implement the logics and using them in Informatica.
  • Extensively used environments to create shell script and maintaining the logs of Informatica admin console.

Environment: Informatica Power Center 9.1.0, Control-m, DB2, Autosys, Flat files, TOAD, Oracle 10g, UNIX and Windows 2010.

Confidential

Informatica Developer/Administrator

Responsibilities:

  • Worked as Informatica Administrator/Developer.
  • Defined the naming standards and standard process for Informatica.
  • Installed Informatica 8.6, 9.0.1,9.1.0.
  • Upgraded Informatica 8.5.1 to 8.6.1,8.6.1 to 9.1 HF4
  • Troubleshooting the issues in Informatica Server.
  • Analyzed the functional specs provided by the data architect and created technical specs documents for all the mappings.
  • Provided, recommended solutions and change the process to minimize the cost for projects.
  • Applied Informatica patches to the Informatica servers.
  • Developed complex scripts to follow the business requirements.
  • Loaded Dimension, Fact and Exception tables and automated email generation when exceptions occurred.
  • Migrating the ETL jobs reports from one environment to another environment.
  • Used the email task in the Production to keep the team posted when session’s fail.
  • Extensively used environments to create shell script and maintaining the logs of Informatica admin console.

Environment: Informatica Power Center 8.x/9.x, Control-m, DB2, Autosys, Flat files, TOAD, Oracle 10g, UNIX and Windows 2010.

Confidential

Software Engineer - ETL

Responsibilities:

  • Designed & developed ETL processes based on business rules, job control mechanism using Informatica Power Center 8.x and 9.x. Re-engineered on existing Mappings to support new/changing business requirements.
  • Used Mapping, Sessions Variables/Parameters, and Parameter Files to support change data capture and automate workflow execution process to provide 24x7 available data processing.
  • Prepared SQL Queries to validate the data in both source and target databases.
  • Developed Informatica Mappings to populate the data into dimension and Fact tables for data classifications to end developers.
  • Automated the ETL deployment process integrated with UNIX and Power Center Repositories and reduced the cost of maintenance activities for future activities.
  • Validated the Mappings, Sessions & Workflows, Generated & Loaded the Data into the target database.
  • Tuned the performance of mappings by following Informatica best practices and applied several methods to get best performance by decreasing the run time of workflows.
  • Extensively worked on Expressions, Source Qualifier, Union, Filter, Sequence Generator, sorter, Joiner, Update Strategy Transformations.
  • Handling the issues in the Informatica level.
  • Creation of folders/user permissions.
  • Developed shell scripts to automate the update process.
  • Executed Workflows and Sessions using Workflow Monitor.
  • Involved and resolving the issues (Tickets) in Power center.
  • Tuned SQL queries and performed refinement of the database design leading to significant improvement in system response time and efficiency.

Environment: Informatica Power Center 8.x/9.x, Oracle, Mainframe, DB2, COBOL, UNIX, VSAM, SQL, PL/SQL.

Hire Now