SUMMARY

• 10 Years of experience in Analysis, Design, Development, Testing and Production Support applications which includes Insurance and Banking Domains on INFORMATICA, INFORMATICA and Oracle/DB2/TERADATA, ODI.
• Client Interaction Experience and familiarity with Onsite/Off shore model
• Having experience as a ETL Technical Lead
• Independent and Team Player/Lead with strong technical background and excellent interpersonal skills with an ability to interact with individuals at all levels.
• Experiences in ETL tools are Informatica and Data Stage.
• Experience on Development, Integration, Migration and Production support projects.
• Experience on Banking, Insurance and Manufacturing domains.
• Good Experience in Oracle9i/10g SQL and PL/SQL objects
• Prepared PL/SQL scripts like Procedures, Functions and Packages based on requirement
• Handled support issues and work requests from support projects.
• Performance tuning of SQL queries used in extraction query to Source system.
• Experience on Push Down Optimization(PDO)
• Exposure on Hadoop components like PIG, HIVE and HBASE.
• Extensively used ETL tool to extract data from Oracle and Flat Files.
• Exposure on OBIEE.
• Exposure on Informatica Data Quality (IDQ)
• Data Quality Implementation - Informatica Developer (IDQ)
• Inventory of critical data quality business rule checks.
• Data analysis, data cleansing, data matching, data profiling with capabilities of IDQ.
• Data quality business rules
• IDQ development around Data profiling, Cleansing, Parsing, Validation, Matching and Data quality exception monitoring and handling.
• Excellent knowledge on Informatica platform as a whole and the integration among different Informatica components and services.
• Experience in Referential data and Metadata Management is a good plus.
• Good knowledge on data governance principals.
• Knowledge On Informatica Metadata Data Manager
• Good experience in Trouble shooting, Bug fixing and Performance tuning.
• Involved in Designing High level Technical Documentation.
• Having good communications and Analytical skills

TECHNICAL SKILLS

ETL Tools: Informatica, Data Stage, ODI 11g

Database Tools: Oracle 9i/10g, DB2, SQL Server, Teradata

BI Tools: OBIEE 12g

Hadoop Components: PIG, HIVE, HABSE

Operating Systems: Linux, Windows

PROFESSIONAL EXPERIENCE

Confidential, Jersy City,NJ

Lead Developer

Environment: INFORMATICA 9.5, Tearadata13.0

Responsibilities:

• Involving into Analysis, Design, Development and Testing.
• Handling the medium team as a Team/Technical lead
• Analyzing the task estimation and assigning the work to team
• Creating Technical template based on mapping spec for subject area.
• Creating mappings based on technical spec which has creating.
• Interacting with Source team to get the inputs or any changes requires from mapping spec.
• Creating Unit Test case template for every subject area
• Doing code review for every mapping level before going to Sign off.
• Handled complex mappings (SCD Type2) to handled Historical data.
• Using Push down Optimization.
• Supporting to team for any complexity or technical issues.
• Data Quality Implementation-Informatica Developer (IDQ)
• Inventory of critical data quality business rule checks.
• Involving into Data analysis, Data cleansing, Data profiling with capabilities of IDQ.
• Data quality business rules
• Excellent knowledge on Informatica platform as a whole and the integration among different Informatica components and services.
• Good understanding of data governance principals.
• Involving into Performance tuning
• Following the Informatica best practices and Coding standards while doing development.

Confidential, Santa Ana

Lead Developer

Environment: Informatica 8.6, Oracle 10g

Responsibilities:

• Working as a Team Leader for multiple applications from Base Line project.
• Leading the Supporting and development teams for multiple applications which are related to Billing Center.
• Assigning the production tickets and work requests for support team.
• Processing the scripts and fixing the issues anything got failed.
• Scheduling the production or UAT or Development jobs using with Tivoli Job Schedule Console.
• Created and modified PL/SQL scripts based on client enhancements.
• Finding the jobs using with Maestro Scheduler which has been failed using with Job name or Job stream.
• Contacting with Datacenter Operations team to reschedule or Rerun or cancel jobs based on condition.
• Monitoring the other team jobs and share the status details as well where Billing Center are having dependency.

Confidential, Santa Ana

Lead Developer

Environment: Informatica 8.6, Oracle 10g

Responsibilities:

