Sr. Informatica ETL Developer

PROFESSIONAL SUMMARY:

• 10 years of professional experience in IT, and the past 7 years spent primarily on Data warehouse projects using Informatica Power Center Server, Business Objects, Cognos, Teradata, SQL Server and Oracle on UNIX and Windows platforms..
• Experienced in full Software Development Life Cycle SDLC process.
• Solid understanding of Relational ROLAP and Multidimensional MOLAP modeling, broad understanding of data warehousing concepts, star and snowflake schema database design methodologies.
• Expertise in full life cycle of ETL Extraction, Transformation and Loading using Informatica Power Center Repository Manager, Mapping Designer, Workflow Manager, Workflow monitor .
• Good exposure to development, testing, debugging, implementation, documentation, user training production support.
• Experience in Teradata with Fast Load, Multi Load and BTEQ.
• Experience in UNIX shell programming.
• Managed and co-ordinate tasks between multiple teams offshore and onsite for many projects.
• Ability to work effectively in a supervisory and non supervisory environment as a team member as well as an individual.
• Experience in Healthcare industry and Telecom with excellent analytical and verbal communication skills.

Technical Skills Summary:

Professional Experience:

Confidential

Sr. Informatica/ETL Developer

Confidential is a global leader delivering innovative communications and technology solutionsThe main objective of the project here was data migration, Started from Oracle to Teradata and now working to move to Big Data/Hadoop. In this process we have done item conversions to move between RDBMS and data for legacy systems to HDFS, built some interfaces regarding AR and AP. Apart from this did some future sales forecasting project also.

Responsibilities:

• Analysis of the existing mappings.
• Enhancements to the existing mappings and sessions.
• Developed the mappings using Source Qualifier, Expression, Lookup, Router, Filter, Sequence Generator, Sorter, Update Strategy, Joiner and Union transformation based on the requirements.
• Extensively used Informatica client tools like Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer.
• Extensively used FLOAD and MLOAD utilities in Teradata through Informatica.
• Extensively used Push down Optimization in Informatica.
• Involved in testing of the mappings and matching the data with existing warehouse.
• Converted Unix-Oracle scripts to Unix-BTEQ scripts.
• Prepared the Deployment documents for code migration and Data migration.
• Involved in Production Support.
• Involved in Unit testing of the mappings.
• Performance Tuning of sessions and mappings.
• Worked closely with DBA's in performance issues.

Environment: Informatica Power Center 9.5.1/9.1.1, Oracle 11g, Teradata, UNIX, SQL Server, SQL, PL/SQL.

Sr. Informatica/DW Developer

Confidential providing revenue cycle management, practice management, consulting services, business process analysis and software integration solutions, Practice management system software including patient demographics and scheduling information as well as all claims and financial data. All transactional data stored in Enterprise Data Warehouse.

Responsibilities:

• Understanding the existing system.
• Involved in preparing the Mapping Document.
• Designed and developed mappings using Source Qualifier, Expression, Lookup, Router, Filter, Sequence Generator, Sorter, Stored Procedure, Update Strategy, Joiner and Rank transformations, SQL transformation, Union transformation.
• Preparing Sessions, Workflows, Worklets for Mappings.
• Developed reusable Mapplets using Mapplets Designer.
• Designing of control tables, and data error tables.
• Developed reusable transformations using Transformation Developer.
• Interacting with the testing team to solve the issues.

Environment: Informatica Power Center 8.6.1, Flat files, Oracle 10g, SQL,PL/SQL, Putty, Windows XP, Toad , Tivoli, Business Objects, Unix scripting, Win SCP.

Confidential

Sr. Informatica/DW Developer

Confidential is a global leader delivering innovative communications and technology solutions The main objective of the project is to develop new system to capture order, change and pending status.

Responsibilities:

• Worked with business analysts for requirement gathering.
• Prepared technical specifications to develop Informatica ETL mappings to load data into various tables confirming to the business rules.
• Designed and developed mappings using Source Qualifier, Expression, Lookup, Router, Filter, Sequence Generator, Sorter, Stored Procedure, Update Strategy, Joiner and Rank transformations, SQL transformation, Union transformation.
• Extensively used Informatica client tools like Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer.
• Preparing Sessions, Workflows, Worklets for Mappings.
• Developed reusable mapplets using Mapplets Designer.
• Developed reusable transformations using Transformation Developer.
• Scheduling the Workflows.
• Extensively used Informatica debugger to figure out the problems in mappings. Also involved in troubleshooting existing ETL bugs.
• Performance Tuning of sessions and mappings.
• Involved in Unit testing of the mappings.
• Developed Shell scripts to automate the process.
• Designing of control tables, audit tables and data error tables.
• Resolved the issues raised by testing team.

Environment: Informatica Power Center 7.1.1, Flat files, Oracle 9i, UNIX, SQL, PL/SQL, MS SQL Server 2000, TOAD, Windows XP, Win SCP

Confidential

ETL Developer

Description: Development of the Singapore Stock Exchange and Midas v1, Midas v2 Projects.

Responsibilities:

• Developed Conceptual and logical ETL applications to populate data from source to target database by Informatica tool.
• Implemented slowly changing dimensions Type2.
• Create Mapplets for Reuse Transformation logic in Mappings.
• Responsible for generating Reports from Central Myzus Server, using Business Objects Tool.
• Create Mappings in Mapping Designer for transforming Source Data into Target Database by Informatica Tool.
• Create Reusable Transformations in Transformations Developer.
• Responsible for generating Reports from Central Myzus Server, using Business Objects Tool.
• Design and develop application to solve business functional requirements.
• Creating oracle objects like Object Types, Object Views, Packages, Stored Procedures, Functions and Sequences in Oracle8.1.
• Generating Reports against the application data model using Business Objects Tool.
• Performed testing the application.

Environment: Informatica Power Center 7.1.1, Flat files, Oracle 8i, UNIX, SQL, PL/SQL, TOAD

Confidential

Oracle Developer

Description: Development of the Prajna Projects.

Responsibilities:

• Understanding the requirements for Recruitment, Training and Appraisal modules.
• Involved in System study, Analysis, and Project Planning.
• Writing Database Packages, Stored Procedures Triggers.
• Designing forms to navigate from main screen to different module screens.
• Responsible for creating stored procedures, triggers, functions etc in the backend.
• Participate in Unit testing.

Environment: Windows, UNIX, SQL, PL/SQL, Oracle 7.1.1