SUMMARY:

• Development, Implementation | Data warehousing | Informatica / Oracle
• Highly accomplished, versatile consultant with demonstrated success in data warehousing development, maintenance, support and database applications with Informatica, Oracle in Unix and Windows environment.
• Proven, 8+years in client facing roles as ETL developer, with demonstrated ability and expertise in ETL techniques with Informatica power center, Oracle PL/SQL stored procedures to extract, transform data from various data sources and to load in transactional/dimensional databases.
• Experienced in dimension data modeling concepts like star schema, snow - flake modeling, FACT, dimensional tables, physical and logical data modeling.
• Adept in delivering data warehousing, data integration, migration and conversion projects for strategic customers globally; ability to direct on- and off-shore teams working at customer sites across the globe in end-to-end services.

CORE COMPETENCIES / TECHNICAL SKILLS:

ETL Tools: Informatica power center 10.2/9.x power exchange

Development tools: SQL *PLUS, TOAD, SQL Loader

Operating System: Windows 2008/07/05/NT/XP, Solaris UNIX

Banking and Finance:

Databases: Oracle 11g/10g/9i, SQL server 2008/12, Sybase IQ

Programming Languages: UNIX shell scripting, batch scripting, HTML, C, C++, Java, Oracle PL/SQL (stored procedures), OBIEE

Scheduling Tools: Control-M, CA7

Data modeling tools: Star schema, snowflake, FACT and dimensions

Versioning Tools: Merant, Harvest, Artifactory, Clear case, UDeploy

Other tools: Business XI R2, ALM performance monitoring, Putty, Bluezone (mainframe)

PROFESSIONAL EXPERIENCE:

Confidential

ETL Developer

Responsibilities:

• Experienced in data warehousing, data integration, data migration and conversion projects, with Informatica, Oracle PL/SQL
• Extensive experience with ETL tool Informatica Power Center /Power Mart Power Exchange in designing and developing Mappings, Mapplets, Transformations, Workflows, Worklets, Configuring the Informatica Server and scheduling the Workflows and sessions.
• Strong experience using Oracle, SQL Server. Strong Experience on database interfaces like SQL Plus and TOAD.
• Have performed various testing activities like Unit Testing, Integration, System Testing, Regression Testing and User Acceptance Testing and ensured that the code is ideal.
• Experience in Slowly Changing Dimensions Type 1, Type 2 and Type 3 for inserting and updating Target tables for maintaining the history.
• Experienced in automating the Informatica jobs, also experienced in Informatica Scheduler, Autosys, UNIX scripts for automation
• Extensive experience in designing and developing complex mappings from varied transformation logic like Unconnected and Connected lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner.
• Experience in various domains like Banking and Retail.
• Seamlessly manage business support, applications across varied business functions including retail, finance & banking; drove customer satisfaction to over and above 95%.
• Led continuous process improvements and delivered many optimization and performance improvement initiatives leading to productivity savings (annual saving in over six digits).
• Irrespective of shift timing, through proactive monitoring, made sure 99.9% on time completion of ETL jobs enabling business continuity and customer appreciations
• As part of application support and maintenance functions all incidents were resolved with-in agreed SLA of 95%

Confidential

Technology Platform: Informatica Power Center 9x/10.2, Oracle 10g, SQL Server 2012/15 R2 management studio, CA7, SCM harvest, Artifactory, UDeploy, TOAD, putty, WinSCP, PL/SQL

Responsibilities:

• Extensive experience with ETL tool Informatica Power Center /Power Mart Power Exchange in designing and developing Mappings, Mapplets, Transformations, Workflows, Worklets, Configuring the Informatica Server and scheduling the Workflows and sessions.
• Strong experience using Oracle, SQL Server. Strong Experience on database interfaces like SQL Plus and TOAD.
• Have performed various testing activities like Unit Testing, Integration, System Testing, Regression Testing and User Acceptance Testing and ensured that the code is ideal.
• Experience in Slowly Changing Dimensions Type 1, Type 2 and Type 3 for inserting and updating Target tables for maintaining the history.
• Experienced in automating the Informatica jobs, also experienced in Informatica Scheduler, Autosys, UNIX scripts for automation
• Extensive experience in designing and developing complex mappings from varied transformation logic like Unconnected and Connected lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner.
• Experience in various domains like Banking and Retail.
• Implemented data warehousing methodologies for Extraction, Transformation and Loading using Informatica Designer, Repository Manager, Workflow Manager, Workflow Monitor.
• Experience in working with UNIX Shell Scripts for automatically running sessions, aborting sessions and creating parameter files. Written number of shell scripts to run various batch jobs.
• Experience on Debugger to validate the mappings and gain troubleshooting information about data and error conditions.
• Experience in handling file transfers (SFTP and FTP) both inside the network and outside the network.
• Extensive experience in production support, solving various tickets within SLA's
• Responsibility includes gathering and understanding of business requirements and functionality of the existing systems. Development and implementation of extraction, transformation and loading of mortgage data using Informatica power center, power exchange and oracle
• Assumed responsibility for end to end delivery including level 3 support, development and enhancement. Responsible for resolving production incidents with in SLA and not to impact on time data availability of data to the end user
• Responsible for preparation of release documentation and migration of informatica and database components to production. Responsible for process improvement initiatives for continuous improvement of application stability and performance.
• Responsible for end to end incident and problem resolutions for mortgage line of business. Also responsible for reporting root cause analysis and findings for the high severity incidents to IT and Business leadership
• Other responsibilities includes pre-production implementation reviews of deliverables, communication to business users of both planned and emergency releases to production, on-call support.

Confidential

Technical Platform: Informatica power center 8.6.1, Oracle 10g, Unix, TOAD, putty, Windows XP, Oracle, PL/SQL

Responsibilities:

• Assumed responsibility for configuration management of the informatica code and leveraging clear case tool for check-in and check-out of objects
• Responsible for stakeholder management for test plan preparation and execution for each release
• Responsible for Operational testing (non-functional testing), including performance, back-out and re-run ability tests
• Responsible for batch preparation, batch schedule deployment and configuration, including scheduling of jobs in Unix environment and changing static parameters for the batch run
• Responsible for warranty support for the application and act as liaison between business and IT team during warranty support phase. Also responsible for L3 support for the application
• Responsible for other functions including environment refresh as per the refresh calendar by coordinating with Oracle, Unix, and storage teams. Batch creation, monitoring and support during system integration testing, functional testing and UAT phases of the project. Batch issues logging, trouble shooting, investigation and issue resolution

Confidential

Technical Platform: Informatica 8.6, Unix, TOAD, putty, Windows XP, Oracle 9i, PL/SQL, Sybase IQ, SQL Loader, Control-M scheduler

Responsibilities:

• Responsible for interacting with business SME for requirement gathering and responsible for preparation of functional design document
• Responsible for extraction, transformation and loading of data from Oracle, flat / csv files into data warehousing
• As part of continuous improvement responsible for performance tuning by analyzing technical gap in the code. Also delivered ETL code enhancements
• Performed functions of system testing and integration testing. During UAT phase worked closely business users and provided necessary UAT support.
• Also responsible for post-production warranty support