SUMMARY

• 7+ years of IT experience wif emphasis on business requirements analysis, data modeling, application design, development, testing and project coordination of applications
• Experienced in different phases of Software Development Life Cycle (SDLC) like designing, programming, testing according to teh requirements of teh clients
• Experienced in analyzing business requirements and translating requirements into functional and technical design specifications
• Designed Data Marts by following Star Schema and Snowflake Schema Methodology
• Experienced in designing of ETL methodology for supporting data transformations using Informatica Power Center 7.x/8.x/9.x
• Highly proficient in Planning, Designing, developing and deploying Data Warehouses and Data Marts
• Extensive experience in ETL methodology for supporting Data Extraction, transformations and loading processing, using Informatica Power Center
• Proficient wif various active Transformations like Filter and Router Transformation, Joiner Transformation and Aggregator Transformation
• Experienced wif various Informatica client tools like Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager, Workflow Monitor and Workflow Manager
• Worked wif relational database development using SQL in various relational databases like Oracle, SQL Server,DB2
• Created and maintained Database Objects like Tables, Views, Materialized views, Indexes, Constraints, Sequence, Table Partitions, Synonyms and Database Link
• Created and developed complex mappings using various transformations such as Lookup, Joiner, Aggregator, Filter, Sorter, Expression, Router, Union, Rank, Update Strategy, Source Qualifier and Sequence Generator.
• Skilled in creating mappings, Mapplets and reusable transformations using Informatica
• Expertise in Data Cleansing at staging level wif utilization Informatica Power Center
• Expertise in Performance Tuning, Indexing and Partitioning techniques on sources, targets, mappings and workflows
• Extensively used various Functions like LTRIM, RTRIM, ISNULL, ISDATE, TO DATE, Decode, Substr, Instr and IIF function
• Experienced in migrating Informatica mappings from Oracle to DB2, and other relational databases
• Experienced writing and modifying ETL Design Documentation, Test Results Documentation and Standard Operating Procedures (SOP) documentation.
• Experienced in developing Shell Scripts on UNIX and experience wif UNIX command line.
• Exposure to handling large volumes of data in production environments
• Worked wif different data sources like Flat Files, XML files, Databases
• Hands on experience in writing, testing and implementation of stored procedures
• Coordinated wif teh off - shore development team to fix release issues and wif project manager to prepare project plans
• Good experience working wif Agile methodology, attending daily scrum meetings, retrospectives, and sprint planning.
• Ability to work across organizational boundaries and in cross-functional teams
• Excellent in multitasking, problems solving, timely resolution of issues
• Self-motivated and excellent abilities to learn new languages and other concepts quickly, excellent interpersonal skills and abilities to communicate wif team players.

PROFESSIONAL EXPERIENCE

Confidential - Atlanta, GA

Sr. ETL / Informatica Developer

Responsibilities:

• Developed mappings/Reusable Objects/Transformation/Mapplets by using mapping designer, transformation developer and Mapplets designer inInformaticaPower Center 9.6
• Integrated data between multiple systems usingInformaticaPower Center version 9.6
• Developed data integration architecture (sources, staging, data and process flows, business rules and transformations, and targets) for client engagements
• Excellent technical and analytical skills wif clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP
• Created work tables and indexes for intermediate processing as part of ETL process
• Updated theInformaticaparameter files which are used during workflow processing
• Developed and deployed UNIX shell scripts to work wif flat files, to define parameter files and to create pre and post session commands
• Recommended solutions to business problems and act as a subject matter expert to business partners
• Implemented best practices as per teh standards while designing technical documents and developing Informatica ETL process
• Actively involved in different phases of teh project Business Requirement Analysis, Design, Development, Testing, Implementations, Maintenance, Enhancements, and support for ETL
• Troubleshoot technical issues/Service requests on teh production platform

Confidential - Atlanta, GA

Sr. ETL / Informatica Developer

Responsibilities:

• Involved in requirement gathering and designing of teh application
• Coordinating wif source system owners, day-to-day ETL progress monitoring, Data warehouse target schema Design (Star Schema) and maintenance
• Created mappings wif heterogeneous sources like flat files, MS Access, Oracle databases and created targets in Oracle data warehouse using Informatica PowerCenter 9.5/9.1
• Built reusable transformations for recurring business logics using mapplets and used them in multiple mappings
• Implemented extracting, cleansing, transformation, integration and loading into Data marts using Informatica
• Created mapplets and reusable session for teh performance tuning
• Worked wif Informatica workflow monitor in running and debugging its components and monitoring teh resulting executable version
• Involved in fine-tuning of sources, targets, mappings and sessions for performance optimization
• Modified Unix Shell Scripts for executing teh Informatica workflows
• Created parameters and variables for incremental data loading TEMPeffectively using Informatica workflow manager
• Created event raise, event-wait tasks for maintaining dependencies between workflows
• Daily monitoring of teh mappings dat ran teh day before and fixing teh issues
• Involved in unit, system and end-to-end testing of teh design
• Worked wif DBA and Reporting team to generate Materialized View of teh data warehouse
• Worked on call for production support

Confidential

Informatica Developer

Responsibilities:

• Involved in different phases of teh project life cycle like design, development, testing and deployment.
• Prepared technical design specifications for Data Extraction, Transformation and Loading
• Worked wif Informatica Utilities Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformation Developer
• Used various transformations like Stored Procedure, Connected and Unconnected lookups, Update Strategy, Filter transformation, Joiner transformations to implement complex business logic
• Created reusable transformations to load data from operational data source to Data Warehouse and involved in capacity planning & storage of data
• Analyzed teh sources, transformed data, mapped teh data and loaded teh data into targets using Informatica Power Center Designer
• Used Informatica Workflow Manager to create workflows, database connections, sessions and batches to run teh mappings
• Used Variables and Parameters in teh mappings to pass teh values between mappings and sessions
• Implemented restart strategy and error handling techniques to recover failed sessions
• Used Unix Shell Scripts to automate pre-session and post-session processes
• Performanced tuning to improve Data Extraction, Data process and Load time
• Constructed complex SQL Queries involving multiple tables wif joins

Confidential

DB2 Administrator & Data Warehouse Developer

Responsibilities:

• Developing solutions to requirements, enhancements and defects.
• Database maintenance, optimization and design
• Designed and supported REST services native to DB2
• SQL performance evaluation and optimization
• Automation of process to capture metadata of changed DB2 objects in production environment
• Created new mapping designs using various tools in Informatica Designer like Source Analyzer, Warehouse Designer, Mapplet Designer and Mapping Designer.
• Developed teh mappings using needed Transformations in Informatica tool according to technical specifications
• Created complex mappings dat involved implementation of Business Logic to load data in to staging area
• Developed mappings/sessions using Informatica Power Center 9.0 for data loading
• Performed data manipulations using various Informatica Transformations like Filter, Expression, Lookup (Connected and Un-Connected), Aggregate, Update Strategy, Normalizer, Joiner, Router, Sorter and Union
• Developed Workflows using task developer, Worklet designer and workflow designer in Workflow manager and monitored teh results using workflow monitor.
• Building Reports according to user Requirement
• Optimizing performance tuning at source, target,mapping and session level
• Participated in weekly status meetings, and conducting internal and external reviews