We provide IT Staff Augmentation Services!

Sr. Informatica Architect Resume

Torrance, CA

PROFESSIONAL SUMMARY:

  • Overall 14+ years of Industry and 12+ Years of Informatica experience. Worked on since V5.x till V9.
  • Worked various projects like Data warehousing, Data migration, SAP conversion project, LRS projects.
  • Extensive experience in Informatica Power Center, PowerConnect/PowerExchange, IDQ and IDE.
  • Expertise in all phases of SDLC like Requirements Gathering, Source system analysis, Designing, Implementation, Gap analysis, Development, Testing and QA activities
  • Worked on different DBs and utilized DB tools for performance gain during loading and a SME on Informatica Power Center and provided technical support for multiple projects.
  • Worked on multiple Data sources including SAP R/3, Mainframe systems, EBCDIC files, COBOL sources, RDBMS, ASCII files, etc.
  • Good understanding of DB architecture and worked on many DB objects and written complex SQLs as a replacement to Informatica scripts wherever possible.
  • Good knowledge in automation process of Data warehousing loading using PMCMD and Unix scripting.

TECHNICAL SKILLS:

Data Warehousing/ETL Tools: Informatica 9/8.6/8.1.1/7/6/5 (Informatica PowerCenter,, PowerConnect/PowerExchange)

RDBMS: Oracle 10g/9i, TeraData V2R5, DB2/UDB 7.0/6.0, SQL Server 2000, Sybase ASE/IQ.

Programming Languages: PL/SQL, SQL, UNIX Shell Scripting, C.

ERP: SAP R/3, IBM Mainframes.

Tools: & Utilities: TOAD 7.x, SQL Analyzer, Embarcadero Sybase editor, Visio, Erwin 4.0, DAC.

Operating Systems: Windows 98/NT/2000/XP/VISTA, UNIX (Sun Solaris, HP - UX, RS 6000), Linux.

PROFESSIONAL EXPERIENCE:

Confidential, Torrance, CA

Sr. Informatica Architect

Responsibilities:

  • Understanding of As-IS interfaces and To-Be interfaces and changes, identifying gaps.
  • Writing of requirement specs for To-Be interfaces based on the New ALFA servicing system.
  • Documenting Informatica batch interface requirements, TIBCO real-time requirements, MFT file transfer requirements.
  • Reviewing of technical design documents in alignment with the approved requirements.
  • Reviewing of Informatica mappings, ETL scripts, Test scripts and providing approvals.
  • Review and recommend best practices and standards for ODS and batch interface design and mappings development.
  • Work with the development team lead for the integrity of the data integration and working across the level for the requirement to final code migration to upper environment.
  • Analyze various downstream applications with diverse technologies like Oracle, SQL server, Siebel, Salesforce, custom development applications, etc.
  • Devised processes and aligning the development team for smother and efficient code development across the team.
  • Involved in the development for the pilot phase of the project and full cutover strategies for various branch/DSSOs.
  • Worked on various tools like Informatica power center, IDQ, DA, TDM, etc.
  • Involved in performance tuning of long running workflows.
  • Raised defects in HPQC for identified ODS Data validation defects.
  • Requirement analysis on the Confidential 's requirement document.
  • Detailed analysis on PHP calculation and system design requirements.
  • Understanding, Analysis and design of Metro 2 format.
  • Designed one time load of Active and charge - off accounts of PHP values from Legacy (Lemans/Shaw) source system.
  • Involved in the calculation/Recalculation of PHP and merging between the one time loads from legacy to newly calculated PHP values.
  • Involved in design of updating the historically derived PHP values and overriding from manual updates from CEP (Salesforce).
  • System Requirement review based on the DST output's requirement document for billing statement project.
  • Design of billing statements in Informatica power center.
  • Development of complex billing statements formats in Informatica power center & UNIX script.
  • Reconciliation of statements between the ALFA, ODS and the vendor system (QV) for the correctness of the statement.
  • Worked across different teams internally and external vendors for the effective delivery of the statement files.

Environment: Informatica PowerCenter 9.6.1/10.1, TIBCO, Oracle, MFT, SQL Server, Toad, UNIX Scripting. DOORs requirement tool, IR(Integration Repository) data base

Confidential, SantaMonica, CA

Database Management developer

