SUMMARY

• 9+ Years of IT Experience in analysis, design, development, implementation and troubleshooting of Data Mart and Data Warehouse applications using ETL tools like Informatica PowerCenter 9.5/9.1/8.6 and PowerExchange 8.6.
• Strong experience in Data Warehousing (ETL & OLAP) environment and acquired excellent analytical, co - ordination, interpersonal skills, have immense leadership potential.
• Exposure to various domains like Healthcare, Telecom, Banking, Finance and Retail Industry.
• Strong knowledge of Dimensional Modeling, Star and Snowflake schema. Designed Fact and Dimension Tables as per the reporting requirements and ease of future enhancements.
• Expertise in Data Flow Diagrams, Process Models and ER diagrams with modeling tools like ERWIN r 7/4 & MS VISIO 2007/2010
• Extensive work experience in ETL processes consisting of data sourcing, data transformation, mapping and loading of data from multiple source systems into Data Warehouse using Informatica Power Center 9.5/9.1 and 8.6
• Have experience in connection to SAP using PowerExchange and connecting to SAP HANA using the SAP HDBODBC drivers.
• Good Understanding of relational database management systems, experience in integrating data from various data source like Oracle 11g/10g, MS SQL Server 2005/2008/2012 , Teradata 13/12, DB2, SAP BW, Flat files, VSAM/COBOL files and XML files into staging area
• Experienced in Administration setup like manage Users, Security Controls and Data Management Proficient in server side programming like stored procedures, stored functions, database triggers, packages using SQL
• Experience in implementing Slowly Changing dimension methodology (SCD) for accessing the full history of accounts and transaction information.
• Experience in implementing complex business rules by creating transformation, re-usable transformations (Expression, Aggregator, Filter, Connected and Unconnected Lookup, Router, Rank, Joiner, Update Strategy), and developing complex Mapplets, Mappings.
• Experience in debugging, error handling and performance tuning of sources, targets, mappings and sessions with the help of error logs generated by Informatica.
• Extensively used Repository Manager, Designer, workflow manager, workflow monitor Client tools of Informatica
• Experience is processing Unstructured data using Informatica B2B Data Transformation Studio, Have experience in processing data from different sources like HL7, EDI and PDF files.
• Experience in performance tuning at database level and Informatica level. Have effectively used Performance tuning techniques like Pushdown Optimization (PDO) and session partitioning.
• Experience in profiling the data and standardizing the data using Informatica Data Quality(IDQ).
• Have good Hands on experience on Informatica Developer and Informatica Analyst tool.
• Extensively worked on transformations like Key Generator, Match, Merge, Standardizer, Labeler, Parser, Case Convertor, and Address Validator.
• Having experience in using the Informatica command line utilities like INFACMD, PMCMD and PMREP.
• Experienced with Teradata utilities (BTEQ, FASTLOAD, FASTEXPORT, MULTILOAD, SQL Assistant, and Visual Explain).
• Experience in UNIX shell and batch scripting, have effectively used AWK and SED utilities.
• Experience in data integration, cleansing and messaging.
• Experience in Scheduling Tools like Autosys, Tivoli, Control-M and Workflow manager.
• Have good work experience in Core Java.
• Have hands on experience in Cognos and BO reporting tools.
• Experience in production support to resolve critical issues and mingle with teams to ensure successful resolution of the reported incident.
• Having good exposure to Onshore and Offshore kind of projects like attending the offshore calls, getting the status and updating the status to onshore counterpart.
• Having good exposure to Agile Methodology, like attending the Sprint planning meeting, Sprint Closure or backlog meetings and Scrum calls.
• Good communication skills both verbal and written, hardworking, self-motivated, ability to work independently or co-operatively in a team, eager to learn and ability to grasp quickly.

TECHNICAL SKILLS

ETL Tools: Informatica PowerCenter 9.5/9.1/8.6, Informatica IDQ(Informatica Developer, Informatica Analyst)

Database: Teradata 13/12,Sql Server 2008/2005, Oracle 11g/10g, DB2

Scripting Languages: Unix Shell scripting.

Operating Systems: Unix,WindowsXP/7.

Utilities: FastLoad, FastExport, Multiload, Bteq.

Other Tools: Toad, Teradata SQL Assiatant, SQL Developer, Tivoli, Control-M, HPQC, WinScp, TFS, Rally, Cognos, BO.

PROFESSIONAL EXPERIENCE

Confidential, Norwalk, CT

Senior Informatica Developer

Responsibilities:

