SUMMARY:

• Experience in all phases of a Project, starting from requirements gathering, analysis, design, development, testing, implementation, post - implementation and support of Data Warehousing Applications using tools like Informatica Power Center, Talend Open Studio, Vertica, Oracle, SQL Server.
• Proficient in analyzing business processes requirements and translating them into technical requirements.
• Efficient in Interacting with Business Users, know their views in developing, modifying and Preparing ETL Strategies
• Highly proficient in Extract, Transform and Load the data into target systems using Informatica power center - (Repository Manager, Designer, Workflow Manager and Workflow Monitor) & Talend for Big Data - (Data Integration).
• Extensive experience in loading data, troubleshooting, Debugging mappings, performance tuning of Informatica (Sources, Targets, Mappings and Sessions) and fine-tuned transformations to make them more efficient in terms of session performance.
• Experience in writing complex SQL queries and PL/SQL, including the use of stored procedures, functions and triggers to implement business rules and validations.
• Good knowledge on Data warehousing concepts, data model schemas star/snow-flake schema.
• Expertise in writing UNIX shell scripts and schedule them using CRON to run on recurring basis.
• Involved in designing logical and physical data model using Erwin and Visio.
• Worked with heterogeneous data sources like Oracle, SQL Server, Salesforce, Flat Files and XML.
• Experience in setting up definitions and process for test phases including unit test, system test, integration test, user acceptance test and product test and upload them into HP ALM
• Involved in Development, migration, enhancement, maintenance of project.
• Proven ability to learn quickly, apply new technologies, hardworking ability to work in a paced environment.
• High end working experience in Agile/Scrum methodologies.
• Effective working relationships with client team to understand support requirements, and effectively manage client expectations.
• Excellent communication, presentation, project management skills, a very good team player and self-starter with ability to work independently and as part of a team.

TECHNICAL SKILLS:

ETL Tools: Informatica PowerCenter 9.x/8.x/7.x, Talend Open Studio 5.5.1

Databases: Oracle 11g/10g, SQL Server, Teradata,DB2

DB Tools: SQL Developer, TOAD, SQL, PL/SQL Developer

Scripting Unix Shell Script, Visual Basic, HTML, XML, Java Script

Job Scheduler: Tidal, Informatica scheduler, CRON

Operating System: Unix/Linux, HPUX, Windows

Office Tools: Visio, Access, Excel, Word, Power Point, OneNote

PROFESSIONAL EXPERIENCE:

Senior Informatica Developer

Confidential, Houston, TX

Responsibilities:

• Solely responsible for development and implementation of vSQL scripts which include copy, projections, segmentation, encoding, partitions, merge and functions
• Involved in optimizing performance of vSQL scripts using swap-partition, by analyzing query plans using EXPLAIN, PROFILE, by performing segmentation, DIRECT hints etc.,
• Developed complex shell scripts to handle the data load and extraction process in vertica system.
• Responsible for maintaining Linux environment for granting the privileges to users.
• Assisted and resolved issues in User Acceptance testing.
• Documented and presented the production/support documents for the components developed, when handing-over the application to the production support team.
• Provide developer support for Production Jobs, involving monitoring of CRON Jobs, communicate with external teams and make necessary decision for smooth ingestion of production process.

Environment: Linux, SAS (Statistical Analysis System), Vertica, Squirrel, apache SVN, HP ALM, CRON

Senior Informatica Developer

Confidential

Responsibilities:

• Re- Designed, Developed and implemented CLKP interfaces to support migration to SVG.
• Design and develop new processes and enhancements to existing processes.
• Responsible for day-to-day systems maintenance, such as installing patches and fixes, space monitoring, performance monitoring, and tuning.
• Build SQL queries and PL/SQL, including the use of stored procedures, functions for validations.
• Use database tool such as SQL Developer, TOAD for Oracle, to create Views, Indexes, Joins, and Sub-Queries as per the requirement.
• Build SQL queries for validating production data.
• Scheduled Jobs based on business rules.
• Monitor automatic restart and recovery in event of failures, Alert and send notification to operations personnel.
• Generation of incident reports to support in case of unpredictable events.
• Coordinate with different teams SAP/BW/HPSB to implement/validate new functionality to support business needs.
• Develop database triggers, packages, functions, and stored procedures using PL/SQL and maintain the scripts for various data feeds.
• Monitor data in databases to ensure data quality
• Monitor Jobs scheduled, running, completed or failed
• Support the MTP’s from Development to production environments
• Worked on Documentation to Interface development, logic, coding, testing, changes and corrections
• Provide technical support and respond to error reports, problems or questions.

