Senior Informatica Consultant Resume Samples

A Senior Informatica Consultant is hired to convert the company’s standard processes such as stored procedures and functions into Informatica. Typical work activities seen on the Senior Informatica Consultant Resume include the following – interacting with business analysis and on-site coordinates for requirement analysis; creating mappings, creating ETL design documents; addressing the technical needs of the customer, driving adoption, providing guidance and leadership; feeding to Informatica R&D teams based on functional requirements, product enhancement requests and customer user-cases.

Those seeking this job role must mention the resume the following skills and abilities – strong knowledge of ETL concepts with relational databases; experience with web services based API’s and REST; knowledge of MDM, good understanding and experience with Cloud applications; programming experience; and a strong background in SOA. Formal education is not mandatory, however, candidates are expected to showcase on the resume adequate experience in business and technical applications and some post-secondary studies.

Senior Informatica Consultant Resume example

Senior Informatica Consultant Resume

Objective : Over 8 years of experience in development and support related activities in data warehousing, using ETL tools like Informatica power center 9.x/8.x/7.x, databases like Oracle and SQL Server. Involved in project life cycle including requirement gathering, Analysis, Design, Development, Testing, and Implementation of data warehouse applications.

Skills : Used Architectures: Big Data/Hadoop Architecture.

Description :

    1. Extracted from sources like Oracle, SAP, feed file from 3rd party and integrated into data warehouse for reporting purposes.
    2. Involved in interacting with business in gathering requirements and identify the scope.
    3. Created HLD (High Level Design) and LLD (Low Level Design) documents.
    4. Created source to target mapping documents.
    5. Involved in the extraction, transformation and loading of the source data to the target database.
    6. Worked on source data analysis to figure the mapping between various legacy source data.
    7. Imported Sources and Targets to create Mappings based on business logic and developed Transformations using Power center Designer.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Executive
Education
Education
Hadoop


Senior Informatica Consultant III Resume

Objective : Seven plus years of progressive IT experience in using Informatica tool for implementation of ETL methodology in Data Extraction, MDM, Transformation and Loading. Experience in coding using SQL, TOAD, SQLPlus, PL/SQL procedures/functions, triggers and exceptions. Experience in Design and maintenance of financial, Pharmaceutical Data Warehouse applications.

Skills : Data Integrations & MDM ETL & Data Architecture Data.

Description :

    1. Designed and built DataMart's by using Star Schemas.
    2. Created Logical and Physical Data models using Erwin 4.5 extensively.
    3. Reported were generated using Business Objects for analysis.
    4. Extensively used Informatica Power center for extracting, transforming and loading data from relational sources and non-relational sources.
    5. Extensively used various transformations such as Source Qualifier, Expression, Lookup, Sequence Generator, aggregator, Update Strategy, and Joiner while migrating data from various heterogeneous sources like Oracle, DB2 and Flat files to Oracle.
    6. Developed Informatica mappings, re-usable transformations, re-usable mappings and Mapplets for data load to data warehouse.
    7. Developed Mappings using Designer to extract, transform data according to the requirements and loaded into database.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Executive
Education
Education
Bachelors


Senior Informatica Consultant II Resume

Objective :

Experience with healthcare data including medical claims, pharmacy claims, employee benefits enrollment, Advanced SAS programming abilities in data warehouse or big data analytics environment.
Well-versed in data analysis and data transformation.
Strong understanding of customer’s strategies, information needs programs, processes and products.

Skills : Big Data/Hadoop Architecture.

Description :

    1. Extracted from sources like Oracle, SAP, feed file from 3rd party and integrated into data warehouse for reporting purposes.
    2. Involved in interacting with business in gathering requirements and identify the scope.
    3. Created HLD (High Level Design) and LLD (Low Level Design) documents.
    4. Created source to target mapping documents.
    5. Involved in the extraction, transformation and loading of the source data to the target database.
    6. Worked on source data analysis to figure the mapping between various legacy source data.
    7. Imported Sources and Targets to create Mappings based on business logic and developed Transformations using Power center Designer.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Executive
Education
Education
Hadoop

Senior Informatica Consultant I Resume

