SUMMARY

• Over Six years of IT experience in the Analysis, Design, Development, Testing and Implementation of business application systems.
• Highly motivated and goal - oriented individual with a strong background in SDLC Project Management and Resource Planning using AGILE methodologies.
• Strong experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center.
• Hands-on experience with Data Warehouse/Data Mart Design, OLAP, Slowly Changing Dimensions (SCD Type1, SCD Type 2, SCD Type 3), Dimensional Data Modeling (Ralph Kimball Approach) using Star and Snow Flake Schema, Identifying Facts and Dimensions, Physical and Logical data modeling using ERwin.
• Extensive Experience in designing and developing complex mappings using Informatica transformations like Lookup, Source Qualifier, Update Strategy, Router, Sequence Generator, Aggregator, Rank, Stored Procedure, Filter, Joiner and Sorter.
• Experience in Debugging, Error Handling and Performance Tuning of sources, targets, transformations, mappings and sessions with the help of error logs generated by Informatica Server.
• Expertise in working with relational database Oracle 12c,11g/10g/9i and Oracle Tools and Utilities like SQL*Loader and Data Pump .
• Extensive experience in PL/SQL development with Stored Procedures, Functions, Views and Triggers, Complex SQL queries, COLLECTION objects, BULK Collect, FOR ALL, Analytical Functions and more using TOAD, SQL Developer, SQL*PLUS.
• Strong experience in SQL, PL/SQL and Database Tuning for better performance.
• Expertise level knowledge of Oracle Database Architecture, Schema Object Creation, Memory and Space Management.
• Experience in AWS File Storage service S3, Computing service EC2 , AMI , Database service RDS , Security service IAM and AWS VPC set up and other AWS Solution Architect Associate components.
• Extensive knowledge in OCI including Oracle Cloud Compute Instance, IAM, Block Volume, Object Storage and File Storage Services, Cloud Networking, and Database Services (VMDB, Bare Metal DB, Exadata DB, ADW, ATP).
• Hands-on experience in writing UNIX shell scripts and automation of the ETL processes using UNIX shell scripting.
• Proficient in the Integration of various data sources with multiple relational databases like Oracle11g/10g/9i, MS SQL Server, Teradata, Flat Files into the staging area, ODS, Data Warehouse and Data Mart.
• Experience in Banking, Insurance and Tele-Communications Domains.

TECHNICAL SKILLS

Language: C, C++, Core Java, SQL, PL-SQL.

Oracle Technology: OCI, Oracle 12c/11g/10g/9i, RDBMS, Data Guard, ASM, Data Pump, RAC and Grid Infrastructure, Oracle Enterprise Manager

Oracle Tools: Toad, SQL Developer, SQL*Plus

Reporting Tools: Crystal Reports, Oracle Reports 2.5

ETL Tools: Informatica Power Centre 10.x/9.x, SQL*Loader

Database: Oracle 12c/11g/10g/9i, MS Access

Operating System: Unix, Linux, Windows 10

Concepts: Data Warehouse Concepts.

Cloud Technologies: Oracle Cloud Infrastructure, AWS.

PROFESSIONAL EXPERIENCE

Confidential, Irving, TX

Informatica ETL developer

Responsibilities:

• Involved in the design, development and implementation of ETL process using Informatica.
• Understood business requirements and developed mappings to extract data from legacy system (Teradata, SQL-Server), transform and load data into target system (Oracle) using Power Center v 10.x/9.x.
• Worked extensively on different types of transformations like expression, filter, sorter, router, aggregator, rank, update strategy, lookup (connected/unconnected), sequence generator, joiner, and stored procedure.
• Designed Informatica mapplets and worklets to utilize the reusability feature of Informatica.
• Worked extensively with dynamic cache with the connected lookup Transformations.
• Focused on fixed width and de-limited flat files, also worked with direct and indirect loading.
• Used Type1, Type2 SCD mappings to update Slowly Changing Dimension Tables.
• Involved in Designing of Data Modeling using ERwin for the Data warehouse.
• Developed mapping description documents.
• Regularly attended client weekly and daily status calls to understand their thought process and expectations.
• Worked on fixing non-fatal and fatal session errors.
• Used Debugger to test the mappings and fix the bugs.
• Worked on optimization of ETL programs by identifying and eliminating performance bottlenecks in Source, Target, Mapping, Session and System using thread statistics, SQL overrides etc.
• Provided excellent Informatica production support.
• Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
• Involved in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files.
• Performed SQL and PL/SQL tuning.
• Extensively involved in using indexes, hints to direct the optimizer to choose an optimum query execution plan.

