SUMMARY:

• Around 11 years of functional and technical IT experience in architecture, analysis, design, development, testing and implementation of ETL / Data Warehouse technologies and solutions.
• Experience in Dimensional Data Modelling strategies and Datawarehousing.
• Experience in Telecom, Banking, Trading and Financial Services domains.
• Experience in Architect and design BI and ETL solutions.
• Hands on experience on all phases of software development life cycle (SDLC) of Data warehousing, including requirement gathering from business users, analysis, design, creation of mapping documents, specification writing, development, testing, implementation and reviews.
• Extensive ETL experience using Informatica PowerCenter client tools (Designer, Workflow Manager, Workflow Monitor and Server Manager) and Informatica.
• Expertise in Analysis, Design, development and Implementation of Oracle Goldengate for Oracle DB and data replication across regional data centers.
• Extensively worked with Oracle PL/SQL Stored Procedures, Functions, Cursors, Indexes and Triggers and involved in Query Optimization.
• Experience in working with Greenplumn, PostgresSQL.
• Expertise in debugging and performance tuning the performance of Mappings and Sessions in Informatica and determining the performance bottlenecks.
• Experience in UNIX Shell scripts for validating and scheduling Informatica jobs.
• Understanding of working with Big Data technologies.
• Experience in different software development methodologies like Waterfall Model and Agile Software Development process.
• Sound knowledge of Entity - Relationship (ER) Data modelling.
• Experience in interaction between cross functional teams to share the common methodologies, Technical designs/discussions and Project dependencies
• Expertise in implementing complex business rules involving financial calculations.
• Expertise in working with various transformations using Aggregator, Look Up, Update Strategy, Joiner, Filter, Sequence Generator, Normalizer, Sorter, Router and reusable transformation using Informatica PowerCenter Designer.
• Demonstrated ability to work and communicate effectively with both business and technical audiences.
• Experience working as an Onsite Tech Lead coordinating with offshore teams
• Ability to quickly analyze and come-up with an efficient industry standard solution for a given problem.
• Willingness to learn and work on new technologies.

TECHNICAL SKILLS

TOOLS: ETL Informatica Power Center 8.1/8.6.1/9.1.0/9.6.1/10.1 , Talend, Syncsort.

Languages: C++, Java, Java script, SQL, PL/SQL, Unix Shell Scripting

Databases: Oracle 11g/10g, Greenplum, PostgreSQL, Teradata, SQL Server 2005/2008, DB2, MS Access 2000, Hadoop, Hive.

Tools: TOAD for Oracle, SQL Developer, SQL* Loader, Business Intelligence.

Data Modelling: Datawarehousing, Dimensional Data Modelling, Star Schema and Snowflake Schema, Erwin.

PROFESSIONAL EXPERIENCE:

Confidential, Princeton, NJ

Sr. ETL\Informatica Engineer

Responsibilites:-

• Build scalable, high throughput systems that process millions of data points a day.
• Key senior architect and developer in design, development, standardize and support technology platforms in an Enterprise environment using Industry leading BI / Reporting solutions and Informatica.
• Work on developing and supporting technology platforms using Informatica, Greenplum, the Hadoop stack and a vareity of BI tools.
• Architect and develop ETL processes to handle large volume of data.
• Involved in database design techniques using dimensional data modelling strategies, advanced SQL and PostgreSQL skills to extract, transform and load extremely large data volumes (Petabytes) in Greenplum.
• Used the industry standard Data Infrastructure (e.g. Warehouse, BI, Analytics and Big-Data) tools for providing Enterprise solutions, Desktop API (DAPI), Bloomberg Industries (BIND) and Connectivity & Integration Solutions (CIS) end users with analytics Confidential the speed of thought.
• Interact directly with Bloomberg product owners to architect and design BI and ETL solutions.
• Coordinate performance of high and low-level design, provision of pseudo codes, implementation of the prototype and conducting of design reviews.
• Design and develop Bloomberg product usage metrics to help business in analyzing the market trends and customer patterns.
• Perform root-cause analysis of identified issues that arise post-implementation and work on solutions related to issue.
• Involved with programming in a Linux/Unix environment including shell scripting.

Environnent:- Informatica Power Center 9.6.1/10.1, ETL Architecture, Datawarehousing, Oracle, Greenplum, PostgresSQL, Unix Scripting, SQL, PL/SQL, Tidal, Hive, Qliksense, Rsync, Hadoop.

Confidential, Jersey City, NJ

Sr. Informatica Lead/Developer

Responsibilites:-

