SUMMARY:

• Overall 11 years of IT experience in Analysis, Design, Development, Implementation, Testing of Data Warehousing and Data Integration Solutions using Informatica Power center and in Solaris server Administration & Shell scripting.
• 8+ 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.
• 3+ years of experience as system administrator experience in multiplatform Unix and Linux & Solaris environments, with hands - on expertise in networking, scripting, and systems integration.
• 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 good experience in handling projects with Agile methodologies and software development as well.
• Skilled with the Integration of various data sources like Oracle, SQL Server, Teradata, Flat Files, XML Files and IBM Mainframe files.
• Experienced in creating and publishing processes in Informatica Intelligent Cloud Services (IICS).
• Experience in working on Push down Optimization (PDO) and Partitioning.
• Developed SCD Type1 and Type2 ETL mappings to load history data using Informatica
• Good 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.
• Good 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, JENKINS, and SVN.

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

PROFESSIONAL EXPERIENCE:

Confidential, Austin, Texas

Senior ETL Developer

Environment: Informatica Power Center 9.x, Oracle 11G, SQL, UNIX Shell Script.

Responsibilities:

• Understanding the Business requirements based on Functional specification to design the ETL methodology in technical specifications.
• Involved in requirement gathering from the clients and conduct architectural review meetings with Agile Methodologies process.
• 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.
• Developed data conversion/quality/cleansing rules and executed data cleansing activities.
• Coordinating with Functional teams to make sure required data has been extracted and loaded and performed the Unit Testing and fixed the errors to meet the requirements.
• Designed and developed Informatica Mappings to load data from Source systems to ODS and then to Data Mart.
• Implemented complex business rules in Informatica Power Center by creating re - usable transformations and robust Mapplets.

Confidential, Houston, Texas

Senior ETL Developer

Environment: Informatica Power Center 9.x, Oracle 11G, Teradata 13, SQL, UNIX Shell Script, IBM AIX, TOAD.

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).
• 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.

Confidential, Broomfield, Colorado

Senior ETL Developer

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

Responsibilities:

• Involved in requirement gathering from the clients and conduct architectural review meetings with Agile Methodologies process.
• Responsible for architecture the application and provide solution to the business requirements.
• 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 IICS 4.0 environment.
• Worked on various sources like Sales Force, Oracle, Flat Files, Teradata, and 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.
• Responsible for capturing Unit and Integrated test results.

Confidential, Oakland, California

Senior Developer/Lead

Environment: Oracle 11G/12C, Informatica 9.X, SQL, PLSQL, TOAD, AIX, AS 400, UNIX, TOAD, IBM TIVOLI, Teradata 13.

Responsibilities:

• Involved in requirement gathering from the clients and conduct architectural review meetings with SDLC process.
• Responsible for architecture the application and provide solution to the business requirements.
• Developed mappings for loading Medicaid and 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.
• 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, D eveloped 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

Senior Developer

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.

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 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.
• Provided defect resolution during SIT and UAT phases of the Project.

Confidential, New York, NY

Informatica Developer

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

Responsibilities:

• Analyzing existing database schemas and designing star schema models to support the users reporting needs and requirements.
• Implemented Slowly Changing Dimensions (SCDs, Both Type 1 & 2).
• 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.

Confidential, New York, NY

Informatica Developer

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

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
• 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.
• Designed and developed mappings using Source Qualifier, Expression, Lookup, Router, Aggregator, Filter, Sequence Generator, Stored Procedure, Update Strategy, joiner and Rank transformations.
• 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.
• Used PMCMD command to automate the Power Center sessions and workflows through UNIX.

Confidential, New York, NY

Solaris Administrator

Environment: Solaris 9 & 10, Linux.

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.