We provide IT Staff Augmentation Services!

Informatica Technology Lead Resume

SUMMARY:

  • 13+ years of IT experience into Business Intelligence/Data warehousing and developing, leading highly effective teams on key customer accounts across Banking, Retail, Insurance, Telecom and Finance domains.
  • Have good understanding of BAL and Geneva Billing systems.
  • More than 2 years of experience in BI apps environment.
  • A consistent performer with a proven track record of providing the services for the company in time and as per the levels of workflow.
  • Keen communicator and team leader with good problem solving and analytical abilities.
  • Aggressive in acquiring new skills, ability to excel under pressure, innovative and self - motivated.
  • Completed Being Agile Aware Confidential certification.
  • Member of Confidential recruitment team.

TECHNICAL EXPERIENCE:

  • Strong understanding of Data Warehousing Life Cycle.
  • Hands on experience in using ETL tools. (Informatica Power Centre and Informatica Power mart and Ab Initio)
  • Currently working on Informatica 10.2.0 version.
  • Extensive knowledge with dimensional data modeling, star schema/snowflakes schema, fact and dimension tables and process mapping using the top-down and bottom-up approach.
  • Have understanding of Business Intelligence.
  • Understanding of Oracle PL/SQL programming.
  • In depth knowledge of Oracle Business Intelligence Enterprise edition.
  • Installation of OBIEE 10.1.3.4.1 , Informatica, DAC and BI APPS on Linux/Windows Environments.

TECHNICAL SKILLS

Languages: C, C++, SQL, PL/SQL.

Database servers: TOAD, Oracle 8i, Oracle 9i, Oracle 10g, Oracle 11g, MySQL server and MSSql server.

ETL TOOLS: Informatica versions 5.1, 6.2, 8.6.0, 8.6.1, 9.0.1, 9.5.1, 9.6.1 and 10.2.0, Ab Initio.

OLAP/Reporting Tools: Cognos, Business Objects.

BI apps: Informatica 9.0.1, DAC 10.1.3.4.1 and OBIEE.

Operating System: Windows 7, Windows 2003, 2008, XP and Unix.

Scheduler: Autosys and DAC (Data Warehouse Administration Console)

Domain Knowledge: Banking, Investment Banking, Retail, Insurance, Telecom and Finance domains.

PROFESSIONAL EXPERIENCE:

Confidential

Informatica Technology Lead

Environment: Database: Oracle

ETL Tool : Informatica 9.6.1, Informatica 10.2.0

Operating system: Unix

Scheduling tool: Autosys

Release Management: SLM

Responsibilities:

  • Leading a team of 6 members in the role of Technology Lead.
  • Actively working on 24*7 support and enhancement related project that has Informatica as ETL tool, UNIX as OS and Oracle as the database.
  • Gather requirements from Client/Onsite.
  • Analyse the High Level Design and Technical Specification Documents.
  • Worked on Requirements analysis, Design, development, Quality Assurance and Operations support.
  • Resolving technical and design issues.
  • Successfully implemented CG initiatives like SLM (Solution life cycle management) for automated releases, PAS (Platform Access Standardization) and Power Center upgrade to 10.2.0 version from 9.6.1 version.
  • Closely working with Business users during the month-end batches and provides timely updates in terms of status of the batches (as they get executed continuously for 2 days) as these are very critical to the Business for reporting purpose.
  • Actively participating in the DR (Disaster Events) that take place over the weekends in every year.
  • Update Business whenever there is any delay in the batches (for any reason) and plan accordingly so that there should not be much impact to Business.
  • Provides spontaneous response to the queries posted by business users and supporting teams.
  • Provide impact analysis for all the supporting applications whenever there any enhancements planned.
  • Single point of contact for SIT/UAT and Performance testing phases.
  • Single point of contact for all the deployments to Production.
  • Worked on production related documentation (KBAs) for recurring Production incidents.
  • Given expert solution to the users for problems in Informatica.
  • Working on releases through SLM (Solution life cycle management).

Confidential

Informatica Technology Lead

Environment: Database: Oracle

ETL Tool : Informatica 9.5.1

Operating system: Unix

Scheduling tool: Control-M

