SUMMARY:

• Around 10+ years of experience in Information Technology including Data Warehouse/Data Mart development using ETL/Informatica Power Center.
• Experience with ETL process using Informatica Power Center 9.x/8.x Power Exchange, Designer (Source Analyzer, Mapping designer, Mapplet Designer, Transformation Developer), Repository Manager, Repository Server, and Workflow Manager & Workflow Monitor.
• Handled integration of various data sources with Multiple Relational Databases like Oracle, DB2.
• Worked with different types of data load strategies and scenarios like Historical dimensions, Surrogate keys, Summary facts etc.
• Experience in the successful implementation of ETL solution between an OLTP and OLAP database in support of decision support systems/business intelligence with expertise in all phases of SDLC.
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star - Schema modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Good understanding of views, Synonyms, Indexes, Joins and Sub-Queries. Extensively used Cursors.
• Extensively created mapplets, common functions, reusable transformations, look-ups for better usability.
• Working experience in tuning and scaling the procedures for better performance by running explain plan and using different approaches like hint and bulkload.
• Handled Teradata utilities FastLoad, MultiLoad, BTEQ scripting, FastExport, SQL Assistant.
• Involved in understanding and translating the business requirements to High Level and Low-level design for ETL processes in Teradata, Data stage and Informatica.
• Utilized Performance Tuning of mappings, ETL procedures and process and involved in complete life cycle implementation of data warehouse.
• Experienced in OLTP/OLAP system study, analysis and ER modeling, developing Database schemas and used in relational and multidimensional modeling by using Erwin, Visio.
• Hands on experience in implementing CDC using Informatica Power Exchange 9.x/8.x
• Ability to write complex SQLs needed for ETL jobs and analyzing data, and is proficient and worked with databases.

TECHNICAL SKILLS:

Informatica Tools: Informatica Power Centre 8x, 9x, 10.1.1, Informatica Master Data Management (MDM) 9.5, Informatica Data Quality 9.5 (IDQ)

Reporting tools: Tableau (Desktop/Server, Public/Reader) 10.2

RDBMS: Teradata, Oracle 9i/10g/11g, SQL Server 2008/R2/2012, TOAD 12.8

Database skills: Stored Procedures, Database Triggers, Cursor, Packages

Languages: SQL, PL/SQL, UNIX

OS: UNIX, Windows 2003/2007/XP

Tools: Control-M 8.0, Autosys R11.3, BMC Remedy 7.6, Atlassian JIRA 6.4, HP Quality Center, Microsoft Office, Microsoft Excel, Microsoft Visio

PROFESSIONAL EXPERIENCE:

Confidential, IA

Sr.ETL Informatica Developer

Responsibilities:

• Participate in design and analysis sessions with business analysts, source-system technical teams, and end users.
• Design scheduling structure of Informatica jobs to be executed within operational calendar.
• Extensively used the Slowly Changing Dimensions-Type II in various data mappings to load dimension tables in Data warehouse.
• Proactively worked to analyze and resolve all Unit testing and UAT issues.
• Facilitate/lead reviews (walkthroughs) of technical specifications and program code with other members of the technical team.
• Involved in extensive performance tuning by determining bottlenecks using Debugger at various points like targets, sources, mappings, sessions or system.
• Writing technical documentation and routine production ETL process support.
• Develop new components in Informatica Data Integration Hub (DIH), a latest tool by Informatica and good understanding of DIH components, concepts.
• Develops Cloud Services tasks (Replication/Synchronization/Mapping Configuration) to load the data into Salesforce (SFDC) Objects.
• Designing, developing, maintaining and supporting Data Warehouse or OLTP processes via Extract, Transform and Load (ETL) software using Informatica, Shell Scripts, DB2 UDB and Autosys.
• Responsible for User administration & maintaining the Informatica Cloud Services - Secure Agent on Unix Server for Dev/QA environment.
• Developed informatica mappings, mapping configuration task and Taskflows using Informatica cloudservice (ICS).
• Analyzed the source data arriving from different source systems like Vendor Management Inventory, Invoice
• Processing System, Materials Forecasting, Purchase Orders and Requisition on Stores.
• Interacted with business teams for gathering business requirements and involved in documentation of Specifications.
• Designed and developed the ETL Mappings for the source systems data extractions, data transformations, data staging, movement and aggregation.
• Developed standard mappings using various transformations like expression, aggregator, joiner, source Qualifier, router, lookup, and filter.
• Developed mapplets for re-usability in ETL process.
• Involved in performance tuning and unit testing.
• Used Pipeline partitioning and External Loader to improve Session performance.
• Scheduled and ran Extraction and Load processes and monitored tasks and workflows.
• Tuned the MMW databases (stage, target) for better, faster and efficient loading and user query performance.
• Involved in creating reports using Business Objects 8.1.