Responsibilities:

  • Understanding the existing business model and Atlas data model for the incoming data.
  • Designing the develop mapping from source to Atlas Data mart.
  • Implementation of data flow from source to target.
  • Working with Cognos team to understand the reporting requirements and set expectations
  • Enhancing ETL layer object to Cognos for the report development.
  • Integration between WAD and DataPassBack (DPB) files.
  • Testing the Informatica mappings.
  • Migration from DEV environment to QA and then to PROD environment.
  • Working with Business users to make the data mart available and usable to them on day to day basis.
  • Worked with external vendors for specific brands (XOUT & USTS) data extraction and posting data files in ftp for meaning reports generated by them for the company using customized marketing applications.
  • Extracted data from OLTP application using customized client from FOXPRO system and loaded data into staging and then to final data tables using informatica.

Confidential, SantaMonica, CA

Informatica Consultant

Responsibilities:

  • Source System analogy for Weblog data.
  • Understanding the existing business model.
  • Designing the Data mapping from source the Data tables.
  • Implementation of data flow from source to target.
  • Testing the Informatica mappings.
  • Devising SQL to generate the report and circulate to designated DL business users.
  • Automation of the data loads and SQL using Informatica scheduler.

Confidential, Irvine, CA

Sr. ETL Developer

Responsibilities:

  • Source System analogy for Trackwise system.
  • Logical and Physical Erwin Data model development for Landing, ODS and Data mart layer.
  • Designing the Data mapping from source the Data mart.
  • Implementation of mappings across Landing, ODS and Data mart layer.
  • Understanding the Datastage mappings and Business rules for Datastage to Informatica implementation.
  • Creation and validation of the incoming source files from external vendor using UNIX scripts.
  • Design of Physical DB layer for landing and Data mart stages.
  • Implementation of mappings for Landing and Data mart tables. understanding the .NET application architecture and underlying table structure and the metadata of the source system.
  • Design the extraction process using the metadata from .NET application.
  • Implementation of Informatica mappings for intermediate and final target tables.
  • Converting existing source system based complex SQLs into the Data mart based SQLs.
  • Documentation for ETL Object Inventory, Source-target column mappings & IQ and OQ process migration documentation.
  • Deployment of code to VAL and PROD from DEV with ETL admin team.
  • Validating and Attending the defects raised by Test director.
  • Production support activities.

Environment: Informatica PowerCenter 9/8.6,Data Stage, Oracle, SQL, Toad, Unix Scripting.

Confidential, Orange, CA

Sr. ETL Developer

Responsibilities:

  • Converting Business requirements to technical scripting.
  • Implementing Informatica objects, SQL and UNIX scripts.
  • Involved in writing generic SQLs for more than 250+ attributes of AGDM.
  • Written complex SQLs as ETL scripts for 100% functional coverage & Testing.
  • Worked across various teams to understand and co-ordinate the required functionality to Business.
  • Performances tuned the existing ETL scripts by optimizing mappings and DB partitions. Covering all the possible scenario exists for the business.
  • Created PATCH mappings and modification in existing and new mappings to address the functional defects.
  • Provided estimates and implementation plan.
  • Provided technical solutions for existing issues/defects.
  • Offshore/Onshore co-ordination technically/Functionally and assign tasks.
  • Part of the certification team to check and verify the Production data mart’s validation for it’s required functionality.
  • Involved in writing Complex validation SQLs for multiple projects which are moved into PROD environment.
  • Involved in integrating SQLs in SAS scripts for automated run of certification scripts.
  • Managed projects and certification team as a POC.
  • Define Auto growth Data mart sourced from FDR- EDW as required by business reporting.
  • Reconcile the AGDM reports with the Existing MIS reports for written Premiums and Retention.
  • Match and provide required business attributes calculated in ETL and reporting Layer.

Environment: Informatica PowerCenter 9/8.6, DB2 UDB, SQL, PL/SQL, Toad, Unix Scripting, DB2 SQL scripting.

Confidential

Technical Lead

