SUMMARY:

• Total 9 years of software development experience which includes Requirement Analysis, Design, and Development, Testing, Infrastructure migration and Release Coordination for Data warehousing applications.
• Hands on experience in all aspects of Software Development Life Cycle (SDLC).
• Strong experience in Extraction, Transformation, loading data from various sources into Data Warehouses using Informatica, UNIX and Oracle along with OLTP and OLAP concepts.
• Experience in Oracle 10g, 11g, SQL/PLSQL, Informatica, Unix Shell scripting and PERL scripting.
• Experience with TERADATA database with following utilities Fast Load, Multi Load, Fast Export, TPUMP and BTEQ.
• Experience with creating Tables, Indexes and Macros in TERADATA
• Extensive experience in developing Stored Procedures, Functions, Views and Triggers, SQL queries and Oracle PL/SQL.
• Experience in Dimensional Data modeling, Star Schema, Snow - Flake Schema, FACT & Dimensions tables, Physical & logical data modeling and De-normalization.
• Experience in data conversion of various data sources like SQL Server, Oracle, Fixed Width and Delimited Flat Files.
• Hands on experience with mappings from varied transformations such as Lookups (connected and unconnected), Router, Aggregator, Sorter, Filter, Update Strategy, Normalizer, Sequence Generator, Joiner.
• Integration with SAP ECC and APO modules using SAP Transports and power exchanges.
• Expertise in design and implementation of Mapplets and slowly changing dimensions - (SCDs Type I & II).
• Experience in working with mapping variable/parameters and created parameter files for imparting flexible runs of workflows based on changing variable values.
• Experience in Unix Shell Scripting and PERL scripting, SVN and scheduling jobs through AutoSys.
• Experience in installing, upgrading and configuring Informatica Power Center on multiple environments. Upgraded Informatica Power Center Repository from 8.x to 9.0.1, Autosys and Oracle 11g
• Expertise in implementation of SCP, SFTP, FTP services to retrieve Flat Files from the external sources
• Involved in designing mappings with multiple files, using indirect file loading process.
• Managing offshore team on daily basis about the development activities and overview the delivery.
• Developed effective working relationships with client team to understand support requirements, develop tactical and strategic plans to implement technology solutions, and effectively manage client expectations.
• Assist with the development and execution of detailed system and user acceptance test plans, test cases and test scripts for manual and automated testing.
• Creating SDLC documents like, Requirement Specification, Design Specification, Configuration Specification, Integrated Design Document and Standard Operating Procedure for Support Team

TECHNICAL SKILLS:

Language:: C, PERL, SQL, PL/SQL

Operating System:: RHEL, AIX, Solaris

Scripting:: UNIX Shell scripting

DBMS/RDBMS:: Oracle 12c, MS SQL Server

Tools: Informatica Powercentre 9.6 and 10.1, Toad, SQL Developer, Autosys, Putty, HP ALM, Remedy

PROFESSIONAL EXPERIENCE:

Confidential, NEW JERSEY,

SR. ETL/DATABASE DEVELOPER

Environment: s: ETL, Informatica Power Center 8.x 9.x, Oracle 11g, PL/SQL, TERADATA, UNIX shell scripting PERL, Autosys and HP-ALM

Responsibilities:

• Involved in requirements gathering, analysis, design, implements and deploy applications using Informatica-power center, Oracle, Microsoft SQL server (Azure), Teradata and UNIX Shell Scripting.
• Prepared Estimation based on the complexity and object details and Schedule, Plan Resources and Task Tracking using the utilization tracker.
• Integration with SAP ECC and APO modules using SAP Transports and power exchanges
• Responsible for developing, support and maintenance for the ETL processes using Informatica PowerCenter 9.x, Informatica Client tools - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Informatica Repository Manager and Informatica Workflow Manager.
• Experience with TERADATA utilities like Fast Load, Multi Load, Fast Export, TPUMP and BTEQ
• Experience in integration of heterogeneous data sources like Oracle, SQL Server and Flat Files (Fixed & delimited) into Staging Area using Informatica mappings, workflows and session objects.
• Extensively worked on different types of transformations like expression, filter, aggregator, lookup, stored procedure, sequence generator, and joiner etc.
• Extensively worked on performance tuning at all levels of the Data warehouse. Implemented performance tuning by using lookup caches, gathering stats, dropped indexes and re-created them after loading data to targets and increased the commit interval.
• Integration with SAP ECC and APO modules using SAP Transports.
• Extracting data from various sources involving flat files and relational tables.
• Involved in support and maintenance of Oracle Import, Export and SQL*Loader jobs.
• Responsible for development of new Adhoc change requests and execution of Data Change Requests.
• Helped in creating of data-mapping best practices document including visual processes and trained team members on data mapping process and tools
• Performed Data Analysis and Data validation by writing basic queries against the database.
• Created test cases and involved in Unit testing, System Testing, User Acceptance Testing to verify accuracy followed by regression testing and completeness of ETL process.
• Involved in monitoring the workflows and optimizing the load times using session partition
• Created SOPs and Run books for support team and schedule meeting to explain the approach and troubleshooting techniques.
• Worked on other tools like WinSCP for transferring the files from Windows to UNIX and vice-versa, Putty for connecting to UNIX and run the scripts.

Confidential, NEW JERSEY, USA

SR. ETL/DATABASE DEVELOPER

Environment: s: ETL, Informatica Power Center 9.x, Oracle 11g, PL/SQL, UNIX shell scripting PERL, Autosys

Responsibilities:

• Perform Requirements gathering, analysis, design, implement, test and deploy applications using Informatica-power center, Oracle and UNIX Shell Scripting.
• Responsible for developing, support and maintenance for the ETL processes using Informatica
• Created database objects like Tables, Views, Procedures, Triggers and Packages for implementing functionalities.
• Worked on SQL*Loader to load data from flat files obtained from various facilities every day.
• Created new mappings and modify the existing mappings in Informatica based on the requirement.
• Worked on production deployment and change plan documents
• Worked on different types of transformations like source qualifier, expression, filter, aggregator, rank, update strategy, lookup, stored procedure, sequence generator and joiner.
• Created and modified several UNIX shell scripts based on the needs of the project and client requirements
• Created a customized script to monitors a file from upstream application and process
• Experience in crontab schedule, awk scripts and getopts command
• Experience in Autosys tool on Scheduling and monitoring
• Collaborated with the QA team to ensure adequate testing of software both before and after completion, maintained quality procedures, and ensured appropriate documentation is in place.

Confidential

ETL/DATABASE DEVELOPER

Environment: s: ETL, Informatica Power Center 8.x, Oracle 11g, PL/SQL, UNIX shell scripting PERL, Autosys

Responsibilities:

• Extensively used Informatica power center for extraction, transformation and loading process.
• Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.
• Used various transformations like Lookup, Filter, Expression, Sequence Generator and Router to develop robust mappings in the Informatica Designer.
• Created database objects like Tables, Views, Procedures, Triggers and Packages for implementing functionalities.
• Monitoring Autosys and cron batch jobs, Application support and Maintenance
• Worked on optimization of batch cycle job duration.
• Extracted the data from Oracle, CSV and Flat files
• Created a PERL scripting to generates Phase 1 Management data (Clinical data)
• Preparing customized utility for applications using UNIX Shell scripting and PERL script
• Constantly interacted with on-site team and designers to discuss the requirements.
• Worked on Unit testing and System Integration Testing
• Set up definitions and processes for test phases including Product test, Integration test, System test and User Acceptance Test (UAT)