Environment: Informatica Power Center 8x, Erwin 4.1, UNIX Shell Scripting, Oracle 10g, PL/SQLBO 8.1, Windows XP/2007.

Confidential

Sr. ETL Developer

Responsibilities:

• Gathered user requirements and designed Source to Target data load specifications based on Business rules.
• Used Informatica Power Center 10.1.1 for extraction, loading and transformation (ETL) of data in the DataMart.
• Created stored procedure and function to improve the Job performance.
• Troubleshooting the job failure during the daily operation.
• Converting the Existing Informatica ETL jobs in to Pentaho Jobs.
• Participation in Performance tuning in database side, transformations, and jobs level.
• Creating Pentaho jobs for loading data sequentially & parallel for initial and incremental loads.
• Using various PDI steps in cleansing and load the data as per the business needs.
• Automating all the Excel Input using Pentaho Jobs for Dashboard reporting.
• Gathering data source for the various business requirement.
• Integrating data from API using Informatica.
• Created Jobs to Process JSON data obtained through API (App Annie).
• Created Jobs to integrate data from sales force API to our reporting database.
• Working with External vendors on the data needs and provision the data as per the needs.
• Worked in Agile environment, with daily scrum and ticket updates.
• Designed and developed ETL Mappings to extract data from flat files, MS Excel and Oracle to load the data into the target database.
• Developing several complex mappings in Informatica a variety of PowerCenter transformations, Mapping Parameters, Mapping Variables, Mapplets & Parameter files in Mapping Designer using Informatica Power center.
• Transformation mapping for inserting and updating records when loaded.
• Extensively used ETL processes to load data from various source systems such as DB2, SQL Server and Flat Files, XML files into target system Teradata by applying business logic on
• Use of Aggregator, Filter, Router, Expression, Joiner, Union, Normalizer and Sequence generator transformations.
• Ran the workflows on a daily and weekly basis using Active Batch Scheduling tool.
• Examined the workflow log files and assigning the ticket to the Informatica support based on the error.
• Involved in doing error handling, debugging and troubleshooting Sessions using the Session logs, Debugger and Workflow Monitor.
• Performed operational support and maintenance of ETL bug fixes and defects.
• Maintained the target database in the production and testing environments.
• Created Mapping Parameters and Variables.
• Worked with Teradata utilities such as Mload, Fload, export etc. to load or extract tables.
• Supported migration of ETL code from development to QA and QA to production environments.
• Migration of code between the Environments and maintaining the code backups.
• Designed and developed Unix Shell Scripts, FTP, sending files to source directory & managing session files.
• Developed PL/SQL code at the database level for the new objects.
• Building Reports according to user Requirement.
• Developed Tableau data visualization using Pareto's, Combo charts, Heat maps, Box and Whisker charts
• Scatter Plots, Geographic Map, Cross tabs, Histograms etc.

Environment: Informatica Power Center 10.1.1, Oracle 11g, PL/SQL, Teradata, Flat files, SQL Server 2008, Erwin, UNIX. Toad 9.0, Oracle SQL developer 11g, Tableau 10.2.

