SUMMARY:

• 6.5 years of IT experience in Enhancements/ Development projects as a dataware housing Professional with Informatica , Oracle PL/SQL , Qlikview and Unix . Orcale Certified Expert and Informatica Certified Professional.
• Domain Experience: Diversified experience in multiple domains like Healthcare and Insurance.
• Handling the Lead role for the past 3 years. Single Point of Contact for all ETL related deliveries and data modeling for warehouse projects.
• Expertise in Requirement Analysis, Functional Analysis, Design, Development, Implementation, Testing, Debugging, Productions Support, Informatica PowerCenter Administration and Maintenance of various Applications.
• Highly proficient in ETL using Informatica Power Center 10.1, 9.5, 9.1/8.x and good working skills on Informatica tools such as Designer, Workflow Manager, Workflow Monitor, Debugger and Repository Manager.
• Participate in Agile team activities including daily standups, sprint planning, PSI planning, product demos, etc.
• Implemented applications in both SDLC (System Development Life Cycle) and agile models with effective implementations and timely delivery.
• Strong expertise in designing and developing Business Intelligence solutions in staging, populating Operational Data Store (ODS), Enterprise Data Warehouse (EDW), Data Marts / Decision Support Systems using Informatica Power Center 9.x/8.x Versions.
• Extensive experience working with databases like Oracle, MS SQL Server, Netezza and Exadata .
• Extensive experience in Performance tuning of Informatica (sources, mappings, targets and sessions) and tuning the SQL queries.
• Experience in scheduling the Informatica workflows using $Universe (UniViewer) and Informatica Scheduler.
• Extensive experience in Data Warehousing Concepts like Ralph Kimball Methodology, Bill Inmon Methodology, Star Schema, Snow Flake Schema, Fact Table, Dimension Table, and Dimension Data Modeling.
• Proficiency in using the different sources and transformations, partitions in informatica.
• Experienced in working on Oracle 12c/ 11g/10g database systems.
• Expertise in creating stored procedures, triggers, functions, packages, views, PL/SQL Collections, cursors and optimizing query performance
• Effectively made use of all database objects like creating Tables, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, primary keys, indexes, constraints, packages, sequences, grants and synonyms & Query Re - Write.
• Extensive experience with Oracle 11g which includes Bulk Collect and Bulk Bind.
• Experience in Performance Tuning using various types of Hints, Partitioning and Indexes, Used Explain Plan to monitor execution path and to decide on which hints to use.
• Have Working Knowledge in Oracle's built in Packages.
• Working experience in Customizing, Bug Fixing and Source Code maintaining of Oracle Database.
• Experience on Logical / Physical Data Models, Conceptual Design & Data Architecture using microsoft Viso.
• Have Working Knowledge in UNIX shells scripting with sh, bash, csh and ksh shells.
• Efficient in writing complex SQL queries, hierarchical queries, use of analytical functions, regular expressions.
• Experienced in data migration techniques using Oracle External Tables, SQL* Loader, Import/Export, Data Pump utility and batch processing.
• Experienced in scheduling the jobs using $Universe and Crontab and monitor the batch processing.
• Experienced in backend database development using tools SQL*PLUS, Oracle Designer, Oracle TOAD and SQL Developer.
• Have Working Knowledge in SSRS reporting.
• Effectively participated in End-to End Data Warehouse testing (UAT, SIT)
• Experience working with onsite-offshore model projects while working closely with clients and team members.
• Excellent communication skills and analytical skills and ability to Lead & perform as team player. ed 'TCS gem’ dedication to work and crucial and timely project delivery.

TECHNICAL SKILLS:

ETL: Informatica 10.1, 9.5, 9.1/8.x

Databases: Oracle-9i, Oracle 10g, Oracle 11g, Oracle 12c, MS SQL Server

Languages/ Utilities: Oracle SQL, PL/SQL, DATAPUMP, TOAD,Ultra Edit, $Universe

Operating Systems: UNIX

Reporting Tools: SSRS, QlikView

Functional Domain: Healthcare and insurance

PROFESSIONAL EXPERIENCE:

Confidential, Louisville, KY

Environment : Informatica, Oracle pl/sql

Tech Lead

Responsibilities:

• Analyzed source data and gathered requirements from the business users.
• Understanding existing business model and customer requirements.
• Develop design documentation & assist data base mapping fields.
• Using Informatica Power Center Designer, Extract & Transform the data from various source systems by incorporating various business rules for different applications by using the different objects and functions which the tool supports.
• Worked on Informatica tool like Source Analyzer, Data Warehousing designer, Mapping Designer, Transformations, Informatica Repository Manager and Informatica Workflow Manager.
• Extensively used the transformations like Expression, Aggregator, Router, Sequence generator, Lookup transformations, Update strategy and stored procedure transformation to create mappings
• Designed and implemented appropriate ETL mappings to extract and transform data from various sources to meet requirements
• Develop complex mappings such Slowly Changing Dimensions Type II - Time Stamping in the Mapping Designer and Created and executed workflows using Workflow Manager.
• Involved in the development of Informatica mappings and trouble shootings.
• Developed Oracle SQL Queries and Scripts to process the data.
• Involved in Data Extraction from SQL server, Flat files.
• Error Handling in Informatica mappings.
• Created and monitored the sessions and workflows.
• Provided support and quality validation thru test cases for all stages Unit and Integration testing.
• Worked with Informatica Debugger to debug the mappings in Designer.
• Developed Informatica Mappings and also tuned for better Performance.
• Used csv or flat files and tables as sources and loaded the data into relational tables.
• Used pushdown optimization to achieve good performance in loading data into Oracle.
• Conduct code walkthroughs and review peer code and documentation.
• Writing Unix scripts for handling the source data and mapping.
• Extensively used $universe tool for scheduling Informatica batch jobs and provided production support on rotation.
• Participate in Agile team activities including daily standups, sprint planning and product demos, etc. Worked with the Product Owner to understand requirements and translate them into the design, development and implementation of ETL process using Informatica 9.x.

