Lead Developer And Informatica Administrator Resume
Vacaville, CA
PROFESSIONAL SUMMARY:
- 9+ years of IT experience with Informatica for ETL, and BI tools and expertise in analysis, design, development and implementation of Data warehousing and Business Intelligence applications, along with Oracle, MS SQL server databases on windows and UNIX platforms. Have good experience in Informatica administration.
- Proficient in Informatica administration work including installing and configuring Informatica PowerCenter and repository servers on windows and Unix platforms, backup and recovery, folders and user account maintenance.
- Experience in Informatica Cloud to extract the data from saleforce.
- Created PMCMD commands to monitor the production workflows.
- Good knowledge on upgrading in Informatica to latest version.
- Informatica Power Exchange for loading/retrieving data from Oracle and MS SQL server system.
- Installing and configuring the Informatica PowerExchange servers on windows and unix for Oracle and MS Sql server.
- Informatica Developer client 9.6 SQL Server 2008/2005, Oracle 9i/10g, Netezza, My SQL, and SQL, PL/SQL programming.
- Informatica PowerC enter 9.6.1/9.5 SQL Server 2008/2005, Oracle 9i/10g, and SQL, PL/SQL programming.
- Oracle, SQL Server, MS Access, Teradata and database development using SQL, PL/SQL, SQL PLUS, TOAD, SQL - LOADER.
- K nowledge in UNIX
- Proven ability to implement Data warehousing technology based solutions for business problems in
- Financial/ Investment Banking/ Credit Cards,
- Food and Beverage/Retail,
- Insurance/ Pharmaceutical/Healthcare and
- Manufacturing of Pharma.
- Data Modeling retaining concepts of RDBMS,
- Logical and Physical Data Modeling,
- Multidimensional Data Modeling Schema (Star schema, Snow-Flake Modeling, Facts and dimensions).
- Designing and developing complex mappings to extract data from diverse sources including flat files, RDBMS tables, legacy system files, XML files, Applications and Teradata. integration of various data sources like Oracle, SQL Server, Flat Files, into Data Warehouse and also experienced in Data Cleansing and Data Analysis.
- Business Objects 5.x/6.x to build user defined queries and reports to enable drill-down and slice and dice analysis on multiple databases.
- Performance Tuning for targets, mappings and sessions, Task Automation using UNIX Shell Scripts, Job scheduling and Communicating with Server using pmcmd.
- Provided data matching, data cleansing, exception handling, reporting and monitoring features to data warehouse.
- Knowledge of Software Development Life Cycle including Planning, Analysis, Design, Implementation, and Maintenance.
- Project and Change request estimations.
- ETL production support role, excellent communication and interpersonal skills.
- Data Architecture and Design
- Requirement Analysis
- Feasibility Study and Impact Analysis
- Designing Solution Architecture
- Maintaining excellent Client Relationships and expert in effective communication
- Onsite Design Lead
- Resource Management and Leading the Development team
- Project Management
- Periodic Status Reporting in regular intervals
- Onsite-Offshore Coordination
- Implementation and UAT support
SOFTWARE PROFICIENCY:
ETL: Informatica Administration, Informatica PowerExchange 9.5,Informatica Developer client 9.6,Informatica Powercenter 9.x/8.x/7.x/6.x (Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Manager, Workflow Monitor and Repository Manager) Informatica Power Analyzer, Informatica Power Exchange 8.1.1/5.2.1/ Power Connect, SSIS (SQL Server Integration Services)
Reporting: Business Objects 5.x/6.x, Microstrategy, SSRS (SQL Server Reporting Services)
Data Modeling: Dimensional Data Modeling, Star Schema, Snow Flake, Fact and Dimension Table Modeling, Physical and Logical Data Modeling in Erwin 3.X
Databases: Oracle 10g/9i/8i/8.x, MS SQL Server 2008/2005/2000/7.0 , Teradata V2R6/V2R5, Vertica, DB2, Netezza.
Other Utilities: Teradata utilities (Fast Load, Multi Load, BTEQ etc.), Toad, CVS, VSS, SQL*Loader, SQL Navigator, MS Visio, MS Office
Scheduling Tools: Control M, CA7
Operating Systems: UNIX (Sun Solaris), Windows 2003/2000/XP/98/NT Server, Mainframes.
EXPERIENCE DETAILS:
Confidential, Vacaville, CA
Lead Developer and Informatica Administrator
Environment: Informatica PowerExchange 9.5,Informatica power center 9.5 Oracle, MS SQL Server.
Responsibilities:
- Define Data source for both MS SQL and Oracle source systems.
- Deployed the Informatica workflows to production.
- Creating user for developer and providing the permission based on the role.
- Define and active the capture registrations for source database.
- Creating the extraction maps for the data source.
- Configure parameters in the dbmover.cfg file for the PowerExchange Listener.
- Configure parameters in the pwxccl.cfg file for the PowerExchange Logger.
- Developed mapping using Informatica power center.
- Developed heartbeat mapping for each and every CDC session to track the Performance of CDC workflows and find out the data movement from source to target.
- Responsible for testing, modifying, debugging, documenting and implementation of Informatica mappings.
- Developed test cases and test plans to complete the unit testing. Support System testing.
- Troubleshoot data issues, validated result sets, recommended and implemented process improvements.
- Responsible for performance tuning in Informatica PowerExchange, Informatica Power Center at the Target Level, Source level, Mapping Level, Session Level, and System Level.
Confidential, San Francisco, CA
Lead Developer
Environment: Informatica PowerExchange 9.5.1,Informatica power center 9.5.1 Oracle, Hadoop, Hive.
Responsibilities:
- Deployed the Informatica workflows to production.
- Developed incremental mappings using Informatica Developer client and deploy the applications.
- Creating physical data objects for relational database, flat files.
- Creating the Hive table and loading the data into Hive tables using Informatica.
- Creating the workflow and deploy the workflow to data integration service to run the workflow.
- Create the application and deploy the application to data integration services.
- Responsible for testing, modifying, debugging, documenting and implementation of Informatica mappings.
- Developed test cases and test plans to complete the unit testing. Support System testing.
- Responsible for performance tuning in Informatica Power Center at the Target Level, Source level, Mapping Level, Session Level, and System Level.
Confidential, Mountain View, CA
Lead Developer
Environment: Informatica Developer 9.6.1,Informatica power center 9.6.1, Neteeza, Hadoop, SQL Server 2008/2005, MySQL, Linux, Python Scripts.
Responsibilities:
- Developed incremental mappings using Informatica Developer client and deploy the applications.
- Creating physical data objects for relational database, flat files.
- Creating the Hive table and loading the data into Hive tables using Informatica.
- Creating the workflow and deploy the workflow to data integration service to run the workflow.
- Create the application and deploy the application to data integration services.
- Developed the mapping by using MAV (mapping architecture Visio).
- Generate the DDL for both Hive and Netezza using java based on source structure.
- Responsible for testing, modifying, debugging, documenting and implementation of Informatica mappings.
- Used shortcuts to reuse objects without creating multiple objects in the repository and inherit changes made to the source automatically.
- Developed test cases and test plans to complete the unit testing. Support System testing.
- Troubleshoot data issues, validated result sets, recommended and implemented process improvements.
Confidential
Team Lead Developer
Environment: Informatica 9.5, Vertica, Vsql, SQL Server 2005, Windows Server 2003
Responsibilities:
- Taking care of Daily Loads and fixing the production issues with in short time.
- Giving support on weekend loads and performing the validations after the Load complete.
- Understanding the complete business flow.
- Designing mappings in order to load data into the tables using transformations.
- Involved in Data Migration form one module to another.
- Reviewed mappings developed by Team members for functionality, Performance and Standards.
- Data quality checking and interacting with the business analysts
- Good experience in communicating with offshore team and client on weekly status report
- Performed testing as per UTCs
Confidential
Developer
Environment: Informatica 8.x, Oracle 10g, unix
Responsibilities:
- Understanding the complete business flow.
- Designing mappings in order to load data into the tables using transformations.
- Reviewed mappings developed by Team members for functionality, Performance and Standards.
- Good experience in communicating with onsite team status report.
- Performed testing as per UTCs
Confidential, Dallas, TX
Developer
Environment: Informatica Power Center 9.1, Teradata,SQL Server 2008/2005, PL/SQL, Windows XP.
Responsibilities:
- Requirement gathering, analysis and designing technical specifications for the data migration according to the business requirement.
- Developed logical and physical dimensional data models using ERWIN.
- Designed, developed and improved complex ETL structures to extract transform and load data from multiple data sources into data warehouse and other databases based on business requirements.
- Extracted data from Flat files, DB2, SQL and Oracle to build an Operation Data Source. Applied business logic to load the data into Global Data Warehouse.
- Developed complex mappings and SCD Type-I, Type-II and Type III mappings in Informatica to load the data from various sources using different transformations like Source Qualifier, Lookup, Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Rank and Router, Stored Procedure, XML and SQL transformations.
- Responsible for testing, modifying, debugging, documenting and implementation of Informatica mappings.
- Used shortcuts to reuse objects without creating multiple objects in the repository and inherit changes made to the source automatically.
- Developed test cases and test plans to complete the unit testing. Support System testing.
- Troubleshoot data issues, validated result sets, recommended and implemented process improvements.
- Responsible for performance tuning in Informatica PowerCenter at the Target Level, Source level, Mapping Level, Session Level, and System Level.
- Extensively worked with PL/SQL, performance tuning of Oracle, SQL queries and T-SQL statements. Created Cursors, functions, stored procedures, packages, Triggers, views, materialized views using PL/SQL.
- Extensively worked with incremental loading using Parameter Files, Mapping Variables and Mapping Parameters.
- Created Data Breakpoints and Error Breakpoints for debugging the mappings using Debugger.
- Involved in database testing, writing complex SQL queries to verify the transactions and business logic like identifying the duplicate rows.
- Good experience with Informatica Administration 9.x.
Confidential, Dallas, TX
Developer
Environment: Informatica Power Center 9.1, Teradata, SQL Server 2008/2005, PL/SQL, Windows XP.
Responsibilities:
- Involved in Systems Study/ Analysis and understand the business needs and implement the same into a functional database design.
- Created Source definitions from Flat Files, Oracle 9i, Imported Target definitions and created Reusable Transformations in Informatica Powercenter Designer 9.1
- Used Informatica Power Connect to extract information from the Oracle ERP systems.
- Created Informatica mappings with PL/SQL procedures/functions to build business rules to load data.
- Used Shell Scripting to get data from source for the transformation to cleanse data as per business rule
- Experienced in developing informatica mappings using transformations such as Source Qualifier, Aggregator, Lookup, Filter, Sequence Generator, Expression, Router, Update Strategy, Rank, XML SQ/Parser/Generator, Normalizer, etc., to load data from different sources like Oracle, Flat Files, Excel Spread Sheets, XML, COBOL files to the target Data Warehouse.
- Developed transformation Logic in informatica Powercenter Designer 9.1 to cleanse the source data of inconsistencies before loading the data into the staging area, which is the source for stage loading.
- Worked on Connected & Unconnected Lookups, Router, Expressions, Source Qualifier, Aggregator, Filter and Sequence Generator etc.
- Used PMCMD commands for automating Batches and Sessions.
- Identified and fixed bottlenecks and tuned the Informatica mappings for better performance.
- Created Test cases for Unit test, used TOAD 9.7 to validate the data with SQL Query.
- Scheduling of Informatica workflows using Tidal Scheduler
Confidential, Phoenix, AZ
Developer
Environment: Informatica Power Center 8.6, SQL Server 2008/2005, PL/SQL, Windows XP, Flat Files.
Responsibilities:
- Responsible for documentation, version control of schema and version release.
- Analyzed specifications and identified source data needs to be moved to data warehouse, Participated in the Design Team and user requirement gathering meetings.
- Interpreted logical and physical data model for business users to determine common data definitions and establish referential integrity of the system.
- Participated in the analysis of development environment of Extraction process and development architecture of ETL process.
- Coordinated with customer in finding the sources and targets for data conversion.
- Involved in the preparation of documentation for ETL standards, Procedures and Naming conventions as per ETL standards.
- Created Reusable transformations and Mapplets for use in Multiple Mappings by using informatica power center design .
- Created multiple universes and resolved loops by creating table aliases and contexts.
- Used session partitions, Dynamic cache memory and Index caches for improving performance of Informatica server.
- Good experience with Informatica Administration 8.x .
- Optimized and performed Tuning in mappings to achieve higher response times.
- Involved in the migration of existing ETL process to Informatica Powercenter.
- Created effective Test data and developed thorough Unit test cases to ensure successful execution of the data loading processes.
- Organized data in reports using Filters, sorting, ranking data with alerts.
- Created reports using Business Objects functionality like queries, slice and dice, drill down, functions and formulas.
Confidential, Phoenix, AZ
Developer
Environment: Informatica Power Center 8.6, SQL Server 2008/2005, Oracle10g, PL/SQL, Windows XP, Flat Files.
Responsibilities:
- Understanding the complete business flow.
- Designing graphs and mappings in order to load data into the tables using transformations.
- Involve in Data Migration form one module to another.
- Reviewed mappings developed by Team members for functionality, Performance and Standards.
- Managed the privileges of users and folders using Repository Manager and used Informatica Administration Console for Admin activities such as starting / stopping server, upgrading the repository etc.
- Data quality checking and interacting with the business analysts
- Good experience in communicating with offshore team
- Communication with the client for weekly status report
- Performed testing as per UTCs
- Testing and debugging of code
Confidential, Phoenix, AZ
Developer
Environment: Informatica Power Center 8.6, SQL Server 2008/2005, Oracle10g, PL/SQL, Unix, Facets
Responsibilities:
- Used Conversion process for VSAM to ASCII source files using Informatica Power Exchange
- Implemented a New Project by changing the current DW, written details design document & turn it over to the developers
- Helped the team in analyzing the data to be able to identify the data quality issues
- Work with Business Analyst and business users to clarify requirements and translate the requirement into technical specifications.
- As a lead member of ETL Team, responsible for analyzing, designing and developing ETL strategies and processes, writing ETL specifications for developer, ETL and Informatica development, administration and mentoring.
- Work closely with various levels of individuals to coordinate and prioritize multiple projects.
- Estimate, schedule and track ETL projects throughout SDLC
- Coordinating with user to gather the new requirements and working with existing issues.
- Involved in business analysis and technical design sessions with business and technical staff to develop requirements document, and ETL specifications
- Developed standard and re-usable mappings and mapplets using various transformations like expression, aggregator, joiner, source qualifier, router, lookup, and Router.