Responsibilities:

  • Define various Data marts for areas such as Premium, Claims, Reinsurance and many more subject areas.
  • Reconcile with the FINMIS system with various sources for premium and claim.
  • Match/Link any new incoming claims into the premium information and evaluation quickly and serve the client better. Currently due to the non-integrated manner, the business is taking too much time with high cost resources and specialists.
  • Create a single centralized repository of reports required by business analyst, so that they will analyze more than worry about the technical difficulties accessing data.
  • Consolidate various sources of information and into a single data repository as a Data warehouse for the swift product development as a market leader than respond to a competitor for new product development.
  • Involved in Requirement gathering & Analysis.
  • Managed teams including Data Modeling and Technical Design.
  • Technically lead the ETL team and Reporting team.
  • Identified required project Standards and implementations of the standards and audit control and balancing.
  • Documented the Coding standards and Test cases and test strategy.
  • Resource identification and building the team.
  • Onshore-Offshore Co-ordination.
  • Organized KT with Client team.

Environment: Informatica PowerCenter 8.6.1, DB2 UDB, SQL Server 2000, Toad, Cognos 8.4.

Confidential

Test Lead

Responsibilities:

  • Develop various Data marts as required by the Confidential cables.
  • Devise strong testing strategy to filter out many an issue during the development projects.
  • Documenting the Design, Coding to testing in the identified tool.
  • Involved Design Review.
  • Involved in Code review in Informatica mappings.
  • Involved in devising a effective Test strategy for 100% coverage.
  • Involved in Testing and documenting the test results.
  • Following Complete cycle in HPQC from releases to requirements, test case, issues, Bug closure and RTM..

Environment: Informatica PowerCenter 8.6.1, Oracle, HPQC, SQL scripting.

Confidential

Informatica Consultant

Responsibilities:

  • Achieved SLA for all the supporting projects/Objects and tune.
  • Achieved loading time within in the loading windows, since the data has grown over the period of time.
  • Documented the recommendation required for the performance improvements.
  • Involved in implementing the recommendations with the client team (SDC) and get an approval from them for a new project for these recommendation implementations.
  • Analyzed & provided performance tuning recommendations the existing ETL objects.
  • Documented and devised implementation strategies.
  • Involved in KT with the offshore and SDC team.
  • Provided Plan and estimation and expected performance out of the implementation of the recommendations.

Environment: Informatica PowerCenter 8.1, Oracle 10g, SQL, PL/SQL, DAC, Windows.

Confidential

SAP Integration Lead

Responsibilities:

  • Design/Develop ETL logic for sourcing SAP R/3 systems.
  • Owned the sourcing part from SAP R/3.
  • Developed source system analysis on the SAP tables and generated common transformation logic across disparate sources.
  • Informatica PowerConnect/PowerExchange used to source from SAP.
  • Converting the business requirements to Technical designs.
  • Designed ETL components with re-usable components used across multiple related modules.
  • Used automation scripts to run off-business hours for data movement.

Environment: Informatica Power Center 8.5, PowerConnect/PowerExchange, DB2 UDB, SQL, PL/SQL, Windows NT

Confidential

SAP Conversion Lead

Responsibilities:

  • Design/Develop ETL logic for sourcing from legacy and loading in to SAP R/3 systems.
  • Developed complex mappings on cleansing rules using fuzzy logic to cleanse the customer/vendor master.
  • Generated outbound IDocs to load into SAP R/3 system.
  • Guide the team with the Informatica and SAP integration and Data quality rules applicable to source systems.
  • Plan and estimation for the entire project.
  • Worked with client SMEs/Senior management and consulted on the Cleansing rule implementation as a technical lead.

Environment: Informatica Power Center 8.5, DB2 UDB, SQL, PL/SQL, Windows NT, iDocs, LSMW.

Confidential

ETL Architect

Responsibilities:

  • Architected the new flow replacing the existing data flow.
  • Estimated based on the Analogy on the existing objects. Used ADM ( Confidential Delivery Methodology) standard estimators for estimation.
  • Planned detailed WBS and resource allocation done based on the available resources and contingency plan for the safe delivery of the project.
  • Designed End-To-End ETL design and producing HLD, LLD and coordinated with the client team for the implementation of the same.
  • Configured Informatica Environment for the proper management of the Environment and standard processes followed.

Environment: Informatica PowerCenter 8.1, Oracle, PL SQL

Confidential

Informatica Consultant

Responsibilities:

  • Contributed for the SME reviews for the project delivery.
  • Participated in responding to the RFP with estimation using standard delivery methodology estimators.
  • Lead Development teams in developing reusable assets and asset ideas for high performance project delivery.
  • Presented and won papers internally to the SME forums.
  • Taken trainings technical and behavioral for the new joiners and lateral recruits.
  • Improve proficiency with the PDP (Proficiency development plan).

