We provide IT Staff Augmentation Services!

Sr. Informatica Consultant Resume

4.00/5 (Submit Your Rating)

Los Angeles, CA

PROFESSIONAL SUMMARY:

  • Eight plus (8+) years of IT experiences in the Analysis, Design, Development, Testing and Implementation of business application systems.
  • Strong experience in the analysis, design, development, testing and implementation of Business Intelligence solutions using Data Warehouse/
  • Data Mart Design, ETL, OLAP, BI, Client/Server applications.
  • Strong Data Warehousing ETL experience of using Informatica 9.1/8.6.1/8.5/8.1/7.1 PowerCenter Client tools - Mapping Designer,Repository Manager, Workflow Manager/Monitor and Server tools - Informatica Server, Repository Server Manager.
  • Expertise in Data Warehouse/Data Mart, ODS, OLTP and OLAP implementations teamed with project scope, analysis, requirements gathering, data modeling, effort estimation, ETL design, development, system testing, implementation and production support.
  • Extensive testing ETL experience using Informatica 9.1/8.6.1/8.58.1/7.1/6.2/5.1 (PowerCenter/ PowerMart) (Designer, Workflow Manager,
  • Workflow Monitor and Server Manager) Teradata and Business Objects.
  • Used transformations like Joiner, Expression, Connected and Unconnected Lookups, Filter, Aggregator, Stored Procedure, Rank, Update Strategy,Java Transformation, Router and Sequence generator.
  • Design and development of multi-layer Web Based information systems using Web Services including Java and JSP.
  • Strong experience in Dimensional Modeling using Star and Snowflake Schema, Identifying Facts and Dimensions, Physical and Logical data modeling using ERwin and ER-Studio.
  • Expertise in working with relational databases such as Oracle 11g/10g/9i/8x, SQL Server 2008/2005, DB2 8.0/7.0, UDB, MS Access and Teradata.
  • Extensive experience in developing Stored Procedures, Functions, Views and Triggers, Complex SQL queries using SQL Server, T-SQL and Oracle PL/SQL.
  • Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions.
  • Experience in all phases of Data Warehouse development from requirements gathering for the Data Warehouse to develop the code, unit testing and documenting.
  • Extensive experience in writing UNIX shell scripts and automation of the ETL processes using UNIX shell scripting.
  • Proficient in the integration of various data sources with multiple relational databases like Oracle11g /Oracle10g/9i, MS SQL Server, DB2, Teradata, VSAM files and Flat Files into the staging area, ODS, Data Warehouse and Data Mart.
  • Experience in using Automation Scheduling tools like Autosys and Control-M.
  • Worked extensively with Slowly Changing Dimensions.
  • Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, system integration and user acceptance testing.

TECHNICAL SKILLS:

ETL Tools: Informatica9.x/8.x/7.x

RDBMS: Oracle 11g/10g/9i, SQL Server, Teradata

Data Modeling: Dimensional Data Modeling - Star, Snowflake Modeling

Languages: SQL, PL/SQL, XML

Technical Tools: Toad, SQL Developer, ERwin Data Modeler 4.x

Environment: Windows, UNIX

PROFESSIONAL EXPERIENCE:

Confidential, Los Angeles, CA

Sr. Informatica Consultant

