SUMMARY

• SDLC: 7 years exposure in overall SDLC including requirement gathering, development, testing, debugging, deployment, documentation, production support.
• Data Warehousing: 7 years of Experience in Extraction, Transformation, and Loading (ETL) using Informatica Power Center 8.5.1/7.1.4/6.2 ,
• Databases: Seven Plus (7+) years experience in dealing with various Data sources like Oracle, SQL Server, Ms - Access, COBOL, Excel, Flat files, Teradata, DB2.
• Data Modeling: Extensive experience in Analyzing the Dimensional Data modeling, Star Schema/Snowflake modeling, FACT & Dimensions tables, Physical & logical data.
• Business Intelligence: Extensive experience in Business Intelligence tools like Business Objects and Cognos.
• Other: Excellent working knowledge of UNIX shell scripting, job scheduling on multiple platforms. Maintained outstanding relationship with Business Analysts and Business Users to identify information needs as per the business requirement. Excellent problem solving, analytical, written and communication skills with ability to work both in team as well as an individual. Experience working with Onside-Offshore model while co-ordinating with peer developers and resolve issues.

PROFESSIONAL EXPERIENCE

Confidential, Montereypark, CA

INFORMATICA DEVELOPER

Responsibilities:

• Worked with business analyst for requirement gathering, business analysis, and testing and project- coordination.
• Created the Detail Design Documents which have the ETL technical specifications for the given functionality, overall process flow for each particular process, Flow diagrams, Mapping spreadsheets, issues, assumptions, configurations, Informatica code details, shell scripts etc. and conducted meetings with the clients for the Approval of the process.
• Analyzed the existing mapping logic to determine the reusability of the code.
• Handled versioning and dependencies in Informatica.
• Implemented Slowly Changing Dimensions - Type I & II in different mappings as per the requirements.
• Performing ETL & database code migrations across environments.
• Created Mapping Parameters, Session parameters, Mapping Variables and Session Variables.
• Involved in extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings, sessions or system. This led to better session performance.
• Created and maintained the Shell Scripts and Parameter files in UNIX for the proper execution of Informatica workflows in different environments.
• Created Unit test plans and did unit testing using different scenarios separately for every process. Involved in System test, Regression test & supported the UAT for the client.

Environment: Informatica Power Center 8.6, Toad, UNIX Shell Scripting, Oracle, SQL Server, Flat Files, Mercury Quality Center, MS Project, NCA Mainframes for CA7 Job Scheduler.

Confidential, CHARLOTTE, NC

INFORMATICA DEVELOPER

Responsibilities:

• Gathered Business requirements by interacting with Business Analyst team and analyzed the requirements to translate into Technical Specifications.
• Identified the bottlenecks in the sources, targets, mappings, sessions and resolved the problems.
• Performed complex defect fixes in various environments like UAT, SIT etc to ensure the proper delivery of the developed jobs into the production environment.
• Responsible to write complex SQL queries and PL/SQL procedures to perform database operations according to business requirements.
• Worked with the testers closely in determining both medium and high severity defects, that would potentially affect the downstream systems before the release of the project, and also fixed the defects before moving the jobs into production.
• Document all ETL related work per company's methodology.
• Attended production implementation calls and co-ordinated with the build engineers during migration of the code and was highly acknowledged.
• Prepared estimates and tracked each and every tasks and strictly adhered to the estimated deadlines.
• Extensive knowledge in promoting packages (code) across development, test, preproduction and production environment using tools like Computer Associate Harvest package.
• Co-ordinated with Off-Shore team in INDIA.
• Extensive knowledge in promoting packages (code) across development, test, preproduction and production
• Preparation of Test Data/Unit Testing /Integrated testing and generated various test cases.
• Involved in different Team review meetings.
• Worked along with UNIX team for writing UNIX shell scripts to customize the server scheduling jobs.
• Communication with the client for weekly status report.

Environment: Informatica Power Center 8.6, SQL Server, Oracle, Toad, UNIX Shell Scripting, Flat Files, Mercury Quality Center, CVS.

Confidential, CAMDEN, NJ

INFORMATICA DEVELOPER

Responsibilities:

• Interacted with business analysts to gather the business requirements by attending regular meetings with the business community.
• Used Informatica user defined functions to reduce the code dependency.
• Handled versioning and dependencies in Informatica.
• Implemented Slowly Changing Dimensions - Type I & II in different mappings as per the requirements.
• Performing ETL & database code migrations across environments.
• Prepared ETL detail design and unit testing document to outline the flow of data, for testing source/targets counts and field-to-field mappings.
• Provided production support by running the jobs and fixing the bugs.
• Taking the backup of the repository at regular interval depending on the amount of work done.
• Aided in migrating the code across various environments.
• Worked on test cases and test plans.
• Documented the process for further maintenance and production support.

Environment: Informatica Power Center 8.1, Unix Shell scripting, Oracle, SQL, PLSQL, flat files, WinSCP, DB2.

Confidential, BIRMINGHAM, AL

INFORMATICA DEVELOPER

Responsibilities:

• Designed mapping document, which is a guideline for ETL Coding following Standards for naming conventions and Best Practices were followed in mapping development.
• Extensively used Informatica version tasks like Decision, Command, Event Wait, Event Raise, and Email.
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, Sequence Generator, Update Strategy, Rank, Joiner and Stored procedure transformations.
• Optimized the sql override to filter unwanted data and improve session performance.
• Used Debugger to track the path of the source data and also to check the errors in mapping.
• Prepared unit testing document covering field to field’s validations and source to target count.
• Scheduling the workflow comprising of different sessions for their respective mappings in order to load data into Oracle database.
• Handled creation, modifications, and documentation of Oracle Packages, Procedures, Functions, and Indexes.
• Assisted the other ETL Developers in resolving complex scenarios.
• Involved in promoting the folders from Development to Test and Test to Production Environment.
• Involved in different Team review meetings.

Environment: Informatica Power Center 7.1, Oracle lOg, Toad 7.6, Autosys, PL/SQL, SQL*Plus, SQL*Loader, XML, Windows NT 4.0, Cobol, DB2, Sun Solaris Unix 2.6, Unix Shell Scripting.

Confidential, MANHATTAN, NY

INFORMATICA DEVELOPER

Responsibilities:

• Extensively used ETL to transfer data from different source system and load the data into the target database.
• Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data Warehouse.
• Developed number of complex Informatica mappings, mapplets, reusable transformations to implement the business logic and load the data incrementally.
• Extracted data from Oracle and SQL Server and load the data into target database.
• Handled slowly changing dimensions of Type1/ Type 2 to populate current and historical data to dimensions and fact tables in the Data Warehouse.
• Developed Informatica mappings by usage of aggregator, SQL overrides in lookups, source filter in source qualifier and data flow management into multiple targets using router transformations.
• Extensively involved in performance tuning of the ETL process by determining the bottlenecks at various points like targets, sources, mappings, sessions or systems. This led to a better session performance.
• Involved in creating the runbook and migration document (from Development to Production).
• Document the process for further maintenance and support.
• Worked on test cases and use cases.

Environment: Informatica Power center 6.4, PL/SQL, Oracle 9i, Autosys, Toad, Flat file, SQL Server, UNIX Shell Scripting.