Objective : Over 15 years of IT experience in System design, development and maintenance. Over 12+ years of Technical and Functional experience in Decision Support Systems - Data Warehousing, ETL (Extract, Transform and Load). Green Card Holder Extensively used Power Builder and SAS for reporting purposes Won 54th annual awards at FDA for implementing their best project for Center for Veterinary Medicine (CVM) Informatica Certified Designer, PowerCenter 7.

Skills : Effective Communication Skills, Team Work.

Description :

    1. Involved in multiple projects such as geographical information systems where I had to load data from SQL Server to Oracle for better reliability, convert bunch of stored procedures into Informatica mappings.
    2. Workrf with admins to load data from SQL SERVER to Oracle 10 g.
    3. Created Tasks, Workflows and Worklets using Informatica and Monitored the Data loads in Workflow Monitor Module.
    4. Used flat files to get data from People Soft and load data in SQL Server.
    5. Created Reusable Transformations and Mapplets to use in Multiple Mappings Major Involvement in performance tuning in data ware house.
    6. Extracted Data from people soft using flat file and loaded into SQL Server.
    7. Checked the quality of data by running the data profiler and troubleshooting the errors.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Executive
Education
Education
M.S. In Engineering

Assistant Senior Informatica Consultant Resume

Objective : Over 15 years of IT experience in System design, development and maintenance. Over 12+ years of Technical and Functional experience in Decision Support Systems - Data Warehousing, ETL (Extract, Transform and Load). Green Card Holder Extensively used Power Builder and SAS for reporting purposes Won 54th annual awards at FDA for implementing their best project for Center for Veterinary Medicine (CVM) Informatica Certified Designer, PowerCenter 7.

Skills : Communication Skills, Analytical Skills.

Description :

  • Demonstrated expertise on Object-Oriented programming and design, SQL, databases, web development, and XML structures.
  • Achieved the Pega Certified Senior System Architect (CSSA) level.
  • Worked independently under minimum supervision to deliver training to the customers/partners.
  • Customized training to the needs of the customers.
  • Assisted subject matter experts for developing certification exams and curriculum.
  • Adjusted language or terminology to fit the characteristics and needs of the audience
  • Created an excellent first impression, commanding attention and respect, and showing an air of confidence.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Executive
Education
Education
M.S. In Engineering

Associate Senior Informatica Consultant Resume

Objective : Effectively deliver technical training courses on the more complex areas to customers, partners, and employees Consistently exceed customer, expectations with positive feedback and high ratings.

Skills : Commercial awareness, Good numerical skills, Attention to detail.

Description :

  • Liaised with other TSO experts and tacticians on operational trends and analysis in order to provide tailored and up-to-date CMCT training
  • Reviewed, developed and updated and adjusted TSO TSE scenarios in accordance with established CSP goals
  • Provided instruction as an Intelligence, Surveillance, and Reconnaissance (ISR), Signals Intelligence (SIGINT), and Forces Targeting Training Element (STTE) subject matter expert and Operations, Tradecraft and Training (OTT) Instructor in support of Air Force systems, Cryptologic Operators (CO), and quick reaction capabilities.
  • Tracked and implemented changes to certification requirements
  • Created Reusable Transformations and Mapplets to use in Multiple Mappings Major Involvement in performance tuning.
  • Created Tasks, Workflows and Worklets using Informatica and Monitored the Data loads in Workflow Monitor Module.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Executive
Education
Education
M.S. In Engineering

Senior Informatica Consultant/Manager Resume

Headline : Designed and constructed current and future state Data Models (Logical and Physical data modeling using Erwin) and identified potential gaps to track data redundancy, and improved management of data flow. Responsible for meeting with business stakeholders or Data science team to analyze application requirements and design big data / ETL solutions.

Skills : Effective communication skills, Analytical skills.

