SUMMARY

• 15+ years of experience in Data warehousing Design, Development, Testing, Maintenance, Enhancement and Production Support environments.
• Extensive experience in all phases of software development life cycle including Requirements gathering and Analysis, Design, Development, Testing, Deployment,Implementation and Production support.
• Strong working experience on DSS (Decision Support Systems) applications.
• Expertise in Informatica PowerCenter, Oracle, Teradata, PL/SQL, shell scripting.
• Experienced in managing the team both Confidential Onsite and Offshore as Technical Lead and Solution Architect.
• Extensive experience in ETL design, development and maintenance using Informatica Power Center 7.x/8.x/9.x/10.x, Oracle, Teradata, SQL, PL/SQL, SQL Loader.
• Experience in Informatica Administration; experience in domain, repository version upgrdes, new Installtion, Deployment Activities; Repository maintenance - backup /restore.
• Experience in RDBMS systesms, conceptual/logical/physical data models, Dimensional/Star/SnowFlake Schemas and Slowly Changing Dimensions.
• Strong skills in Data Analysis, Data Requirement Analysis and Data Mapping for ETL processes.
• Extensive experience in Production environment.
• Experience in Unix Shell scripting.
• Experience in performance tuning of Informatica Sources, Targets, Mappings, Transformations & Sessions.
• Experience in Value addtions and Optimization of production jobs.
• Expertise in Planning and Testing in various phases including Unit, Assesmbly, System Testing and Performance /Load Testing.
• Experience in integration of various data sources like Teradata, Oracle, and DB2, Flat Files, XL files, etc.,.
• Extensive Experience with Teradata Utilities FastExport, FastLoad and Mload.
• Worked extensively with complex mappings using Expressions, Joiners, Routers, Lookups, and Update strategy, Source Qualifiers, Aggregators to develop and load data in to different target types.
• Extensive experience in creating the Workflows, Worklets, Mappings, Mapplets, Reusable transformations and scheduling the Workflows and sessions using Informatica Power Center.
• Experience in programming with PL/SQL.
• Experience in Sales Ordering System - CRM & OMS
• Experience in management activity - preparation of Estimation & Schedule, Metrics and SQA processes
• Experience in Dimensional Modeling tool ERWIN and reporting tools COGNOS and Business Objects.

TECHNICAL SKILLS

ETL Tools: Informatica PowerCenter, Informatica IDQ,DataStage, Oracle Data Integrator

Business Intelligence Tools: Business Objects,Cognos, MicroStrategy

Languages: SQL, PL/SQL, SQL*Plus, C, C++, Java,Scala,Python, UNIX Shell scripting.

Databases: Teradata, DB2, Oracle 11g/10g/9.i/8.i

Utilities/Tools: Cassandra,Vertica, Toad, Teradata SQL Assistant, SQL* Loader, PL/SQL, Core FTP,Erwin,Oracle SQL Developer,Quality Center, Teradata Utilities - Fload,Mload,FastExport

Operating Systems: Windows 98/2000/NT/XP, AIX, SUN OS, RHEL

PROFESSIONAL EXPERIENCE

Confidential

Sr. ETL Developer / Technical Lead

Responsibilities:

• Prepared Impact Analysis, Understanding Documents.
• Prepared Estimates for CR’s and WR’s.
• Prepared Desing Documents, User Strories.
• Design and Development of Informatica mappings, sessions and workflows, stored procedures, shell scripts, etc.,
• Worked on performance improvement and query tuning.
• Woked on Informatica Administration, upgrades, maintenance, deployments, user creation, access controls
• Conducted reviews for development and testing.
• Production Support overview: Execution, monitoring the production jobs, backup maintenance, data validations, client communication on production cycles, issues, delays, adhoc fixes etc.,
• Identified Optimizations and Value Adds in the project and development and oversight.
• Onsite - offshore co-ordination.

Confidential

Sr. ETL Developer / Technical Lead

Responsibilities:

• Prepared Impact Analysis / Understanding Documents.
• Prepared Estimates for CR’s and WR’s.
• Prepared HLD (High Level Design Documents) and DD ( Detailed Design Documents ).
• Coding: Creating mappings, sessions, worklets and workflows, writing shell scripts.
• Testing: Writing Unit and Integration Test Plans, Conducting Unit and Integration Testing.
• Code Review: reviewing the code developed by other team members.
• Production Support:Running, monitoring the production jobs, backup maintenance, data validations, communicating with clients regarding production cycles, issues, delays, adhoc fixes etc.,
• Contributing in Optimizations and Value Adds in the project .
• Onsite - offshore co-ordination.

Confidential

Technical Lead

Responsibilities:

• Attending Business Requirements meetings.
• Preparing Impact Analysis / Understanding Documents.
• Preparing HLD (High Level Design Documents) and DD ( Detailed Design Documents ).
• Informatica Coding: Creating mappings, sessions, worklets and workflows.
• PL/SQL: creating Functions,Procedures and Packages.
• Testing: Writing Unit and Integration Test Plans, Conducting Unit and Integration Testing.
• Code Review: reviewing the code developed by other team members.
• Supporting UAT and System Test.
• Production, Lab cycle support, on failure cycle recovery, data validations.
• Creating Build Trun Over documents.
• System Test, Lab and Production deployment validations.
• Perform as on-site co-ordinator when Confidential onsite and as Development lead Confidential offshore
• Contributing in Optimizations and Value Adds in the project .

Confidential

Technical Lead

Responsibilities:

• Attending Business Requirements meetings.
• Preparing Impact Analysis / Understanding Documents.
• Preparing HLD (High Level Design Documents) and DD ( Detailed Design Documents ).
• Informatica Coding: Creating mappings, sessions, worklets and workflows.
• PL/SQL: creating Functions,Procedures and Packages.
• Testing: Writing Unit and Integration Test Plans, Conducting Unit and Integration Testing.
• Code Review: reviewing the code developed by other team members.
• Supporting UAT and System Test.
• Production, Lab cycle support, on failure cycle recovery, data validations.
• Creating Build Trun Over documents.
• System Test, Lab and Production deployment validations.
• Perform as on-site co-ordinator when Confidential onsite and as Development lead Confidential offhsore
• Contributing in Optimizations and Value Adds in the project .