• Interact with Business teams to understand the requirements and translating them into appropriate technical solutions.
• Attend the sprint planning meetings and provide the estimations for each and every user story.
• Designed the technical specification documents as per the mapping documents, attended the review sessions with ETL Architect, BA team and got the required signoffs.
• Designed mappings using different transformations like Lookup’s (connected, Unconnected, Dynamic), Expression, Sorter, Joiner, Router, Union, Transaction Control, Update strategy, Normalizer, Filter, Rank, Unstructured and Aggregator using Informatica Power center designer.
• Extracted data from different data sources like Oracle, SQL Server, Flat files including Delimited and fixed width text files, XML files and loaded them into the target tables.
• Designed the mappings using Slowly Changing Dimension (SCD) Type 1 and Type 2.
• Written complex SQL queries using inner joins, left outer joins, right outer joins and have written PL/SQL stored procedures.
• Created and configured workflows, worklets and sessions using Informatica Workflow Manager.
• Involved in optimizing the performance by eliminating the Source, Target, Mapping and Session bottlenecks.
• Have improved the performance by effectively using the Pushdown optimization and Informatica session partitioning techniques.
• Have used Oracle DB Hints to fine tune the Oracle query.
• Have created deployment groups and promoted the code from Dev to test environment.
• Participated in the code review sessions that are developed by the offshore team.
• Supported the Production team during the deployment phase.
• Worked on agile methodology, attended the sprint planning meetings and provided the appropriate estimations, attended the sprint closure meetings.
• Attend the daily scrum calls and the client status calls and provide the appropriate status to the entire team.

Environment: Informatica PowerCenter 9.0.1, Oracle 11g, UNIX, Toad, Jira, SQL Server, DB2, XML Viewer.

Confidential, Bellevue, WA

Senior Informatica Developer

Responsibilities:

• Interacted with Business teams to understand the requirements and translated them into appropriate technical solutions.
• Attended the sprint planning meetings and provide the estimations for each and every user story.
• Designed the technical specification documents as per the mapping documents, attended the review sessions with ETL Architect, BA team and got the required signoffs.
• Designed mappings using different transformations like Lookup’s (connected, Unconnected, Dynamic), Expression, Sorter, Joiner, Router, Union, Transaction Control, Update strategy, Normalizer, Filter, Rank, Unstructured and Aggregator using Informatica Power center designer.
• Extracted data from different data sources like Oracle, SQL Server, Flat files including Delimited and fixed width text files, XML files and loaded them into the target tables.
• Connecting to SAP HANA and extracting the delta data using Informatica PowerCenter.
• Designed the mappings using Slowly Changing Dimension (SCD) Type 1 and Type 2.
• Written complex SQL queries using inner joins, left outer joins, right outer joins and have written PL/SQL stored procedures.
• Created and configured workflows, worklets and sessions using Informatica Workflow Manager.
• Have loaded data using different utilities like Fastload, Multiload and BTEQ.
• Involved in optimizing the performance by eliminating the Source, Target, Mapping and Session bottlenecks.
• Have improved the performance by effectively using the Pushdown optimization and Informatica session partitioning techniques.
• Profiling the data using Informatica Analyst tool and updating it to the business on the values and getting the appropriate Domain values.
• Have written unit test cases and execute those during the unit testing phase.
• Supported the users during the User Acceptance testing phase.
• Scheduled and monitored the jobs using Control-M.
• Closely worked with the BO reporting team and helped them to get the data for creating reports.
• Have created deployment groups and promoted the code from Dev to test environment.
• Participated in the code review sessions that are developed by the offshore team.
• Worked on agile methodology, attended the sprint planning meetings and provided the appropriate estimations, attended the sprint closure meetings.
• Attend the daily scrum calls and the client status calls and provide the appropriate status to the entire team.

Environment: Informatica PowerCenter 9.5.1, Informatica Analyst, Teradata 13, SAP BW, UNIX, Control-M, Toad, HPQC, Oracle, SQL Server, DB2, XML Viewer, BO.

Confidential, Hartford, CT

Senior Informatica Developer

Responsibilities:

• Created Technical specification documents based on the design documents.
• Connected to Oracle GoldenGate and extracting the incremental data from the source.
• Developed mappings, mapplets, user defined functions, sessions, workflows, worklets, tasks using Informatica PowerCenter Designer and Workflow Manager.
• Used Aggregator, Union, Router, Rank, Joiner, Expression, Normalizer Transformations etc in the mappings.
• Involved in Optimizing the Performance by eliminating Target, Source, Mapping, and Session bottlenecks and loaded the data into the Oracle DataMart.
• Written PL/SQL stored procedures to handle the complex transformations.
• Have experience in profiling the data using Informatica Analyst tool and providing the results to the Data Architects team.
• Standardizing the data, parsing the data as per the business standards.
• Used Address Validator transformation to validate the customer billing address and maintained the address as per the specified standards,
• Used Match transformation on the Customer and Member data and processed the data as per the business logic.
• Integrated the mappings designed in Informatica IDQ tool with the Informatica Power Center.
• Have use Informatica B2B Data Transformation studio for processing the Unstructured data like EDI and PDF files.
• Done Unit Testing (UT) based on Unit Test Case documents and captured the results.
• Reviewed Test Cases and participated in Code Reviews within the team.
• Attended daily status meetings with the client and use to update the status.
• Coordinated with the offshore team and get the deliverables on time.
• Participated in Offshore Onsite meetings to gather new requirements and change requirements on a regular basis.

Environment: Informatica 9.1, Informatica IDQ, Informatica B2B, PowerExchange, PL/SQL, Oracle 10g, Toad, Putty, HPQC, SQL Server 2008, DB2, Cobol files, XML, EDI.