• Handled the Team as a Lead and as well as Involving into design and development.
• Prepared Deployment strategy, Fit gap analysis, Test case and Test Plan documents.
• Involved into script enhancements based on client requirement
• Involved into scheduler process is TIVOLI maestro scheduler.
• Member of all deployments are DEV, UAT, SIT, Pre-Production and Production
• Fine-tuned existing Informatica Jobs for performance optimization.
• Creating complex SQL scripts.
• Using the Informatica designer to develop jobs for extracting, transforming, integrating, and loading data into strategy.
• Using the Informatica to develop jobs for extracting, transforming, integrating, and loading data into the Staging and Integration layers.
• Using transformer, lookup and aggregator stages in designer to achieve complex business logics
• Involved into Query tuning and SQL scripts.
• Involved into creation of PL/SQL objects like Procedures and Functions based on requirement.

Confidential, San Francisco

Lead Developer

Environment: Informatica 9, Oracle 10g

Responsibilities:

• Responsible for Business meeting, conversion of business rules into technical specifications
• Prepared PL/SQL scripts (Stored Procedures, Functions and Packages).
• Performance Tuning in SQL scripts level.
• Prepared PL/SQL blocks for single execution purpose for few infotypes.
• Performance tuning of SQL queries used in extraction query to Source system.
• Worked with Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Developer, and Mapping Designer
• Worked with Task Developer, Worklet Designer, and Workflow Designer in the Workflow Manager
• Responsible for extracting data from Oracle and Flat files
• Data Quality Implementation-Informatica Developer (IDQ)
• Involving into Data Quality like Data analysis, Data cleansing, Data profiling with capabilities of IDQ.
• Prepared Data quality business rules
• Excellent knowledge on Informatica platform as a whole and the integration among different Informatica components and services.
• Responsible for Performance in Informatica PowerCenter at the Target Level, Source level, Mapping Level, Session Level, and System Level
• Extensively worked with both Connected and Un-Connected Lookups

Confidential, San Francisco,CA

Sr ETL Developer

Environment: Informatica 8.6, Oracle 10g

Responsibilities:

• Responsible for Business meeting, conversion of business rules into technical specifications
• Prepared PL/SQL scripts(Stored Procedures, Functions and Packages).
• Performance Tuning in SQL scripts level.
• Prepared PL/SQL blocks for single execution purpose for few infotypes.
• Performance tuning of SQL queries used in extraction query to Source system.
• Created Views and Materialized views on requirement
• Create indexes and Functional indexes on required tables
• Worked with INFORMATICA Power Center client tools like Repository Manager, Designer, Workflow Manager, and Workflow Monitor
• Worked with Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Developer, and Mapping Designer
• Worked with Task Developer, Worklet Designer, and Workflow Designer in the Workflow Manager
• Responsible for extracting data from Oracle, Sybase, and Flat files
• Responsible for Performance Tuning at the Mapping Level, Session Level, Source Level and the Target Level
• Responsible for the Data Cleansing of Source Data using LTRIM and RTRIM operations of the Expression Transformation
• Responsible for Performance in Informatica PowerCenter at the Target Level, Source level, Mapping Level, Session Level, and System Level
• Extensively worked with both Connected and Un-Connected Lookups
• Extensively worked with Look up Caches like Persistent Cache, Static Cache, and Dynamic Cache to improve the performance of the lookup transformations
• Worked with re usable objects like Re-Usable Transformation and Mapplets

Confidential, Baltimore, MD

ETL Developer

Environment: Informatica 7X/8X, Oracle 9i

Responsibilities:

• Prepared PL/SQL scripts like Procedures, Functions and Packages.
• Involved into performance tuning in Database and ETL mapping level.
• Performance tuning of SQL queries used in extraction query to Source system.
• Created Views and materialized views for Analysis team.
• Created Simple, Complex and Functional indexes on required tables.
• Worked with INFORMATICA Power Center client tools like Repository Manager, Designer, Workflow Manager, and Workflow Monitor
• Worked with Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Developer, and Mapping Designer
• Worked with Task Developer, Worklet Designer, and Workflow Designer in the Workflow Manager
• Responsible for extracting data from Oracle, Sybase, and Flat files
• Extensively worked with both Connected and Un-Connected Lookups
• Extensively worked with Look up Caches like Persistent Cache, Static Cache, and Dynamic Cache to improve the performance of the lookup transformations.