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.
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 :
Extracted from sources like Oracle, SAP, feed files from 3rd party and integrated into a data warehouse for reporting purposes.
Imported Sources and Targets to create Mappings based on business logic and developed Transformations using Power center Designer.
Experienced in end-to-end projects life cycle (SDLC) Dev, Testing, Deployments Process, and Production support.
Experienced working in Dev and QA environments.
Experienced in Dataware housing - ETL Tools (Datastage, Informatica) and Data Mining.
Analyzed the business logic involved in SAP Business Objects.
Gathered requirements and prepare functional and technical designs.
Experience
2-5 Years
Level
Executive
Education
Hadoop
Senior Informatica Consultant III Resume
Objective : Seven plus years of progressive IT experience in using Informatica tool for the 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 :
Designed and built Datamarts by using Star Schemas.
Created Logical and Physical Data Models using Erwin 4.5 extensively.
Reported were generated using Business Objects for analysis.
Extensively used Informatica Power center for extracting, transforming, and loading data from relational sources and non-relational sources.
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.
Developed Informatica mappings, re-usable transformations, re-usable mappings, and Mapplets for data load to the data warehouse.
Developed Mappings using Designer to extract, transform data according to the requirements, and loaded into the database.
Experience
2-5 Years
Level
Executive
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 strategies, information needs programs, processes, and products.
Skills : Big Data/Hadoop Architecture.
Description :
Involved in interacting with business in gathering requirements and identifying the scope.
Created HLD (High-Level Design) and LLD (Low-Level Design) documents.
Created source to target mapping documents.
Involved in the extraction, transformation, and loading of the source data to the target database.
Worked on source data analysis to figure the mapping between various legacy source data.
Driven data profiling, drafting business rules, building reports, and counseling the client on the DQ results.
Built DQ architecture designs and implementation plans
Experience
2-5 Years
Level
Executive
Education
Hadoop
Senior Informatica Consultant I Resume
Objective : To obtain a part-time Senior Informatica Consultant I position with an emphasis on Sales Support/Office Management utilizing extensive experience and skills. Productive in contributing effectively towards the objectives of a team, and is able to share knowledge, ideas, and information.
Skills : Effective Communication Skills, Team Work.
Description :
Involved in multiple projects such as geographical information systems where I had to load data from SQL Server to Oracle for better reliability, convert a bunch of stored procedures into Informatica mappings.
Worked with admins to load data from SQL SERVER to Oracle 10 g.
Created Tasks, Workflows, and Worklets using Informatica and Monitored the Data loads in Workflow Monitor Module.
Used flat files to get data from People Soft and load data in SQL Server.
Created Reusable Transformations and Mapplets to use in Multiple Mappings Major Involvement in performance tuning in the data warehouse.
Extracted Data from people soft using flat file and loaded into SQL Server.
Checked the quality of data by running the data profiler and troubleshooting the errors.
Experience
2-5 Years
Level
Executive
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 in 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 in developing certification exams and curricula.
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.
Experience
2-5 Years
Level
Executive
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.
Led DQ projects and work well with the offshore team.
Experience
2-5 Years
Level
Executive
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 the Data science team to analyze application requirements and design big data / ETL solutions.
Skills : Effective communication skills, Analytical skills.
Description :
Responsible for designing database solutions (Logical and Physical data modeling using Erwin) and ETL Architecture to satisfy application (business and technical) requirements.
Involved in Understanding client Requirements, Analysis of Functional specifications, Technical specification preparation, Review of Technical specifications.
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 redesigning the existing mappings for improving the performance.
Responsible for the integration of SalesForce with data warehouse through Informatica Power Exchange.
Closely worked with the SalesForce Consultant to understand the Business requirements.
Demonstrated expertise in Object-Oriented programming and design, SQL, databases, web development, and XML structures.
Knowledged of SQL to write efficient and highly optimized queries across large volumes of data.
Experience
5-7 Years
Level
Executive
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 :
Monitored and tracked the application runs, fixing the failures, working on user queries, participating in planning and executing a portion of Teradata upgrade, Informatica maintenance, and Disaster recovery process.
Monitored and tracked the applications as per the schedule run.
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 the database.
Provided the status report for all the application monitoring, tracking status Communication with SOR, Downstream users if any delays happen Root cause analysis for recurring abends Involved in verifying applications to move from Tivoli Workload scheduler to Autosys scheduler.
Participated in planning and executing a portion of Teradata upgrade, Hardware Upgrade.
Developed UNIX shell script newpmcmd. sh to run the PMCMD commands in the UNIX environment to run the workflows using the Autosys scripts.
Created, launched & scheduled Workflows/sessions by developing the Autosys Jobs by generating the JIL files in UNIX Environment.
Experience
2-5 Years
Level
Executive
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 a different combinations of tools.
Skills : Analytical Skills, Effective communication skills,Teaworking.
Description :
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.
Used Teradata utilities like FLoad and MLoad to load data.
Developed fine-tuned Transformations, Mappings, and Mapplets between source systems and warehouse components.
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 (Reload, Fastload, and FastExport) MS SQL Server.
Assisted subject matter experts in developing certification exams and curricula.
Knowledged of Fidelity backend product tables (WIDE, Snowflake, etc.).
Learned new tools are exciting and interesting.
Experience
2-5 Years
Level
Executive
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 :
Improved policy and expand knowledge of health care and human service systems.
Dealt 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 are more effective.
Experienced with Testing strategies and Test Execution.
Possessed excellent communication (both verbal and written) and interpersonal abilities to work with multiple stakeholders, onsite/offshore teams, and senior leadership.
Hands-on experienced with relational databases and SQL queries.
Creating an account is free and takes five seconds.
You'll get access to the PDF version of this resume template.
Choose an option.
Sign up with Google
Sign up with Facebook
Sign up with Linkedin
This helps us make sure you're human and prevents spammers from abusing our services.
By continuing, you agree to our Privacy Policy and Terms.
Unlock the Power of Over 10,000 Resume Samples.
Take your job search to the next level with our extensive collection of 10,000+ resume samples. Find inspiration for your own resume and gain a competitive edge in your job search.
Get Hired Faster with Resume Assistant.
Make your resume shine with our Resume Assistant. You'll receive a real-time score as you edit, helping you to optimize your skills, experience, and achievements for the role you want.
Get Noticed with Resume Templates that Beat the ATS.
Get past the resume screeners with ease using our optimized templates. Our professional designs are tailored to beat the ATS and help you land your dream job.
