SUMMARY:

• 6+Years of experience in IT industry with extensive experience in Design (Logical, physical), Development,testing and Admin Activities.
• Primary skills and experience working with Informatica, Teradata, Autosys and Informatica Admin Activities.
• Secondary Skills with Oracle, DB2, Netezza, Data stage, IDR, Talent for Big data
• Experienced in Data - modeling/Data-profiling
• Experienced in developing Packages, procedures, functions, Partitions and views.
• Excellent Knowledge and Experience in Business Intelligence and Data Warehousing.
• Have working knowledge for Star Schema Modeling, and Snowflake modeling, FACT and Dimensions tables.
• Experience in full life-cycle database including logical and physical design, data modeling, andimplementation.
• Experience in Database Performance Tuning, Performance Monitoring and Query Optimization usingTeradata Explain and Table partitioning.
• Experience working with Teradata utilities Multiload/Fastload/BTEQ to load data from flat files/database tothe Teradata database.
• Have worked on Agile Methodology.
• Worked on Batch Jobs
• Knowledge of reporting tools BO,MSRS and Cognos
• Have also worked on network/Telecom support project for some time.
• Developed excellent professional skills by working independently and also as a team member to analyze theFunctional/ Business requirements and to prepare Estimation of work including Analysis, code, Test plans, Test scripts, Test cases for manual testing.
• Strong trouble shooting capabilities and problem solving and team leading capabilities
• Worked with team of 4-6 Associates as part of the on shore-offshore model.
• Good Exposure to Big data/Hadoop technology.
• Excellent Troubleshooting, Analytical and Interpersonal skills.
• Open to take up challenging tasks.
• Ability to grasp new technology and tools quickly
• Certified Power Center Data Integration 9.x:Developer Specialist

TECHNICAL SKILLS:

Operating Systems: AIX, Linux, Sun Solaris, Windows 2000/XP

RDBMS: Oracle, Teradata, DB2, Netezza

Languages: SQL, PL/SQL, Unix

Tools: and Utilities: PL/SQL Developer, INFORMATICA, Data stage, BO, AUTOSYS IXP, CA Service Desk,HPOV, SCM

PROFESSIONAL EXPERIENCE:

Agile Informatica Developer

Confidential - Irvine, CA

Responsibilities:

• Gathering requirements, understand and sharing the details with support team and users.
• Developed PL/SQL Packages, Procedures and Functions accordance with the business requirements forloading data into database tables.
• Worked on Slowly Changing Dimensions Type 2 and Type 1.
• Used and created different reusable components from Reusable User Defined Variable to Maplets.
• Used Pre/Post SQLs
• Used Oracle Reusable Packages/SEQGEN in the mappings
• Loaded ODS tables and EDW tables.
• Develop the mapping and workflows based on requirement
• Involved in Development, unit, performance and integration testing for the jobs
• Created Autosys jobs
• Worked on Informatica Data Replicator (IDR) tool.
• Used NZ scripts to load the Data to NZ DB.
• Worked on Agile Methodology

Environment: /Tools/Technologies: Linux, Autosys, Informatica PC, IDR, Toad, Netezza, Oracle

Informatica Admin

Confidential - Phoenix, AZ

Responsibilities:

• Support the Informatica Grid environments
• Support newly introduced Informatica TDM and DVO utilities
• Supported PWX for DB2, cdc and data files. monitor and work for PWX starter tasks and restart tokens
• Supported the Informatica Analyst project
• Work on any on the services failures using the admin console and using the infa commands.
• Work on different adhoc requests using different infa commands or metadata table queries.
• Monitor the Informatica Health and Automate the critical Alerts
• Work on regular Admin activities as per request (Creating Connection String, Native Access Groups,Assigning the IS, File changes, Permission/Owner changes, Seq Reset, ..)
• Creating the Deployment group in Lower environment and migrating them to Production.
• Trouble shooting the long running jobs, Crashes, Service restarts, Performance improvement suggestion toApplication Team, Any configuration Changes in Admin Console as per improving the system
• Work on the Cognos/Micro strategy admin activities.

Environment: /Tools/Technologies: AIX, Linux, Mainframe, Informatica Family(PC, Analyst, TDM, DVO), Micro strategy, Cognos

Informatica Developer

Confidential - Detroit Lakes, MN

Responsibilities:

• Worked on Agile Methodology with 2 Week sprint
• Created the HLD and then LLD and get it approved with TL and then the Architect
• Preparing documentation for requirements, design, install and Unit testing
• Developed the code using creating reusable components
• Prepared the final Handover Document

Environment: /Tools/Technologies: AQT (DB2), UNIX, Informatica

Informatica Developer

Confidential - San Antonio, TX

Responsibilities:

• Involve in the discussion with Business to clarify the requirement
• Involve in the discussion with testers to get the scenarios checked
• Created the HLD and then LLD and get it approved with TL and then the Architect
• Preparing documentation for requirements, design, install and Unit testing
• Keeping in touch with other development team to make sure we are in right direction and checking theprogress time to time
• Develop the mapping and workflows based on requirement
• Involved in Development, unit, performance and integration testing for the jobs
• Creating the Implementation plans and reviewing with team before the implementation date.

Environment: /Tools/Technologies: AQT (DB2), UNIX, Informatica

Data Analyst

Confidential - Cincinnati, OH

Responsibilities:

• Meet with Business to get the requirements, improvements and suggestion
• Meet with the Source System teams to get the changes and replicate to ETL side as required
• Gathering requirements, understand and sharing the details with development team.
• Data profiling, Data modeling and then creating the Technical Specs
• Preparing documentation for requirements, design, install and Unit testing
• Keeping in touch with development team to make sure we are in right direction and checking the progresstime to time
• Involved in Development, unit, performance and integration testing for the jobs
• Develop test cases and review the Unit testing.
• Creating the Implementation plans and reviewing with team before the implementation date.
• Knowledge of US Financial and Credit and Risk team with in it.

Environment: /Tools/Technologies: AQT (DB2), UNIX, Datastage

Informatica Developer

Confidential

Responsibilities:

• Designed the ETL processes using Informatica to load data from Mainframe DB2, Oracle, SQL Server, FlatFiles, XML Files and Excel files to target Teradata warehouse database.
• Designed Reusable Transformations, Mapplets, reusable Tasks and designed Worklets as per thedependencies of various sessions and parent-child tables.
• Worked on Teradata utilities BTEQ, MLOAD and TPUMP and tuned SQL.
• Created Oracle stored procedure, package and triggers. Worked on analytical query to format report. Createdmaterialized view to store summarized data.
• Investigate, debug and fix problems with Informatica Mappings and Workflows.
• Implemented SCD - Type I & II in different mappings as per the requirements.

Environment: /Tools/Technologies: Informatica Power Center 8.6, Oracle 11g, UNIX Shell Scripting, SQL, Autosys, Teradata 12, Utilities BTEQ, FLOAD, HPOV.