Professional Summary:

• 7 years of experience in IT industry with emphasis on analysis, design, development, Implementation and management of applications in Data Warehousing and Data Integration Solutions using Informatica PowerCenter.
• Interact with the business users, collect the requirements, analyze the requirements, design and recommend solutions. Document detailed application specifications, translate technical requirements into programmed application modules and business objects.
• Expertise in Software Development Life Cycle SDLC .
• Extensively worked in developing ETL program for supporting Data Extraction, Transformations and Loading using Informatica PowerCenter.
• Experience in creating re-usable Transformations Joiner, Sorter, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Sequence Generator, Normalizer and Rank and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
• Extensively worked on developing and debugging Informatica mappings, mapplets, sessions and workflows.
• Worked on Performance Tuning, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.
• Experience in Star Schema Modeling, and Snowflake modeling, FACT and Dimensions tables, physical and logical modeling.
• Working experience in data cleansing, data scrubbing techniques.
• Expert in creating SQL Queries, PL/SQL packages, functions, stored procedures, triggers, views and cursors.
• Created database objects like tables, views, sequences, synonyms, indexes using Oracle tools like Toad and SQL Developer.
• Proficiency with tools used in Oracle Applications development including PL/SQL, Forms, Reports, Workflow Builder.
• Experience in performance tuning the SQL queries using Explain plan and SQL Trace to for higher efficiency.
• Working experience in Informatica Data Explorer.
• Knowledge in UNIX Cron Jobs, shell scripting and Batch Processing.
• Proficient in features of Oracle for PL/SQL programming like Using Records and Collections, Bulk Bind, Ref Cursors, Nested tables, Dynamic SQL and exception handling.
• Familiar with SQL Loader to load data from external source like flat files into database tables.
• Solid understanding of Hadoop framework and HDFS, developed mapreduce jobs for big data analysis purpose.
• Strong background in Object oriented programming languages like Java, Javascript, C/C .
• Provided on-call and worked in 24x7 production support role.

TECHNICAL SKILLS:

PL/SQL, Informatica PowerCenter 8.x/9.x, Java, Hadoop, Big Data, UNIX Shell Scripting, Oracle Database 10g/11g, Teradata, C/C , JSP, JavaScript, HTML, TOAD, Eclipse, VI Editor, Matlab, Linux, Unix, Windows 95/98/2000/XP.

Work Experience:

Confidential

Technical ETL Developer

• Develop various modules and applications utilizing programming methodologies, languages and platforms such as Java, PL/SQL, Informatica, JSP, UNIX Shell scripting, Windows, LINUX, and UNIX.
• Extracted data from various databases and spreadsheets and staged into a single place and applied business logic to load them in to the central oracle database.
• Utilized Informatica PowerCenter for extraction, transformation and load ETL of data in the data warehouse.
• Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression and Lookup, Update strategy and Sequence generator and Stored Procedure.
• Developed complex mappings in Informatica to load the data from various sources.
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Implemented data integration and DW solutions in an Oracle 10/11g database.
• Automated check and invoice printing utilizing Java, Informatica, PL/SQL, XML Publisher and shell scripts.
• Developed advanced PL/SQL packages, procedures, triggers, and functions to meet business requirements.
• Developed export feature of invoice data in web-based application to required format like csv, excel, and text file.
• Develop and modify Custom reports and Forms for various modules. Develop reports using complex SQL queries as per business requirement.
• Wrote UNIX shell scripts for Data Staging, Loading and cleanup process.
• Used SQL loader to load the data from the files provided by the interfacing applications.
• Develop workbooks using Discoverer to develop custom reports for business analysis.
• Document detailed application specifications, translate technical requirements into programmed application modules.
• Involved in full Software Development Life Cycle SDLC including Analysis, Design and Review of Business and Software Requirement Specifications.
• Participate in code reviews and ensure that all solutions are aligned to pre-defined architectural specifications.

Confidential

ETL and Data Warehouse Developer

• Extensively used Informatica PowerCenter to extract, transform and load data to a target database from multiple data sources.
• Developed workflows using task developer, worklet designer, and workflow designer in workflow manager and monitored the results using workflow monitor.
• Developed standard and reusable mappings and mapplets using various transformations like Expression, Source Qualifier, Aggregator, Joiner, Router, Lookup Connected and Unconnected and Filter.
• Load and transform large sets of structured, semi structured and unstructured data. Prepared various mappings to load the data into different stages like Landing, Staging and Target tables.
• Identified performance issues in existing sources, targets and mappings by analyzing the data flow, evaluating transformations and tuned accordingly for better performance.
• Modified several of the existing mappings based on the user requirements and maintained existing mappings, sessions and workflows.
• Used workflow manager for session management, database connection management and scheduling of jobs.
• Applied data cleansing/data scrubbing techniques to ensure consistency amongst data sets.
• Created PL/SQL stored procedures to perform complex data oriented business logic.
• Involved in uploading of the data from flat files into Databases and validated the data with PL/SQL procedures.
• Data Migration across various databases. Created translation and cleansing scripts using PLSQL Packages, Procedure, Functions and SQL.
• Created data flow diagrams as part of documenting the technical requirements.
• Developed various backend application programs, such as Views, Functions, Triggers, Procedures and Packages using SQL and PL/SQL for business team for decision-making.
• Involved in complete Software Development Life Cycle SDLC , and followed Agile Methodologies.
• Developed automation tools using bash shell scripts for deployment jobs and for monitoring.
• Developed simple to complex MapReduce jobs in Java for analysis of web/application server logs.
• Loading data from Linux file system to HDFS.
• Created MapReduce programs to transform logs data into structured way to analyze user location, number of website visits, etc...

Confidential

ETL PL/SQL Developer

• Analyzing the business requirements and designing the Technical Specification for architect's review.
• Developed end-to-end ETL process from various source systems to Staging area, from staging to Data Marts utilizing Informatica PowerCenter.
• Extensively worked on Informatica to extract data from Flat files, Excel files, and Oracle database to load the data into the target database.
• Implemented the Incremental loading of Dimension and Fact tables.
• Created packages, procedures, functions, views, materialized views using Oracle SQL and PL/SQL for business reports.
• Generated dynamic web-reports using Java, JSP, and JavaScript.
• Involved in Developing and handling the PL/SQL Packages, Procedures and Database Triggers.
• Create Materialized Views and partitioning tables for performance reasons.
• Worked on tuning SQL queries and database modules for optimum performance. Created and maintained Partitioned Tables and Indexes for better performance of application.
• Data validation after loading the data to staging database.
• Written Unix shell scripts for data files handling, FTP and executing the SQL Loader. Maintain Unix shell scripts used in batch scheduler.
• Bug fixes and triage issues after the code is migrated to production.
• Created various shell scripts to manipulate flat files which contain unstructured data, and to cleanse the data and extract meaningful data.
• Developing PL/SQL Packages and Procedures in accordance with business requirements and also to extract the data from different sources and load it into data warehouse.
• Developed Reports and Forms for the end users as per requirements.
• Involved in integration testing, writing test plan documents and unit testing for the application modules.