SUMMARY

• Over 8 years of IT experience in analysis, design, development, testing and implémentation of data warehouses as an ETL Developer using Informatica. Expertise in data warehousing concepts using Bill Inmon and Ralph Kimball Methodologies and 6+ years of Data Warehouse experience with domain knowledge of Finance/Banking, Retail, Appliance and Lighting.
• Extensive ETL experience using Informatica Power Center client tools (Designer, Workflow Manager, Workflow Monitor and Server Manager) and Informatica Power Exchange.
• Expertise in using Dimensional Data modeling, Star Schema, Snow flake schema, Fact and Dimension tables, Physical and logical data modeling.
• Experience in data conversion of various data sources like Oracle, SQL Server, Teradata, Fixed Width and Delimited Flat Files, Teradata Load/unload utilities Mload, Fast Load, BTEQ, Tpump, TPT, and Fast Export for loading and extracting data to and from the warehouse.
• Experience in developing Slowly Changing Dimensions mapping (Type I, Type II& Type III) and Change Data Capture (CDC).
• Extensive experience in creating the Workflows, Worklets, Mappings, Mapplets, Reusable transformations and scheduling the Workflows and Sessions usingInformatica Power Center.
• Expertise in working with various transformations like Aggregator, Look up, Update Strategy, Joiner, Filter, Sequence Generator, Normalizer, Sorter, Router and reusable transformations in Informatica Power Center Designer.
• Expertise in tuning the performance of Mappings and Sessions in Informatica and determining the performance bottlenecks.
• Worked with Informatica Data Quality (IDQ) toolkit, Analysis, data cleaning, data matching, data conversion, exception handling, and monitoring capabilities of IDQ.
• Ability to analyze source data for potential data quality issues and addressing these issues in ETL procedures.
• Worked extensively with debugging and tuning of ETL processes to improve the overall performance.
• 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, and implementation.
• Experience in different software development methodologies like Waterfall Model and Agile Software Development process.
• Experience in SQL, T - SQL, PL/SQL Programming (Stored Procedures, Functions and Triggers).
• Experience in developing Unix Shell Scripts for scheduling Informatica jobs.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.5/9.1/8.6.1/8.1/7.1/6.2 , Informatica Power Exchange, IDQ

Databases: Oracle 12c/11g/10g, SQL-Server 2008/2005/2000 , Teradata and MS Access.

Tools: and Utilities Erwin 8.2/8.0, MS-Visio, TOAD, SQL Developer, SQL Navigator, SQL Server Management Studio, SQL* plus, SQL* Loader

Languages: HTML, SQL, PL/SQL, UNIX Shell Script

Operating Sys: Windows NT, Windows 2000/2003, Windows XP, UNIX

PROFESSIONAL EXPERIENCE

Confidential, Saint Louis, MO

Sr. Informatica Developer

Responsibilities:

• Data conversion of various data sources like Oracle, SQL Server, Teradata, Fixed Width and Delimited Flat Files, Teradata Load/unload utilities Mload, Fast Load, BTEQ, Tpump, TPT, and Fast Export for loading and extracting data to and from the warehouse.
• Monitoring the workflows daily by using Informatica Workflow Monitor and jobs are monitored through the TWS Scheduler.
• Identify the root cause of the issues and providing a permanent solution.
• Working on service requests on priority.
• Working on Change Request's (CRs) as per the business requirement.
• Informing to the Business for any delay of reports and production outage.
• Preparing reports based on the business request on Hourly, Daily, Weekly, Monthly and ad-hoc basis.
• Preparing the scripts for alerts on Informatica workflows and TWS object failures.
• Checking the file system disk space and doing the house keeping of the file system before reaching the mount point size 100%.
• Performing the health checks on Application server, source DB and Target DB's.
• Responsible for handling daily and monthly loads to the production database, handled the production support and deployment activities.

Confidential

Team Lead - Informatica Practice

Responsibilities:

• Working with various transformations like Aggregator, Look up, Update Strategy, Joiner, Filter, Sequence Generator, Normalizer, Sorter, Router and reusable transformations in Informatica Power Center Designer
• Handling critical Asia Lighting, Transportation Freight folders.
• Resolving the Data issues while the execution of the Production ETLs and ensuring clean data to subscribers and reporting systems
• Supporting reporting related issues raised by the End Users
• Provide support to Application Tuning Team
• Working closely with clients and Business to ensure a detailed understanding of the requirements
• Design, Development, Testing and Deployment of enhancements.

Confidential

Informatica Developer

Responsibilities:

• Offshore Module Lead (ML) for the Project and direct communication with the client as offshore team lead.
• Develop, build, UAT etc. as per EIS and Work packages as per the requirement for new interfaces and improvement of existing interfaces.
• Configuration Controller (CC) for the Project-Adhere to the Organization’s development processes.

Confidential

Senior Developer

Responsibilities:

• Module Lead (ML) for the Project and associated all the documentation and Process Audits.
• Configuration Controller (CC) for the Project.
• Quality Auditor (QA) for the project
• Testing - Unit testing & integration testing
• SPOC (Single Point of Contact) for the Application-Gathering requirements and presenting the modules o the client