PROFESSIONAL SUMMARY:

• 8 Years of IT experience in ETL Architecture, Development, enhancement, maintenance, Production support, Data Modeling, Data profiling, Reporting including Business requirement, system requirement gathering.
• 4.5 years of experience at the client site (in US) where worked closely with the business users to understand their requirements and converting them into successful implementation.
• Played several roles like Senior Informatica Developer/Lead & Data Analyst.
• Over 3+ years of experience in leading team and solving issues for team members.
• Lead projects from initialization phase from capturing business requirements to final phases of testing.
• Served as mentor and reviewer to junior Specialists in all areas of data warehousing and ETL.
• Knowledge on Various ETL, Reporting, and Database development tools like Informatica, Visio, SQL Server, and Oracle with strong SQL coding skills.
• Extensively worked on Data Extraction, Transformation, and Loading with RDBMS, Flat files and XML
• Expert in slowly changing dimensions type 1, type 2 and type 3 for inserting and updating Target tables for maintaining the history.
• Significant knowledge of all transformations of Informatica like Unconnected and Connected lookups, Normalizer, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy etc.
• Experience in performing Unit Testing, Integration Testing, and User Acceptance Testing (UAT) environments and experience in Bug Reporting and Fixing.
• Experienced in End user training, documentation, and Audit record maintenance and application/product demos.
• Strong communication skills.
• Ability to quickly adapt to changing priorities, requests, and environments.
• Dedicated to maintain high quality standards.
• Excellent team player, self - learner and self-initiator with positive attitude, with excellent analytical and logical skills.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 8.5.1, 9.1

Databases: SQL Server 2005, 2008, CDC, Oracle 7i/8i/9i, Teradata 13.10

Modeling Tools: Microsoft Visio

Languages: SQL, PL/SQL

Methodologies: Ralph Kimball’s Star Schema and Snowflake Schema.

Operating System: Windows NT/95/98/2000/XP, UNIX

PROFESSIONAL EXPERIENCE

Confidential, Austin, TX

ETL Informatica Lead

Environment: Informatica 9.1/9.5, Teradata 13.10, SQL Server 2008, UNIX Shell Scripting, OLAP - Microstrategy..

Responsibilities:

• Lead L1, L2 and L3 teams successfully to meet all targets and reduce escalations.
• Participated in ETL design meetings (with Architect and Dev. leads) to identify flaws and suggest best ETL design for our project.
• Drove formal meetings, conference calls, live meetings, walkthroughs, sessions and workshops with the business users, technical analysts.
• Involved in all phases of SDLC from requirement gathering, design, development, testing, Production, user training and support for production environment.
• Had hands on experience of data profiling, rules creation & matching rules using Informatica Data Quality Analyst & Informatica Developer tool.
• Have hands on experience of loading constraint based data model etc.
• Create new mapping designs using various tools in Informatica Designer like Source Analyzer, Warehouse Designer, Mapplet Designer and Mapping Designer.
• Created complex mappings that involved implementation of Business Logic to load data in to staging area.
• Used Informatica reusability at various levels of development.
• Performed data manipulations using various Informatica Transformations like Filter, Expression, Lookup (Connected and Un-Connected), Aggregate, Update Strategy, Normalizer, Joiner, Router, Sorter, XML parser and Union.
• Developed Workflows using task developer, Worklet designer and workflow designer in Workflow manager and monitored the results using workflow monitor.
• Assisting junior developers to resolve their technical problems.
• Extracted data from Oracle and SQL Server and used target as Teradata for data warehousing using utilities fast load, Multi load etc.
• Implemented slowly changing dimension methodology for accessing the full history of accounts.
• Write Shell script running workflows in UNIX environment.
• Optimizing performance tuning at source, target, mapping and session level
• Implemented Performance tuning in Mappings and Sessions by identifying the bottlenecks and Implemented effective transformation Logic.
• Participated in weekly status meetings, and conducting internal and external reviews as well as formal walk through among various teams and documenting the proceedings.

Confidential, Charlotte, NC

ETL Lead

Environment: Informatica 9.1, CDC, Oracle 11g, Perl Scripting, ESP Scheduler, SQL Server 2008, OLAP - Microstrategy.

Responsibilities:

• As an ETL expert, I have lead the design and development of ETL components for Maximo System which is an Asset Management software provides asset lifecycle and maintenance management for all asset types on a single platform.
• Working closely with the business users to understand the requirements and converting them into project level technical capabilities.
• Worked with business analysts to identify the appropriate data elements for required capabilities.
• Participating in the data modeling sessions to understand the data model and providing them inputs based on the existing data to make sure designed model is technically feasible.
• Assisting the systems analysts in source data analysis and in creation of the functional specification documents.
• Working with Project managers to divide the project into smaller modules and helping them in defining the time lines based on the development complexities.
• Assigned the work to development team by creating the individual tasks and updating the status to the project managers.
• Designed and developed Batch Control process to run the ETL sequences in batches for restart ability and recoverability.
• Identifying the common functionality between the processes and created reusable code.
• Extracted the data from various sources like Flatfiles, xml, oracle MS SQL server, queues using ETL and loaded into the ORACLE database or MS SQL server database..
• Created the ETL parallel jobs and sequences for extracting and loading the data using various stages like Flat File, RDBMS, Transformer, lookup, sorter, remove duplicate, Change Capture, joiner etc.
• Designed and developed the parallel jobs for slowly changing dimensions (SCD Type1, Type 2 and Type 3) and fact tables loading.
• Derived the incremental extraction and load logic for each target table based on the source data.
• Created PERL scripts to execute the external programs through ETL and ESP scheduler.
• Performed the performance and tuning at source, Target and ETL job levels using Indexes and Partitioning in MS SQL server database and ETL.
• Creating the Technical Specification documents and conducting the walk through meetings with Systems Analysts.
• Analyzing the dependencies between the jobs and scheduling them accordingly using the ESP Scheduler.
• Investigating and fixing the bugs occurred in the production environment and providing the on-call support.
• Key player in integrating the Maximo Asset management along with Upstream and Downstream interfaces using ETL solution.
• Co-ordinate with the Data Stage Center of Excellence team in tuning the performance of the Data Stage jobs.
• Facilitated the Production move ups of ETL components from Acceptance to Production environment.
• Co-ordinate with the QA team in various testing phases by resolving the defects and ensuring smooth execution of the test plans.

Confidential, Danville, Accenture

Senior Software Engineer

Environment: Informatica 9.1/9.5, IDQ, Informatica Analyst, CDC, Oracle 11g, Teradata 13.10, SQL Server 2008, UNIX Shell Scripting, Tidal 6.1,OLAP - Business Objects.

Responsibilities:

• Acting as sole owner on ETL deliverables. Involved in project from starting phase from creation of BRD, design phase of data model, Development phase for ETL mappings and integration of Universe to current existing wellness project.
• Worked as Subject Matter Expert for the project in delivery and support.
• Created mapping documents ETL developers.
• Had hands on experience of Informatica mappings development, workflow integrations.
• Had Played as Informatica Admin in migrating code from development to production environments.
• Has played vital role and revamping of Informatica folders. Created Source & Target DB connections.
• Modified existing BETQ scripts which runs on Teradata to accommodate new changes in data model.
• Analyzed complex SQL queries written for Microstrategy which facing performance issues.
• Hands on experience of moving data from Stage to Foundation using CDC.
• Extracted data from different sources like SQL server, Oracles.

Confidential

ETL Developer

Environment: Informatica 8.6, Teradata V2R5, SQL Server 2005, UNIX Shell Scripting

Responsibilities:

• Involved in development, unit testing and integration testing of new Informatica jobs.
• Extracted data from legacy systems and put it in the Flat files, DB2 tables for further processing.
• Worked in implementation of user defined functions, initialization scripts for global variables used in during course of Job Execution, working with stored procedures and functions.
• Modified the existing Informatica jobs being used, according to latest requirements.
• Tuned jobs for performance optimization of the resources.
• Responsible for release engineer roles such as, configuring management and deployment.
• Involved in documenting high level design, detail design documents.
• Performed pre-production activities and involved in documenting all the test cases, tuning, enhancements procedures.
• Coding & code walk through, writing detailed unit test plans and test requirements hierarchy, Unit Testing & Preparing Logs. Provide temporary and permanent fixes for the production batch abends.
• Review the deliverables to maintain the quality.
• Oversee the UAT execution for the production fixes.
• Working with different Sources such as Oracle and Flat files. Using Informatica, extracting data into Data Mart built on Oracle.
• Design, Development and Testing of Mappings, Mapplets using Informatica Power Center.
• Understanding the present system and creating / reviewing documents highlighting the system flow.