PROFESSIONAL SUMMARY

• Informatica 10x certification professional having experience around 5 years in information technology with special emphasis on Design, Development of Database, Data warehousing applications.
• Five years of IT experience in Information Technology as software engineer performing analysis, design and development of various applications in client - server environment. Good experience in providing Business Intelligence solutions in Data Warehousing for decision support systems and OLAP application developments.
• Expertise inAnalysis, DesignandDevelopment ofData warehousing solutions and developing strategies forExtraction, Transformation and Loading (ETL)mechanism usingPower Center Informatica 10x
• Actively involved in design meeting with clients, provided various technical solutions in end-to-end implementation.
• Well versed with SDLC phases like planning, analysis, design, implementation and maintenance.
• Strong knowledge on Data Warehousing concepts and Dimensional modeling like Star Schema and Snowflake Schema.
• Good exposure to loading and maintaining Data Warehouses in Teradata and Oracle. Experience with Unix shell scripting and basics of PL/SQL programming. Good understanding of tools MLoad, BTEQ, FastExport and FastLoad to design and develop dataflow paths for loading transforming and maintaining data warehouse in Teradata.
• Experienced in Full life cycle of Data warehousing involving all stages of SDLC using Informatica Power Center (9x/10x).
• Experienced in ETL tool Informatica in using Mapping Designer, Workflow Manager and Monitor. Expertise and well versed with various transformations like Experssion, filter, sorter, aggregator, Lookup, Normalizer, Joiner, Union and Update Strategy etc.
• User Acceptance Tests (UAT) for various application and reports on a daily/weekly or monthly basis along with preparation of Ad-hoc reports.
• Coordinating with testing team for System Integration (SIT) and Regression testing.
• Used various Performance Tuning techniques to improve the overall performance.
• Excellent knowledge on using MS office tools and utilities.
• Excellent written and oral communication, interpersonal and presentation skills.

TECHNICAL SKILLS

ETL Tools: Informatica PowerCenter 9x/10xRDBMS: Oracle 11g/12c and Teradata

Operating System: Linux, Windows Operating Systems

Scripting Languages: Unix Shell Scripting

Data Extraction Tools: Oracle SQL Developer, Teradata SQL Assist.

Scheduling Tools: Autosys and related scheduling tools.

Other Tools: Subversion (Version Control), JobTrac (Scheduling)

PROFESSIONAL EXPERIENCE

Confidential - Atlanta, GA

ETL Developer

Responsibilities -

• Gathering user requirements, Analyzing and converting the requirements to simple technical specs.
• Functioned as the primary liaison between the business line, operations, and the technical areas throughout the project life cycle. Worked on gathering, analyzing and documenting business requirements.
• Worked with enterprise architects to develop the new logical and physical ER data models in line with corporate standards and guidelines.
• Designing and creating the stage load and enhancing normalization process with error handling and control dashboard maintenance for all the front and back office feeds.
• Worked in creating the FO-MO-BO recs which enables users to check the daily breaks.
• Designing and implementing Enrichment engine to find and fix trade / transactional breaks.
• Designing/implementing the control board dashboard to capture and report input errors at field level.
• Working with Reporting team in creating the daily/monthly and adhoc reports for users.
• Working with the MDM team generate user interface for business to examine and fix the trade breaks.
• Weekly status meeting with the client to communicate the development progress and any issues arising during Design, Development and Testing phases.
• Extensive use of Microsoft technologies like Excel, word and Power point. Experience using the VLOOPS and Pivot table concepts in Excel.

Environment: Informatica Power center, Oracle 11g and 12c, PL/SQL and Unix shell scripting.

Confidential - Irving, TX

ETL Developer

Responsibilities:

• Designing and creating the stage load and enhancing normalization process with error handling and control dashboard maintenance for all the front and back office feeds.
• Designing and implementing error data mart in star schema model to report errors at granular level.
• Designing/implementing the control board dashboard to capture and report input errors at field level.
• Created Informatica Mappings to load data from flat files, oracle and Sybase. Use of transformations like Stored procedure transformation, Connected and Unconnected lookups, Source Qualifier, Expression, Sorter, Aggregator, Joiner, Filters, Sequence, Router, Normalizer, rank and Update Strategy transformations.
• Worked with Variables, Parameters, Parameter files and File list on Informatica.
• Extensively used Stored Procedures, Functions and Packages using PL/SQL for creating Connected and Unconnected Stored Procedure Transformations.
• Workflow Manager for creating, validating, testing and running the sequential and concurrent sessions and scheduling them to run at specified time and as well to read data from different sources and write it to target databases.
• Weekly status meeting with the client to communicate the development progress and any issues arising during Design, Development and Testing phases.

Environment: Informatica Power Center, Oracle 11g, SQL, PL/SQL and UNIX shell scripting.

Confidential

Junior ETL Developer

Responsibilities:

• Involved in Onsite-Offshore coordination model in designing and developing the ETL systems
• Performed Data profiling, creation of informatica mappings and related DB modules
• Application of complex business rules into informatica using components like Lookup, joiner etc.,
• Involved in all phases of testing life cycle which include unit testing, system integration testing and user acceptance testing.
• Performance enhancing the existing/new features of application.
• Creation of Automation jobs using Autosys scheduler.