SUMMARY:

• 12 years of Extensive experience in implementation of Business applications for Financial, Retail and Manufacturing verticals using Data Warehousing, Business Intelligence, Data architecture and ETL development technologies.
• Proficient in Data Warehousing ETL tool - Informatica (12 yrs) and close to 8 years of experience in Banking & Financial Services industry Domain. Also having good basic knowledge of the Reporting/BI tools.
• Cognitive about designing, deploying and operating highly available, scalable and fault tolerant systems using Amazon Web Services. 2.3 years of work experience working on AWS platform.
• Used various AWS services like EC2,S3,Red-shift,Lambda,Aurora,Cloud formation,IAM and dynamo DB.
• Worked extensively on Oracle Database and various other Relational Databases(Teradata,SQl Server)& designed processes using PL/SQL programs.
• Rich experience involving designing,develop,testing and support of applications using Perl/UNIX scripting.
• Successfully implemented DataWarehouse/BI projects from end-to-end through SDLC life cycle(Methodologies-Agile/Waterfall,Iterative)

PROFESSIONAL EXPERIENCE:

Confidential, Holmdel-NJ

ETL Lead

Responsibilities:

• Developed ETL programs using Informatica to implement the business requirements.
• Communicated with business customers to discuss the issues and requirements.
• Created shell scripts to fine tune the ETL flow of the Informatica workflows.
• Analyzed the existing Perl scripts whose functionality was to be phased out to ETL programs.
• Used Informatica file watch events to pole the FTP sites for the external mainframe files.
• Production Support has been done to resolve the ongoing issues and troubleshoot the problems
• Performance tuning was done at the functional level and mapping level. Used relational SQL wherever possible to minimize the data transfer over the network.
• Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.
• Involved in enhancements and maintenance activities of the data warehouse including tuning, modifying of stored procedures for code enhancements.

Technologies: Informatica PowerCenter9.5, Oracle 10g/11g, PL/SQL, Business Objects 6.5 Linux, Putty, Autosys, Unix/Perl scripting

Confidential, Parsipanny-NJ

ETL Lead/AWS Developer

Responsibilities:

• Built cloud-first solutions and migrated existing on-premise application to AWS environment.
• Used various AWS services like EC2, S3, Red-shift, Lambda, Aurora, Cloud-formation, IAM and dynamo DB.
• Configured S3 buckets with various life cycle policies to archive the infrequently accessed data to storage classes based on requirement.
• Created cloud formation templates in JSON format for provisioning resources.
• Experienced with event-drivenand scheduledAWSLambda functions to trigger variousAWS resources.
• Experienced with AWSCLI and control variousAWSservices through SHELL scripting.
• Built enterprise data mart in Redshift, integrated data from staging layer to Redshift. Migrated historical data from DB2 to Redshift using Copy Command and ETL technology.
• Implemented data warehousing projects, built staging, data marts by integrating data from various sources (DB2, Postgres, Teradata, Oracle, Flat Files, xmls) by creating ETL’s, SQL, Unix Scripts.
• Designed and integrated customer data from various source systems to MDM Cust 360. Applied Informatica data quality address standardization, address doctor and cleansing rules.
• Created PL/SQLstored procedures, functions and packagesfor moving the data from staging area to data mart.
• Created scripts to createnew tables, views, queriesfor new enhancement in the application using TOAD
• Implemented Continuous Integration using Jenkins and GIT Hub.

Technologies: Informatica PowerCenter10.0, Informatica on Cloud, AWS - AWS S3, EC2, Redshift, Dynamo DB, Aurora DB, Lambda, Cloud Formation, Cloud Watch,, Putty, Autosys, Unix/Perl scripting, Oracle 11g, SQL * Plus, TOAD, SQL*Loader

Confidential, Mt Laurel-NJ

ETL Lead

Responsibilities:

• Performed multiple roles as a team lead including providing data services solutions to business requirements. Involved in multiple projects, enhancements to existing production jobs & administering Informatica repository.
• Worked as technical lead to understand requirements and create Design documents.
• Coordinate requirements with Team and guide the team during Development and testing Phases.
• Responsible for projects estimates, design documents, resource utilization and allocations.
• Managing Security by Creating folders, user groups and users within them and assigning selective privileges.
• Set up ODBC, Relational, Native and FTP connections for Oracle, DB2, and UDB, SQL server, VSAM and flat file.
• Extensively written generic UNIX shell script in order to automate the day to day batch load process and maintenance activity.
• Involved in Performance Tuning of the workflows and mappings. Partitioning mapping for optimal performance.
• Scheduling of daily, weekly and monthly jobs in Maestro.
• Extensively used parameter file for standardizing the ETL and making it generic. Merged workflow level parameter file with session level.
• Extensive use of Lookup Shared Cache, Persistent cache, Static cache, Connected, Unconnected lookups, Update override.
• Developed AdvancePL/SQLpackages, procedures, triggers, functions, IndexesandCollectionsto implement business logic usingSQLNavigator. Generated server sidePL/SQLscriptsfordata manipulationand validation and materialized views for remote instances.
• Led an onsite / offshore model team of up to 3 onsite and 10 offshore resources usersInteracted with Business users for gathering the Reporting requirements.

