Professional Overview:

• 7 years of experience in Information Technology with a strong background in Data warehousing and ETL process.
• Worked in various domains including but not limited to Healthcare, Retail and Telecommunications.
• Worked extensively with all Informatica Power Center Designer tools including Source Analyzer, Target Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Proficient in using Informatica workflow monitor and workflow manager to create, schedule and control workflows and tasks.
• Extensively worked on Informatica Power Center transformations such as Lookup, Filter, Router, Expression, Joiner, Rank, Aggregator, Update Strategy, Normalizer, Sorter and Sequence Generator.
• In-depth knowledge of Data warehousing Methodologies like Bill Inmon Ralph Kimball approaches and
• Data warehousing concepts including dimensional Star Schema and Snowflake Schema methodologies.
• Hands on experience in Performance tuning of the Informatica jobs.
• Understanding Working knowledge of Informatica CDC Change Data Capture .
• Strong expertise in Relational data base systems like Oracle, SQL Server and Teradata.
• Proficient in working with UNIX Operating System and writing UNIX shell scripts mostly for file operations and ftp transfers.
• Proficient in understanding business processes/requirements and translating them into technical requirements.
• Highly adept at creation, execution, testing and debugging of Informatica mappings, mapplets, sessions, tasks, worklets and workflows.
• Experience in unit testing, UAT testing co-ordination, production monitoring and impact analysis of existing workflows. Experience in doing Production support.
• Experience in all aspects of software development life cycle SDLC like analyzing the business application, Design, Development, Testing, Implementation and Maintenance.
• Flexible and versatile and can adapt to any new environment and learn fast.
• Self-motivated and able to work independently and as a member of a team with excellent communication, interpersonal and analytical skills.

Technical Summary:

Confidential

Sr. Informatica Developer

Responsibilities:

• Actively Interacted with Users and Business Analysts to understand the requirements.
• Arranging the meetings with the Business teams and interact with Release Management, Configuration Management, Quality Assurance, Architecture other Development teams and Operations as required.
• Designed ETL processes using Informatica Power Center 9.1 in creating mappings, sessions and workflows to load data from CRMS Files to staging tables and then to the Final Care Gaps Database.
• Improving the performance of mappings and workflows by removing bottlenecks.
• Creating reusable transformations based on the business rules to ease the development.
• Documenting the guidelines for support team.
• Creating mappings using different transformations like Source Qualifier, Joiner, Aggregator, Expression, Filter, Router and Lookup transformations.
• Resolving data anomalies by analyzing the existing mappings.
• Created and used different tasks like command and email tasks for session status.
• Followed agile methodology.
• Developing test cases and test plans to complete the unit testing.
• Monitored and configured the sessions that are running, scheduled, completed and failed through Autosys.
• Prepared the documentation to describe program development, logic, coding, testing, changes and corrections.
• Providing production support for ETL processes and programs.
• Providing daily status to Client about the assignment progress.
• Understanding of Hadoop framework, Hadoop Distributed File System HDFS and Map Reduce.

Environment: Informatica Power Center 9.1,Oracle 10g, IDQ,PL/SQL Developer 9.0, SQL Plus 9.2, Flat files, UNIX shell scripting, Autosys, Windows, Hadoop Framework.

Confidential

Sr. Informatica Developer

Responsibilities:

• Actively participated in understanding business requirements, analysis and designing process from Business Analyst.
• Developed ETL jobs to extract information from Enterprise Data Warehouse.
• Responsible for developing the mappings from given technical documents using various transformations.
• Experience in making changes to existing mappings according to the user requirements.
• Worked with sources like Sqlserver, flat files and Oracle. Target database was Oracle. Developed various types of sql queries involving joins, aggregate calculations and tuning the queries. Done extensive testing and developed queries in SQL to ensure the loading of the data.
• Expertise in working with data extract using Power Exchange tool by COBOL copybooks layouts.
• Worked on Mainframes to check the data using FILE - AID.
• Performed unit testing at various levels of the ETL and documented the results.
• Created tasks like Session, Decision, Email and Command in preparing the Workflow.
• Extensively used Expression, Joiner for heterogeneous sources, look-up, filter, aggregate, and update strategy transformations to transform data before loading into the target tables.
• Developed workflow sequences to control the execution sequence of various jobs and to email support team.
• Implemented Slowly Changing Dimension methodology including Type 1, Type 2 changes to keep track of historical data.
• Used Informatica debugging techniques to debug the mappings and used session log files and bad files to trace errors occurred while loading.
• Worked extensively with parameterizing the workflows, configuring the reusable success and failure mails, command tasks.
• Extensively worked in the performance tuning of Source, Target, Mappings and Sessions.

