SUMMARY:

• 9+ Years of Experience in ETL Design/Development, Query Creation, Data Modeling, Performance Tuning, Unix Shell Scripting, Implementation, Troubleshooting, Support, Error Handling in the field of Data Warehousing, Application Development and gathering Business Requirements.
• Strong business understanding of verticals like Banking, Insurance, Retail and Healthcare.
• Expertise in ETL process using Informatica Power Center Designer, Workflow Manager, Workflow Monitor, Informatica Server and Repository Manager.
• Good Experience in Designing, Configuring, Customizing, and Developing and Administrating ETL program. Have a pleasant experience in handling projects with agile methodologies and software development as well.
• Experienced in creating and publishing processes in Informatica cloud real time (ICRT).
• Skilled with the Integration of various data sources like Oracle, SQL Server, Teradata, Flat Files, XML Files and IBM Mainframe files.
• Expertise in using complex transformations like Transaction Control Transformation, XML Generator Transformation, Lookup Transformation, Normalizer Transformation.
• Experience in working on Push down Optimization (PDO) and Partitioning.
• Developed SCD Type1 and Type2 ETL mappings to load history data using Informatica
• Pleasant experience in developing UNIX shell scripts to run the Informatica workflows and controlling the ETL flow.
• Expertise in creating mappings, mapplets, mapping wizards and reusable Transformations, workflows and worklets using Informatica.
• Extensively worked in Performance Tuning, Error handling, Oracle query optimization, Product support on various Platforms.
• Proficient in all aspects of the software development life cycle from concept through retirement.
• Pleasant experience in Performance Tuning at both Database and Informatica Level.
• Involved in analysis, design, Preparing HLD, LLD documents, coding, testing, code review, and code migration to development, QA and UAT and Production utilizing Software Configuration Management (Daily Build, Release and Testing methodology).

SOFTWARE KNOWLEDGE:

ETL Tools: Informatica Power center 10.x/9.x, Informatica Cloud

Operating Systems: UNIX, Windows 98/ NT/2000/XP, Solaris 9&10.

Database: Oracle 12C/11g/10g/9i, SQL Server, Teradata 13/12V.

Database GUI Tools: TOAD

Web Development: HTML

Programming Languages: SQL, PLSQL, UNIX Shell Script, BTEQ and Python.

Supporting Tools: Microsoft Visio, GITHUB, AUTOSYS, SVN Tortoise.

Software Engineering Tools: Toad, Putty, Remedy, Tivoli, Service now, Rally.

PROFESSIONAL EXPERIENCE:

Confidential, Richmond, VA

Senior ETL Informatica Developer

Responsibilities:

• Responsible to convert business requirements into technical requirements and system design.
• Review and interpret requirements, data and data models.
• Collaborate and communicate with the Business, testing and other technical teams to fully understand requirements, request / provide clarifications as necessary.
• Participate in Daily scrum calls, work in Agile Sprints, and provide Retrospective.
• Design and develop the data transformations rules and logic and Targets, create ETL mappings, maplets and workflows using Informatica designer tools.
• Conduct ETL design reviews with Tech lead Data modeler and DBA to ensure that code meets performance requirements
• Develop code as per tech design by creating mappings using the transformations such as Joiner, Expression, Filter, Aggregator, Dynamic look up, Router, Union, SQL Transformation, Java and web services transformations.
• Crete and schedule batch jobs using Informatica Power center and Autosys.
• Monitor Workflows and Sessions using Workflow Monitor
• Troubleshoot the mappings using the debugger.
• Perform unit testing, coordinate with testing team for SIT and UAT in terms of help create test scenarios, prepare mock - up data, run jobs, and address defects.
• Track and fix the defects by coordinating with testers and business.
• Code implementation following configuration and change management procedures
• Work with Production control team for job scheduling.
• Production check-out communicate to the project team and help business validate data.
• Documentation for all mappings and workflows developed/modified as part of the project.
• Hand over the application to level 2 support and provide warranty (post-production) support.

Environment: Informatica Power Center 9.6, UNIX, DB2, Rapid Sequel, Version1, Autosys, HP ALM.

Confidential, Broomfield, CO

ETL Senior Informatica Developer

Responsibilities:

• Responsible for architecture the application and provide solution to the business requirements.
• Involved in requirement gathering from the clients and conduct architectural review meetings with Agile Methodologies process.
• Responsible for managing technology in the project and providing technical guidance for the developers and solution for the business requirements.
• Collecting requirements from various source teams and implementing business rules using Informatica v10.
• Convert specifications to programs and data mapping in an ETL Informatica Cloud environment.
• Worked on various sources like Sales Force, Oracle, Flat Files, Teradata, SQL Server.
• Have developed mapping to load data into Teradata from Flatfiles/Oracle.
• Developed complex Source Qualifier Queries using Oracle 12C.
• Developed complex mappings using various transformations to implement business rules and store data in EDW on oracle.
• Extensively worked on using the PDO (Push down optimization), CDC (Change data capture) mechanism.
• Designed and developed complex Shell scripts which controlled the entire process.
• Guided other team members to develop their code effectively.
• Reviewed the code developed by others and provided review comments.
• Responsible for capturing Unit and Integrated test results.

