SUMMARY

• More than 9 years of IT experience in Requirement gathering, Functional Analysis, Design, Development, implementation, Testing, Debugging, Productions Support, and Maintenance of various Data warehousing Applications by using, Informatica 9X, 8.6, IDQ, MDM,Oracle 8i/9i/11i, SQL, PL/SQL, SQL* Loader, UNIX, LINUX,, SQL Server, Toad & Erwin.
• 9 years of IT experience in Analysis, Design, Development, Implementation, Testing and Support of Data Warehousing and Data Integration Solutions using Informatica Power center (9.6.1/8.6/7.1/6.1 ) and IDQ
• Proficiency in developing SQL with various relational databases like Oracle, SQL Server, Teradata, SAP, Mainframe etc.
• Knowledge in Full Life Cycle development of Data Warehousing.
• Have extensively worked in developing ETL program for supporting Data Extraction, transformations and loading using Informatica Power Center.
• 2 Yrs. experience with Informatica IDQ(Data profiling and cleaning ) tool
• 1 Yr. experience in Master Data Management( INFORMATICA - MDM)
• Experience with dimensional modeling using star schema and snowflake models.
• Understand the business rules completely based on High Level document specifications and implements the data transformation methodologies.
• Created UNIX shell scripts to run the Informatica workflows and controlling the ETL flow.
• Extensively worked with Informatica performance tuning involving source level, target level and map level bottlenecks.
• Extensive experience in error handling and problem fixing in Informatica.
• Excellent skills in retrieving the data by writing simple/ complex SQL Queries. Strong with relational database design concepts.
• Experience in using SQL Loader to load data into database by writing CONTROL files.
• Experience on Teradata Utility scripts like Fast Load, Multi Load to load data from various source systems to Teradata.
• Strong business understanding of verticals like Banking, Brokerage, Insurance, Health Insurance, Telecommunication and Retail.
• Independently perform complex troubleshooting, root-cause analysis and solution development.
• Understanding in writing Test plans, Test cases, Unit testing, System testing, Integration testing and Functional testing.
• Involved in many Informatica Admin activities like Creation folder, User creation, Assigning role the USER, Code back up, Migration of code(Dev to QA to UAT),Informatica connection creation(relational and application) etc.
• Ability to meet deadlines and handle multiple tasks, decisive with strong leadership qualities, flexible in work schedules and possess good communication skills.
• Team player, Motivated, able to grasp things quickly with analytical and problem solving skills.
• Exposure towards OBIEE, Cognos and Business object reporting tool.
• Worked on onsite\offshore model
• Comprehensive technical, oral, written and communicational skills

TECHNICAL SKILLS

Primary Skills: Informatica 9X, 8.6, IDQ,MDM,Oracle and Unix

Operating Systems: UNIX ( Confidential AIX, Sun Solaris, SunOS, HP UX, Linux), Win NT/95/98/2000, DOS

Languages: SQL,PL/SQL, C, C++, Visual Basic 6.0, java, .Net, XML

Development Tools: Informatica 9X, 8.6, IDQ, Business Objects 6.5, Data Stage 8.5, Erwin, Visual Basic, VSS, PVCS, TOAD, Lotus notes, Service center, ASP, Jscript, IIS, Citrix, JSConsole, Encryption and Decryption Technique, MS Project

Scripts: UNIX or LINUX Shell Scripts

Databases: DB2, Oracle 8i/9i/11i, Teradata, SQL Server 2005, MS Access 2000

PROFESSIONAL EXPERIENCE

Confidential

Informatica Developer

Responsibilities:

• Extensively used Informatica 9.6.1 for extracting the data from Mainframe, Flat File, Oracle and Sqlserver to loading data into SAP HANA..
• Creation of jobs using different transformations and validate the mapping.
• Created various mappings, mapplets to implement the business logic using different transformations as Aggregator, Connected and Unconnected Lookups, Router, Update Strategy, Filter, Rank, Joiners.
• Expression, Sequence generator. Used debugger to test the mapping and fixed the bugs.
• Created Informatica IDQ mapping for Data profiling and Data Cleansing
• Used Power Exchange for extracting the data from Mainframe.
• Extensively used Informatica Analyst, IDQ tool for source data profiling.
• Implemented Slowly Changing dimensions Type 1,Slowly Changing dimensions Type 2 history of dimensional data in the table
• Designed and Developed the Informatica workflows/sessions to extract, transform and load the data into dimension, fact tables and transactional tables.
• Used Workflow Manager for creating, validating, testing and running the sequential and concurrent sessions.
• Used Workflow Monitor to monitor the progress of workflow.
• Responsibility involved in Non Function point Estimation, Impact
• Created of Informatica MDM Mappings, Cleanse Functions and Cleanse List.
• Good experience with Trust Configuration and Validation Rules.
• Experience Match & Merge setup. Experience in setting up fuzzy and exact match rules and tuning it.
• Analysis, Defect Closing, preparation of HLD, LLD, Test Case etc. maintain the coding standard according to the Naming convention.
• Interacted with technical team and business users to perform analysis of business requirements
• Prepare the technical document after going through the functional specification.
• Worked with testing team on ALM to resolve the defects
• Met SLA(>98%) and achieved the customer satisfaction
• Maintain a good relationship with key stakeholders and work towards strengthening them.
• Close coordination with customer’s managers/leaders to ensure good understanding and alignment with their IT goals.
• Cultivate key client relationships, which lead to new business opportunities.
• Facilitate quarterly surveys of the IT application systems showing findings and trend analysis by application