Environment: Informatica Power Center 9.1,Oracle 10g,IDQ, SQL Plus, Toad, Microsoft SQL Server 2008, DB2,Windows 7,UNIX,Mainframes.

Confidential

Sr. Informatica Developer

Responsibilities:

• Involved in analysis of business requirements and keeping track of data available from various data sources, transform and load the data into Target Tables using Informatica Power Center.
• Prepared documentation for ETL strategies, source versus destination system mappings. Involved in building and supporting the extraction flows.
• Extracted data from sources like Oracle 10g, SQL Server and Flat files transformed the data according the business requirement.
• Developed various mappings using Mapping Designer and worked with Aggregator, Lookup, Filter, Router, Joiner, Source Qualifier, Expression, Sorter and Sequence Generator transformations.
• Loaded data from XML flat files to MAXIMO and used Informatica to load data from MAXIMO to Oracle database.
• Developed mappings for handling error records for audit purpose.
• Created and participated in SSR and defects review meetings to expedite defects fixes and enhancements.
• Participated in full testing cycle Unit testing, Integration testing, Acceptance including bug fixes.
• Involved in performance tuning by removing the Source/Target bottlenecks in the Mappings.

Environment: Informatica Power Center 8.6/8.1 Oracle 10g,Microsoft SQL Server 2008, Windows 7, PL/SQL Developer, Maximo 6.0

Confidential

Sr. Informatica Developer

Jan 2011 to Sept 2011

Responsibilities:

• Interacted with the Business Users to analyze the business requirements and transform the business requirements into the technical requirements.
• Prepared technical specifications for the development of Informatica ETL mappings to load data into various target tables and defining ETL standards.
• Created logical and physical data models using Erwin.
• Created Entity Relationship ER diagrams based on requirements.
• Created ETL mapping documents for every mapping and Data Migration document for smooth transfer of project from development to testing environment and then to production environment.
• Created mappings using different transformations like Source Qualifier, Joiner, Aggregator, Expression, Filter, Router, Lookup, Update Strategy, and Sequence Generator etc.
• Implemented audit process to ensure Data warehouse is matching with the source systems in all reporting perspectives.
• Implemented Performance tuning in Mappings and Sessions by identifying the bottlenecks and Implemented effective transformation Logic. .
• Worked extensively with the Teradata SQL Assistant to interface with the Teradata.
• Created Test tables and worktables on development and production on Teradata.
• Involved in Unit Testing, User Acceptance Testing UAT to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.
• Preparing and using test data/cases to verify accuracy and completeness of ETL process.
• Involved in the Production support and also transferred knowledge to the other team members.

Environment: Informatica Power Center 8.6, Power Exchange 8, Teradata V2R6, Oracle 10g,IDQ, Unix, Microsoft SQL server 2008, ,TOAD, Teradata SQL Assistant ,Erwin, Mainframes.

Confidential

Informatica Developer

Responsibilities:

• Participated in regular meetings with the clients to understand the requirement for efficient documentation and designing.
• Extensively used Informatica client to extract data from the database Oracle, MS SQL Server and load it into a single data warehouse repository Oracle .
• Implemented Slowly Changing Dimension type 1 methodology to capture the changes.
• Designed and Developed ETL Extract, Transformation Load strategy to populate the Data Warehouse from the various source systems feeds using Informatica Power Center.
• Developed sessions using Workflow Manager for loading the data into target Database.
• Involved in Unit Testing and Integration Testing of Informatica Sessions, Workflows and the Target Data.
• Involved in Performance Tuning of various mappings and sessions to identify and remove Bottle Necks.

Environment: Informatica Power Center 8.6, Oracle 10g, Toad 7.3, Erwin 4.0,Unix shell scripting.

Confidential

ETL Developer

Responsibilities:

• Involved in gathering the business requirements from Business Analyst.
• Analyzed the functional specifications provided by the data architect and created technical specifications documents for all the mappings.
• Developed logical and physical data models that capture current/future state data elements and data flows.
• Used various transformations like Source Qualifier, Aggregators, Lookups, Filters, Sequence Generators, Routers, Update strategy, Expression and Sorter.
• Extracted data from different sources and cleansed the data, validated the data before loading into the Data warehouse.
• Extensively used Informatica client tools Source Analyzer, Target designer, Mapping designer and Mapplet Designer.

Environment: Informatica Power Center 8.6, Oracle 9i, PL/SQL Developer, SQL Plus, SQL Loader, Unix Shell Script, Erwin.