Responsibilities:

  • Involved in full life cycle development including Design, ETL strategy, troubleshooting, reporting, and Identifying facts and dimensions.
  • Prepared the required application design documents based on functionality required.
  • Designed the ETL processes using Informatica to load data from Oracle, Flat Files (Fixed Width), and Excel files to staging database and from staging to the target Teradata Warehouse database.
  • Wrote Queries, Procedures and functions that are used as part of different application modules.
  • Implemented the best practices for the creation of mappings, sessions and workflows and performance optimization.
  • Created mappings using transformations like Source Qualifier, Joiner, Aggregator, Expression, Filter, Router, Lookup, Update Strategy, and Sequence Generator.
  • Involved in Dimensional modeling (Star Schema) of the Data Warehouse and used ERwin to design the business process, dimensions and measured facts.
  • Designed and developed the logic for handling slowly changing dimension table’s load by flagging the record using update strategy for populating the desired.
  • Involved in cleansing and extraction of data and defined quality process for the warehouse.
  • Involved in performance tuning and optimization of Informatica mappings and sessions using features like partitions and data/index cache to manage very large volume of data.
  • Involved in migration of mappings and sessions from development repository to production repository.
  • Involved in Unit testing, User Acceptance Testing to check whether the data is loading into target, which was extracted from different source systems according to the user requirements.
  • Used Web Services for authentication of the end users.
  • Created Stored Procedures to transform the Data and worked extensively in PL/SQL for various needs of the transformations while loading the data.
  • Wrote SQL queries, PL/SQL programming and Query Level Performance tuning.
  • Conduct status meetings with project managers, escalate issues when necessary, conducts meetings for issues resolution.
  • Interacted with Lead Developers, System Analysts, Business Users, Architects, Test Analysts, Project Managers and peer developers to analyze system requirements, design and develop software applications.
  • Created new extracts for external vendors and use Informatica ETLs for new workflows to move data out of multiple data sources.
  • Unit test coding changes, fill out required documentation such as installation instructions, and follow standards and procedures.
  • Provided Tier l support duties for Informatica Production Support, including off hours and weekends. Keep the Production Support team management informed of any issues or concerns.

Environment: Informatica9.X/Informatica PowerCenter9.5.1/8.6, PowerExchange, Oracle 11g/10g, DB2, Teradata, Mainframe, ERwin 4.0

Confidential, Deerfield, IL

Sr. Informatica Consultant

Responsibilities:

  • Involved in analyzing existing logical and physical data modeling with STAR and SNOWFLAKE schema techniques using ERwin in Data Warehouse.
  • Partitioned tables which have frequent inserts, deletes and updates to reduce the contention and to improve the performance.
  • Maintained development, test and production repositories using Repository Manager. Also used Repository Manager and Metadata Manager to maintain the metadata, Security, Backup and Locks.
  • Designed the Data Warehousing ETL procedures for extracting the data from all source systems to the target system.
  • Extensively used Transformations like Router, Lookup (connected and unconnected), Update Strategy, Source Qualifier, Joiner, Expression, Stored Procedure, Aggregator and Sequence generator.
  • Involved in the development of Informatica mappings and also performed tuning for better performance. Scheduled InformaticaB2B Data Transformation.
  • Designed and developed sophisticated workflows and data transformations involving InformaticaB2B components dx (Data Exchange) and DT (Data Transformation).
  • Created, scheduled, and monitored workflow sessions on the basis of run on demand, run on time, using Informatica PowerCenter Workflow Manager.
  • Used Workflow Manager for session management, database connection management and scheduling of jobs.
  • Configured the session so that PowerCenter Server sends an Email when the session completes or fails.
  • Debugged and sorted out the errors and problems encountered in the production environment.
  • Determined various bottle necks and successfully eliminated them to great extent.
  • Extensively worked in the performance tuning of the programs, PL/SQL procedures and processes.
  • Provided production support by monitoring the processes running daily.
  • Involved in analysis, requirements gathering and documenting Functional & Technical specifications.
  • Used Informatica debugging techniques to debug the mappings and used session log files and bad files to trace errors occurred while loading.
  • Created materialized views that are built over views to update the number of times views have been generated.
  • Created and scheduled sessions, jobs based on demand, run on time and run only once using Workflow Manager.
  • Created parameter files to Dev, Test and Prod environments.
  • Created Perl Scripts and called in Pre session and Post session commands.
  • Involved in various testing activities like database testing, unit testing, system testing, performance testing and was also responsible for maintaining of testing metrics, defect tracking.
  • Actively participated in data base testing like checking the constraints, correctness of the data, Stored Procedures, field size validation, etc
  • Identified and debugged the errors before deploying and worked on migration of the maps and workflows from development to UAT and from UAT to Production.

Environment: Informatica PowerCenter 9.1/8.6.1, InformaticaB2B, DTD files, IDCOS, Oracle 10g/11g, ERwin, WinSQL, PostgreSQL, PL/SQL, SQL*Plus, SQL Loader, HTML 4.0, MS SQL Server 2000, MS-Excel, XML, Flat files, Windows NT, HP-UX, Shell Scripting.