Confidential

Sr. ETL Developer

Responsibilities:

• Created Groups, roles, privileges and assigned them to each user group.
• Code change migration from Dev to QA and QA to Production
• Worked on SQL queries to query the Repository DB to find the deviations from Company’s ETL Standards for the objects created by users such as Sources, Targets, Transformations, Log Files, Mappings, Sessions and Workflows.
• Used Pre session and Post Session to send e-mail to various business users through the Workflow Manager
• Leveraging the existing PL/SQL scripts for the daily ETL operation.
• Ensure that all support requests are properly approved, documented, and communicated using the MQC tool. Documenting common issues and resolution procedures
• Documented business requirements, discussed any data issues with business people to get resolved and translated the input into ETL design documents.
• Worked with data analysts to find Source, target and RDBMS table's information to implement design of Informatica mappings, transformations, workflows, scripts and commands to meet business requirements.
• Involved in writing the ETL test scripts and guided the testing team in executing the test scripts.
• Used UNIX Shell Scripting to invoke Sessions in the workflow manager.
• Perform UNIX code migration from one environment to another environment for application execution.
• Created BTEQ is in batch mode and executed using UNIX commands.
• Extracted data from various sources like Oracle, MS SQL server, Teradata, flat files, XML files and loaded into multiple targets like MS SQL server, Oracle database and created flat files and XML files.
• Worked extensively on Teradata Database to load data in EDW and Datamart using MLOAD, FASTLOAD, TPT and BTEQ.
• Involved in performance tuning of the ETL process by addressing various performance issues at the extraction and transformation stages.
• Developed SFTP, FTP, and Session Parameter files for the workflows.
• Worked on Data Quality to trouble shoot data issues to meet the Project requirements.
• Involved in writing SQL queries to validate the data on the source and target databases according to source to target mapping document.
• Involved in creating staging tables using People soft App designer tool.
• Developed Pre-session and Post-session scripts, MS - DOS commands and scripts to rename files and move files from one share to another share location.
• Involved in ETL code reviews and followed Company standards in developing the interfaces.
• Worked with Support team to migrate the ETL code to Production servers from development servers by Creating a mapping document and Request for Change (RFC) of the process.
• Involved in Knowledge Transfer sessions to Support team after completion of UAT signoff.
• Handled Production issues and monitored Informatica workflows in production.

Environment: Informatica Power Center 9x, Oracle 11i/10g, UNIX, MS SQL Server, Teradata, TOAD, SQL Developer, BMC CONTROL-M, HP Quality Center, Windows 7/XP professional.

Confidential

ETL Developer

Responsibilities:

• Worked on Field analyzing like identifying the business logic for each field, Participated in team meetings and proposed ETL Strategy. Worked on documenting solution and detail documents for the High-level Design Specifications for ETL Coding and mapping standards.
• Transformation, Expression Transformation, Source Qualifier Transformation, Joiner Transformation, Look up Transformation, Update Strategy Transformation, Rank Transformation, and Aggregator.
• Created User Defined functions, reusable transformations to be re-used during the development life cycle.
• Created and implemented Informatica work flows in UNIX and Windows environments.
• Written and used UNIX shell scripts extensively for scheduling and pre/post session management
• Standardized parameter files to define session parameters such as database connection for sources targets, last updated dates for Incremental loads and many default values of fact tables.
• Performed tuning of Informatica Mappings for optimum performance and SQL overrides in place of Homogeneous sources. Designed and coded rejected row handling process.
• Implemented Data Validation and Exception handling logic in the mapping to handle at runtime.
• Implemented Slowly Changing Dimensions Type 1 and Type 2 to update the dimensional schema.
• Added enhancements such as mail functioning, success flag, pre and post session functions etc.
• Provided detailed technical, process and support documentation like daily process rollback and detailed, specifications and very detailed document of all the projects with the workflows and their dependencies.
• Extracting data from Database, Excel and Flat files through Informatica.
• Created data lineage documents for data flow and ETL process using Informatica mappings to support the project once it implemented in production.

