We provide IT Staff Augmentation Services!

Sr. Informatica Developer/technology Lead Resume

Minneapolis, MN

EXPERIENCE SUMMARY:

  • Over 8 years of experience in the field of IT Industry.
  • Experience in full life cycle of Software Engineering including design, implementation, testing and maintenance.
  • Strong technical and development expertise in Informatica Power Center, Infomatica Data Quality, Oracle SQL, Oracle PL/SQL, UNIX Shell scripting applied predominantly in Health care, Auto finance, Telecom domain as well as Pharmaceutical Sector.
  • Worked in Agile SCRUM development methodology.
  • Worked on tools like Informatica Power center, IDQ, Tivoli Workload Scheduler, Toad, Aqua data studio, SQL developer.
  • Strong analytical and development skills.
  • Thrives in challenging environments with an aptitude for learning and applying new technologies.

TECHNICAL SKILLS:

Data warehousing: Data warehousing concepts

Methodologies: Software Development Life cycle (SDLC) and Agile SRUM Methodology

ETL Tool: Informatica power center 8.6.1/9.1.1 , 9.5.1,9.6. IDQ 9.1

RDBMS: Oracle 9i, Oracle 10g, Oracle 11g/12c, SQL SERVER 2005

Other tools: Toad, SQL Developer, Tivoli workload scheduler, Aqua data studio, Winscp, HPSM, Remedy, Putty.

Configuration Management tools: VSS

Generic tools: MS Word, MS Excel, PowerPoint, MS Excel

Operating System: Windows XP/7/Unix

BUSINESS SKILLS:

  • Business Process Analysis & Research
  • Technical Requirements Development
  • Requirements Gathering
  • Change management (CCR)
  • Gap Analysis and Impact analysis

PROFESSIONAL EXPERIENCE:

Confidential, Minneapolis, MN

Sr. Informatica Developer/Technology Lead

Responsibilities:

  • Tuning the long running Informatica Workflows.
  • Worked on Database of size 45TB and tables with more than 500 million records.
  • Extensively used SQL, PL/SQL in writing Stored Procedures for complex scenarios like master record creation.
  • Created/modified database objects like tables, views, materialized views, procedures.
  • Strong in Unix shell scripting, created complex generalized scripts for processing files based on the command line input. Added logging and lock mechanism as well in the scripts.
  • Job monitoring and defect fixing.
  • Enhancement of existing Informatica mappings and Development of new Informatica Mappings.
  • Worked on Standardizer, labeler, Address validator and Consolidation transformations in IDQ.
  • Extensively used Unix Command like AWK, SED, GREP.
  • Worked closely with Customer and multiple vendors for carrying out day to day business activities and worked on the solutions to some of the complex business requirements/issues.
  • Expertise in Root cause analysis and necessary Test plans to ensure successful execution of the data load Process
  • Understanding Reporting queries written in SAS and doing root cause analysis.
  • Modified existing Unix Scripts to reduce log size.
  • Fixing the data issues business is facing in the data warehouse.
  • Impact analysis for changes that are happening on the existing/new tables.
  • Gatekeeper role for new changes that are moved into production.
  • Worked on Incident, problem tickets and Change management.
  • War - room support for Post Go-Live support activities.
  • Mentored new developers on the business and technical aspects of the project to enable them complete their modules successfully.

Environment: Informatica power center 9.1.1/9.6.1 , IDQ 9.1, Oracle 11g/12c, HPSM, Tivoli workload scheduler, Aqua data studio, Toad, ITG, UNIX

Confidential, Irvine, CA

Informatica Architect /EDW Developer

Responsibilities:

  • Designing business requirement documents by analysing the existing EDW mappings and procedures.
  • Creation of High level and Low level design documents.
  • Creation of data warehouse depending on the new tables in new ERP system.
  • Worked on Agile SCRUM methodology to design ETL mappings to load data from staging layer to data mart layer using Informatica Power Center.
  • Created complete control framework for incremental data load including parameter file creation and exception handling .
  • Created stored procedures to delete the target records in case of more updates and do insert append to improve the performance.
  • Used parallel and full hints, indexing and other ways to tune the SQL queries.
  • Loading data into derived facts and transaction based facts.
  • Created Unix Scripts to alter files as per our requirement.
  • Experience in calling Informatica jobs from Unix Scripts by using PMCMD commands .
  • Loading data into SCD type 1 &2 dimensions.
  • Working with SAP R3 connectors to get the data from SAP and creating ABAP program for the mapping.
  • Unit testing my ETL’s.
  • Creation of deployment group for moving the workflows from lower environments to higher.
  • Created indexe s on the tables for faster retrieval of the data to enhance database performance.
  • Review project/task statuses/issues with the team and ensuring completion of project on time.
  • Created/modified database objects like tables, views, materialized views, procedures.
  • Mentored new developers on the business and technical aspects of the project to enable them complete their modules successfully.

Environment: Informatica power center 9.5.1, SAP R3 connectors, Oracle 10g, SQL Developer, Toad, UNIX, Putty, Control M, Erwin.

Confidential, Chicago, IL

Informatica Developer

Responsibilities:

  • Creating mappings Using complex logics in Informatica Tool to populate promote or demote notification for a partner by using their competencies.
  • Extensively worked on Unix shell scripting.
  • Worked with email, command tasks, Mapplets, Reusable Transformations and worklets.
  • Performed Unit testing, system testing and regression testing.
  • Work closely with Customer and multiple vendors for carrying out day to day business activities and working on the solutions to some of the complex business requirements.
  • Tuned performance of mapping and sessions by optimizing source, target bottlenecks and implemented pipeline partitioning.
  • Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL
  • Developed materialized views for data replication in distributed environments
  • Used SQL LOADER to load data from files into testing environments.
  • Involved in Performance tuning at source, target, mappings, sessions level.
  • Scheduling workflows through Workflow scheduler.

Environment: Informatica power center 8.6.1, Oracle 10g, Toad, UNIX, Putty.

Confidential, Indianapolis, IN

SQL Developer

Responsibilities:

  • Creation of Live reports and web reports .
  • Migration of new data into the tool.
  • Troubleshooting the issues faced by users.
  • Tool administration.
  • Folder creation and group creation.

Environment: Livelink, SQL SERVER 2005, Visual source safe

Confidential

Software Developer

Responsibilities:

  • Gathering different requirements that need to be considered while evaluating the Customer.
  • Developing the code using java.
  • Creation of SQL scripts to load data into tables.
  • Creation of PPT’s to explain the process.
  • Unit testing.

Environment: Java, Tomcat, SQL

Hire Now