Confidential

Informatica Developer

Responsibilities:

• Extensively used Informatica 9.6.1 for extracting the data from legacy system and loading data into SQL SERVER
• Creation of jobs using different transformations and validate the mapping.
• Created various mappings, mapplets to implement the business logic using different transformations as Aggregator, Connected and Unconnected Lookups, Router, Update Strategy, Filter, Rank, Joiners.
• Created Informatica IDQ mapping for Data profiling and Data Cleansing
• Expression, Sequence generator. Used debugger to test the mapping and fixed the bugs.
• Implemented Slowly Changing dimensions Type 1,Slowly Changing dimensions Type 2 history of dimensional data in the table
• Designed and Developed the Informatica workflows/sessions to extract, transform and load the data into dimension, fact tables and transactional tables.
• Used Workflow Manager for creating, validating, testing and running the sequential and concurrent sessions.
• Used Workflow Monitor to monitor the progress of workflow.
• Responsibility involved in Non Function point Estimation, Impact Analysis, Defect Closing, preparation of HLD, LLD, Test Case etc. maintain the coding standard according to the Naming convention.
• Interacted with technical team and business users to perform analysis of business requirements
• Prepare the technical document after going through the functional specification.
• Providing solutions for the new enhancements and proposing new ideas to client for the operational cost reduction.
• Managing and providing the solution to Other teams
• Handles customer escalations and works proactively to close the gaps
• Lead the documentation initiative to create functional knowledge base with in the engagement.
• Met the SLA and achieved the customer satisfaction
• Maintain a good relationship with key stakeholders and work towards strengthening them.
• Close coordination with customer’s managers/leaders to ensure good understanding and alignment with their IT goals.
• Cultivate key client relationships, which lead to new business opportunities.
• Facilitate quarterly surveys of the IT application systems showing findings and trend analysis by application

Confidential

Informatica Developer

Responsibilities:

• Extensively used Informatica 9.1 for extracting the data from PEOPLESOFT application and loading data into OBIEE DATAWAREHOUSE.
• Creation of jobs using different transformations and validate the mapping.
• Created various mappings, mapplets to implement the business logic using different transformations as
• Used Aggregator, Connected and Unconnected Lookups, Router, Update Strategy, Filter, Rank, Joiners.
• Expression, Sequence generator. Used debugger to test the mapping and fixed the bugs.
• Implemented Slowly Changing dimensions Type 1,Slowly Changing dimensions Type 2 history of dimensional data in the table
• Designed and Developed the Informatica workflows/sessions to extract, transform and load the data into dimension, fact tables and transactional tables.
• Used Workflow Manager for creating, validating, testing and running the sequential and concurrent sessions.
• Used Workflow Monitor to monitor the progress of workflow.
• Responsibility involved in Non Function point Estimation, Impact Analysis, Defect Closing, preparation of HLD, LLD, Test Case etc. maintain the coding standard according to the Naming convention.
• Interacted with technical team and business users to perform analysis of business requirements
• Prepare the technical document after going through the functional specification.

Confidential

Informatica Developer

Responsibilities:

• Extensively used Informatica 8.6 for extracting the data from Flat FILE and loading data into Oracle
• Creation of jobs using different transformations and validate the mapping.
• Created various mappings, mapplets to implement the business logic using different transformations as
• Used aggregator, Connected and Unconnected Lookups, Router, Update Strategy, Filter, Rank, Joiners, Expression, Sequence generator transformations. Used debugger to test the mapping and fixed the bugs.
• Implemented Slowly Changing dimensions Type 1 and Type 2 to keep a full history of dimensional data in the table
• Used Workflow Manager for creating, validating, testing and running the sequential and concurrent Sessions.
• Designed and Developed the Informatica workflows/sessions to extract, transform and load the data into Transactional tables.
• Used Workflow Monitor to monitor the progress of workflow.
• Wrote SQL queries, PL/SQL Procedures/Functions to support the business requirements and to
• Interacted with technical team and business users to perform analysis of business requirements
• Prepare the technical document after going through the functional specification.