Technologies: Informatica PowerCenter9.5, Oracle 10g/11g, PL/SQL, Business Objects 6.5 Linux, Putty, Autosys, Unix/Perl scripting

Confidential, NY

ETL Informatica Consultant

Responsibilities:

• Developed ETL programs using Informatica to implement the business requirements.
• Communicated with business customers to discuss the issues and requirements.
• Created shell scripts to fine tune the ETL flow of the Informatica workflows.
• Developed the batch jobs for loading the FALCON side trades into Workbench using the Perl scripts
• Analyzed the existing Perl scripts whose functionality was to be phased out to ETL programs.
• Used Informatica file watch events to pole the FTP sites for the external mainframe files.
• Production Support has been done to resolve the ongoing issues and troubleshoot the problems
• Performance tuning was done at the functional level and mapping level. Used relational SQL wherever possible to minimize the data transfer over the network.
• Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.
• Involved in enhancements and maintenance activities of the data warehouse including tuning, modifying of stored procedures for code enhancements.

Technologies: Informatica PowerCenter9.5, Sybase, SQL Server, Linux, Autosys, Unix/Perl scripting

Confidential

ETL Designer/Data Stage Developer

Responsibilities:

• Interacted with End user community to understand the business requirements and in identifying data sources
• Analyzed the existing informational sources and methods to identify problem areas and make recommendations for improvement. This required a detailed understanding of the data sources and researching possible solutions.
• Helped in preparing the mapping document for source to target.
• Worked with Data stage Manager for importing metadata from repository, new job Categories and creating new data elements.
• Designed and developed ETL processes using Data Stage designer to load data from Oracle, MS SQL, Flat Files (Fixed Width) and XML files to staging database and from staging to the target Data Warehouse database.

Technologies: IBMData Stage 8.0 (Designer, Director, Manager, Parallel Extender), Oracle 11g, WinSQL, Putty, OBIEE reports, Autosys

Confidential, New York

ETL Informatica Consultant

Responsibilities:

• Act as an interface between the client and the Company team for all new deployments
• Coordinate with Infrastructure administrators for Production downtime, Disaster Recovery Tests, and critical Production issues.
• Ensure quick escalation and delay notifications for critical issues needing immediate attention.
• Ensure compliance to Service level (SLA’s).
• Ensure batch/system issues and user queries are resolved in a timely fashion.
• Coordinate Production turn-over with Developers and Infrastructure Administrator’s.
• Provide feedbacks/suggestions to the Development team for enhancements/bug-fixes.
• Conducted and designed project induction for the new hires.

Technologies: Informatica-8.0, Oracle (Exadata), TIDAL (Scheduling tool), UNIX shell scripts

Confidential

SrInformatica Developer

Responsibilities:

• Understand the client’s requirements in terms of the legacy system's functionality and map the same to SAP using Informatica.
• Create technical documents for DM/BI/FS objects used in build stage containing the transformation logic.
• Analyze and address any transformed issues that arise within the DM/BI/FS Data Conversion area based on technical design documents.
• Make ETL mappings for DM/BI/FS Objects and ensure that mapping were accurate in terms of field -to-field mapping from legacy to target tables and further to the upload file.
• Actively involved in the performance tuning of the mappings.

Technologies: Informatica PC 8.0, Windows Based Informatica Server, MS SQL Server 2005

Confidential

Informatica Developer

Responsibilities:

• Develop UNIX Shell Scripts and use the Teradata environment for building mappings and BTEQ components (Bteq and mlaod etc.).
• Prepare ETL specification, creating mappings, Teradata scripts for extraction, transformation and loading of data to data warehouse.
• Adhere to quality, coding standards and project time line and subsequently prepare the test results.
• Participate in teleconference calls with the BA/DA at onshore and be involved in the technical design of this release.
• Responsible for client interaction and query handling.
• Automation of ETL jobs using Informatica batches and Pre-Session and Post-Session UNIX shell scripts.

Technologies: Teradata, Informatica, UNIX, TD Staging Environment, Oracle

Confidential

Junior Developer

Responsibilities:

• Understand business and functional requirements for project discussed in analyze calls with onshore business analyst.
• Resolve design issues with ETL architects and discuss the data mapping document which formed the basis for the Informatica mappings.
• Building the code for Informatica mappings.

Technologies: Informatica, UNIX, IBM DB2, MS SQL Server