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