Confidential

Informatica Developer

Responsibilities:

• Extensively used Informatica 8.6 for extracting the data from Flat FILE and loading data into oracle.
• Creation of jobs using different transformations and validate the mapping.
• Created various mappings, mapplets to implement the business logic using different transformations as
• Aggregator, Connected and Unconnected Lookups, Router, Update Strategy, Filter, Rank, Joiners,
• Expression, Sequence generator. Used debugger to test the mapping and fixed the bugs.
• Implemented Slowly Changing dimensions Type 1 and Type 2 to keep a full history of dimensional data in the table
• Used Workflow Manager for creating, validating, testing and running the sequential and concurrent sessions.
• Designed and Developed the Informatica workflows/sessions to extract, transform and load the data into Transactional tables.
• Used Workflow Monitor to monitor the progress of workflow.
• Wrote SQL queries, PL/SQL Procedures/Functions to support the business requirements and to
• Interacted with technical team and business users to perform analysis of business requirements
• Prepare the technical document after going through the functional specification.
• Excellent skills in analysis and business requirements gathering from end users to the client and experience in documentation of developed applications
• Responsible for ensuring that the requirements of the business clients have been captured and documented correctly before a solution is developed.
• Responsible for issue resolution, work closely to perform data quality & analysis and monitoring of data load
• Peer review, code review.

Confidential

Informatica Developer

Responsibilities:

• Responsible for ensuring that the requirements of the business clients have been captured and documented correctly before a solution is developed.
• Responsible for issue resolution, work closely to perform data quality & analysis and monitoring of data load.
• Excellent skills in analysis and business requirements gathering from end users to the client and experience in documentation of developed applications
• Implemented the Informatica coding in BODI tool
• Involved in doing code review
• Extensively used Informatica 8.6 for extracting the data from Flat FILE and loading data into Oracle.
• Creation of jobs using different transformations and validate the mapping.
• Created various mappings, mapplets to implement the business logic using different transformations as
• Aggregator, Connected and Unconnected Lookups, Router, Update Strategy, Filter, Rank, Joiners, Expression, Sequence generator. Used debugger to test the mapping and fixed the bugs.
• Implemented Type II slowly changing dimension to keep a full history of dimensional data in the table
• Coded BTEQ scripts to load data from Teradata staging to Enterprise Data warehouse.
• Worked Extensively on Teradata SQL Assistant to analyze the existing data and implemented new business rules to handle various source data anomalies.
• Used MLOAD,FLOAD to load the data in to Teradata warehouse
• Used PL/SQL for writing stored procedures and database triggers to enforce database integrity.
• Used Workflow Manager for creating, validating, testing and running the sequential and concurrent Sessions.
• Designed and Developed the Informatica workflows/sessions to extract, transform and load the data into Transactional tables
• Debug mappings to gain troubleshooting information about data and error conditions using Informatica Debugger.
• Used Workflow Monitor to monitor the progress of workflow.
• Wrote SQL queries, PL/SQL Procedures/Functions to support the business requirements.

Confidential

Informatica Developer

Responsibilities:

• Involved in Non-Function point Estimation, Impact Analysis, Defect tracking and Closing, SRS, HLD, LLD, Test Case, Peer review, maintain the coding Coded BTEQ scripts to load data from Teradata staging to Enterprise Data warehouse.
• Worked Extensively on Teradata SQL Assistant to analyze the existing data and implemented new business rules to handle various source data anomalies.
• Used MLOAD,FLOAD to load the data in to Teradata warehouse
• Used PL/SQL for writing stored procedures and database triggers to enforce database integrity.
• Determined scope of project phases, and documented the mappings.
• Determined where the data resided and how to write to temporary file for initial load.
• Wrote detailed specifications to code navigation path to store data within proper tables.
• Coordinated execution of the test plans and verified data to be loaded into Warehouse.
• Created Mapping and Mapplets for Transforming data from transient staging to Warehouse and feeding specific data marts.
• Used Informatica Source Analyzer, Mapping Designer and Warehouse Designer for Extraction, Transformation and Loading.
• Created reusable transformations and used in different mappings.
• Used Joiner Transformation to extract data from multiple sources and Sequence Generator Transformation to create unique primary key values.
• Used Aggregator, Sequence Generator, Joiner, Look up, Expression, Filter, Rank, Router, Update Strategy Transformations to populate target. Used debugger to test the mapping and fixed the bugs.
• Implemented SCD1 and SCD2.
• Involved in analysis, design, development, test and implementation of Informatica transformations and workflows for extracting the data from the source systems.
• Worked cooperatively with the team members to identify and resolve various issues relating to Informatica and databases