Environment: Informatica Power Center 9.1.1 (Designer, Repository Manager, Workflow Monitor, Workflow Manager), Autosys, Oracle 11g, DB2 V 9.1, Flat Files, UNIX Scripting, Windows XP.

Confidential, Washington, DC

Informatica ETL Consultant

Responsibilities:

• Analyzed the source data arriving from different source systems like Vendor Management Inventory, Invoice
• Processing System, Materials Forecasting, Purchase Orders and Requisition on Stores.
• Interacted with business teams for gathering business requirements and involved in documentation of specifications.
• Designed and developed the ETL Mappings for the source systems data extractions, data transformations, data staging, movement and aggregation.
• Developed standard mappings using various transformations like expression, aggregator, joiner, source
• Qualifier, router, lookup, and filter.
• Worked with Data modeler in developing STAR Schemas
• Extensively involved in enhancing and managing Unix Shell Scripts.
• Developed workflow dependency in Informatica using Event Wait Task, Command Wait.
• Involved in analysing the existence of the source feed in existing CSDR database.
• Involved in converting the business requirement into technical design document.
• Documenting the macro logic and working closely with Business Analyst to prepare BRD.
• Involved in requirement gathering for procuring new source feeds.
• Involved in setting up SFTP setup with the internal bank management.
• Building Unix scripts in cleaning up the source files.
• Involved in loading all the sample source data using sql loader and scripts.
• Creating Informatica workflows to load the source data into CSDR.
• Involved in creating various Unix script used during ETL load process.
• Handling high volume of day to day informatica workflow migrations.
• Periodically cleaning up informatica repositories.
• Developed mapplets for re-usability in ETL process.
• Involved in performance tuning and unit testing.
• Used Pipeline partitioning and External Loader to improve Session performance.
• Scheduled and ran Extraction and Load processes and monitored tasks and workflows.
• Tuned the MMW databases (stage, target) for better, faster and efficient loading and user query performance.
• Involved in creating reports using Business Objects 8.1.

Environment: Informatica Power Center 8x, Erwin 4.1, UNIX Shell Scripting, Oracle 10g, PL/SQLBO 8.1, Windows XP/2007.

Confidential, Charlotte, NC

ETL Developer

Responsibilities:

• Worked with Business Analyst and Analyzed specifications and identified source data needs to be moved to data warehouse, Participated in the Design Team and user requirement gathering meetings.
• Worked on Informatica - Repository Manager, Designer, Workflow Manager & Workflow Monitor.
• Involved in discussing Requirement Clarifications with multiple technical and Business teams.
• Performed Informatica upgrade from V9.1 to 9.5.
• Creation and maintenance of Informatica users and privileges.
• Migration of Informatica Mappings/Sessions/Workflows from Dev, QA to Prod environments.
• Documented the LDAP configuration process and worked closely with Informatica Technical support on some of the issues.
• Fixing all the workflows failure in unit testing and system testing.
• Scheduling all the ETL workflows for the parallel run comparison.
• Involved in preparing the migration list inventory.
• Involved in requirement gathering for redesign candidates
• Worked along with the Informatica professional to resolved Informatica upgrade issue.
• Monitoring the disk space issue and cleaning up the unwanted logs periodically.
• Worked with BA in the QA phase of testing.
• Worked on Informatica Schedulers to schedule the workflows.
• Scheduled batch jobs using Autosys to run the workflows.
• Extensively involved in ETL testing, Created Unit test plan and Integration test plan to test the mappings, created test data. Use of debugging tools to resolve problems.
• Used workflow monitor to monitor the jobs, reviewed error logs that were generated for each session, and rectified any cause of failure.

Environment: Informatica Power Center 9.1/8.6, Oracle 11g, PL/SQL, Autosys, SQL, Teradata, SQL* LOADER, TOAD, Shell Scripting