Environment: Informatica Power Center 9.5.1/8.6, UNIX, TIDAL, Oracle 11g, SQL Server, SQL/PLSQL.

Senior Informatica Developer

Confidential, King of Prussia, PA

Responsibilities:

• Developed and implemented Small Projects (SMP’s) to support different partners.
• Worked with the project teams to implement new functionality to support business needs.
• Implemented technical data requirements for integrating partner data to be used for production support teams.
• Developed, maintained and supported the data exchange process between Development and production support team to ensure data quality and integrity.
• Created and Documented ETL Test Plans, Test Cases, Test Scripts, Expected Results, Assumptions and Validations.
• Importing client data files into Oracle (10g) databases.
• Developed database triggers, packages, functions, and stored procedures using PL/SQL and maintained the scripts for various data feeds.
• Created Workflows with worklets, event wait, email and command tasks using Workflow Manager and monitored them in Workflow Monitor.
• Performing quality assurance checks.
• Updating databases to ensure data integrity.
• Monitored sessions that were scheduled, running, completed or failed
• Worked on Documentation to describe program development, logic, coding, testing, changes and corrections
• Provide technical support and respond to error reports, problems or questions.
• Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation

Environment: Informatica Power Center 8.6, Oracle 10g, Windows XP, SQL/PLSQL, UNIX, XML.

Senior Informatica Developer

Confidential, Columbus, OH

Responsibilities:

• Analyzed the source systems which include order processing system, quote system etc.
• Consolidated, Cleansed, Integrated, ETL, and customized the data.
• Responsible for Data Modeling and populating the business rules using mappings into the Repository for Meta Data management.
• Extensively involved in the Analysis, Design and Modeling.
• Design the ETL architecture and Source to Target mapping to load data into Data warehouse.
• Created and Documented ETL Test Plans, Test Cases, Test Scripts, Expected Results, Assumptions and Validations.
• Implemented various loads like Daily Loads, Weekly Loads, and Quarterly Loads using Incremental Loading Strategy
• Created Workflows with worklets, event wait, email and command tasks using Workflow Manager and monitored them in Workflow Monitor.
• Extensively worked on the performance tuning of the Informatica PowerCenter Mappings as well as the tuning of the sessions.
• Monitored sessions that were scheduled, running, completed or failed
• Worked on Documentation to describe program development, logic, coding, testing, changes and corrections
• Involved in design and development of complex ETL mappings and stored procedures in an optimized manner. Used Power exchange for mainframe sources.
• Developed database triggers, packages, functions, and stored procedures using PL/SQL and maintained the scripts for various data feeds.
• Optimized Query Performance, Session Performance and Reliability.
• Developed test plans for unit testing and integration testing.
• Developed data conversion, integration, loading and verification specifications.
• Created various UNIX Shell Scripts for scheduling various data cleansing scripts and loading process. Maintained the batch processes using Unix Shell Scripts.

Environment: Informatica Power Center 8.6, Teradata 13, Windows XP, UNIX, XML.

Informatica Developer

Confidential, Abbott Park, IL

Responsibilities:

• Gathered user Requirements and designed Source to Target data load specifications based on Business rules.
• Analyzed the functional specs provided by the data architect and created technical specs documents for all the mappings.
• Developed slowly changing dimension Type 2 mappings to maintain the history of the data.
• Developed several mappings in Informatica, a variety of PowerCenter transformations, Mapping Parameters, Mapping Variables and Parameter files in Mapping Designer.
• Created reusable transformations and applets and used them in mappings.
• Used Informatica debugging techniques to debug the mappings and used session log files and bad files to trace errors that occur while loading.
• Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.
• Implemented performance tuning logic on Sources, Targets, mappings, and sessions to provide maximum efficiency.
• Used Informatica Version Control for checking in all versions of the objects used in creating the mappings and workflows and to keep track of the changes in the development, testing and production environments.
• Created and Documented ETL Test Plans, Test Cases, Test Scripts, Expected Results, Assumptions and Validations.
• Implemented various loads like Daily Loads, Weekly Loads, and Quarterly Loads using Incremental Loading Strategy
• Created Workflows with worklets, event wait, email and command tasks using Workflow Manager and monitored them in Workflow Monitor.
• Developed database triggers, packages, functions, and stored procedures using PL/SQL and maintained the scripts for various data feeds.
• Created Pre/Post Session/SQL commands in sessions and mappings on the target instance.
• Created various UNIX Shell Scripts for scheduling various data cleansing scripts and loading process. Maintained the batch processes using Unix Shell Scripts.

