SUMMARY

• Looking for a ETL Developer with 6+ years of experience in design, development and implementation of Data Warehousing and Data Integration projects for Healthcare, Finance, Insurance, and Telecom service sectors and contribute my expertise on Business Analyst, architecture, design and Implementation of Data Warehouse development using Informatica, Oracle, UNIX, Microsoft SQL server, Teradata, Maestro ( TWS), BO and DB2.
• Extensive hands on Gathering requirements, analyzing the source data and developing Source to Target mapping document.
• Strong Experience on source data profiling and Analyzing the data change impact
• Extensive experience in various project design and development involved in the complete life cycle of the projects and contributed to the development of the system architecture.
• Extensive experience in ETL methodology for developing data extraction, loading and transformation processing Using Informatica (Power Center 9.x/8.x/7.x - Repository Manager, Designer and Workflow Manager).
• Worked on Slowly Changing Dimensions (SCD's) and its implementation (Type1, Type 2, andType 3) to keep track of historical data.
• Knowledge of SIF using SoapUI / IDD and API
• Installation and configuration of Informatica Server and Informatica Repository Server in Windows-UNIX Operating Systems.
• Experienced with Informatica PowerExchange (5.x/9.x) for Loading/Retrieving data from different source and Target
• Experience in Load balancing /optimizing resource usage and defining Environment Variables for performance tuning
• Strong development experience in Informatica with various databases like Oracle 10G, DB2 8.x and MS SQL Server
• Hands on knowledge on UNIX operating systems (AIX, HP-UX and Solaris), Windows and working experience on Schedulers like Control-M, Autosys, Maestro and Cronjobs
• Expert in designing and developing Unix Shell Scripts for automation of ETL Processes, Error handling and Auditing
• Experience in ETL Error Handling, Performance Tuning and Code Optimization.
• Hands on experience on Realtime and Batch jobs
• Good knowledge in interacting with Informatica Data Explorer (IDE), and Informatica Data Quality (IDQ 9.1).
• Exceptional problem solving and sound decision making capabilities, recognized by associates for quality of data, alternative solutions, and confident, accurate, decision making.
• Expert in handling dynamic mechanism to handle dynamic requireemnt in Informatica 9.0.1
• Expert in migrating Informatica 8.x and Informatica 9.x
• Experienced with creation of database models, data flow diagrams, DB scripts, SP, Packages, structures and data standards to support and implement a robust data architecture
• Strong experience in Data Profiling
• Excellent analytical, logical, communication and leadership skills
• Have experience on performing managerial activities

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.1/8.6.1/8.6/8.5.1 , Informatica Power Exchange 9.0/8.6/8.1/7.2

Data Modeling: Star Schema Modelling, Snow Flake Modelling, Erwin 4.0

OLAP Tools: Business Objects XI 3.1/3.0/XI R2 BO SDK, Crystal Reports, Central Management Console, Central Configuration Manager, Designer

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

Languages: SQL, PL/SQL, Unix Shell Script, Java, J2EE, Web Services

Tools: Microsoft Office - Word, Excel, Access, PowerPoint, Toad,, TWS(Tivoli Workload Scheduler ), Autosys, Control-M, SQL Plus Loader, AS/400

Operating Systems: Unix, Windows 2007/2003/2000/ NT/XP, AIX

PROFESSIONAL EXPERIENCE

Confidential, VA

ETL Developer

Responsibilities:

• Responsible to analyze the impact to the system whenever there is a change in source data.
• To develop the Source to target mapping document for the changes happening in source and propose optimal design
• Interacted with business users to understand their business needs for developing ETL process.
• Documented user requests in the form of Functional and Technical specifications.
• Used ETL tool Informatica Power Center, for Extraction, Transformation and. Loading data into Data Warehouse
• Production Support & Maintenance
• Implemented efficient and effective performance tuning procedures
• Involved in Code migration to different Repositories (Dev/Test /Prod)
• Requirement gathering by working with business users, Financial Analysts, Project managers, and involved in analysis and creation of architecture that can be considered 'best practice' and scalable.
• Weekly reviews on enterprise wide decisions with Technical Architects, Business Architects on Technology, Tools, applications and architectures designs.

Environment: Power Center 9.0.1, ORACLE 10G/11G, TOAD, UNIX, Tiwoli ( TWS ) and QC

Confidential, CO

ETL Developer

Responsibilities:

• Interacted with business users to understand their business needs for developing ETL process.
• Documented user requests in the form of Functional and Technical specifications.
• Implemented CDC for slowly changing dimensions.
• Created Data Migration mapping templates.
• Responsible to analyze the impact to the system whenever there is a change in source data.
• Implement new changes/ modify existing ones (ETL specific) related to two applications specified above depending upon the client requirements
• Test the changes/code fixes that are implemented as part of change requests/code fixes
• Monitor the deployment activity when the specific deliverables are going into production
• Ensure the deployed code is working fine in production environment
• Give approaches/solutions in case of any production failures/errors
• Created validation rules and rule bindings for data profiling according to business requirements.
• Scheduled and monitored ETL Loads through Management Console.
• Created and updated Universe using Business Objects Designer.
• Created BO Reports for Validation of the Data.

Environment: PowerCenter 8.6.1, SQL Server, Oracle 10g/11g, Control-M, QC,TOAD, UNIX,AS/400.

Confidential, Deerfield, IL

ETL Developer

Responsibilities:

• Responsible for creating Functional document, Source to Target mapping document
• Involved in Extensive Design and reviews of ETL Informatica Objects
• Designing, Developing, Testing and Implementation, Coordination with the Client/Onshore team
• Design and build of Extract, Clean, Transform and Load components as per the client requirements based on the proven ETL solutions using Informatica ETL tool
• Have been instrumental in creating detailed technical design specification’s document
• Developed Unix shell scripts to execute the Informatica ETL transformation
• Involved in development of ETL code in the project
• Taking overall responsibility and ownership for team deliverables
• Involved in coordinating the communication between the offshore and Client.
• Involved in areas of improving the productivity by focusing on innovative ideas.
• Validated and executed batch jobs. Tested data flows and scripts against sample data and real data. Creation of initial and incremental load jobs
• Identified and tracked project issues/risks and recommended solutions.

Environment: Informatica 8.6.1, TOAD, ORACLE 10G, DB2, UNIX, TWS and QC,AS/400.

Confidential, Los Angeles, CA

ETL developer

Responsibilities:

• Extracted Data from all the Relational Databases including oracle, DB2 and loaded in different environments which includes ORACLE, DB2 and .CSV files.
• Worked on the shell scripting to handle the job failure/success notifications.
• Participated in Requirements gathering, analysis, feasibility study and technical clarifications to the business. Coordinating with ETL dev team for designing and performance tuning
• Developing UNIX shell scripts for the scheduler and other reusable components in Informatica.
• Developed Informatica mappings/mapplets based on business requirements using various transformation such as partition, expression, join, union, sort, router, aggregator etc
• Review and involve in mapping Design and identify GAPs and provide efficient solution for the issues identified.
• Involved in Extensive Design and Code reviews of ETL Informatica Objects
• Taking overall responsibility and ownership for Environment support

Environment: Informatica 8.5.1, Oracle 10g, DB2, AIX, Autosys, SOAP and QC

Confidential, Boston, MA

ETL Developer

Responsibilities:

• Worked on Source to Target-Mapping for legacy systems
• Worked on transforms, Jobs, Workflows, Data flows, scripts etc in Data Service to extract, cleanse and load into target Data Base.
• Responsible for creating Functional document, Source to Target mapping document
• Involved in Extensive Design and reviews of ETL Informatica Objects
• Designing, Developing, Testing and Implementation, Coordination with the Client/Onshore team
• Design and build of Extract, Clean, Transform and Load components as per the client requirements based on the proven ETL solutions using Informatica ETL tool
• Have been instrumental in creating detailed technical design specification’s document
• Developed Unix shell scripts to execute the Informatica ETL transformation
• Involved in development of ETL code in the project
• Used look-up function extensively for source to target mapping scenarios
• Worked on data-cleansing to standardize the operational data.

Environment: Informatica 8.6, DB2, UNIX, QC, Clear case, Control-m, and Windows.