We provide IT Staff Augmentation Services!

Informatica Developer Resume

3.00/5 (Submit Your Rating)

SUMMARY

  • 10+ years of experience in Requirement Analysis, Functional/Technical Analysis, Design, Development, implementation, Testing, Debugging, Productions Support, and Maintenance of various Data Warehousing Applications.
  • Experience in Analysis, Design, Development, Testing and Implementation of Business Intelligence applications using QlikView and over 2+ years of experience as Qlik Sense application developer.
  • Data Warehousing experience using Informatica Power Center 10.1/0.9.6/9.5/9.1/8.6./8. x, Power connect, Repository Admin console, Repository Manager, Designer, Workflow Manager, Workflow Monitor, ETL, Data mart, OLAP, OLTP.
  • Experience with Database Systems like Oracle 11g/10g, MS SQL Server, Teradata and DB2.
  • Excellent experience in extraction, transformation and loading the data from various source databases to target database.
  • Implemented Slowly Changing dimensions Type 1 and Type 2, methodology for accessing the full history of accounts and transaction information.
  • Working closely with architects for requirement gathering and working with teams on the solution
  • Involved in Full Life Cycle Development of building a Data Warehouse.
  • Experienced in Performance of Mapping Optimizations in Informatica.
  • Experienced in the Analysis, Design, Development, Testing, and Implementation of business application systems for Pharmaceutical, Financial, Insurance, Telecommunication and Manufacturing Sectors.
  • Strong knowledge in designing and developing QlikView and QlikSense dashboards by extracting data from different sources like Sales Force, SQL Server, Oracle, SAP, Flat Files, Excel files, XML Files.
  • Experience in optimizing QlikView and QlikSense applications to improve the performance.
  • Developed QlikView and QlikSense objects like Multi Boxes, Straight tables, Pivot tables, Containers, Line charts, Bar charts, Combo charts, Scatter charts, Line objects, Pie charts, Buttons.
  • Proficient in troubleshooting and fixing the QlikView and QlikSense dashboard issues.
  • Extensive experience in creating Pixel Perfect reports, Excel reports, Word reports, PowerPoint reports using NPrinting designer and automating the jobs in NPrinting Server.
  • Hands on experience in customizing the QlikView and NPrinting reports as per the business requirements.
  • Worked in Agile methodology environments and involved in scrum meetings.
  • Experience on QlikView Scripting, Set analysis and Section Access.
  • Scheduled the jobs and distributed to end users from QMC.
  • Experience in database programming, SQL, Tables, Views, Indexes, Joins, and Sub - Queries.
  • Trained end users to develop and use QlikView and QlikSense applications.

TECHNICAL SKILLS

ETL Tool: Informatica,SSIS,DataStage

Databases: Oracle, SQL Server, Terdata, DB2

Programming: C, C++, .Net, SQL, PL/SQL, VB-Script, Html

Reporting Tools: QlikView, QlikSense, Tableau,Cognos,Business Objects

Others: QViewer, Kdiff, Toad, Putty, Rally, Tidal, MS Office, IBM Data Studio, IP Switch

Operating Systems: Windows, Unix

PROFESSIONAL EXPERIENCE

Informatica Developer

Confidential

Responsibilities:

  • Involved in gathering business requirements, analysis, development, testing, and production support of client application.
  • Involved in discussions with business analysts for gathering requirements, understanding the requirements and explanation of technical probabilities and Application flow.
  • Involved in developing Logical and Physical data models that capture current state Developed and tested all the Informatica Data mappings, sessions and workflows.
  • Produced data models to meet functional data requirements. Data modeling at the enterprise level through to ETL and application.
  • Developing mappings to extract the Data from XML files and loading them into stage files.
  • Processing mapping and Data Load mapping through DB2
  • Experienced in creating complex mappings efficiently for full target tables in Power Center Designer using Unconnected and Connected Look up, Update Strategy, Router and Union etc.
  • Worked with Informatica Power center client tools like Source Analyzer, Warehouse Designer, Power Exchange Data Capture and Mapping.
  • Developed mappings, transformation logic and processes in Informatica for implementing business rules and standardization of source data from multiple systems into the data warehouse.
  • Created complex Informatica mappings to load the data and monitored them. The mappings involved extensive use of transformations like Aggregator, Filter, Router, Expression, Joiner, Sequence generator and Stored Procedure.
  • Created Mapplets, Sessions, Reusable worklets and Batches in Workflow Manager and Scheduled the sessions at specified frequency.
  • Perform error handling process, debugging and troubleshooting the jobs.
  • Involved in testing process and performing the Unit testing and System testing.
  • Tested applications & reports using predefined review checklists; tested data quality before delivering to users.
  • Coordinated with Onsite team on project development tasks and provided updates to the managers.

Environment: Informatica Power center 10.1.0, IP Switch WS FTP 12, IBM Data Studio

Informatica Developer / Data Analyst

Confidential

