We provide IT Staff Augmentation Services!

Agile Informatica Developer Resume

Irvine, CA

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.

Hire Now