We provide IT Staff Augmentation Services!

Informatica Developer Resume

CAREER OBJECTIVE:

To become a successful professional in the field of IT and to work in the best way I can, in an innovative and competitive world, by keeping my earnest enthusiasm to carry out the best advancements.

PROFILE SUMMARY:

  • 6.2 years of overall experience in the organization, 3.5 years of experience in Informatica Power Center and 2.5 years in ITIL.
  • Currently working as development team.
  • Experience in ETL\DWH development and testing.
  • Experience in DWH concepts like star schema, snow flake schema, fact table, dimension table etc.
  • Experience in ETL methodology for supporting Data Extraction, Transformation and loading process in corporate - wide-ETL solution using Informatica 9.1, 9.6
  • Excellent communication skills.
  • Able to create Job, Effective Documentation, Test Cases, Test results and Issue Reports.
  • Quick learner, adaptable and flexible to the ever-changing technology and confident.
  • Ability to engage in multiple projects simultaneously.
  • Maintain and develop the client relationship by giving continuous service improvement.
  • Responsible to achieve uptime commitment as defined in SLA.
  • Ability to accept challenges and complete the task on time.
  • Hands on creating mapping, testing and preparing test cases.

TECHNICAL SKILLS:

Oracle, Informatica power center, Qlikview (Training in progress), Unix (Basic commands)

PROFESSIONAL EXPERIENCE:

Confidential

Informatica Developer

Software Application: Power Center Client Informatica tool (V9.6.1) Tidal, GitHub, hpsb tool, Winscp, putty Oracle database (11g), sql server, seeburger tool, FileZilla tool

Responsibilities:

  • We are responsible for analyzing, implementation and coding.
  • Extensively worked on Informatica Power center tools like Designer, workflow manager and workflow monitor and schedule sessions and workflows through Tidal.
  • We work on Oracle Database and files(.csv) and used Unix directories for archiving files.
  • Prepared test cases by understanding the business requirements data mapping documents and technical specifications.
  • Understanding HLD, LLD and designed mapping accordingly.
  • As L4 team, we are handling multiple applications and working on development, code changes, implementation and testing.
  • Tidal is scheduler and is used to scheduled informatica jobs, hence we are monitoring jobs through tidal.
  • If any code changes required in Production, we raise 21 days RFC and follows the procedures for moving from ITG environment to Production Environment. Code moving to prod is done by Admin team.

Confidential

Software Application: Power Center Client Informatica tools, Control-M, Oracle database.

Informatica Developer

Responsibilities:

  • Designing mapping with the help of Informatica designer tool with various transformations used.
  • Extensively worked on Informatica Power center tools like Designer, workflow manager and workflow monitor and schedule sessions and workflows through Control-M.
  • Prepared test cases by understanding the business requirements data mapping documents and technical specifications.
  • Provide timely test reports and defect indicators. Tested the ETL mapping from source to target.
  • Performed SQL validation to verify the data extract and record counts in the database tables by writing SQL queries.
  • Understanding HLD, LLD and designed mapping accordingly.
  • Prepared SQL queries and executed to validate the ETL processed data in target database.
  • Verifying the column mapping between source and target databases.
  • Have Experience to work in team environment and escalate the defects to specified team.

Confidential

Informatica Developer

Responsibilities:

  • Evaluate business requirements
  • Come up with High Level Design
  • Develop mapping that follow the Informatica standards
  • Pre-Production process were followed.

Hire Now