Environment: Informatica 10.1, Informatica Cloud, Teradata, Oracle 12c, Linux, SQL Server, PUTTY, Winscp

Confidential, Oakland, CA

Informatica Senior Developer/Lead

Responsibilities:

• Involved in requirement gathering from the clients and conduct architectural review meetings with Agile Methodologies and SDLC process.
• Responsible for architecture the application and provide solution to the business requirements.
• Developed mappings for loading Medicaid and membership DataMart which were loaded on daily basis for reporting.
• Involved in the ongoing delivery of migrating client mini-data warehouses or functional data marts from Oracle environment to Teradata.
• Developed and guided the team members in enhancing their technical capabilities and increasing the productivity.
• Extensively worked on Informatica IDE/IDQ.
• Involved in massive data profiling using IDQ (Analyst Tool) prior to data staging.
• Worked extensively with slowly changing dimensions SCD Type1 and Type2 .
• Created Informatica file watch events to pole the FTP sites for the external mainframe files.
• Experience in working with TPUMP, FLOAD, and MLOAD Teradata utilities to export and load data to/from Flat files.
• Extensively worked on conversion project of Sybase source system to Oracle source system.
• Created Informatica reusability at various levels of development which reduced development time significantly.
• Implemented slowly changing dimension methodology for accessing the full history of accounts.
• Designed, developed efficient Error Handling methods and implemented throughout the ETLs.
• Have experience on implementing business rules in BTEQ scripts.
• Developed BTEQ scripts for loading the data into the base tables in EDW.
• Experience in scheduling of ETL jobs using Crontab, Tivoli, and Control-M .
• Created Test Plans and user test Cases with estimated Test results to compare with Actual results. Involved in all levels of testing including Unit, System, Integration, Regression testing.
• Developed Unix Shell Scripts for invoking the Informatica mappings and BTEQ scripts as part of the ETL Control and email notifications.
• Responsible for Deploying/Migrating Informatica Objects to Production.
• Optimizing performance tuning at source, target, mapping and session level.
• Interacting with onsite and offshore team to assign Development tasks and scheduling weekly status calls with offshore team on status.

Confidential, Plano, Texas

Informatica Senior Developer

Responsibilities:

• Worked with Business Users and gathered the requirements for building the Data Mart.
• Convert Specifications, Statement of Problems and Procedures into detailed logical flow so the data can easily be integrated using Informatica.
• Analyze user needs, software requirements, existing systems and procedures to improve performance of existing process.
• Created the end to end ETL Design and Source - Target mapping documents.
• Worked with Analysts to identify the Entities involved and built the Logical and Physical Data Model.
• Built Data Mart DDL Scripts and deployed them in the databases.
• Built UNIX shell scripts to load data from flat files to Oracle using SQLLDR command line utility.
• Built Mappings to load SCD Type1 & SCD Type 2 Dimension tables.
• Experience in various transformations like Lookup, Aggregator, Joiner, Sorter, Sequence Generator, update etc. and normalized the de-normal Customer data using Normalizer transformation.
• Designed/developed Stored Procedures for data mappings to implement complex business logics involving looping and called from Informatica Stored Procedure Transformations.
• Built Semantic Layer including Materialized View, Summary and Aggregate tables to help Reporting and as well as Ad-hoc User community.
• Created Test Plans and Test Cases with estimated Test results to compare with Actual results. Involved in all levels of testing including Unit, System, Integration, Regression testing.
• Experience in making changes to the existing Informatica Mappings/Objects using Informatica Versioning.
• Responsible for Deploying/Migrating Informatica Objects to Production.
• Provided defect resolution during SIT and UAT phases of the Project.
• Provide support to other team members to develop the code better with good Quality and addressing ad-hoc issues coming in day to day activities.

Environment: Informatica Power Center/ Power Mart 8.5.1/7.1.4 , Oracle 11g/10g/9i, SQL, AS 400, Solaris 10, Business Objects 6.5, TOAD, IBM TIVOLI, Autosys.

Confidential, New York, NY

Informatica Developer

Responsibilities:

