We provide IT Staff Augmentation Services!

Informatica Developer Resume

SUMMARY

  • 8 years of IT industry experience encompassing a wide range of skill set, roles and industry verticals
  • 5 yrs experience in Informatica, involved in system study, design, development, maintenance and testing stages of various projects
  • 2 yrs experience in Mainframe with Informatica
  • Proficient in analyzing and translating business requirements to technical requirements and architecture
  • Having Experience as a Tech Lead/ Programmer Analyst/Onsite Coordinator
  • Understanding of all phases of Project Life Cycle/SDLC including Requirement gathering, Analysis, Design, Development, Implementation and Testing
  • Strong skills in Data Analysis, Data Requirement Analysis and Data Mapping for ETL processes
  • Strong experience in Data Warehousing and ETL using Informatica Power Center 9.1
  • Strong experience in developing the complex SQL queries, unions and multiple table joins
  • Worked on UNIX shell scripts to run the Informatica workflows and controlling the ETL flow
  • Experience with dimensional modeling using star schema and snowflake models
  • Excellent ability to determine appropriate system test scenarios, create end - user Business procedure guides, and provide hands-on guidance and training where necessary
  • Have a sound knowledge on estimation of the project using the Function Point counts

TECHNICAL SKILLS

Operating System: UNIX, Windows

Programming Languages: UNIX Shell scripting, SQL

Database skills: Teradata, Oracle

Tools: PL/SQL developer, Autosys

ETL Tool: Informatica

Processes: Clear Quest

Estimation: Function Point Counting

PROFESSIONAL EXPERIENCE

Informatica Developer

Confidential

Responsibilities:

  • Analyze the requirements from the customers and coordinating with the technical team and providing resolution of any technical issues
  • Provide current application design, architecture and application details for ICD-10 and System replacement project for CA-MMIS
  • Created the system functional design document and Technical design document
  • Worked on ETL programs using Informatica to implement the business requirements
  • Extensively worked on Informatica Power Center 9.1 - Data extraction, Transformation and loading data from various sources like Oracle and Flat files
  • Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTF connections and relational connections
  • Used Informatica Power Center Workflow manager to create sessions, workflows and batches to run with the logic embedded in the mappings
  • Used various transformations like Source Qualifier, Expression, Aggregator, Joiner, Filter, Lookup and optimizing the Mapping
  • Created shell scripts to fine tune the ETL flow of the Informatica workflows
  • Used debugger to identify bugs in existing mappings by analyzing data flow, evaluating transformations
  • Performed unit testing Confidential various levels of the ETL and actively involved in team code reviews
  • Mentored new team members to help them understand the application better and quickly

Environment: Informatica, Oracle

Informatica/Mainframe Developer

Confidential

Responsibilities:

  • Deliver new and complex high quality solutions to clients in response to varying business requirements
  • Coding, code reviews and testing with Unit test case preparation and execution.
  • Develop implementation and test plans and deliver the product to System Analyst for system testing.
  • Reviewed the design, test case records and stored in Rational Portfolio Management (RPM) and PRISM tools for tracking purpose.
  • Month end process, creation of file processing reports, error file processing reports etc
  • Created mappings and sessions to implement technical enhancements for data warehouse by extracting data from sources like Teradata and Delimited Flat files
  • Used various transformations like Source Qualifier, Expression, Aggregator, Joiner, Filter, Lookup and optimizing the Mapping
  • Effectively worked on Onsite and Offshore work model
  • Performed unit testing Confidential various levels of the ETL and actively involved in team code reviews
  • Developed Teradata, Fastload, Multiload and Bteq scripts

Environment: Teradata, Informatica

Application Developer

Confidential

Responsibilities:

  • Self and independent testing of enhancements made in the system with respect to the new business requirements
  • Utilized COBOL, JCL and CICS in the coding and testing data extraction
  • RPM is being used to track every phase of the projects assigned
  • Analyzed and tested new systems using Xpediter, IBM Utilities, and Eztrieve
  • Created reporting programs which eliminated erroneous and redundant submission
  • Developed CICS online update and inquiry screens

Environment: COBOL, COOL: Gen, DB2, CICS

Hire Now