We provide IT Staff Augmentation Services!

Etl Informatica Developer Resume

Pompano Beach, FL

SUMMARY:

  • Aiming at constant up gradation both professionally as well as personally in my career path with emphasis on sincerity in work to pursue a result oriented career in information and technology constituting challenging opportunities in a dynamic environment.
  • 4.5 Years of experience in IT Industry including expertise in Analysis, Design, Development, Implementation, Modelling, Testing, and support for Data warehousing applications and 2 years of experience as Lecturer in reputed engineering colleges in India.
  • Involved in Full Life Cycle Development of building a Data Warehouse.
  • Clear understanding of Data warehousing and Business Intelligence concepts with emphasis on ETL and life cycle development Using Power Center, Repository Manager, Designer, Workflow Manager and Workflow Monitor.
  • Knowledge of complete SDLC including Requirement Analysis, Requirement Gathering, Project Management, Design, Development, Implementation and Testing.
  • Excellent communication and interpersonal skills. Ability to work effectively working as a team member as well as an individual.
  • International Publication under IRACST on Security Threats in Mobile Ad - Hoc Network.
  • Publication under JCT on Identification and Removal of malicious nodes in Mobile Ad-Hoc Network and Black Hole Attack in Wireless Ad-Hoc Network.
  • International Publication under IJCA on Result analysis of Virtual IP address Configuration Protocol.
  • International Conference on Virtual IP Generation and Allocation Technique in ICIIA, Singapore.
  • National Publication under ISTE on Topic IPv4 versus IPv6.

IT SKILLS:

ETL Tool: Informatica Power Center 9.1/8.6/8.5/8.1/7.1 (Designer, Workflow Manager, Workflow Monitor, Repository manager and Informatica Server)

Databases: Oracle 11g/10g/9i/8i, MS SQL Server 2008/2005, MS Access. Data Warehouse.

Programming: SQL, PL/SQL, C, C++, Java, Unix Scripting.

Operating System: RED HAT LINUX 5.0, UNIX (SOLARIS8, AIX) & WINDOWS NT/2000 Technologies: XML

PROFESSIONAL EXPERIENCE:

Confidential, Pompano Beach, FL

ETL Informatica Developer

Responsibilities:

  • Responsible for Business Analysis and Requirements Collection.
  • Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
  • Parsed high-level design specification to simple ETL coding and mapping standards.
  • Designed and customized data models for Data warehouse supporting data from multiple sources on real time
  • Created Tables, Keys (Unique and Primary) and Indexes in the SQL developer.
  • Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
  • Created mapping documents to outline data flow from sources to targets.
  • Extracted the data from the flat files and other relational databases into staging area and populated onto Data warehouse.
  • Maintained stored definitions, transformation rules and targets definitions using Informatica repository Manager.
  • Used various transformations like Filter, Expression, lookup, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
  • Developed mapping parameters and variables to support SQL override.
  • Used existing ETL standards to develop these mappings.
  • Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment, Timer and scheduling of the workflow.
  • Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.
  • Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables
  • Modified existing mappings for enhancements of new business requirements.
  • Involved in Performance tuning at source, target, mappings, sessions, and system levels.
  • Prepared migration document to move the mappings from development to testing and then to production repositories.
  • Constantly interacted with business users to discuss requirements.

Confidential, Louisville, KY

ETL Informatica developer

Responsibilities:

  • Developed ETL programs using Informatica to implement the business requirements.
  • Communicated with business customers to discuss the issues and requirements.
  • Created shell scripts to fine tune the ETL flow of the Informatica workflows.
  • Used Informatica file watch events to pole the FTP sites for the external mainframe files.
  • Production Support has been done to resolve the ongoing issues and troubleshoot the problems.
  • Performance tuning was done at the functional level and map level. Used relational SQL wherever possible to minimize the data transfer over the network.
  • Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.
  • Involved in enhancements and maintenance activities of the data warehouse including tuning, modifying of stored procedures for code enhancements.
  • Effectively worked in Informatica version based environment and used deployment groups to migrate the objects.
  • Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.
  • Effectively worked on Onsite and Offshore work model.
  • Pre and post session assignment variables were used to pass the variable values from one session to other.
  • Designed workflows with many sessions with decision, assignment task, event wait, and event raise tasks, used informatica scheduler to schedule jobs.
  • Reviewed and analyzed functional requirements, mapping documents, problem solving and trouble shooting.
  • Performed unit testing at various levels of the ETL and actively involved in team code reviews.
  • Identified problems in existing production data and developed one time scripts to correct them.
  • Fixed the invalid mappings and troubleshoot the technical problems of the database.

Environment: Informatica 8.6.1 ,SQL Server 2008 R2, HP-UX

Hire Now