• Designed and developed Complex Mappings, to store the data in EDW on SQL Server in Normalized form, Error handling, and implementation of business rules.
• Implemented CDC for mappings so as to capture the changes and preserve history.
• Extensive experience in creation of ETL mappings and transformations to reflect business rules using Informatica Power Center to move data from multiple sources into target area, source systems are mainly relational tables, and flat files.
• Worked with (Fact and Dimensional tables) OLAP (Star schema, Snowflake schema).
• Extensively worked with Debugger using breakpoints and various test conditions to test the logic and the validity of the data moving through the mappings.
• Involved in the ongoing delivery of migrating client mini-data warehouses or functional data marts from Oracle environment to Teradata .
• Worked with Variables and Parameters in the mappings to pass the values between sessions.
• Used various transformations like Source Qualifier, Lookup (connect, unconnected), Update Strategy, Router, Filter, Sequence Generator, and Joiner on the extracted source data according to the business rules and technical specifications.
• Performance Tuning of SQL Queries and ETL Mappings.
• Responsible for monitoring all the sessions that are running, scheduled, completed and failed Debugged the mapping of the failed session.
• Migration of mappings, sessions and workflows from Development to Stage and Production environments.
• Designed, developed efficient Error Handling methods and implemented throughout the ETLs.
• Code validation of the mappings migrated to QA and production environment.
• Performed Unit tests on the sessions and recommended measures to improve the performance of sessions.
• Responsible for performance tuning of ETL process to optimize load and query Performance.
• Experience in writing Batch/ Shell scripts handle files and Informatica jobs from AIX UNIX
• Worked with DBA group to create Best-Fit Physical Data Model from the Logical Data Model using Forward Engineering.
• Requirement study, System study analysis, Data profiling and Data analysis to meet the business requirements
• Involved in conceptual/logical and physical data models to meet the business and IT requirements.
• Creating the data analysis, data mapping and design documentation for the IT requirements.
• Involved in analysis of the given data in any format such as XML, Table, Web service, flat files and provided the accurate inferences, in accord with the objectives of the analysis
• Gathering required data to conduct analysis from several source systems, cleansing, transformed and integrated into the target system.

Environment: Informatica Power Center 8.x (Meta-Data Repository, Designer, Server Manager), Oracle9i/8i, Teradata 13/14, SQL, UNIX Shell Script, Python, IBM AIX, Win 2000/NT. TOAD, IBM TIVOLI.

Confidential, Treasury, New York, NY

Informatica Developer

Responsibilities:

• Analyzing existing database schemas and designing star schema models to support the users reporting needs and requirements.
• Created Informatica Mappings to load data using transformations like Source Qualifier, Sorter, Aggregator, Expression, Joiner and Connected and Unconnected lookups, Filters, Sequence, Router and Update Strategy.
• Implemented Slowly Changing Dimensions (SCDs, Both Type 1 & 2).
• Cleansed the source data, extracted and transformed data with business rules, and built reusable mappings, known as ‘Mapplets’ using Informatica Designer.
• Involved in the development of Informatica mappings and also performed tuning for better performance.
• Extensively worked on parallel processing capabilities, Session-Partitioning and Target Table partitioning utilities.
• Automated the entire processes using UNIX shell scripts.
• Provided defect resolutions to issues raised by Clients.
• Responsible for fixing of defects within SLA in warranty period
• Responsible for defect tracking in QC.
• Tested the target data against source system tables by writing some QA Procedures.

Environment: Informatica Power Center 7.x & 8.x, Oracle 8i, SQL, shell scripts, Sun-Solaris and Windows NT.

Confidential, New York, NY

Informatica Developer

Responsibilities:

• Understanding the Business requirements based on Functional specification to design the ETL methodology in technical specifications.
• Developed data conversion/quality/cleansing rules and executed data cleansing activities such as data
• Consolidation, standardization, matching Trillium for the unstructured flat file data.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Power Center 8.5.
• Experience in integration of heterogeneous data sources like Oracle, DB2, SQL Server and Flat Files (Fixed & delimited) into Staging Area.
• Wrote SQL-Overrides and used filter conditions in source qualifier thereby improving the performance of the mapping.
• Designed and developed mappings using Source Qualifier, Expression, Lookup, Router, Aggregator, Filter, Sequence Generator, Stored Procedure, Update Strategy, joiner and Rank transformations.
• Managed the Metadata associated with the ETL processes used to populate the Data Warehouse.
• Implemented complex business rules in Informatica Power Center by creating re-usable transformations, and robust Mapplets.
• Implemented performance tuning of Sources, Targets, Mappings and Sessions by identifying bottlenecks and used Debugger to debug the complex mappings and fix them.
• Improved session Performance by enabling property incremental aggregation to load incremental data into target table.
• Worked with Functional team to make sure required data has been extracted and loaded and performed the Unit Testing and fixed the errors to meet the requirements.
• Copied/Exported/Imported the mappings/sessions/ worklets /workflows from development to Test Repository and promoted to Production.
• Used Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows based on changing variable values.
• Worked with Static, Dynamic and Persistent Cache in lookup transformation for better throughput of Sessions.
• Used PMCMD command to automate the Power Center sessions and workflows through UNIX.

Environment: Informatica Power Center 8.5, Oracle 10g, SQL Server 2005, SQL*Plus, Flat files, UNIX, Windows 2000

Confidential, New York City, NY

Solaris Administrator

Responsibilities:

• Responsible for UNIX server administration and support, including scripting of various tasks to streamline administrative functions and automate system management.
• Maintained and obtained production web environment availability and systems security.
• Created and maintained documentation for critical systems and procedures.
• Maintained and obtained recoverability and backups.
• Installed, configured and supported Solaris and application servers.
• Communicated and worked with the individual application development groups, DBAs and the Operations.
• Assigned to selected projects and successfully defined hardware and software needs to complete them.
• Provided root cause analysis of incident reports during any downtime issues.

Environment: Solaris 9 & 10, Linux.