Responsibilities:

  • Analyzed business requirements to compose functional and implementable technical data solutions. Identified integration impact to dependent systems, data flows and data stewardship.
  • Produced data models to meet functional data requirements. Data modeling at the enterprise level through to ETL and application.
  • Developing mappings to extract the Data from multiple Flat Files and loading them into staging through CDM database.
  • Worked on Informatica Designer tools like Source Analyzer, Warehouse Designer, Transformation Developer, Mapping Designer and Mapplet Designer.
  • Developed complex mappings in Informatica to load the data from various sources using different transformations like Source Qualifier, Look up (connected and unconnected), Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Update Strategy Rank and Router transformations.
  • Integrated Informatica Data Quality with Informatica Power Center.
  • Created new data constraints and or leveraged existing constraints for reuse.
  • Produced ER diagrams for presentation of requirements and solution review with technical team members, business team members and other leaders and stakeholders.
  • Participated JAD session as Data Analyst in expanding existing DB and developing new ones.
  • Assisted application developers in creating business requirements and transformed requirements into implementable technical data solutions.
  • Perform data flow mapping and create data dictionaries, ensure data integrity from the design standpoint
  • Assist in creating High Level and Detailed Design documentation
  • Work with Architects to create meaningful requirements for Data Warehouse ETL development
  • Work with Data Modelers to perform data analysis, define requirements and data needs
  • Work closely with project and technical teams to identify, define and translate key business requirements into technology specifications. Document the development of the technology and business specifications.
  • Involved in designing, developing, testing, publishing, maintaining, and supporting QlikView&QlikSense applications.
  • Building QVDs, QVWs, QVFs using source systems like Oracle, SQL Server, Excel files, Sales Force & SAP
  • Involved in the requirement analysis and identifying sources and targets.
  • Created QlikView&QlikSense dashboards using different objects like List Boxes, Multi Boxes, Pie charts, Line charts, Funnel charts, Scatter charts, Bar charts, Combo charts, Straight tables, Pivot tables, Buttons, Containers.
  • Created Pixel Perfect reports, Excel reports, PowerPoint reports and Word Reports using NPrinting tool.
  • Created tasks and scheduled the jobs in NPrinting server.
  • Involved in performance tuning of QlikView&QlikSense apps for faster data reloads and efficient response times.
  • Involved in optimizing the existing data models and load scripts to improve the performance.
  • Developed reports in QlikView and in NPrinting and emailed the reports to end users.
  • Sending the updated status report to the managers on daily, weekly and monthly basis.
  • Automated and scheduled daily data loads of QVW documents using QlikView Publisher.
  • Coordinated with Onsite team on project development tasks and provided updates to the managers.

Environment: Informatica Power center 9.6.1, 9.6,Tableau, QlikView, Qlik Sense, QlikView Publisher, QlikView Management Console, Informatica, Microsoft SQL Server, Oracle, SAP

Informatica Developer / Data Analyst

Confidential

Responsibilities:

  • Involved in gathering business requirements, analysis, development, testing, and production support of client application.
  • Involved in discussions with business analysts for gathering requirements, understanding the requirements and explanation of technical probabilities and Application flow.
  • Involved in developing Logical and Physical data models that capture current state Developed and tested all the Informatica Data mappings, sessions and workflows.
  • Flexible and intuitive interface for accessing and validating data across many different databases and platforms.
  • Experienced in creating complex mappings efficiently for full target tables in Power Center Designer using Unconnected and Connected Look up, Update Strategy, Router and Union etc.
  • Worked with Informatica Power center client tools like Source Analyzer, Warehouse Designer, Power Exchange Data Capture and Mapping.
  • Developed mappings, transformation logic and processes in Informatica for implementing business rules and standardization of source data from multiple systems into the data warehouse.
  • Created complex Informatica mappings to load the data mart and monitored them. The mappings involved extensive use of transformations like Aggregator, Filter, Router, Expression, Joiner, Sequence generator and Stored Procedure.
  • Created Mapplets, Sessions, Reusable worklets and Batches in Workflow Manager and Scheduled the sessions at specified frequency.
  • Developed Pre - session and Post-session events to log the archive records.
  • Developed Data Encapsulation routines using TRANSLATE function, PL/SQL stored procedures
  • Gathered functional requirements & developed QlikView dashboards.
  • Developed, enhanced, & maintained QlikView applications. Provided production support to QlikView applications.
  • Used Mapping Loads to eliminate dimension tables & reduce no. of tables & complexity in QlikView data model.
  • Built QVD's from different data sources like SQL Server, Oracle, SalesForce, Excel, CSV and Flat Files.
  • Developed dashboards using different sheet objects like List boxes, Multi boxes, Buttons, Text objects, Input boxes, Scatter charts, Bar charts, Pivot Table, Straight Table, Containers, Slider, Funnel chart.
  • Perform error handling process, debugging and troubleshooting the jobs.
  • Involved in testing process and performing the Unit testing and System testing.
  • Wrote scripts and created batch files for automatic running of QlikView applications.
  • Implemented Set Analysis to improve the calculation times on the front end.
  • Designed the daily refresh process and created tasks and triggers using QMC.
  • Implemented Direct Discovery feature to fetch Live Data from huge fact table that consists of user's information.
  • Tested applications & reports using predefined review checklists; tested data quality before delivering to users.

