PROFESSIONAL SUMMARY:

• Having 7+ years of IT experience in Analysis, Design, Development, Testing, Implementation and Support of Data Integration, Data Migration and Data Quality Projects using Informatica PowerCenter, Data Quality software tools.
• Experienced in working with various relational databases like Oracle, Teradata, DB2, MySQL and SQL server.
• Extensive experience in ETL (Extraction, Transformation and Loading) of data using Informatica PowerCenter from heterogeneous sources like Flat files (Fixed width, delimited), XML files, Relational databases.
• Extensive knowledge in SDLC (Software Development Life Cycle) and executed projects in Waterfall and Agile methodologies.
• Strong understanding of Dimensional Modeling, Star, Snowflake Schema, OLAP and DW concepts.
• Extensive knowledge in RDBMS concepts and Relational and Dimensional Data modeling.
• Worked closely with the data stewards to get data quality project requirements.
• Experienced in understanding the Project scope, Dependencies, Risks and provide estimations.
• Experienced in coordinating and leading onsite - offshore development model.
• Created complex mappings using transformations like Source qualifier, Expression, Aggregator, Joiner, Lookup, Normalizer, SQL, Union, Update Strategy, Filter, Router, XML transformation.
• Expertise in analyzing the source data systems for better understanding the business requirements, designing optimal ETL design.
• Developed technical specifications of the ETL process flow, High level and Low-Level Design and Source to Target mapping documents.
• Designed and Developed Audit, Control and balancing process.
• Strong experience in handling Slowly Changing Dimensions (SCD) and Change Data Capture (CDC).
• Experience with Informatica Advanced Techniques - pushdown optimization, session partitioning.
• Extensively involved in creating reusable objects to standardize Informatica code and to bring down the development and testing efforts.
• Expertise in developing the flexible ETL code for maintenance and future enhancements by adopting parameterization.
• Extensively involved in Optimization and Tuning of mappings and sessions in Informatica by identifying and eliminating bottlenecks at Source, Transformations, Target layers.
• Experienced in setting up Shared Informatica infrastructure and UNIX platform in co-ordination with Infrastructure partner team.
• Extensively involved in writing Unix Shell Scripting programs like Source file validations, Files upload/Download to/from remote server, Source/Target Files Archival/purge requirements and to run ETL batch jobs from UNIX using PMCMD command.
• Independently perform complex troubleshooting, root-cause analysis and provide solution to fix defects.
• Experienced in writing SQL queries using OLAP functions to improve the performance of the queries.
• Experienced in creating and using Stored Procedures, Functions, Views and Materialized views.
• Extensively involved right from Project engagement to till Production Warranty support of the project.
• Generated warning and Error reports and shared with Business users to further analysis.
• Supported and guided Testing and Business users while SIT, UAT in progress and obtained sign off from SIT, UAT Teams.
• Extensively involved in generating automated alerts to Business users and Email notifications as per Business requirement.
• Ability to meet deadlines and handle multiple tasks, decisive with strong leadership qualities, flexible in work schedules and possess good communication skills.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 10.1/9.1/8.x/7.x/6.x, Power Exchange 9.1/8.x/7.x, Informatica Data Quality, Power Mart 5.x (Source Analyzer, Data Warehouse Designer, Mapping Designer, Mapplet, Transformation Developer, Repository Manager, Workflow monitor)

Data Modeling: MS Visio, ER Diagrams

Databases: Oracle 12C/11g/10g/9i/8i, Sybase, DB2, MS SQL Server, Teradata

DB Tools: Oracle SQL Developer, SQL*Loader, Toad, Oracle SQL*Plus

Operating Systems: Windows 98/2003/2000/ XP/7/NT, UNIX, MS-DOS

Scheduling Tools: Informatica Scheduler, Skybot, Autosys, Control M, DAC

Languages: SQL, PL/SQL, UNIX, HTML, XML, C, C++, Java

Office Suite: MS Word, MS Power Point, MS Excel, MS Access

Methodologies/Data: Modeling Tools Data Mart, Dimensional, Snow Flake, Star Schema, ERWIN

Other Tools: Tableau, UML Tools

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

Senior ETL/Informatica Developer

Responsibilities:

