OBJECTIVE:

• Around 8 years of experience with full life - cycle development: requirements analysis, design, development, testing, documentation specializing in Data Warehousing with Informatica.

SUMMARY

• 8 years of extensive experience in Analysis, Design, Development, Implementation and Testing of ETL procedures.
• Strong experience in performing ETL procedures to load data from different sources into databases, data marts and data warehouses using Informatica PowerCenter.
• Experience in extracting data from multiple sources, applying business logic and loading into Data Warehouse, Data Marts, Data Cubes.
• Experience in building Operational Data Store in order to make reporting and analysis easier.
• Extensive experience in data Extraction, Transformation, and Loading from multiple relational databases like Oracle, Teradata, DB2, SQL Server and Flat files(Fixed Width & Delimited) like TXT files, CSV files, XML files, Excel Files.
• Good understanding of Data Warehousing concepts. Knowledge of Identifying Facts and Dimensions tables.
• Clear understanding of data modeling concepts such as star and snowflake schemas.
• Good understanding of OLAP and OLTP methodologies.
• Experience in writing UNIX Shell Scripts and Perl Scripts for data validation, data cleansing, automation of sessions and file transfers.
• Hands on experience in creating/executing DDL, DML, SQL, PL/SQL Procedures, Functions, Triggers, Cursors, Views, Materialized View, Indexes and Packages.
• Performed unit testing and provided support to SIT (System Integration Test) and UAT (User Acceptance Test) to check the data quality.
• Experience in Tuning the Performance of Sources, Targets, Mappings & Sessions, SQL Queries, Informatica Sessions to optimize load and run times on the server.
• Experience with both SDLC, Scrum software development methodology.
• Experience in UNIX shell scripting, job scheduling, communicating with server using pmcmd, FTP, SFTP and file management in various UNIX environments.
• Experience in Preparing Design documents for ETL Specifications.
• Used Informatica debugging techniques to debug the mappings and used session log files and bad files to trace errors occurred while loading.
• Experience with power exchange to connect to SAP database.

TECHNICAL SKILLS

Data Warehouse/ETL: Informatica Power Center 8.x/9.x (Source Analyzer, Target Designer, Mapping Designer, Mapplet Designer, Transformations Developer, Repository Manager, Manager, Workflow Monitor), Metadata Manager, Power Exchange.

Reporting Tools: Business Object, SSRS (SQL Server Reporting service).

Operating Systems: Windows XP Professional/2000, Red Hat Enterprise Linux.

Languages: UNIX Shell Scripting,Perl scripting, PL/SQL.

Databases: Oracle 11g/10g/9i, Teradata, Sap-R3,SQL Server 2008/14,Vertica

Scripting Languages: Unix Shell Scripting, Batch Scripting

Scheduling Tools: Control-M, Autosys.Active Batch

PROFESSIONAL EXPERIENCE

Confidential, PA

ETL / Informatica Developer

Responsibilities:

• Used ActiveBatch extensively for scheduling and creating dependencies between informatica workflows
• Designed Source to Target Mapping Design Documents, ETL specification document, Unit Test document.
• Loaded data from different accounting systems like Geneva,Investier, Investran into SEI datawarehouse called Netik.
• Designed and developed complex mappings using various transformations to load data from Flat Files,into staging tables later into the target SQL Server Data warehouse.
• Analyzed performance bottlenecks, tuned various mappings and created reusable transformations and Mapplets to increase the performance.
• Using Audit Table(CDC STATUS TABLE) to keep a log for each Infa jobs. Which contains the information as such Job Name, Folder, Last Run Date, Table Name, DW Row Count, Row Count.
• Extensively used the transformations Sequence Generator, Expression, Filter, Router, Sorter, Rank, Aggregator, LOOK UP (Static and Dynamic), Update Strategy, Source Qualifier, Joiner, Normalizer.
• Performed migration of the workflows and mappings from the development folder to the integration test folder.
• Created parameter file to make workflows flexible to move from one environment to the other.
• Developed pre-session, post-session routines to drop indexes and to reassign them and batch execution routines to run Informatica sessions.
• Scheduled sessions and work flows using Informatica work flow scheduler and pmcmd.
• Created Workflows and used various tasks like Assignment, Command, Email, Event-wait and Event-raise, Timer, Decision, Session in the workflow manager.
• Implemented Type-1,2 slowly changing dimensions.
• Loaded the data from multiple source files that have the same structure and properties using Indirect Load method.
• Developed unit test cases and did unit testing for all the developed mappings.
• Working with versioned repositories to keep track of the development changes.
• Analyzed with Business Analysts and client representatives and solved client specific data issues.
• Developed ETL of existing stored procedure to avoid dead lock.

Environment: Informatica PowerCenter 9.6.0/9.1.0 ,SQL Server 2014/2008/2005 , WINDOWS 7, ActiveBatch.

Confidential

Informatica Developer

Responsibilities:

• SAP as source system and oracle is the final Datawarehouse .
• Provided L2/L3 application support in Production environment.Including reporting, investigating, analyzing, and coordinating resolution of issues.
• Provided detailed level analysis on workflow failure to development team.
• Identifying production issues, review errors, approve resolution, and advice of potential downstream impacts.
• Monitored running workflows and tasks, if any error occurs, analyze the issue by checking logs. Intimate about the error to the concerned person.
• Interacting with the users and troubleshooting the problems involved with the development of stored procedures, triggers and with the privileges.
• Created command tasks to run shell scripts to kick off workflows using PMCMD, organize flat files.
• Created e-mail tasks to notify the status of the Session, workflow, worklet if they completed or stopped, or failed while execution.
• Created and used Debugger Sessions to debug sessions and created breakpoints for better analysis of mappings.
• Migrated repository objects, services and scripts from development environment to production environment. Extensive experience in troubleshooting and solving migration issues and production issues.
• Worked with DBA to resolve the database problems and performance tuning.
• Handled adhoc issues depending on the priority and implement the change requests in production..
• Submitted ETL support documents to trouble shoot in future production runs.
• Worked on AOTs/Remedy Tickets assigned to support group and provided resolution to the customer issues within specified SLA.
• Following Instruction from development team to complete load.
• Maintained the root cause analysis & issues tracker sheet.

Environment: Informatica Powercenter 8.1, WinScp, SAP, Oracle,Control-M.

Confidential

ETL developer

Responsibilities:

• Interacted with Business Users and Business Analyst to gather the Requirements and Business logics.
• Involved in Agile development, project planning and release planning activities.
• Extensively used Transformations like Aggregator, Router, Joiner, Expression, Lookup, Update Strategy, and Sequence Generator.
• Extensively worked in the performance tuning of ETL mappings.
• Defined Target Load Order Plan and Constraint based loading for loading data correctly into different Target Tables.
• Performed cleansing and scrubbing on data which came from various sources.
• Used different Cache properties, such as dynamic cache session property to perform the Update and Insert into the relational table simultaneously using Lookup transformation.
• Involved in identifying bottlenecks and performance tuning of SQL Queries, Sources, Targets and Informatica Sessions for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Performed Unit testing, System Integration testing of mappings.
• Created Mapplets and Worklets to reuse the logic in several mappings.
• Developed UNIX shell scripts to create parameter files, rename files, compress files and for scheduling periodic load processes.
• Used Scrum software development methodology .

Environment: Informatica 7.1.3 power center, Oracle 9i, TOAD 8.6.1, SQL Plus, SQL. Perl scripting