SUMMARY:

• Informatica consultant with 7 years of experience in designing and implementing innovative Data warehousing solutions to meet ever - changing business requirements within diverse industries like Pharmaceutical, Insurance, Electrical(Power and Energy), Real Estate Industries.
• 7+ years of experience in analysis, design, development and maintenance in IT industry.
• Experienced in Data Warehouse applications using Informatica, Oracle, Teradata, MS SQL server and SSIS on Windows, and UNIX platforms.
• Developed tactical and strategic plans to implement technology solutions and effectively manage client expectations.
• Developed effective working relationships with client team to understand support requirements.
• Experienced to work in Development team, Production support teams in handling critical situations to meet the deadlines for successful completion of the tasks/projects.
• Excellent interpersonal and communication skills, technically competent and result-oriented with problem solving skills and ability to work independently and use sound judgment.
• Strong expertise in designing and developing Business Intelligence solutions in staging, populating Operational Data Store (ODS), Enterprise Data Warehouse (EDW), Data Marts / Decision Support Systems using Informatica Power Center 10.x/9.x/8.x ETL tool.
• Excellentworking experience in Informatica Cloud.
• Expertise in Data Modeling using Star Schema/Snowflake Schema, OLAP/ROLAP tools, Fact and Dimensions tables, Physical and logical data modeling using ERWIN7.3
• Experience in documenting High Level, Low level Design,Unit test cases and Deployment documents.
• Experienced in Repository Configuration/using Transformations, creating Informatica Mappings, Mapplets, Sessions, Worklets, Workflows, Processing tasks using Informatica Designer / Workflow Manager to move data from multiple source systems into targets.
• Experienced in Installation, Configuration, and Administration of Informatica Power Center 10.x/9.x/8.x.
• Experienced in Performance tuning of Informatica (sources, mappings, targets and sessions) and tuning the SQL queries.
• Experienced in integration and transforming of various data sources from Databases like MS Access, Oracle, Teradata, SQL Server and formats like flat-files, COBOL files, XML, etc.
• Experienced in using ETL tools like Informatica, SSIS and Pentaho data integration.
• Experience in Oracle, MS SQL Server and Teradata environmentsusing Triggers, functions, Stored Procedures, SQL, T-SQL, PL/SQL, BTeq, FLoad, MLoad and TPT.
• Expertise in scheduling Informatica jobs using Informatica,Autosys, Airflow DAGs and DAC schedulers.
• Expertise in creating UNIX shell scripts and Python Script.
• Having Good exposure on Onsite and offshore Model.
• Experience on Agile Methodology and SDLC.
• Quick learner, Capable of working as an individual as well as a part of team.
• Experienced in working for the post development cycle and applications in Production Support.

TECHNICAL SKILLS:

Operating Systems: Windows 98/NT/2000, Windows XP, UNIX

Web Based Development: JavaScript, HTML, Python Script, UNIX Shell Scripting

Databases: Oracle 11g/10g/9i, MS SQL Server 2008,Teradata 14.1

Front End Tools: Oracle Developer 2000, Visual Basic 6, JAVA, SQL Navigator

Case Tools: Erwin 4.0/7.1, Visio

Reporting Tools: OBIEE, Tableau

Methodologies: Star Schema, Snow Flake Schema

Office Tools: MS-Office 97/2000/2003/2007/2010

Scheduling Tools: Autosys, Airflow DAG, DAC

PROFESSIONAL EXPERIENCE:

Confidential, Santa Clara, CA

Sr. Informatica Developer

Responsibilities:

• Involved in gathering and analyzing the requirements and preparing business rules.
• Implementation of MS SQL Server 2008/2014 Management studio to create new tables, views, indexes Complex Stored Procedures, User Defined Functions (UDFs) and Views using T-SQL to evaluate result for the reports.
• Responsible for installation and Configuration of SQL Server 2005 and 2008 database.
• Responsible for performing T-SQL tuning, multi-tasking and optimizing queries for reports which take longer time in execution with SQL Server 2008/2014.
• Created ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Created SSIS Reusable Packages to extract data from Multi formatted files, Excel, XML files into EDW Database.
• Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source (Oracle), Excel Spreadsheet to SQL Server 2008/2014.
• Performed operations like Data validation and error handling after Extracting data into SQL Server.
• Worked on SSIS Package, DTS Import/Export for transferring data from Database (Oracle) to SQL Server.
• Developed, deployed, and monitored SSIS Packages thru SSMS job monitor.

Environment: MS Visual Studio 2008/2014(SSMS/SSIS), Informatica Cloud, AWS S3, Athena and Python

Confidential

Sr. Informatica consultant

Responsibilities:

• Resolving issues related to Enterprise data warehouse (EDW), stored procedures in OLTP system and analyzed, design and develop ETL strategies.
• Developed mappings, sessions and workflows in Informatica Power Center.
• Identified performance issues in existing sources, targets and mappings by analyzing the data flow, evaluating transformations and tuned accordingly for better performance.
• Worked with heterogeneous source to Extracted data from Teradata, Oracle and Sql server databases, XML, flat files and loaded to a relational Teradata warehouse.
• Developed standard and reusable Mappings and Mapplets using various transformations like Expression, Aggregator, Joiner, Router, Lookup (Connected and Unconnected) and Filter.
• Performed tuning of SQL queries and Stored Procedure for speedy extraction of data to resolve and troubleshoot issues in OLTP environment.
• Troubleshooting of long running sessions and fixing the issues related to it.
• Worked with Variables and Parameters in the mappings to pass the values between sessions.
• Involved in the development of stored procedures, functions, MutiLoad, FastLoad, Bteq queries and TPT to process business data in OLAP system.
• Carried out changes into Architecture and Design of Teradata Schem as for both OLAP and OLTP systems.
• Worked with Services and Portal teams on various occasion for data issues in OLTP system.
• Worked with the testing team to resolve bugs related to day one ETL mappings before production.
• Creating the weekly project status reports, tracking the progress of tasks according to schedule and reporting any risks and contingency plan to management and business users.
• Involved in meetings with production team for issues related to Deployment, maintenance, future enhancements, backup and crisis management of DW.
• Designed and created an Autosys job plan to schedule our processes.
• Worked with production team to resolve data issues in Production database of OLAP and OLTP systems

Environment: Informatica Power center 9.5.1/10.1.1, Teradata 14.1, Oracle 11g, Sql server 2008, Shell scripting, Autosys and OBIEE

Confidential

Informatica Developer

Responsibilities:

• Understanding the business requirements.
• Extensively used Source Qualifier Transformation to filter data at Source level rather than at Transformation level. Created different transformations such as Source Qualifier, Joiner, Expression, Aggregator, Rank, Lookups, Filters, Stored Procedures, Update Strategy and Sequence Generator.
• Created different parameter files and changed Session parameters, mapping parameters, and variables at run time.
• Used Debugger to test the data flow and fix the mappings.
• Created and monitored workflows and task using Informatica Power Center Workflow Manager.
• Partitioned Sessions for concurrent loading of data into the target tables.
• Tuned the workflows and mappings.
• Involved in identifying the bottle necks and tuning to improve the Performance.
• Created workflows using Workflow manager for different tasks like sending email notifications, timer that triggers when an event occurs, and sessions to run a mapping.
• Executed Workflows and Sessions using Workflow Monitor.
• Dealt with data issues in the staging flat files and after it was cleaned up it is sent to the targets.
• Actively coordinated with testing team in the testing phase and helped the team to understand the dependency chain of the whole project.
• Executed the workflow using pmcmd command in UNIX

Environment: Informatica Power center 8.6/9.1, Oracle 10g, Sql server 2005, Shell scripting, Control-M

Confidential

ETL Developer

Responsibilities:

• Interacted with business analysts and translate business requirements into technical specifications.
• Designed and developed end-to-end ETL process from various source systems to Staging area, from staging to Data Marts.
• Extensively worked on Informatica to extract data from Flat files, Excel files, and MS Access database to load the data into the target database.
• Implemented the Incremental loading of Dimension and Fact tables.
• Created Stored Procedures for data transformation purpose.
• Created Tasks, Workflows, and sessions to move the data at specific intervals on demand using Workflow Manager.
• Developed the control files to load various sales data into the system via SQL*Loader.
• Developed Unix Shell scripts for maintaining Files.
• Designed and created an Autosys job plan to schedule our processes.
• Created PL/SQL Stored procedures and implemented them through the Stored Procedure transformation.
• Develop, test and implement break/fix change tickets for maintenance.
• Involved in writing test cases, assisting Testing team in testing.
• Developed the document of the complete ETL process.

Environment: Informatica Power center 8.6 Oracle 10g, Sql server 2005, Shell scripting and Autosys

Confidential

ETL Developer

Responsibilities:

• Developed ETL programs using Informatica to implement the business requirements.
• Communicated with business customers to discuss the issues and requirements.
• Created shell scripts to fine tune the ETL flow of the Informatica workflows.
• Production Support has been done to resolve the ongoing issues and troubleshoot the problems.
• Performance tuning was done at the functional level and map level. Used relational SQL wherever possible to minimize the data transfer over the network.
• Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.
• Involved in enhancements and maintenance activities of the data warehouse including tuning, modifying of stored procedures for code enhancements.
• Effectively worked in Informatica version based environment and used deployment groups to migrate the objects.
• Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.
• Effectively worked on Onsite and Offshore workmodel.
• Pre and post session assignment variables were used to pass the variable values from one session to other.
• Designed workflows with many sessions with decision, assignment task, event wait, and event raise tasks, used informatica scheduler to schedule jobs.
• Reviewed and analyzed functional requirements, mapping documents, problem solving and trouble shooting.
• Performed unit testing at various levels of the ETL and actively involved in team code reviews.
• Identified problems in existing production data and developed one time scripts to correct them.
• Fixed the invalid mappings and troubleshoot the technical problems of the database
• Involved in status meetings.

Environment: Informatica Power center 8.6 Oracle 10g, Sql server 2005, Shell scripting