• Analyze the business requirements and framing the Business Logic for the ETL Process and maintained the ETL process using Informatica PowerCenter.
• Experienced in Parsing high-level design specs to simple ETL coding and mapping standards.
• Worked on Agile Methodology, participated in daily/weekly team meetings, guided two groups of seven developers in Informatica PowerCenter/Data Quality (IDQ), peer reviewed their development works and provided the technical solutions. Proposed ETL strategies based on requirements.
• Coded Teradata BTEQ scripts to load, transform data, fix defects like SCD 2 date chaining, cleaning up duplicates.
• Worked with team to convert Trillium process into Informatica IDQ objects.
• Extensively used the DQ transformations like Address validator, Exception, Parser, Standardizer, Solid experience in debugging and troubleshooting Sessions using the Debugger and Workflow Monitor.
• Extensively worked on UNIX shell scripts for server Health Check monitoring such as Repository Backup, CPU/Disk space utilization, Informatica Server monitoring, UNIX file system maintenance/cleanup and scripts using Informatica Command line utilities.
• Extensively worked on CDC to capture the data changes into sources and for delta load. Used Debugger to validate the Mappings and gained troubleshooting information about the data and error conditions.
• Developing workflows with Worklets, Event waits, Assignments, Conditional flows, Email and Command Tasks using Workflow Manager.
• Proficient in System Study, Data Migration, Data integration, Data profiling, Data Cleansing / Data Scrubbing and Data quality.
• Worked on Informatica Data Quality (IDQ) toolkit, analysis, data cleansing, data matching, data conversion, address standardization, exception handling, reporting and monitoring capabilities of IDQ.
• Coded Teradata BTEQ SQL scripts to load, transform data, fix defects like SCD 2 date chaining, cleaning up duplicates.
• Experience in creation of ETL Mappings and Transformations using Informatica PowerCenter to move data from multiple sources into target area using complex transformations like Expressions, Routers, Lookups, Source Qualifiers, XML generator, XML Parser, Aggregators, Filters, Joiners.
• Responsible in preparing Logical as well as Physical data models and document the same.
• Performed ETL code reviews and Migration of ETL Objects across repositories.
• Developed ETL's for masking the data when made available for the Offshore Dev. Team.
• Developed UNIX scripts for dynamic generation of Parameter Files& for FTP/SFTP transmission.
• Monitored day to day Loads, Addressed & resolved Production issues in an abrupt & timely manner and provided support for the ETL jobs running in Production in order to meet the SLA's.
• Integrated IDQ mappings through IDQ web service applications as cleanse functions in Informatica IDQ cleanse Adapters.
• Migrated codes from Dev to Test to Pre-Prod. Created effective Unit, Integration test of data on different layers to capture the data discrepancies/inaccuracies to ensure successful execution of accurate data loading.
• Scheduled Informatica workflows using OBIEE.
• Involved in implementing change data capture (CDC) and Type I, II, III slowly changing Dimensions.
• Developed functions and stored procedures to aid complex mappings

Environment: Informatica PowerCenter 10.x/9.6, Informatica Data Quality (IDQ) 9.6, Oracle 11g, Teradata, PL SQL, SQL developer, TOAD, Putty, Unix

Confidential, Cary, NC

Sr. ETL/Informatica Developer

Responsibilities:

• Involved in production support and development projects working as Informatica developer, which included full life cycle development including design, ETL strategy, troubleshooting reporting etc.
• Interaction with Business SME's on requirement gathering, understanding the business and functional requirements.
• Collaborated with the end users to identify technical requirements for the development project based on their business requirements.
• Developed Informatica mappings, reusable transformations and created PL/SQL Stored procedures/packages for extracting data from source systems to staging and processing and loading to the data warehouse.
• Developed informatica mappings, mapping configuration task and Task flows using Informatica cloud service (ICS).
• Worked on the installation and setup ETL (Informatica cloud) applications on Linux servers.
• Utilized Informatica Data Quality (IDQ) for data profiling and matching/removing duplicate data, fixing the bad data, fixing NULL values.
• Used IDQ (Informatica Data Quality) as data Cleansing tool to create the IDQ Mapplets and to correct the data before loading into the Target tables.
• Monitored and cleansed data using Informatica Data Quality (IDQ) - source data profiling using Informatica Analyst and creating mappings in Informatica Developer to apply cleansing and business rules.
• Developed PowerExchange CDC/Real Time mappings to retrieve data from Oracle.
• Optimized/tuned mappings for better session performance and eliminated bottlenecks by analyzing session statistics and throughput.
• Defined mapping/session parameters and variables according to the requirements and performance related issues.
• Performance tuned Informatica mappings by adopting explain plans, cutting down query costs using Oracle hints, changing the mapping designs.
• Involvement in Project efforts estimation.
• Involved in the Performance Tuning & Preparation of unit test cases.
• Involvement in code deployment and post production deployment activities.
• Tracking and fixing the defects being raised in previous releases.
• Created several Functions, Procedures, Packages, and Triggers according to the Clients requirements in further enhancement projects.
• Tuning the performance of SQL statements using HINTS, INDEXES, and procedures using EXPLAIN PLAN and SQL Trace. Developed a set of views to fine tune the performance tuning process.
• Developed Complex SQL queries using various joins and also extensively used various dynamic SQL's in stored procedures and functions.
• Created database objects like Tables, Indexes, Sequences, and Views.
• Used UNIX shell scripting for execution of Informatica workflows.

Environment: Informatica Power center 10.0,9.6.1, Informatica Cloud, Informatica Data Quality 10.0,9.6.1, Informatica Analyst 9.6.1,10.0, Informatica DVO, SQL, PL/SQL, Oracle 11g, Teradata, SQL Developer, Unix.

Confidential, Schenectady, NY

ETL/Informatica Developer

Responsibilities:

