Sr. Informatica Consultant Resume
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