We provide IT Staff Augmentation Services!

Sr. Informatica Developer Resume

SUMMARY

  • Around 4+ years of extensive IT experience in the Design, Testing, Implementation and support for Data warehousing applications, extraction, transformation and loading of data using Informatica Power Center (Designer, Workflow Manager and Workflow Monitor.
  • Develop and advocate the development standards and practices for the development team, i.e. coding, code management, and documentation.
  • Design, Develop and Test ETL Mappings, Mapplets, Workflows, Worklets using Informatica Powercenter 9.6.1.
  • Develop Informatica code, Design, Develop and modify Informatica mappings and workflows.
  • Involvement with management in terms of supplying input for key design and architecture decisions, as well as work estimation and resource planning.
  • Applies policies, procedures and standards relating to BI ETL process development, in conjunction with Data Warehouse best practices.
  • Develop and advocate the development standards and practices for the development team, i.e. coding, code management, and documentation.
  • Involvement with management in terms of supplying input for key design and architecture decisions, as well as work estimation and resource planning.
  • Coordinates extensive projects with all relevant personnel and management in Informatica.
  • Models cross - functional and divisional business processes and enterprise data in Informatica.
  • Knowledge in database development such as Oracle, SQL, DB2, MS-SQL and operational procedures.
  • Experience with Essbase and BI Visualization tools like, Tableau, and Qlikview.
  • Experience in Consumer Banking and Financial (Finance Systems like General Ledger, Forecasting, Planning and Analysis etc).
  • Identify request and business requirement solution alternatives based on target application and functionality.
  • Review solution alternatives and impact analysis with users and facilitate solution selection.
  • Related areas of IT Project Management or experience with applications handling lot of data from diverse sources.
  • Experience in Data warehousing, Data Analysis, Development, Data integration, ETL implementation, Maintenance & Support.
  • Strong experience programming in Informatica.

TECHNICAL SKILLS

Data Warehousing Tools: Informatica Power Center 9.6.1

Languages: SQL, PL/SQL

Tools: /Utilities: TOAD, Oracle/SQL Developer, SSMS

Databases: Oracle, MS SQLSever, MS Access, SQL

Operating Systems: Windows, UNIX.

PROFESSIONAL EXPERIENCE

Confidential

Sr. Informatica Developer

Environment: Informatica Power Center 9.6.1, Power Analyzer, TOAD, Oracle, Flat Files, Windows, MS Outlook

Responsibilities:

  • Develop Informatica workflows to collect data from multiple data sources based on mapping specifications provided to the developer.
  • Provide assistance and training to developers regarding the use of ETL development standards as necessary.
  • Assist project team with unit testing. Develop system test plans and perform full system testing prior to implementation.
  • Provide guidance to onshore, offshore, and near shore development service providers as necessary
  • Work closely with technical leads, analysts and developers to design and implement Oracle solutions within a structured development process.
  • Assist in continuous improvement efforts and enhancing project team methodology and performance.
  • Contribute to the design and development of Informatica master data management components of the solution in support of both member and provider master indexes.
  • Data Warehousing ETL development and testing experience using Informatica 9.5 or higher.
  • Experience in Extraction, Transformation and Loading (ETL) data from various sources into a Data Mart/ODS.
  • Working knowledge of the Informatica Power Center Client tools - Mapping Designer, Repository Manager and Workflow Manager/Monitor.
  • Experience in working with relational databases such as Oracle 11g or higher, DB2 as well as with the flat files and XML using the Informatica XML Parser.
  • Experience in developing Stored Procedures, Functions, Views, Triggers, Complex SQL queries using Oracle PL/SQL.
  • Experience in resolving maintenance issues and bug fixes, monitoring Informatica sessions as well as performance tuning of mappings and sessions.
  • Ability to communicate with both technical and non-technical groups on a regular basis to maintain transparency on work efforts and to ensure design and implementation is understood by all team participants.
  • Resolve all emergency production issues and ensure appropriate resolution of all issues within required time-frame.
  • Document all designs and perform all unit tests and develop appropriate applications.
  • Ensure quality of deliverables, set development standards in areas of code quality, test coverage, monitoring, logging, exception management, documentation and others.
  • Experience in writing large packages, hierarchical queries, complex procedures/functions and triggers with medium/complex functionality, using analytical functions, usage of collections, dynamic refcursors.
  • Install, upgrade and patch Informatica components of the NY APD solution so that the environment remains current
  • Implement procedures to maintain, monitor, backup and recovery operations of the ETL environment so that the environment is reliable and highly available through time.

Confidential

Informatica Developer

Environment: Informatica Power Center 9.6.1, Oracle 11g, SQL Server Developer, PL/SQL, flat files, Toad &UNIX.

Responsibilities:

  • Coordinates extensive projects with all relevant personnel and management in Informatica.
  • Become a subject matter expert for specific areas, applications or technologies.
  • Analyzes requirements for major projects involving multiple components internal and external to the division. Selects appropriate solutions.
  • Models cross-functional and divisional business processes and enterprise data in Informatica.
  • Identifies and implements appropriate technology across the organization or directs others in these activities.
  • Creates test strategies for cross application or solutions.
  • May lead discussions with clients, management, co-workers, operations, technical support and vendors.
  • Build coding / design standards and constantly adjust them to meet the evolving needs.
  • Stays up-to-date on evolving industry patterns, practices, techniques / standards.
  • Responsible for ensuring application monitoring, error reporting and production readiness, adhere to Ameriprise development policies & standards.
  • Bachelor’s degree in Computer Science or similar field or equivalent work experience.
  • Experience in systems analysis, design and an expert understanding of development, quality assurance and integration methodologies.
  • Strong analytic, problem-solving, multi-tasking and organizational skills.
  • Quickly acquire broad knowledge of applications in Finance space and system inter-dependencies.
  • Self-starter with confidence to drive issues through to completion in highly pressured situations.

Confidential - Detroit, MI

Informatica Developer

Environment: Informatica Power Center 9.6.1, SQL Server Developer, flat files & UNIX.

Responsibilities:

  • Development tests, monitor results and take corrective action and translate data access, transformation and movement requirements into functional requirements and mapping designs.
  • Identify and manage interfaces, service levels, standards and configurations.
  • System and Application Administration for Informatica PowerCenter and PowerExchange.
  • Develop PowerCenter Mappings, Sessions and Workflows and also set up PowerExchange connections to database and files.
  • Develop mappings in Informatica Developer and export them over to PowerCenter.
  • Develop wrapper script jobs to call workflows and other processes.
  • Schedule the ETL workflows and jobs through Informatica and JAMS schedulers.
  • Plan, install and configure upgrades of Informatica releases and hot fixes among various environments.
  • Fill out required documentation such as installation instructions and follow client standards and procedures.
  • Anticipate customers’ analytic needs and proactively conceptualize and champion high-value Business Intelligence solutions.
  • Keep the Production Support team management informed of any issues or concerns.
  • Provide guidance to project team on collecting metadata and maintaining the data dictionary.
  • Serves in a leadership role for technical project decisions.
  • Provides support for the implementation and deployment of new data solutions.
  • Mentors and guides other data developers in best practices for Data Warehouse and Data Application development

Hire Now