SUMMARY:

• Oracle and Informatica certified professional with over 10 years of experience in the complete System Development Life Cycle with specialization in Business Intelligence
• Extensive experience in various technical areas like data analysis, implementation of ETL/ELT processes, enterprise reporting including dashboard development and database performance tuning
• Expertise in analyzing data and creating Application Implementation Methodology (AIM) documents for development of the project
• Experience configuring Informatica PWX CDC to achieve near real time data
• Working experience in Informatica IDQ
• Expertise in Data Analysis: SQL, Excel (Pivot tables, macros, VLOOKUP, hlookup, statistical functions)
• Prioritized requirements and created conceptual prototypes and mock - ups
• Proficient in Oracle Data Integrator 11g and 12c, OBIEE 12c
• Experience using Various ODI Knowledge modules and Journals for ELT data processing
• Provided on-call support to business and end-users to resolve any data related issues
• Strong experience in coding UNIX shell scripts. Extensively coded shell scripts for automating ETL processes and batch processing disparate applications
• Expertise in multiple Relational Database Management Systems (RDBMS) like DB2, Oracle, Netezza, Teradata
• Experience tuning Oracle SQL queries for better performance
• Experience integrating OLTP source data and OLAP architecture
• Working knowledge in change data capture technologies
• Strong experience coding SQL queries to obtain maximum performance and tuning database parameters like indexes to improve performance
• Experienced agile team player: implemented project using agile methodologies
• Working experience with Big Data and Hadoop File System (HDFS)
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema modeling, Snowflakes modeling, fact and dimension tables

SKILL:

ETL Tools: Informatica 9, 10, Power Exchange (PWX), PowerCenter, IDQ, ODI 11g, 12c

Reporting Tools: OBIEE 11g, 12c

Methodologies: Data Modeling, Star Schema, Snowflake Schema

RDBMS: Oracle, Netezza, MS SQL Server 2005, SQL TOAD 7.6, Teradata 13.0

Programming: SQL, XML.

Scheduling Tools: Control m, Autosys, DAC, WLM

Big Data: Ecosystems Hadoop, HDFS, Hive

Operating Systems: SOLARIS, Win XP, 7, 10, MSDOS

Packages: MS Office (Word, Excel, Access, PowerPoint)

EXPERIENCE:

Sr. Informatica Developer

Confidential, Dallas, TX

Responsibilities:

• Developed Informatica mappings, sessions and workflows as per the business rules and loaded requirements using mapping parameters and variable
• Involved in business analysis and technical design sessions with business and technical staff to develop data models, requirements document, and ETL specifications
• Generated the ‘|’ delimiter Flat files by using the SFTP to transfer the files from Informatica Server to GreenPlum (Target) Landing Zone
• Coded as per the mapping documents
• Unit tested the mappings.
• Based on the requirements, used various transformations like Source Qualifier, Normalizer, Expression, Filter, Router, Update strategy, Sorter, Lookup, Aggregator, Web-Service Consumer, Joiner, Stored procedure transformations in the mapping
• Responsible for requirement gathering analysis and end user meetings
• Converted functional requirements into technical specifications
• Worked with joiner functions like normal join, full outer join, master outer join, and detail outer join in the joiner transformation
• Used PMCMD command to start, stop and ping server from UNIX and created UNIX Shell Perl scripts to automate the process
• Implemented Persistent cache to reduce session processing time
• Deployed Informatica jobs into testing, validation and production environments
• Prepared deployment documents, user guides, coding standards, and other technical documents
• Prepared ETL mapping documents for every mapping and data migration document for smooth transfer of project from development to testing environment and then to production environment
• Developed mapplets and worklets for reusability

Environment: Informatica 9.5.1, Informatica 10.2, Informatica Power Exchange, Data Quality, PL/SQL, Oracle 10g, SQL Server 2008 R2, Flat Files, UNIX Shell Scripting, CA Autosys 11.3

Senior Informatica Developer

Confidential, Herndon, VA

Responsibilities:

• Led design/development/implementation/testing of Oracle DWH/Data Marts
• Processed XML files using Informatica B2B
• Used the Data Processor transformation to process XML data and create hierarchical output
• Validated XML hierarchy and file using Altova XML viewer
• Developed mapping to process data including sourcing, extracting, transforming and loading as per data integration load rules
• Created profile and load rules in IDQ
• Implemented SCD Type1, Type2 mappings to capture data changes into target table
• Prepared business requirement document and technical design document
• Configured PWX CDC on the source tables and load near real time data
• Migrated power exchange and verify PWX CDC migration
• Performed testing and document test scripts for validation
• Created shell scripts to validate, process and archive source files
• Facilitated meeting to explain business requirement for code handover to SIT, UAT team for testing
• Created Autosys job and automate to execute ETL jobs at scheduled time
• Created business system testing test scripts for unit, system and integration testing for developed code
• Migrated code to higher environments SIT, UAT using Jenkins for business testing purpose
• Documented all changes for code hand over to business
• Coordinated with business, system analyst, product owner to facilitate business requirements meetings and influence decisions

Environment: Informatica 10.1.0, PWX, IDQ, Oracle, Toad, UNIX, Autosys, Jenkins, SVN

Senior Informatica Developer

Confidential, Richmond, VA

Responsibilities:

• Led design/development/implementation/testing of Teradata DWH/data marts
• Led the Data Warehouse implementation, operational and strategic planning projects, organizing and allocation of resources
• Used Power Exchange to source copybook definition and VSAM files
• Created custom mappings for loading organization data to populate end-point reports
• Developed extracted, transformed and loaded data
• Extracted data from multiple Source Systems (Eg. CS90, ACES, FACETS, WMS etc.) and loaded data into EDW
• Created UNIX shell scripts to pre-process source files for file validation, create list files for indirect data load and execute work flows from Control-M
• Worked with business team to gather business requirements
• Created Application Implementation Methodology document and provided to onsite and off-shore team
• Performed testing and documented test scripts for validation
• Developed Business User Acceptance test cases and data sets
• Facilitated business requirements meetings and influenced decisions
• Documented all changes during the process of implementing and migrating code and made code ready for production deployment
• Identified bottleneck with existing Data Quality Review Process, negotiated and resolve the conflicts in the process

Environment: Informatica 10.1.0, PWX, Informatica DVO 10.0.0, Hadoop, Teradata, AIX UNIX, Control-M, WLM, Clear Case