We provide IT Staff Augmentation Services!

Sr Informatica Developer/informatica Admin Resume

VirginiA

 Summary of Qualifications:

  • Over 17 years of IT experience, which includes 10+ years of data modeling and ETL development using Informatica 9.5.1/8.x/7.x/6.x/5.x, 1 year of business Objects and 5 + years of Visual Basic.
  • Experience in complete life cycle of an Enterprise Data warehouse
  • Expertise in implementing complex Business rules by creating robust mappings/mapplets, shortcuts, reusable transformations, User defined functions and Partitioning Sessions
  • Developed standards for Informatica/Data Integrator development, code reviews, and migration methodologies
  • Extensive knowledge of performance tuning techniques for Informatica and Data Integrator
  • Used multiple RDBMS including Oracle 8i/9i/10/11, Teradata SQL Server and MS Access
  • Worked with different Data sources ranging from flat files, Oracle, SQL server, Teradata databases
  • Hands on experience in Star and Snow flake schema design and De - normalization techniques
  • Well versed with Data warehousing concepts such as Design, Development and Extraction of data
  • Exceptional analytical and problem solving skills. Team Player with the ability to communicate effectively at all levels of the development process

COMPUTER SKILLS:

ETL tools: Informatica Power Center 9.5.1/8.1.1/7. x/6.x…

Reporting Tools : Business Objects XI, 5.1, 4.0, Web Intelligence, Crystal Reports

Data modeling tools: ERWIN 3.x, 4.0; Oracle Designer 2000

GUI: Visual Basic 6, 5, 4; API, COM, ActiveX, VBA, VBScript

RDBMS: Teradata, Oracle 9i, 8i, 8x, 7x; MS SQL Server, Sybase

Languages: Korn shell, SQL, PL/SQL

Operating Systems: Solaris, Compaq Tru64, AIX, LINUX, HP-UX Windows XP/ 2003/2000/98/95/ NT

EMPLOYMENT HISTORY:

Confidential, Virginia

Sr Informatica Developer/Informatica Admin

  • Was part of the team during the upgrade from 8.6.x to 9.5.1.
  • Worked on following projects
  • NFTS(convert SQL code to Informatica).(Lead Developer)
  • Files Mart(2nd iteration of NFTS)(Lead Developer)
  • C3 Consolidation
  • C3 Benefits Mart
  • VSS(Canadian Visa)(Lead Developer)
  • Created complex mappings and reusable code for the common shared dimensions across all applications.
  • Worked on implementing a very sophisticated parameterization of the entire ETL code.
  • Deploy the code to different environments.
  • Provided guidance to my peer developers.
  • Tune the mappings to enhance the performance by considering various options (use DB lookup or Informatica lookups/ use dynamic lookups vs lookup cache, weather to use the join conditions in the Source qualifier or the joiner transformation ……)

Confidential, 

Virginia,

Data Warehouse ETL Developer

  • Was part of the team during the upgrade from 7.1 to 8.1.1.
  • Sources: flat files, tables (My SQL, SQL Server, Oracle) & XML files.
  • Target: Teradata, Oracle
  • Participated in the Software Development Lifecycle and created the Software Development Plan
  • Involved in full life cycle development including design, ETL strategy, troubleshooting and reporting
  • Performed data cleansing and transformation using Power Center/Power Mart
  • Worked extensively on Normalizer, sorter, Expression, Lookup (connected and unconnected) Sequence, Update Strategy, Filter, Joiner, Router, Expression, and Aggregate Transformations.
  • Created Mapplet input, Mapplet output transformations, reusable transformation, reusable tasks and Worklets
  • Created and scheduled workflow with the following tasks: command, decision tree, email, event wait and timer.
  • Shell scripts to notify the operations team to notify failure in job failures.
  • Wrote SQL stored procedures to create temp tables on the source DB for ETL process.
  • I have documented all of the initiatives that were assigned to me. I have documented the requirements, design and the Technical ETL process.
  • Worked with QA to create the test plan and provide the test cases to be tested.

Confidential 