Environment: Informatica PowerCenter 8.6.1, Oracle 10g/11g, Teradata 13, SQL, PL/SQL, UNIX, Flat files, XML, MS Access, Web services, DB2, SQL Server 2008, Business Objects.

ETL Analyst

Confidential, Detroit, MI

Responsibilities:

• Worked with the business analysts and DBA to gather business requirements to be translated into design considerations.
• This also gave some good expertise with some of the tool migration techniques.
• Identified and tracked the slowly changing dimensions to capture the changes in plans of customers, heterogeneous sources and determined the hierarchies in dimensions.
• Speeding up of work by using re-usable transformations and work-lets, for further lowering of errors and enhancing work flow performance. Developed schedules to automate the update process and Informatica Batches/Sessions.
• Extracted data from Oracle, and loaded them into Oracle.
• Worked with team, that was focused on capturing mainly changes in customer plans.
• Worked with Source Analyzer, Warehouse Designer, Transformation designer, Mapping designer and Workflow Manager
• Developed data Mappings between source systems and warehouse components.
• Created various Transformations like Joiner, Aggregator, Expression, Lookup, Filter, Update Strategy, Stored Procedures, and Router etc.
• Organized data in order to capture the basic nature of the business environment, providing a stable view of the data associated with the core business processes.
• Monitored sessions that were scheduled, running, completed or failed.
• To retrieve the data from various Tables and to test the database, wrote SQL Queries.
• Understanding the entire functionality and major algorithms of the project and adhering to the company testing process.

Environment: Informatica Power Center 8.6/8.1, Oracle 10g, Flat Files, SQL Developer.

ETL Developer

Confidential, Bloomington, IL

Responsibilities:

• Worked with Business analysts and the DBA for requirements gathering, business analysis and designing of the data warehouse.
• Created Complex mappings using Unconnected, Lookup, and Aggregate and Router transformations for populating target table in efficient manner.
• Created Mapplet and used them in different Mappings.
• Created events and tasks in the work flows using workflow manager
• Created Schema objects like Indexes, Views, and Sequences.
• Designed and Developed Oracle PL/SQL and UNIX Shell Scripts, Data Import/Export.
• Developed mappings for policy, claims dimension tables.
• Tuned performance of informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Tuned performance of existing SQL statements and PL/SQL code.
• Developed procedures, functions, packages and triggers in PL/SQL
• Working with database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.
• Developed shell scripts for running batch jobs and scheduling them

Environment: Informatica Power Center 8.0 Work Flow Manager/Monitor, Oracle 10g/9i, SQL, PL/SQL, SQL * Loader, UNIX Shell Scripting, Win 2000/NT.

Informatica Developer

Confidential

Responsibilities:

• Developed mappings and mapplets using Informatica Designer to load data into ODS from various transactional source systems.
• Used Informatica Designer to import the sources, targets, create various transformations and mappings for extracting, transforming and loading operational data into the EDW from ODS.
• Used various transformations such as expression, filter, rank, source qualifier, joiner, aggregator and Normalizer in the mappings and applied surrogate keys on target table.
• Created mapplets and reusable transformations.
• Created Workflow, Worklets and Tasks to schedule the loads at required frequency using Workflow Manager.
• Created stored procedures, Functions and Packages in Oracle, used PL/SQL and SQL. Used SQL*loader to load data from MS-EXCEL sheets.
• Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository.
• Migrated mappings from Development to Testing and performed Unit Testing and Integration Testing.

Environment: Informatica Power Center 7, Repository Manager, SQL*loader, Oracle 8i, PL/SQL, SQL, UNIX, Win 2000/NT.