Environment: Informatica PowerCenter 8.1, Oracle, Teradata, SQL server, SQL, PL SQL

Confidential

Informatica Offshore Lead

Responsibilities:

  • Upgraded the Informatica V.5 to Informatica 8.1.
  • Involved in enhancements on Batch processing
  • Rationalized the existing objects.
  • Created an Inventory for existing repository.
  • Improved manageability by controlling and re-using existing object inventory.
  • Involved as an offshore technical lead.
  • Technically reviewed and enhancement of various objects from the lower version to higher versions.
  • Devised steps for conversion from lower version to higher version.
  • Validated and devised testing approach for the converted/Enhanced ETL.
  • Also involved in Backups, Running iterative upgradating process, Proper allocation of temp tables and spaces in the ETL repository

Environment: Informatica PowerCenter V 5.x, V.7.2.1& 8.1, Oracle, Unix, Shell Scripting.

Confidential

Technical Lead

Responsibilities:

  • Involved in Source system Analogy and produced a Data dictionary for the source system.
  • Produced Logical data mapping and data profiling.
  • Involved in Designing the R&R Data mart.

Environment: Informatica PowerCenter V 7.1, Erwin, Oracle, Unix, Shell Scripting.

Confidential

Onshore Team Lead

Responsibilities:

  • Involved in Understanding the child companies DWH. Environment.
  • Generated reports on and above of the two DWH systems.
  • Involved in Analogy and identification of metadata for the child company.
  • Involved in managing the Onshore Development and Supporting team.
  • Design, Development and coordination across teams from provider team to client and then to third party data provider like FDI.
  • Data loading plan and implementation.

Environment: Informatica PowerCenter V 7.2.1, Oracle, EBCDIC Files, V-Editor, Cobol,Scripting.

Confidential

Onshore Team Lead

Responsibilities:

  • Migrated data from the older application to newer application.
  • CBS application is a local one and BBS is a centralized Java application, which has a drastic data model change. Involved in this movement according to Data movement.
  • Developed Level information needs to be mapped to Reference data/Master data.
  • Involved in Informatica environment standard/Best practices needs to be followed in project environment.
  • Involved in requirement gathering, Client discussions, Cleansing and Transformations and rules finalization.
  • Reported the Weekly reporting to client manager.
  • Test environment and test script generation and test case with data capture.
  • DB design, Data migration and reporting and application performance
  • Informatica Administration and users/Group management

Environment: Informatica PowerCenter V 7.2.1, Oracle.

Confidential

Technical Team Lead

Responsibilities:

  • Involved in Source SAS data sets migrated into Sybase.
  • Involved in Re-aligning the existing data for the new Java application
  • Lead the ETL team for Data migration with cleansing.
  • Involved in Re-modeling of source system into Target model.
  • Involved in Requirement Gathering and Analysis and Validation of survey code and Review.
  • Lead the Informatica team for re-usable components design and ownership for more than 40 Surveys.
  • Involved in migration of surveys and preparation of data mapping sheets, Risk Analysis document, Unit Test cases, Data consistency with the defined data model.
  • Coordination with the Java Application team to ensure the single point of understanding as far as the Migration and application development is concern.
  • Managed Informatica Administration like managing users/Groups,In Folder creation, Access privileges, Automated Backups, Interface trouble shooting.
  • Performed Code review, System testing, UAT and performance tuning in Informatica scripts.

Environment: Informatica PowerCenter V 6.2.1, Sybase ASE 12 & IQ, Windows Batch programming.

Confidential

Technical Team member

Responsibilities:

  • Extracted, Transformed and loaded data from site FoxPro files into Target DB.
  • Used external loader, Indirect loading Partitions and performance tuning of Informatica scripts.
  • Designed Informatica scripts, DTS scripts, Used BO and generated reports.
  • Involved in Analysis, Design using DTS with SQL server 2000 and created packages for the monthly transfer activities.
  • Maintenance and troubleshooting of data related errors. Responsible for report generation and correctness of Business parameters.
  • Regular back up of ISO and SQL Server through SQL queries.
  • Performed Code review, System testing, UAT and performance tuning in Informatica scripts.

Environment: Informatica PowerCenter V 5.0, SQL server 2000,SQL Analyzer, VMS.

Hire Now