Lead Etl Informatica Resume
Houston, TX
SUMMARY
- Around 9 years of experience in Information Technology with a strong background in Analyzing, Designing, Developing, Testing and Implementation of Data Warehousing projects in various verticals such as Insurance, Sales, Healthcare, Energy, Power and Capital.
- Strong experience in Data Warehousing and ETL using Informatica PowerCenter 9.6.1, Source Analyzer, Warehouse Designer, Transformation developer, Mapplet Designer, Mapping Designer, Repository manager, Workflow Manager, Workflow Monitor, and Informatica server) ETL, Datamart, Tableau 10.x, OBIEE 11g, BI Publisher, Postgre SQL, Greenplum, Oracle, SQL, OLAP and OLTP.
- Working knowledge on Informatica Cloud Data Synchronization.
- Working experience using Talend Open Studio.
- Actively participated in Informatica upgrade activities (from Version 8.x to 9.1) and configured domains, nodes, Integration Services and Repository Services.
- Hands on Experience on Informatica Administrator (Admin Console) and Repository Manager Client.
- Extensive experience in Creating reports from different source systems like Excel Files, Oracle database, Pivotal Green Plum database, MS SQL server, tableau extracts in metric insights and provided a single view of truth using Tableau Desktop.
- Worked as a Tableau Administrator and involved in setting up the servers, Publishing/Migrating dashboards in various versions of Tableau.
- Hands on experience in Shell scripting and UNIX Job Scheduling on multiple platforms like Windows NT/2000, HP - UNIX, Sun Solaris.
- Working knowledge on ETL Oracle Data Integrator, BI Publisher, OBIEE tools.
- Hands on experience on OBIA Package which involves Informatica, OBIEE, DAC Scheduling.
- Expertise in Business Model development with Dimensions, Hierarchies, Measures, Partitioning, Aggregation Rules, Time Series, Cache Management .
- Experience in Dimensional Data Modeling using Star Schema & Snowflake Schema, FACT & Dimensions tables, Slowly Changing Dimensions (Type I & II), Physical & logical data modeling, surrogate key assignment and CDC (change data capture).
- Strong experience in TOAD and ODBC interfaces to Oracle.
- Configured Informatica Power Center Integration services to extract and load Relational, Non-Relational, and Changed Data during Batch, Change and Real- Time basis.
- Experience in integration of various data sources like Oracle, DB2UDB, Teradata, SQL Server, MS Access, Flat Files, Mainframes etc.
- Hand on experience in Database development skills using Oracle PL/SQL to write Stored Procedures, Functions, Packages and Triggers.
- Hands on experience of Migration, backup, recovery, tuning, tracing and troubleshooting.
- Ability to work in teams as well as individually, quick learner and able to meet deadlines.
- Involved in Unit testing, System testing and performing validation criteria.
TECHNICAL SKILLS
BI/Data Warehousing: Informatica PowerCentre Client Tools 9.x/8.x/7.x, Talend, Tableau 10.x/9.x/8.x, Informatica Cloud Data Synchronization, Informatica Administrator, Tableau Administrator, Teradata, OBIA, DAC, ODI, OBIEE, BI Publisher.
Dimensional Data Modeling: Dimensional Data Modeling using Star & Snow Flake schema, Ralph Kimball and Bill Inmon Methodologies.
Programming: SQL, PL/SQL, Unix Shell Scripting.
Databases: Oracle 11g, SQL, PL/SQL, SQL*Plus, SQL Server 2012, Postgre SQL, Greenplum
Environment: Windows, Unix, Linux.
PROFESSIONAL EXPERIENCE
Confidential, Houston, TX
Lead ETL Informatica/Tableau Developer and Onsite Coordinator
Technologies: Informatica Power Center 9.6.1, Tableau 9.3, Oracle 11g, UNIX Shell Scripting, Win SCP FTP tool, Postgre SQL, Greenplum
Responsibilities:
- Interacted with the Business users to identify the process metrics and various key dimensions and measures. Involved in the complete life cycle of the project.
- Developed FRD (Functional requirement Document) and data architecture document and communicated with the concerned stakeholders. Conducted Impact and feasibility analysis.
- Worked on Informatica Power Center 9.6.1 as ETL tool for developing the project.
- Perform the Gap Analysis of the requirements.
- Reviewing the code, optimizing the code, optimizing source query to take less time, test case review, suggestion to include important test cases particular to particular ETL logic.
- Analyze the source data, perform impact analysis see how the data would fit into the data model designed and how it would help in feeding the reports.
- Mentor the team members by providing assistance with the functional environment/Technical aspects.
- Prepared High level estimates, system integration support and worked in code migration activities moving the code from DEV/QA/PROD.
- Developed PL/SQL procedures/Packages for loading the data from stage table to Facts/Dimensions with complex transform logic.
- Analyzed the design specifications of the project, source target mapping matrix, maintained the naming conventions of the enterprise standard and customized.
- Worked on SQL Server, SAP sources, Confidential Support Central data forms and FLAT files.
- Created complex mappings using various transformations like SQ, filter, sorter, aggregator, expression, union, joiner, router, SQL, Look up and various other transformations.
- Designed the ETL process and customized templates around Informatica and Oracle.
- Experience in creating Reusable Transformations (Joiner, Sorter, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Sequence Generator, Normalizer and Rank) and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
- Created Workflows and used various tasks like Email, Event-wait and Event-raise, Timer, Scheduler, Control, Decision, Session in the workflow manager.
- Involved in Optimizing the Performance by eliminating Target, Source, Mapping, and Session bottlenecks.
- Actively coordinated with testing team in the testing phase and helped the team to understand the dependency chain of the whole project.
- Dealt with data issues in the staging flat files and after it was cleaned up it is sent to the targets.
Confidential
Sr. Informatica Developer
Technologies: Informatica power center 8.6, MS SQL Server, OBIEE 11g, UNIX, Shell Scripting, Win SCP FTP tool
Responsibilities:
- Developed standard and reusable mappings and Mapplet using various transformations like Expression, Aggregator, Joiner, Router, Lookup (Connected and Unconnected) and Filter.
- Extensive use of Persistent cache to reduce session processing time.
- Identified performance issues in existing sources, targets and mappings by analyzing the data flow, evaluating transformations and tuned accordingly for better performance.
- Modified the shell/Perl scripts as per the business requirements.
- Maintained warehouse metadata, naming standards and warehouse standards for future application development.
- Used Workflow Manager for creating, validating, testing and running the sequential and concurrent sessions.
- Developed shell scripts for Daily and weekly Loads and scheduled.
- Developed shell scripts for file transferring.
- Implemented screen door process for cleaning flat files as per the business requirements.
- Preparing ETL mapping Documents for every mapping and Data Migration document for smooth transfer of project from development to testing environment and then to production environment.
- Involved in Unit testing, Iterative testing to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.
- Preparing and using test data/cases to verify accuracy and completeness of ETL process.
- Actively involved in the production support and also transferred knowledge to the other team members.
- Co-ordinate between different teams across circle and organization to resolve release related issues.
Confidential
Senior Informatica Developer
Technologies: Informatica power center 9.1.0/8.6/8.1.1 , Oracle 10g, Tableau 8.0/8.1, Unix Shell Scripting, Win SCP FTP tool
Responsibilities:
- Involved in Extraction, transformation, Loading and Implementation
- Worked on Informatica tool - Source Analyzer, Mapping Designer and Transformations.
- Developed mappings using Informatica Power Center Designer to transform and load the data from various source systems like Flat files, oracle and loading to Oracle target database
- Extensively used various types of transformations such as source qualifier, Expression, Joiner, Update strategy, Aggregator, Lookup to load the data
- Extracted information from flat files with related information such as, position, product, period, sales transaction, and payee information.
- Used Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows based on changing variable values.
- Performed Mapping Optimizations to ensure maximum Efficiency
- Created sessions to run the mappings and set the session parameters to improve the load performance.
- Optimized/Tuned mappings for better performance and efficiency
- Created complex joins, transformations of all types to pass data through ETL maps.
- Recommended tuning options to source/target database DBA team to gain optimum performance.
- Involved in fixing invalid Mappings, testing of Stored Procedures and Functions, Unit and Integration Testing of Informatica Sessions, Batches and the Target Data.
- Analyzed business requirements and worked closely with the various application teams and business teams to develop ETL procedures that are consistent across all application and systems.
- Developed Custom metadata repository.
- Design and development of mapping and Database management.
- Unit testing
- Prepared Low Level design document
- We undergo discussion to understand the requirement.
- Used Debugger to test the data flow and fix the mappings.
Confidential
Informatica Administrator
Technologies: Informatica 8.x, Oracle 8i, Business Objects 6.5.1, Toad, Edit Plus, Putty
Responsibilities:
- Administration of Informatica Server.
- User Administration.
- Creation of Informatica Folders and assigning privileges.
- Creation of UNIX Level folders.
- Migration among different environments (Mappings & Data Marts).
- Load Monitoring.
- Catering to Ad-hoc Load Requests.
- Setting up Screen Door Process for Data marts.
- Session/Batch Scheduling using Informatica Server Manager & Crontab.
- Maintaining all level of securities for all Repositories.
- Automation of job processing, establish automatic email notification to the concerned persons.
- Documentation & Presentation of the project.
- Worked on HPSD Change Requests (CR) while integration testing and UAT are in progress.
- Provided 24 *7 production support during all the production release weeks.
Confidential
Informatica Developer
Technologies: Informatica power center 8.6/8.1.1/7.0 , Oracle 10g, MS SQL Server, OBIEE 10g
Responsibilities:
- Involved in Extraction, transformation, Loading and Implementation
- Worked on Informatica tool - Source Analyzer, Mapping Designer and Transformations.
- Developed mappings using Informatica Power Center Designer to transform and load the data from various source systems like Flat files, oracle and loading to Oracle target database
- Extensively used various types of transformations such as source qualifier, Expression, Joiner, Update strategy, Aggregator, Lookup to load the data
- Extracted information from flat files with related information such as, position, product, period, sales transaction, and payee information.
- Used Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows based on changing variable values.
- Performed Mapping Optimizations to ensure maximum Efficiency
- Created sessions to run the mappings and set the session parameters to improve the load performance.
- Design and development of mapping and Database management.
- Created unit test cases and completed Unit testing
- Having daily interaction with the client for gathering the requirements and status updates.
- Perform the Gap Analysis of the requirements.
- Created the ETL design document.
- Reviewing the code, optimizing the code, optimizing source query to take less time, test case review, suggestion to include important test cases to specific ETL logic.
- Analyze the source data, do impact analysis see how the data would fit into the data model designed and how it would help in feeding the reports.
- Mentor the team members by aiding with the functional environment/Technical aspects.