PROFESSIONAL SUMMARY:

• Over 7+ years of experience in the field of Information Technology, with extensive 6 years of experience in ETL - Informatica Power Center 8.1/8.6/9.1/9.6.1
• Extensive experience in various verticals like Retail, Banking, Health Care, Telecommunication and Insurance sectors.
• Strong experience in ETL Designing, Data Conversion, Data Warehouse, Data Mart Design, Star Schema and Snowflake Schema methodologies, Unit Testing and Documentation.
• Major experience using Databases like Oracle 10g/11g, MS SQL Server, Teradata, RDBMS Tables, DB2.
• Proficient in understanding business processes / requirements and translating them into technical design.
• Extensive experience in database technologies (Creating Indexes, Tables, Views) by extraction of data from various Heterogeneous Sources like Relational Database, Flat Files and XML Files to load into Data Warehouse/Datamart Targets.
• Prevalent knowledge in writing SQL Queries, Stored Procedures (PL/SQL), Triggers, Unix Shell Scripts.
• Vast experience of complex Mapping Designer, Workflow Manager, Workflow Monitor, Repository Manager.
• Solid knowledge in Transformations such as Source Qualifier, Lookup, filter, Expression, Normalizer, Joiner, Aggregator, Sorter and Sequence Generator.
• Strong understanding of OLAP/OLTP, BI Life Cycle, SDLC, DML/DDL.
• Used Debugger to debug mappings to gain troubleshooting information about data and error conditions.
• Provides strategic thinking, leadership pertaining to new ways of leveraging information to improve business processes.
• Highly motivated team player with excellent analytical and problem solving skills possessing the ability to effectively communicate with higher management and stakeholders.

TECHNICAL SKILLS:

ETL Tool: Informatica Power Center 8.1/8.6/9.1/9.6.1

Databases: Oracle 8i/9i/10g/11g, IBM DB2,MS SQL Server, Teradata, MS Access.

Reporting Tools: Oracle Business Intelligence, Business Objects.

Programming GUI: SQL, PL/SQL, SQL Plus, Transact SQL, ANSI SQL, Unix Shell ScriptingEnvironment: UNIX, Windows, Linux, IOS.

WORK EXPERIENCE:

Confidential, NY

Sr. Informatica Developer

Responsibilities:

• Extracted data from flat files and oracle database, applied business logic to load them in the central oracle database.
• Developed mappings/Reusable Objects/Transformation/Mapplets by using mapping designer, transformation developer and mapplet designer in Informatica Power Center 9.6.1
• Implemented populate slowly changing dimension to maintain current information and historical information in dimension tables.
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, Sequence Generator, Update strategy, Union, Lookup, Joiner, XML, Source Qualifier and Stored Procedure transformations.
• Develop PL/SQL, Stored Procedure, Triggers and UNIX Shell Scripts for scheduling the sessions in Informatica.
• Created E-Mail notification tasks using post-session scripts.
• Worked with command line program pmcmd to interact with the server to start and stop sessions and batches, to stop the Informatica server and recover the sessions.
• Written documentation to describe program development, logic, coding, testing, changes and corrections.
• Involved in managing the Unix servers and defining the file systems. Directory structures on the Unix box for various parameters and deciding the disk space and memory requirements.
• Provided support to develop the entire warehouse architecture and plan the ETL process.

Environment: Informatica Power Center 9.6.1, Oracle 10g/11g, SQL Server, Teradata12/13, Toad for Oracle, UNIX Shell Script, ESP Scheduler.

Sr. Informatica Developer

Responsibilities:

• Gathered requirements from the end users and involved in analysis of source system, business requirements and identification of business rules.
• Involved in the Data Warehouse, Data Modelling based on the client requirement.
• Responsible for developing, support and maintenance for the ETL processes using Informatica Power Center.
• Extracted sources from Flat-Files, Oracle, SQL Server and load them into WH.
• Responsible for creating system design and detail design documents based on the requirement document provided by the business users.
• Developed various Mappings and Mapplets, also developed an Error Processing to capture the error records and loads them into a message log table.
• Created UNIX Scripts to automate the activities like start, stop and abort the information workflows by using PMCMD command in it.
• Extensively used Debugger Process.

Environment: Informatica Power Center 9.6.1, Oracle 10g/11g, Teradata12/13, SQL Assistant, UNIX Shell Script, Toad Quest Software.

Sr. Informatica Developer

Responsibilities:

• Developed complex Informatica mappings to load the data from various sources using different transformations.
• Worked Informatica power center tools like source analyzer, mapping designer, mapplet and transformations.
• Teradata views have been developed against the departmental database and claims engine database to get the required data.
• Developed Re-Usable transformations and Re-Usable mapplets.
• Extensively worked with both connected and unconnected Lookup Transformations.
• Load balancing of ETL processes, involved in Unit testing and System testing.
• Developed UNIX Shell scripts and used UNIX to create parameter files and for real time applications.
• Detail system defects are created to inform the project team about the status throughout the process.

Environment: Informatica Power Center 8.1/8.6.1, Oracle 10g/11g, Teradata, UNIX Shell Script, XML.

ETL Informatica Developer

Responsibilities:

• Involved in end to end ETL required to build the customer billing data marts.
• Worked closely with Data architect to build dimensional models.
• Designed ETL process from source system to final datamarts and created ETL documents in vision to assign work to off shore team.
• Developed new mappings with reusable transformations and mapplets based on business requirements.
• Worked with the Informatica admin team for the code deployment and version controlling.
• Coordinating with source system owners for day-to-day ETL progress monitoring.
• Worked on shell scripts to handle flat files which include files from source systems and transferring files to downstream systems.
• Involved in Reviewing of Checklists and Project Deliverables.
• Worked on a Remedy tool to create service requests, incidents for the changes in the database.

Environment: Informatica Power Center 7.1/8.1//8.6.1, Oracle 10g, PL/SQL, UNIX Shell Script, XML Flat Files, Windows XP, MS Office Suite.

Oracle Developer/Database Analyst

Responsibilities:

• Coordinating with end users and business analysts to understand the scope of business requirements, user expectations, and ensure the accuracy of reporting specifications.
• Designed and Documents Universe and Report Requirements Definition templates, security strategies, Migration strategies and Report distribution strategies.
• Evaluated the possible use of aggregated tables and worked with DBA to create aggregated tables.
• Involved in writing Unix Shell Scripts to run batch jobs and automating their schedules.
• Designed and Developed data validation, Stored Procedures, Functions and Triggers using SQL Server and Oracle.
• Designed Report output formats, complex, filtering and formula calculations, as well as the rendering of multi-band and multi-grouped reports.
• Coordinated between management, users and technical teams for requirement gathering.
• Involved in various activities like preparation of technical Documentation, Client Discussions for purposed solution and User acceptance testing.

Environment: Oracle 8i/9i/10g, Server, DB2, UNIX Shell Script, MS Office.