SUMMARY

• Having overall 7 years of experience in Informatica Power center, Unix/Linux Shell scripting and Oracle PL/SQL.
• Worked on all Hphases of data warehouse development life cycle, from gathering requirements, ETL design and implementation, and support of new and existing applications.
• Excellent technical and analytical skills with clear understanding of ETL design and project architecture based on reporting requirements.
• Strong knowledge on Data warehousing concepts.
• Emphasized on Performance tuning.
• Domain Knowledge - Data warehousing- Banking and financial Services.
• Experience in Dimentional Data modelling
• Hands-on experience of informatica installation in different environments, configuring, upgrading repositories, defining strategies, developing, testing and migrating code to TEST, QA and PRODUCTION environments. Hands-on experience in very large enterprise wide implementations.
• Informatica admin activities like creation of folders, users and restricting their access; Starting and stopping Informatica ( Infa, Repository, Integration ) services
• Good exposure on UNIX/LINUX shell scripting, SQL and PL/SQL
• Extensively worked on performance tuning of existing mappings/sessions.
• Highly skilled, self-motivated team player, outstanding organizational and excellent communication and interpersonal skills with results oriented dedication towards goals.
• Ability to work independently and deliver projects within deadlines
• Completed corporate development courses such as: ‘Listening Skills’, ‘Problem Solving’, ‘Time Management’, ‘Diversity Awareness’, ‘Negotiating’, ‘Project Management’, ‘Ethics & Code of Conduct’.
• Deduced many important ideas which eventually led to the development of many tools within and Confidential my project scope.
• Created “Informatica Analyser” tool for analyzing the whole repository (by doing queries over the OPB tables).

TECHNICAL SKILLS

Technology: Data Wearhousing

Programming Languages: SQL, PL/SQL

Databases: Oracle 9i/10g/11g,SQL Server 2008

ETL Tools: Informatica Power Center 8.1.1,8.6.1,9.1.0,9.5.1

FTP Tool: WinSCP (for secure file transfer between a local and a remote system),Smart FTP

Scripting Languages: Unix/Linux Shell Scripting, Autosys Scheduling

Operating Skills: Windows 98/XP/2000,XP, Vista, Windows 7, Unix, Linux

Version Control Systems: MS Visual Source Safe (VSS)

Other Tools: Toad, SQL Developer, Tortoise SVN

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

SR ETL Developer

Responsibilities:

• The role is to work as a Senior ETL developer/ETL Architect at Controls Room - Confidential and co-ordinate with offshore team on development activities on day to day basis.
• Analyze business requirements to infer and document functional requirements.
• Works on technical specifications, design and development of informatica mappings and workflows for data centric applications and is needed to augment and strengthen our capabilities in this space.
• Managed Functional modules independently and merge work as required per release schedule.
• Managing and co-coordinating work items and deliverables across team located onsite and offshore.
• Writing and Executing the Test Cases for the ETL BUILD.
• Design, document and develop solutions based on functional requirements using Generic ETL Framework.

Environment: Informatica, Oracle, Unix, SQL Server database, Cognos and Qlikview as a reporting application, SVN, Autosys Scheduler

Confidential, Houston, Texas

Architect/Lead Developer

Responsibilities:

• Architected solutions for business problems.
• Involved in all the phases of SDLC (Software Development Life Cycle).
• Actively involved with Installation of INFA PowerCenter 8.6 Hotfix 5 on Dev, QA & Prod environments.
• Maintained logical/physical data models.
• Converted the business requirements into technical specifications for ETL process.
• Designed and developed complex mappings to handle complex business logic.
• Created Global Cache using persistent cache property of lookup to improve performance.
• Worked with System owners to resolve source data issues and refine transformation rules.
• Used UNIX scripts to perform sanity checks like data files availability, check header/trailer records, row counts, logging in processing status to status tables.
• Worked/created AUTOSYS jobs for scheduling and automating the process.
• Configured alerts to alert support resources and business users on failures, errors, completion of the jobs.
• Extensively used various Informatica components like parameters, variables and partitioning to gain performance.
• Ensured performance metrics are met and tracked.
• Worked with Memory management for the better throughput of sessions containing Lookup, Joiner, Sorter and Aggregator transformations and involved in pipeline partitioning.
• Applied Informatica Performance and Tuning Logic and tuned the SQL statements by passing Optimizer Hints wherever applicable.
• Created packages and procedures to drop, recreate indexes and truncate tables.
• Performed and documented impact analysis of the business requirement changes.
• Participated in design and development reviews.
• Wrote and maintained unit tests and QA Reviews.
• Performed production migrations.
• Automated code migration & deployment process from one environment to another.

Environment: Informatica, Oracle, Unix, SVN, Autosys Scheduler

Confidential, Houston, Texas

ETL Developer

Responsibilities:

• Involved profoundly in data analysis.
• Performed and documented impact analysis of the business requirement changes.
• Conducted series of discussions with end users and Business analysts to understand the requirements.
• Coordinated with functional analysts to design the ETL process according to the business requirements.
• Converted the business requirements into technical specifications for ETL process.
• Designed and developed complex mappings to handle complex business logic.
• Worked on SCD data coming from transactional systems.
• Created, tested and implemented an automated reusable scheduler.
• Worked with the team to create client specific change management request form and defect analysis document for testing purposes.
• Worked on AUTOSYS jobs for automation.
• Involved in unit, system integration and regression testing the entire application.
• Handled client specific code migration process.
• Extensively worked on performance and tuning of existing mappings/sessions.
• Knowledge transfer and transition.
• Developed UNIX Scripts performing keyless SFTP.
• Worked/created AUTOSYS jobs for scheduling and automating the process.

Environment: Informatica Power Center 9.1.1/8.6, Oracle 11g/10g, PL/SQL Developer, UNIX Shell Scripting, SVN, AUTOSYS Scheduling