Confidential, Mooresville, NC

Informatica Consultant

Responsibilities:

  • Requirements gathering from business analysts and responsible for populating the business rules using mappings into the Repository for Meta Data Management.
  • Performance tuning in the context of dimensional design by creating Mini Dimensions thus providing smaller entries in to the Fact table.
  • Flattening out Many to Many relations by creating bridge tables as in the case of account and customer dimension tables.
  • End-to-end ETL development of the Data Mart. Designed and developed Informatica mappings for data loads.
  • Extensively used ETL and Informatica to load data from Oracle, MS SQL Server, flat files into the target Oracle database.
  • Implemented various transformations like Joiner, Aggregate, Expression, Lookup, Filter, Update Strategy, Stored Procedure and Router etc.
  • Defined various facts and dimensions in the Data Mart including Fact less Facts, Aggregate and Summary facts.
  • Worked on Informatica PowerCenter tool - Source Analyzer, Data Warehousing Designer, Mapping & Mapplets Designer and Transformation Designer.
  • Development of Informatica mappings and also in tuning of mappings for better performance.
  • Used Informatica features to implement Type I & II changes in slowly changing dimension tables. Created and ran workflows and Worklets using Workflow Manager to load the data into the target database.
  • Actively participated in resolving Email tasks working on priority and non-priority issues of employee’s profiles and figuring out those issues through mappings.
  • Converted existing PL/SQL Procedures/Packages to ETL Mappings using Informatica PowerCenter.
  • Created mappings for populating data to Dimensions and Fact tables.
  • Optimized/Tuned mappings for better performance and efficiency. Performance tuning of SQL Queries, Sources, Targets and sessions.
  • Maintained warehouse metadata, naming standards and warehouse standards for future application development.
  • Implemented efficient and effective performance tuning procedures including pushdown optimization.

Environment: Informatica PowerCenter 8.6, Oracle 10g/9i, MS SQL Server 7.0/2000, IBM DB2/400, Flat files, SQL, SQL*Loader, ERwin, Toad 7.0, Windows 2000, UNIX Shell Scripting.

Confidential

Informatica Consultant

Responsibilities:

  • Monitoring the identified ETL processes, restarting the ETL processes that aborted.
  • Rescheduling specific ETL processes when there is one such requirement.
  • Work with System Administration on backups/image copies.
  • The above listed maintenance tasks for the other environments where the similar ETL process runs.
  • Monitoring the Data Quality, generating weekly/monthly/yearly statistics reports on production processes - success / failure rates for causal analysis as maintenance part and enhancing exiting production ETL scripts.
  • Modifying existing ETL scripts to fix defects at the root cause as enhancement part of project.

Environment: Informatica PowerCenter 8.6, Windows XP, UNIX, Oracle 10g, Cognos 10

Confidential

Informatica Consultant

Responsibilities:

  • Requirements gathering and analysis, developing technical design document, coding, code review, test plans, user acceptance testing, and production support.
  • Developed Packages, Procedures and function to maintain the Business logic using PL/SQL.
  • Designed and Developed Informatica Mappings and Work flows.
  • Used various Informatica Transformations like Lookups,Aggregator,Router etc.
  • Creating database objects including Tables, Indexes, Views, Sequences, Synonyms and granting Roles, and Privileges to the system users.
  • Creating SQL scripts for deployment of database objects on Production.
  • Involved in fine tuning of SQL query to achieve good performance.
  • Developed Oracle based (SQL and PL/SQL) programs for the creation of DW/ETL Process, ad hoc queries/reports, including requirements gathering, design, coding and unit testing.
  • Wrote SQL queries (Sub queries and Join conditions), PL/SQL programming and Query Level Performance tuning.
  • Tuning of SQL statements using EXPLAIN PLAN, TKPROF, SQL Trace, and Oracle Hints to improve the performance.
  • Wrote PL/SQL Stored Procedures, Packages to apply and maintain the Business Rules.
  • Extensive SQL & PL/SQL Coding and tuning.

Environment: Oracle 8i, PL/SQL, SQL*Loader, SQL, SAP ABAP, Sun Solaris, Informatica 6.0

We'd love your feedback!