Confidential, Louisville, KY

Environment : Informatica, Oracle pl/sql, Unix shell scripting

Tech Lead

Responsibilities:

• Analyzed source data and gathered requirements from the business users.
• Understanding existing business model and customer requirements.
• Develop design documentation & assist data base mapping fields.
• Using Informatica Power Center Designer, Extract & Transform the data from various source systems by incorporating various business rules for different applications by using the different objects and functions which the tool supports.
• Worked on Informatica tool like Source Analyzer, Data Warehousing designer, Mapping Designer, Transformations, Informatica Repository Manager and Informatica Workflow Manager.
• Extensively used the transformations like Expression, Aggregator, Router, Sequence generator, Lookup transformations, Update strategy and stored procedure transformation to create mappings
• Designed and implemented appropriate ETL mappings to extract and transform data from various sources to meet requirements
• Develop complex mappings such Slowly Changing Dimensions Type II - Time Stamping in the Mapping Designer and Created and executed workflows using Workflow Manager.
• Involved in the development of Informatica mappings and trouble shootings.
• Developed Oracle SQL Queries and Scripts to process the data.
• Involved in Data Extraction from SQL server, Flat files.
• Error Handling in Informatica mappings.
• Created and monitored the sessions and workflows.
• Provided support and quality validation thru test cases for all stages Unit and Integration testing.
• Worked with Informatica Debugger to debug the mappings in Designer.
• Developed Informatica Mappings and also tuned for better Performance.
• Used csv or flat files and tables as sources and loaded the data into relational tables.
• Used pushdown optimization to achieve good performance in loading data into Oracle.
• Conduct code walkthroughs and review peer code and documentation.
• Writing Unix scripts for handling the source data and mapping.
• Extensively used $universe tool for scheduling Informatica batch jobs and provided production support on rotation.
• Participate in Agile team activities including daily standups, sprint planning and product demos, etc. Worked with the Product Owner to understand requirements and translate them into the design, development and implementation of ETL process using Informatica 9.x.

Confidential

Environment : Informatica, Oracle pl/sql, Unix shell scripting

Tech Lead

Responsibilities:

• Interact with the Product Owners to get a brief knowledge of business logics.
• Participate in Agile team activities including daily standups, sprint planning and product demos, etc. Worked with the Product Owner to understand requirements and translate them into the design, development and implementation of ETL process using Informatica 9.x.
• Working with business and technical resources to address business information and application needs.
• Developed Orcale SQL Queries and procedures, packages and functions to process the data.
• Involve in Data validating, Data integrity, performances related to DB, Field size validation, check Constraints and Data Manipulation and updates by using SQL.
• Extensively worked on Informatica data integration platform.
• Extract data from flat files, oracle & Netezza and to load the data into respective tables.
• Implementing various loads like Daily Loads, Weekly Loads, and Quarterly Loads using Incremental Loading Strategy for Confidential .
• Developed Slowly Changing Dimension Mappings for Type 1 SCD, Type 2 SCD and fact implementation.
• Extensively used Mapping Variables, Mapping Parameters, and Parameter Files for the capturing delta loads.
• Extensively used Normal Join, Full Outer Join, Detail Outer Join, and master Outer Join in the Joiner Transformation.
• Used csv or flat files and tables as sources and loaded the data into relational tables.
• Created and Configured Workflows, Worklets, and Sessions to load the data to Netezza tables using Informatica PowerCenter.
• Working with the business analyst team to analyze the final data and fixed the issues if any.
• Used pushdown optimization to achieve good performance in loading data into Netezza and oracle.
• Responsible for determining the bottlenecks and fixing the bottlenecks with performance tuning.
• Extensively work on Informatica Metadata tables and created reusable transformations for error handling and exception reprocessing.
• Conduct code walkthroughs and review peer code and documentation.
• Writing Unix scripts for handling the source data and mapping.
• Validate the ongoing data synchronization process using validation tools to ensure the data in source and target system are synchronized.
• Extensively used $universe tool for scheduling Informatica batch jobs and provided production support on rotation.

Confidential

Environment : Oracle pl/sql, UNIX Shell Scripting

Developer

Responsibilities:

• Handling developer role.
• Estimating the tasks based on the requirements.Designing the ETL for the project
• Analysis of the specifications provided by the clients.
• Design of Conversion, Data extraction,transformation and load.
• Planning, Assigning tasks and mentoring team to deliver the activities on time
• Created workflows to retreive the data from mainframe files.
• Worked on Informatica Server and Client components such as Informatica Admin Console,
• Repository Manager, Designer, Workflow Manager, and Workflow Monitor for ETL
• Provide support for Integration testing.
• Responsible for overseeing the Quality procedures related to the project.
• Analyzing source systems and creating a Best Practices mapping to the target database schema.
• Defining and implementing the required business transformation rules and logic (ETL development).
• Designing and developing exception handling and data cleansing / standardization procedures.
• Optimizing ETL performance.
• Assessment and recommendation of ETL/other tools.
• Defining a suitable architecture for data integration from multiple, disparate data sources.