Responsibilities:

  • Gather requirements from Client/Onsite.
  • Leading a team of 8 members at Offshore.
  • Resolving all environmental issues like Informatica upgrade from and helping CM team in sync up of database between DEV-SIT-PROD.
  • Analysed the High Level Design and Technical Specification Documents.
  • Worked on Requirements analysis, Design, development, Quality Assurance and Operations support.
  • Assigning the tasks to the team members and help them in developing the code and unit testing.
  • Reviewing the code before delivering it to the client/onsite.
  • Resolving technical and design issues.
  • Documentation of various standards, best practices & review process documents to be used as guidelines.
  • Single point of contact for SIT/UAT and Performance testing phases.
  • Single point of contact for all the deployments.
  • Worked on production related documentation.
  • Given Knowledge transfer to Application support Group.
  • Given expert solution to the users for problems in Informatica.
  • Mentored new team members with continuous knowledge transfer.

Confidential

Informatica Technology Lead/Onsite Co-ordinator

Environment: Database: Oracle

ETL Tool : Informatica 9.5.1

Operating system: Unix

Responsibilities:

  • As an Onsite Co-ordinator I have interacted with different teams, SMEs, process & system owners to clarify the requirements.
  • Also ensured to complete SIT, UAT and performance testing process.
  • Contributing to the system architecture design.
  • Setting up the infrastructure in co-ordination with client infrastructure team.
  • Analysed the High Level Design and Technical Specification Documents.
  • Requirements analysis, Design, development, Quality Assurance and Operations support.
  • Reviewing the code before delivering it to the client.
  • Documentation of various standards, best practices & review process documents to be used as guidelines.
  • Created Cyber Ark account for Informatica and dlepriv and dleread accounts for UNIX as per RBS best practice.

Confidential

Informatica Technology Lead

Environment: Database: Oracle

ETL Tool : Informatica9.0.1

Responsibilities:

  • Gather requirements from Client/Onsite.
  • Leading a team of 16 members at Offshore.
  • Analysed the High Level Design and Technical Specification Documents.
  • Requirements analysis, Design, development, Quality Assurance and Operations support.
  • Developed several Mappings and Mapplet using corresponding Source, Targets and Transformations.
  • Extensively worked on transformations like Filter, Aggregator, Expression, Router, Lookup, Update Strategy, Sequence generator, Rank.
  • Expertise in tuning the mappings and sessions to optimize the performance.
  • Preparing unit test cases and documentation.
  • Preparing Mapping specs and Test specs documentation.
  • Reviewing the code before delivering it to the client/onsite.
  • Documentation of various standards, best practices & review process documents to be used as guidelines.

Confidential

Informatica ETL Code Designer, DAC implementation and Team Lead

Environment: Database: Microsoft SQL server 2008

ETL Tool: Informatica9.0.1

Scheduler Tool: DAC 10.1.3.4.1 (Data Warehouse Administration Console)

Responsibilities:

  • Gather requirements from Client/Onsite.
  • Extract the data from different source systems like JDE8.0,JDE9.0 and flat files and loading into warehouse.
  • Building mappings according to OBIEE standards.
  • Designed the project in such a way that there are total 5 phases
  • Created sessions and workflows following OBIEE standards both for Full and Incremental loads.
  • Unit testing and data validations.
  • Helping the team in resolving the technical/non-technical issues.
  • At DAC level, I have scheduled the EP’s as per the client specifications after creating the tasks, assembling ‘subject areas’ and building the ‘Execution plans’.
  • Prepare the road-map for the completion of tasks and plan to share the work among the team as per each individual capability.
  • Prepared documents like Technical design document and Data mapping document.
  • Reports will be generated using OBI reporting tool.

Confidential

Informatica ETL Code Designer, DAC implementation and Team Lead

Environment: Database : Oracle 9i

ETL Tool : Informatica9.0.1

Scheduler Tool: DAC 10.1.3.4.1 (Data Warehouse Administration Console)

Responsibilities:

  • Gather requirements from Client/Onsite.
  • Building mappings according to OBIEE standards.
  • Designed the project in such a way that there are 2 phases, SDE and SIL, as per the BI standards at Informatica level
  • Created sessions and workflows following OBIEE standards both for Full and Incremental loads.
  • Unit testing and data validations.
  • Helping the team in resolving the technical/non-technical issues.
  • At DAC level, I have scheduled the EP’s as per the client specifications after creating the tasks, assembling ‘subject areas’ and building the ‘Execution plans’.
  • Prepared documents like Technical design document and Data mapping document.
  • Reports will be generated using OBI reporting tool.

Hire Now