Environment: Informatica Power Center 10.x/9.x, Oracle 11g/10g/9i, Teradata, MS SQL-Server, SQL, PL/SQL, UNIX, TOAD, SQL Developer, SQL*Loader, Erwin, Windows 10, Oracle Cloud Infrastructure, Data Warehouse Concepts.

Confidential

Informatica Developer

Responsibilities:

• Worked with ETL methodologies for supporting Data Migration, Data Exchange, Data Transformation using Informatica Power Center.
• Used Power Center client tools like the Designer components (Source Analyzer, Target Designer, Transformation Developer, Mapplet and Mapping Designer) to create Mappings.
• Worked with relational sources and flat files.
• Generated workflows using reusable tasks, worklets and workflows containing sessions, commands, event raise/wait, decision and timers for flow control.
• Extensively involved in monitoring the jobs using the workflow and session run properties to trace and debug in the Workflow Monitor .
• Implemented the knowledge of Relational and Dimensional modeling techniques in Data Warehouse which includes Star Schema, Snowflake Schema, Slowly Changing Dimensions, Surrogate keys, and Normalization/De normalization.
• Extensively used various Performance Tuning techniques like run test sessions, analyze thread statistics, monitor system resource usage to improve the performance for data loads.
• Worked with cross-functional teams such as QA, DBA and Environment teams to deploy code from development to QA and Production server.
• Performance tuned the workflows by identifying the bottlenecks in targets, sources, mappings, sessions and system and eliminated them.
• Provided production support including error handling and validation of mappings, sessions and workflow.
• Extensively used Debugger Process to test data and applying Break Points while Session is running.
• Provided production support for Business Users and documented problems and solutions for running the workflow.
• Developed UNIX scripts for scheduling the jobs.
• Designed and developed Oracle PL/SQL Procedures.
• Performance tuning of Oracle PL/SQL Scripts.

Environment: Informatica Power Center 9.x, Oracle 11g/10g/9i, SQL, PL/SQL, UNIX, TOAD, SQL Developer, SQL*Loader, ERwin, Oracle Reports, Windows 2000.

Confidential

PL-SQL developer

Responsibilities:

• Created Custom Packages, Stored Procedures, Functions and SQL Scripts to load data into warehouse from different sources.
• Worked on SQL*Loader to load data from flat files obtained from various facilities every day.
• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Developed PL/SQL triggers and master tables for automatic creation of primary keys.
• Worked extensively on Query Level Performance tuning using EXPLAIN PLAN, SQL*TRACE, TKPROF, and AUTOTRACE utilities, and also used DBMS PROFILER for PL/SQL tuning.
• Did Database Tuning with standard Diagnostic tools (AWR, ADDM,ASH).
• Created indexe s on tables for faster retrieval of data to enhance database performance.
• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
• Used Bulk techniques (FOR ALL, BULK COLLECT) for better performance and easy retrieval of data, by reducing context switches between SQL and PL/SQL engines.
• Handled Analytical functions (LEAD, LAG, RANK) for solving complex issue.
• Partitioned the fact tables and materialized views to enhance the performance.
• Created records and collections (varrays, nested tables and associative arrays) for improving Query performance.
• Created database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, SQL Developer and SQL* plus.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.

Environment: Oracle 11g/10g/9i, SQL, PL/SQL, UNIX, TOAD, SQL Developer, SQL*Loader, Data Pump, Oracle Enterprise Manager, Crystal Reports, Windows XP.