• Involved in the full SDLC of the project including Analysis, Design, Development, Testing, Implementation and Support.
• Understanding Business requirements and preparing HLD and detailed design documnent.
• Extensively worked on deriving and validating the target general ledger code block mappings.
• Develop re-usable Transformations, Sessions, Mapplets, Worklets, Workflow as per the proposed solutions.
• Root cause analysis of the failed jobs.
• Design and implementation of Oracle Goldengate Replication between Oracle Databases
• Liaise with Confidential business team to gather requirements.
• Implementing performance tuning methods to optimize developed mappings
• Designed/Developed a Informatica Auto Deployment Utility for Confidential . This utility helps to auto deploy the informatica objects from DEV to QA to PROD informatica repositories and viceversa.
• Participate in creating application architecture review sessions and documents.
• Perform high and low-level design, provide pseudo codes, implementation and reviews .
• Developed shell scripts to fine tune the ETL flow of the Informatica Power Center workflows
• Performance tuning for proposed solutions. Optimized/tuned mappings for better performance and efficiency.
• Involved in coding of the Business Rules through PL/SQL using the Functions, Triggers, Cursors and Stored Procedures.
• Developing and designing new & modifying existing informatica and Unix components.
• Analyze project requirements and estimate size and effort.
• Provide technical solutions to the business and regulatory requirements.
• Deliver high quality code and unit test application enhancements.
• Support system integration and user acceptance testing.
• Provide deployment and post-deployment support.
• Perform root cause analysis of any issues and work on solutions related to issue fixing.
• On call production support during onsite business hours and weekends.
• Onsite-Offshore coordination.

Environnent:- Informatica Power Center 9.6.1/10.1, Oracle 11g, Oracle Goldengate 10, 11.1, Unix Scripting, SQL, PL/SQL, Autosys

Confidential St. Louis, MO

ETL Designer and Developer

Responsibilites:-

• Understanding Business requirements and preparing HLD and detailed design documnent business requirement.
• Develop Mappings, Sessions, Workflow and scheduled the Workflow to run Confidential a specified frequency.
• Impact analysis of functional changes required in existing systems.
• Performance tuning for proposed solutions.
• Developing and designing new & modifying existing INFA and Unix components.
• Developed Unix shell scripts for file validation, SQL programming and to automate the validation and execution of Informatica jobs.
• Develop database scripts such as SQL queries, PL/SQL Packages, Stored Procedures, Triggers, Functions, Cursors and Indexes.
• Monitoring, Enhancement & Quality addition to Production processes.
• QC deployment and testing.
• Develop troubleshooting guides for operation support team and provide training to operation support team.
• Developed Initial data load scripts to load data across Databases.
• Coordinate with Infrastructure team, system administrator to deploy application in production environment .
• Root cause analysis of the failed jobs.
• Develop golgen gate pocesses to facilitate near realtime data replication.
• Design and implementation of Oracle GoldenGate active-active, Bi-Directional Replication between Oracle Databases
• Preparation of Unit Test Plan and Unit Test cases for the business scenarios
• Performing unit testing and Integration testing scenarios.
• Performing code reviews according to standards.
• Tracking the defects and fixing them.
• Deployment support handle using check list in different environment.
• Release coordination & Implementation activities.
• Provided on call production support on rotation basis within the team .
• Handling client calls and discussing the daily issues and concerns.

Environment: - Informatica Power Center 9.5.1/9.6.1 , Oracle 11g, Oracle Goldengate 10/11.1, Unix, SQL, PL/SQL

Confidential St. Louis, MO

ETL Developer.

Responsibilities:

• Developed Informatica mappings, sessions and workflows to load the data from the source to staging levels and from staging tables to the respective Dimensions and Fact tables.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, and SQL, Lookup (File and Database) to develop robust mappings in the Informatica Designer.
• Involved in Performance tuning Confidential source, target, mappings, sessions, and system levels.
• Created shell scripts to fine tune the ETL flow of the Informatica workflows.
• Migration of Informatica code to QA and Production Environments.
• Scheduling the jobs in production.
• Monitor the production jobs through IPC Workflow Monitor, Tivoli, Oracle and UNIX.
• Fixing the load failures and restart the load to meet SLA (Service Level Agreement).
• In case of Job Failure Fix the Problem and make the job run successfully.
• Capture failures and process messages.
• Document all the failures and leverage on them when the similar situation occurs
• Validate the production run after successful job execution.
• Root cause analysis of the failed jobs.
• Co-ordinate with all the application groups on any issues.
• Update the run book as and when required.
• Escalating data issues to clients encountered during the load

Environment: - Informatica PowerCenter 8.6.1, Oracle 11g, SQL, Unix, PL/SQL

Confidential

Executive Professional Services/Developer

Responsibilities:-

• Develop Server Side scripts to handle transactions within Netsuite system
• Develop user event scripts to execute when certain event is fired.
• Involved in writing Procedures, functions & packages
• Responsible for reconciliation of the sales through Pensio and Collector Payment Gateways for credit card payments.
• Carrying out builds/deployment on test and production servers.
• Active participation in developing and deciding an approach for implementing a new requirement.

Environment: - PLSQL, SQL, JavaScript, xml, Netsuite API, Payment Gateways API

Confidential

Developer and Support Executive

Responsibilities:

• Developed Informatica workflows to load the data from the source to staging levels and from staging tables to the respective Dimensions and Fact tables.
• Scheduling the jobs in production.
• Monitor the production jobs through IPC Workflow Monitor, Tivoli, Oracle and UNIX.
• Fixing the load failures and restart the load to meet SLA (Service Level Agreement).
• In case of Job Failure Fix the Problem and make the job run successfully.
• Capture failures and process messages.
• Document all the failures and leverage on them when the similar situation occurs
• Validate the production run after successful job execution.
• Root cause analysis of the failed jobs.
• Co-ordinate with all the application groups on any issues.
• Update the run book as and when required.
• Escalating data issues to clients encountered during the load

Environment: - Informatica 8.1, Oracle 11g, SQL, Unix .