• Designing Functional and technical specs based on requirements provided by business.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica power center.
• Created Mappings using Mapping Designer to load data from various sources like Oracle, Flat Files, MS SQL Server and XML.
• Unique Device Identification (UDI) Program for Medical Devices in Global instance that meet regulatory.
• Created a view to handle multiple packages in the XML.
• Generated XML's using Informatica power center to Submit FDASIA-SKUS to FDA through a middle vendor GHX using PTC Wind chill Tool.
• Maintained day to day report on the errors and successful ACK3 from FDA and prepared Excel charts.
• Involved in writing batch scripts to pull the required information from Ack3 xml files.
• Ack3 are loaded into database Tables using Informatica power center.
• Created new mappings and Enhancements to the current mappings to meet the user's requirements.
• Having hands on experience in Informatica Power Exchange and Informatica IDQ (Use Labeler, Standardizer, KEY Gen transformation).
• Actively Involved into Informatica code migrations and monitoring according to our client's standards.
• Involved in the documentation of the ETL process with information about the various mappings, the order of execution for them and the dependencies.
• Used Parameter files to specify DB Connection parameters for sources.
• Worked extensively in Using Java Transformation to normalize the data.
• Used debugger to test the mapping and fixed the bugs.
• Involved in Performance Tuning at various levels including Target, Source, and Mapping.
• Prepared unit test cases to meet the business requirements and performed unit testing of mappings.
• Involved in integration testing at various levels including Target, Source, and Mapping.
• Perform ETL Informatica Administration functions such as user access accounts, roles, and setting standards.
• Create and manage users, groups and folders. Ensure appropriate privileges are assigned to the different users.
• Extensively Worked in Oracle UTL FILE package, External Tables and Oracle Tuning.

Environment: Informatica Powercenter9.1.0, Informatica Power Exchange, Informatica IDQ, Windows XP, TOAD, OracleSQL, PL/SQL, Oracle11g/9i and SQL Server, Skybot.

Confidential, Houston, TX

ETL/Informatica Developer

Responsibilities:

• Based on the business requirements, created Functional design documents and Technical design specification documents for ETL Process.
• Developed a standard ETL framework to enable the reusability of similar logic across the board.
• Designed, developed, implemented ETL process to extract, transform, and load (ETL) data from inbound flat files and various source systems and load into Data Mart using the Informatica PowerCenter.
• Developed mappings to extract data from SQL Server, Oracle, Flat files and load into Teradata, Oracle using the PowerCenter.
• Created complex mappings and reusable transformations. Made use of mapping variables, mapping parameters.
• Worked extensively on different types of transformations like Source qualifier, expression, Aggregator, Router, filter, update strategy, Connected and Un-connected lookup, sorter, Normalizer, SQL transformation and sequence generator.
• Created workflows, worklets and used all the other tasks like email, command, decision, event wait, event raise and assignment tasks in the Workflow Manager.
• Designed and developed process to handle very high volumes of data using Teradata Parallel Transporter (TPT) load protocols like LOAD and UPDATE.
• Expertise in writing BTEQ scripts on Linux/Unix. Used BTEQ scripts in pre/post load processes for inserting/updating the process activity tables. Also used Teradata Macros and Query banding.
• Used Informatica Push Down Optimization (PDO) to push the transformation processing from the PowerCenter engine into the relational database to improve performance.
• Written shell scripts to execute the workflows, cleanup the files and to execute BTEQ Scripts.
• Used Autosys to Schedule and control the batch jobs
• Assisted and worked on performance testing, data quality assessment & production deployments.
• Involved in jobs scheduling, monitoring and production support in a 24/7 environment.

Environment: Informatica Power Center 9.1, Teradata 13.10, Oracle 10g, Teradata SQL Assistant, TOAD, SQL Loader, Autosys, NDM, SQL, PL/SQL, UNIX Shell Scripts, Linux/Solaris, Tortoise SVN .

Confidential

ETL/Informatica Developer

Responsibilities:

• Involved in understanding the Requirements of the End Users/Business Analysts and developed strategies for ETL processes.
• Responsible for requirements gathering for an enhancement requested by client.
• Involved in analysis and implementation for an Intranet Based Information Management Information System.
• Wrote several Oracle 10g Stored Procedure scripts to implement the business logic.
• Used Informatica to extract data from Oracle load it into Teradata staging.
• Created data models for information systems by applying formal data modelling techniques.
• Strong expertise in physical modelling with knowledge to use Primary, Secondary, and Join Indexes.
• Performed reverse engineering of physical data models from databases and SQL scripts.
• Provided database implementation and database administrative support for custom application development efforts.
• Synchronizing all regions PCR, Unit and System while migration changes from lower region to acceptance.
• Reviewing programs for QA and Testing.
• Issues either in Informatica mappings or the UNIX scripts was handled proactively.
• Responsible for Coding, Unit Test Plans, Unit Test Results, Functional Testing and Regression Testing.
• Involved in comprehensive end-to-end testing- Unit Testing, System Integration Testing, User Acceptance Testing and Regression.
• Provided 24/7 On-call Production Support for various applications and provided resolution for night-time production job failures, attend conference calls with business operations, system managers for resolution of issues.

Environment: Informatica PowerCenter 8.6.1, Oracle 10g, SQL* Plus, Teradata 12, TOAD, SQL Developer, Shell Scripts, UNIX, Windows.