Informatica Technology Lead Resume
Irvine, CA
SUMMARY
- Data Warehouse professional having 13 years of Experience in Business Analysis, Data Analysis, Data Mapping, Data Modeling and ETL in Banking, Retail, Insurance, Telecom and Finance domains.
- Strong understanding of Data Warehousing Life Cycle.
- Extensive hands - on knowledge on MS SQL Server Integration Services (SSIS).
- Hands on experience in using various ETL tools. (Informatica Power Centre and Informatica Power mart and Ab Initio) and currently working on Power Center 10.2.0.
- 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.
- Well experienced in creating deliverables such as Business Requirement Document (BRD), Functional Specific Documents (FSD), System Interface Requirements (SIR), Requirement Traceability Matrix (RTM), High level Design Document (HLD), Use Cases and Data Scenarios.
- Exceptional track record of working in every stage of Software Development Life Cycle (SDLC) using both waterfall and agile methodologies.
- Strong Knowledge of Data Warehousing and Business Analytics.
- Extensive knowledge of using Structured Query Language (SQL) in Teradata, Oracle and SQL Server.
- Implementing end to end process flow using JIRA to handle the production issues and monitoring the activities being the JIRA Admin.
- Designing the new Tables and structures in adherence to Metadata and information management standards defined by client organizations.
- Highly dependable Data Analyst successful at profiling and interpreting data. Supportive and enthusiastic team player dedicated to streamlining processes and efficiently reconciling data issues.
- Experienced in managing project delivery from concept to post production validation.
- Having good experience in tools like Microsoft Excel, Word, PowerPoint, and Visio.
- Excellent Coaching, communication, presentation and analytic skills.
- Experienced in creating User Stories and Use Cases as part of translating business requirements.
- Having good experience in SIT, UAT phases, production support,data stage and customer interaction.
- Experienced in source data quality analysis, defining of quality criteria and data governance.
- Extensive experience in data transformation, data mapping from source to target database schemas.
- Experience in working as project lead coordinating project deliveries from onshore and offshore locations.
- O nshore experience with clients like British Telecom, RBS and Confidential .
- Have good understanding of BAL and Geneva Billing systems.
- More than 2 years of experience in BI apps environment and data stage.
- 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.
- 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.
- Completed Being Agile Aware certification.
- Extensively worked on transformations like Filter, Aggregator, Expression, Router, Lookup, Update Strategy, Sequence generator, Rank.
- 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.
- Given expert solution to the users for problems in Informatica.
- Mentored new team members with continuous knowledge transfer.
- Analysed the High Level Design and Technical Specification Documents.
- Requirements analysis, Design, aelopment, Quality Assurance and Operations support.
- Used Informatica to extract data from Legacy database (Oracle and Flat Files) and load into Oracle 8i to the Data warehouse and Data Mart.
- 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.
- 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’.
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, MS SSIS, Data stage
Data Modelling: ERWIN, Microsoft Visio
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)
Bug Tracking Tools: HP ALM, JIRA
Domain Knowledge: Banking, Investment Banking, Retail, Insurance, Telecom and Finance domains.
PROFESSIONAL EXPERIENCE
Confidential, Irvine, CA
Informatica Technology Lead
Responsibilities:
- Leading a team of 6 members in the role of Technology Lead.
- Working on enhancement related project that has Informatica as ETL tool, UNIX as OS and Oracle as the database.
- Gather requirements from Client.
- Analyse the High-Level Design and Technical Specification Documents.
- Requirements analysis, Design, development, Quality Assurance and Operations support
- Developed Mappings and Mapplet using corresponding Source, Targets and Transformations.
- Extensively worked on transformations like Filter, Aggregator, Expression, Router, Lookup, Update Strategy, Sequence generator, Rank.
- Worked on importing data into the data warehouse using MS SQL Server Integration Services (SSIS).
- Worked on Requirements analysis, Design, development, Quality Assurance and Operations support.
- Resolving technical and design issues.
- Preparing unit test cases and documentation.
- Preparing Mapping specs and Test specs documentation.
- Expertise in tuning the mappings and sessions to optimize the performance.
- Reviewing the code before delivering it to the client/onsite.
- 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).
Environment: Oracle, Informatica 9.6.1, Data Stage ETL,Informatica 10.2.0, UNIX, Auto sys, SLM
Confidential
Informatica Technology Lead
Responsibilities:
- Gather requirements from Client/Onsite.
- Leading a team of 8 members at Offshore.
- Resolving all environmental issues like Informatica upgrade from 861 to 951 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 and date stage.
- Mentored new team members with continuous knowledge transfer.
Environment: Oracle , Informatica 9.5.1, UNIX, Control-M
Confidential
Informatica Technology Lead/Onsite Co-ordinator
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.
Environment: Oracle , Informatica 9.5.1, UNIX,Data Stage.