Confidential, Minneapolis, MN

Informatica Developer

Responsibilities:

• Understanding the Client Requirements and design & functionality of the system by viewing the Design documents.
• Analyze impacts to the existing system and provide estimate.
• Involved in translating business requirements to Technical specifications.
• Designed, developed, implemented and maintained Informatica PowerCenter for matching and merging process.
• Work with source system SMEs to identify the source data to be brought down to the Warehouse.
• Involved in full project life cycle - from analysis to production implementation and support.
• Extensively used Informatica Client tools - Powercenter Designer, Powercenter Repository Manager, Powercenter Workflow Manager and Powercenter Workflow Monitor.
• Worked on Teradata utilities like Fastload, FastExport, Bteq and Multiload
• Created pre and post session Stored procedures to drop, recreate the indexes and keys of source and target tables.
• Developed the source to target mapping document for ETL development in Informatica.
• Have implemented the iterative logics with the help of Java code.
• Have worked extensively in core java and having good hands on advanced java concepts.
• Worked Extracted/loaded data from/into diverse source/target systems like Oracle, XML and Flat Files.
• Performed unit testing to ensure data is loaded and mapped correctly to Warehouse tables according to the source to target mapping document.
• Designed, developed Informatica mappings using Informatica 9.0.1, enabling the extract, transport and loading of the data into target tables and loading into the target tables.
• Assist business analysts/users in identifying data gap and data variances.
• Developed ETL procedures to transform the data in the intermediate tables according to the business rules and functionality requirements.
• Create and execute unit test plans based on system and validation requirements, Troubleshoot, optimize, and tune ETL processes.
• Responsible to create interactive Dash board reports as per the Business requirements.
• Documented and maintained and ensured the process and quality of the system.
• Guide the fellow resources to in meeting the project dead-lines.
• Supporting the users during the UAT phase of the application and fixing the issue.
• Attending the Daily & weekly status calls and updating the status of the Project and Team to the client from offshore.

Environment: Informatica Power center 9.0.1, Oracle Exadata, Teradata, XML, Toad for DB2, Flat Files, Tivoli, Quality Center and UNIX, SQL Server Management studio, TFS.

Confidential

Programmer Analyst

Responsibilities:

• Deployed the Code to Production environment based on the instructions provided by the development team.
• Monitored the scheduled jobs in production in using Tivoli tool.
• Gathered the scheduled run statistics and track it for metrics purpose.
• Fixing the failed jobs, by analyzing the issue using the session log.
• Rerunning of the jobs for those that got failed in the production environment.
• Use to make sure that the production is up and running and used to clean up the unix box that is with unnecessary files.
• Have fixed the minor issues in that comes through change request.
• Used to tune the user queries for better performance.
• Have written complex SQL’s by using inner, left outer and right outer joins.
• Have attended daily status call and provided the status to the onsite team.

Environment: Oracle 10g, Informatica 8.6, HPQC, Tivoli, Toad, UNIX, SQL Server, Putty, Winscp.

Confidential

Informatica Developer

Responsibilities:

• Created the mappings in the Power Center as per the mappings in the mapping document.
• Have done unit testing and deployed the code to testing environment.
• Monitored the scheduled jobs in production using Tivoli tool.
• Fixing the failed jobs, by analyzing the issue using the session log.
• Use to make sure that the production is up and running and used to clean up the unix box that is with unnecessary files.
• Have fixed the minor issues in that comes via change request.
• Have supported UAT user and provided the queries as requested by the business.
• Used to tune the user queries for better performance.
• Have written complex SQL’s by using inner, left outer and right outer joins.
• Have attended daily status call and provided the status to the onsite team.

Environment: Oracle 10g, Informatica 8.5, Tivoli, Toad, UNIX, SQL Server, Putty, Winscp.

Confidential

Software Engineer

Responsibilities:

• Understanding the Client Requirements and design & functionality of the system by viewing the Design documents.
• Involved as team member in coding and understanding the problem.
• Worked with data analyst to know the requirements of the project.
• Worked with various data sources like oracle, flat files, Sybase data coming as customers data and load into Oracle warehouse.
• Have used core Java to fulfil the complex design logic.
• Involved in designing of Informatica mappings by using transformations like source qualifier, expression, update strategy, router, joiner, connected lookup, unconnected lookup, dynamic lookup, transaction control, rank, sequence generator, Aggregator.
• Implemented Slowly Changing Dimensions (SCD) Type 1 and Type2.
• Created reusable transformations and Mapplets and used them in mappings.
• Worked on shared folders and reusable transformations.
• Worked on UNIX Shell scripting.
• Created PL/SQL procedures for certain Business Requirements
• Designed SQL overrides in source Qualifier according to business requirements
• Created sessions and workflows for designed mappings and created Sequential Workflow using
• Monitoring the session logs to check the progress of data load.
• Supported testing team, UAT team and production team.
• Attending the Daily & weekly status calls and updating the status of the Project and Team to the client from offshore.

Environment: Informatica 8.5, SQL Server, Java, PL/SQL, Sybase, Oracle, Toad, UNIX, Putty, TFS.