Description :

    1. Responsible for designing database solutions (Logical and Physical data modeling using Erwin) and ETL Architecture to satisfy application (business and technical) requirements.
    2. Involved in Understanding client Requirements, Analysis of Functional specification, Technical specification preparation, Review of Technical Specification.
    3. Involved in identifying bugs in existing mappings by analyzing the data flow, evaluating transformations and fixing the bugs so that they conform to the business needs and redesign the existing mappings for improving the performance.
    4. Responsible to the integration of SalesForce with datawarehouse through Informatica Power Exchange.
    5. Closely worked with the SalesForce Consultant to understand the Business requirements.
    6. Demonstrated expertise on Object-Oriented programming and design, SQL, databases, web development, and XML structures
    7. Achieved the Pega Certified Senior System Architect (CSSA) level.
Years of Experience
Experience
5-7 Years
Experience Level
Level
Executive
Education
Education
Masters In Computer Application

Senior Informatica Consultant/Instructor Resume

Objective : Over Ten years of experience as a Tech Lead / Informatica Developer in developing large-scale Data Warehouse and Client/Server Applications, including Data Profiling, Data Migration, Data Modeling, Business Process, Design and Development, Integration and Testing, Database Programming, SDLC, Project Management and Production Support.

Skills : Informatica, Oracle 10G.

Description :

    1. Monitored and tracked the application runs, fixing the failures, working on user queries, participating in planning and executing portion of Teradata upgrade, Informatica maintenance and Disaster recovery process.
    2. Monitored and tracked the applications as per the schedule run.
    3. Reloaded of applications run and need to make sure reloading process is completed Restarting of applications run and need to make sure restart process is completed Catching up for the applications and need to make sure catch up process is completed Validate the data loaded into database.
    4. Provided the status report for all the application monitoring, tracking status Communication with SOR , Downstream users if any delays are happened Root cause analysis for recurring abends Involved in verifying applications to move from Tivoli Workload scheduler to Autosys scheduler.
    5. Participated in planning and executing portion of Teradata upgrade, Hardware Upgrade.
    6. Developed UNIX shell script newpmcmd.sh to run the PMCMD commands in UNIX environment to run the workflows using the Autosys scripts.
    7. Created, launched & scheduled Workflows/sessions by developing the Autosys Jobs by generating the JIL files in UNIX Environment.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Executive
Education
Education
M.Tech In Computer Science

Associate Senior Informatica Consultant I Resume

Objective : An accomplished software engineer with 7+ years of experience in Database design and in Data modeling and Data warehousing applications. Extensive project development experience using Oracle/Netezza as the main Relational Database Management System, under many platforms & using different combination of tools.

Skills : Analytical Skills, Effective communication skills,Teaworking.

Description :

    1. Involved in analyzing the source data coming from different data sources such as Oracle, Flatfiles, DB2, Mainframes, Teradata and SQL Server and identifying data anomalies in operational data.
    2. Used Teradata utilities like FLoad and MLoad to load data.
    3. Developed fine-tuned Transformations, Mappings and Mapplets between source systems and warehouse components.
    4. Created documents for workflow migration and impact analysis for database changes The technology environment of the project includes: Informatica Power Center 7.1.2 Teradata CRM Teradata V2R6 BTEQ Teradata SQL assistant 7.1 Erwin 4.0 Oracle 9i, DB2 SQL PLUS HP-UX Teradata Utilities (Mload, Fastload and FastExport) MS SQL Server.
    5. Worked independently under minimum supervision to deliver training to the customers/partners
    6. Customized training to the needs of the customers
    7. Assisted subject matter experts for developing certification exams and curriculum.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Executive
Education
Education
Bachelor's In Computer Science

Senior Informatica Consultant Resume

Objective : Highly qualified Senior Informatica Consultant with experience in the industry. Enjoy creative problem solving and getting exposure on multiple projects, and I would excel in the collaborative environment on which your company prides itself.

Skills : Analytical Skills, Effective Communication Skills.

Description :

  • Worked independently under minimum supervision to deliver training to the customers/partners
  • Customized training to the needs of the customers
  • Assisted subject matter experts for developing certification exams and curriculum
  • Improved policy and expand knowledge of health care and human service systems
  • Dealed with shifts in health care practice, technology, and regulation
  • Optimized performance, quality, coverage, and health outcomes
  • Created strategies for institutions, communities, associations, foundations, governments, and people to make health care and human services systems more effective.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Executive
Education
Education
MS In Computer Science