Environment: Informatica 9.5, 9.6,QlikView, QlikView Publisher, Microsoft SQL Server, Oracle, Excel, Access, Sales force.

Informatica Developer/ Analyst

Confidential - Atlanta, GA

Responsibilities:

  • Analyzed business requirements to compose functional and implementable technical data solutions. Identified integration impact to dependent systems, data flows and data stewardship.
  • Identified implementation impacts as they affect business processes. Worked with multiple team members technical and business subject experts.Produced data models to meet functional data requirements. Data modeling at the enterprise level through to ETL and application.
  • Created new data constraints and or leveraged existing constraints for reuse. Produced ER diagrams for presentation of requirements and solution review with technical team members, business team members and other leaders and stakeholders
  • Assisted application developers in creating business requirements and transformed requirements into implementable technical data solutions.
  • Perform data flow mapping and create data dictionaries, ensure data integrity from the design standpoint
  • Assist in creating High Level and Detailed Design documentation
  • Work with Architects to create meaningful requirements for Data Warehouse ETL development
  • Work with Data Modelers to perform data analysis, define requirements and data needs
  • Work closely with project and technical teams to identify, define and translate key business requirements into technology specifications. Document the development of the technology and business specifications. Provide input to the technical project plan and test plan.
  • Document detailed business requirements and functional documentation; partner with others to identify business requirements and solutions; work with information management resources to translate requirements into information approach, design and implementation.
  • Designed the relational data model for operational data store and staging areas, Designed Dimension & Fact tables for data marts.
  • Extensively involved in various data modeling tasks including forward engineering, reverse engineering, complete compare, creating DDL scripts, creating subject areas, creating DDL scripts, data dictionary, publishing model to PDF and HTML format, generating various data modeling reports.
  • Worked on creatings a Conceptual Data Model, Logical Data Model, and Physical Data Model using Erwin.
  • Designed Informatica ETL Mappings documents, created ETL staging area framework, created data mapping documents, data flow diagram, ETL test scripts etc.
  • Extensively used Erwin and Normalization Techniques to design Logical/Physical Data Models, relational database design.
  • Experience with utilities Informatica Data Quality (IDQ) and Informatica Data Explorer (IDE).
  • Conducted data modeling sessions for different user groups, facilitated common data models between different applications, participated in requirement sessions to identify logical entities.
  • Extensively involved in various data modeling tasks including forward engineering, reverse engineering, complete compare, creating DDL scripts, creating subject areas, creating DDL scripts, data dictionary, publishing model to PDF and HTML format, generating various data modeling reports etc..
  • Extensively involved in creating, maintaining, updating documents like requirement document, database design document, System design document, naming standard procedures, SOPs etc.
  • Analyzed and optimized the existing business processes using Conceptual Models and Data Flow Diagram. The process included performance enhancement requirements assessment and mapping of existing work flow and data flows.

Environment: Informatica Power Center 9.6, Qlikview, Tableau,Erwin,, DB2, MS SQL Server, Teradat, RedHat Linux, PL/SQL,TOAD, Microsoft Project Plan

DWH Data analyst

Confidential, NY

Responsibilities:

  • Gathered Business requirements from the end users and reporting team
  • Participated in the entire life cycle of the project, which involved understanding scope of the project, functionality, Data modeling, technical Architecture document, technical design and complete development.
  • Extensively used ERWIN to design Logical/Physical Data Models, forward/reverse engineering, publishing data model to acrobat files.
  • Designed and developed Operational Data Store, Slowly Changing Dimension, Staging areas etc.
  • Developed technical specifications & business requirement documents, defined KPIs, and identified data sources.
  • Designed & developed reporting applications using QlikView.
  • Created Input boxes, Pivot Tables, Straight Tables, Bar Charts, Buttons, Multi boxes on the User Interface to make the data easily accessible to the users. Implemented data level security using Section access
  • Analyzed the QlikView data model, script logics and the ETL business logic for the existing QlikView applications.
  • Maintained QlikView applications user guides & documentation. Migrated QlikView applications to production environments and handled performance tuning of the QlikView dashboards.
  • Conducted end user training sessions and prepared the training documentation.
  • Migrated jobs & common objects between environments and scheduled jobs using QlikView publisher
  • Created test cases and conducting Unit Testing, Integration Testing and System Testing.
  • Participated in design & code review meetings.

Environment: Oracle, Flat files, Excel files, XML files, Informatica, QlikView, Microsoft SQL Server.

We'd love your feedback!