Washington D.C., Data Warehouse Architect

  • Installed Business objects XI on a cluster environment for DCStat.
  • Created objects such as dimension and fact tables and sequences
  • Involved in analysis, design and development of the Enterprise Data Warehouse.
  • Involved in the detailed design of STAR Schema Dimensional Model using Erwin 4.0.
  • Installed and configured all Business Objects modules (Supervisor, Designer & Business Objects) and created Repository.
  • Extensively used Business Objects clients - Supervisor, Designer & Business Objects and scheduled the actions like Refreshment and Distribution of Documents, using Broad Cast Agent.
  • Developed Universes using the Business Objects Designer and connected to the Database using ODBC.
  • Used Designer Module to Create prompts and queries, applied Aliases to remove cyclic Loops
  • Created Cardinalities, Joins and Aliases for resolving Loops and checked the Integrity of the Universes.
  • Linked one Universe to another in Business Objects Designer to incorporate Inheritance.
  • Created reports for the users on a regular and ad-hoc basis using Business Objects and WebI, which were used by the Managers to take key decisions.
  • Used Aggregate Awareness feature of Business Object Universe for better performance and smooth execution of BO reports.
  • Extensively used BO & WebI reporting functionality such as Slice and Dice, Sorting, Hierarchies, Drill Down, Drill up, Filter, Calculation, Report Layout, Prompts, Tabular, Cross-Tabular, Bar-Chart reports, Aggregates, formatting, Scheduling of Jobs for full client reports for Performing OLAP on the generated reports.
  • Worked with multiple Data Providers (Universes, stored procedures and personal data files) in a report.
  • Developed BO Reports and published on the Web under Corporate Documents folder.
  • Worked on Web Intelligence in developing and publishing thin client reports.
  • Define Sets by grouping your business data using highly visual step-wise queries.
  • Define key Metrics you want to track over time, and perform advanced time series analysis.
  • Define Business rules to automate actions based on conditions, define and publish alerts.
  • Migration of Universes from development to Production environment.
  • Worked on the hot fixes and production fixes on emergency basis and gave support to the users.
  • Proficiently worked together with management as well as development team

Confidential

Washington D.C., Data Warehouse Developer

  • Used Informatica 6.0/7.1, Oracle Designer, SQL, PL/SQL, Oracle 9i, Shell Scripts, Windows NT, PVCS
  • Participated in the Software Development Lifecycle and created the Software Development Plan
  • Involved in full life cycle development including design, ETL strategy, troubleshooting and reporting
  • Dimensional modeling for the data marts using Oracle Designer
  • Performed data cleansing and transformation using Power Center/Power Mart
  • Identified the Slowly Changing Dimensions
  • Implement business rules using Oracle procedures, packages, functions and triggers
  • Designed, created and scheduled Korn shell scripts for various jobs and wrote scripts to generate the parameter files
  • Created repository using Informatica Repository Manager
  • Created objects such as dimension and fact tables and sequences
  • Worked extensively on Lookup, Sequence, Update Strategy, Filter, Joiner, Router, Expression, and Aggregate Transformations in Informatica 6.0.
  • Created Mapplet input, Mapplet output transformations, reusable transformation, Mapplets, reusable tasks and Worklets
  • Used type coercion, string manipulations, arithmetic functions, aggregation
  • Created and scheduled workflow with the following tasks: command, decision tree, email, event wait and timer
  • Loaded the data warehouse using relational data and text files (fixed length, fixed width and comma delimited)
  • Created a centralized metadata repository of all the applications
  • Tuned Informatica for better performance
  • Train the new employees in Informatica

Software Quality Assurance (SQA) Responsibilities:

  • Performed SQA Audits to ensure that all applications are following the CMM standards
  • Developed processes and procedures to facilitate learning CMM for the team
  • Created, updated and maintained SQA processes, procedures and tools to support SQA planning, tracking, audits, reviews, reporting and training for each project
  • Worked with project management team to coordinate SQA for the project, which included customizing the SQA activities and use of documented processes, procedures, and project compliance
  • Ensured that quality methods, procedures, and standards were followed at each step in the software development life cycle
  • Identified and provided training needs on SQA processes and procedures using standardized training material
  • Worked with the SQA manager to define project-specific SQA activities
  • Performed audits/reviews of project work products using the SQA plan
  • Performed software baseline audits of the documentation against the new product baseline
  • Reported SQA product activities and results to the SQA manager , along with evidence of use
  • Sorted SQA audit work products in PVCS Dimensions
  • Recommended activities to the SQA manager to improve the work products, including checklists and guidelines as a result of usage and lessons learned

Hire Now