sr informatica consultant resume example with 12+ years of experience
JessicaClaire
, , 100 Montgomery St. 10th Floor(555) 432-1000, resumesample@example.com
Summary
Over 13 years of IT experience with a strong background in Data warehousing, Data Integration tools including Informatica PowerCenter,Informatica PowerExchange,Informatica Intelligent Cloud services(IICS).
Expertise in Informatica Power Center 10.4,10.2/10.1/9.5.1/9.0.1/8.6/7. 1 extracting data from Oracle, SQL Server, Teradata, DB2 databases, Flat files, Web Services, API's, XML files.
Experience in Application Design, Data Extraction, Data Acquisition, Data Conversion, Development, Implementations and Testing of Data warehousing and Database business systems.
Experience in the full-cycle software development including requirements gathering, prototyping, and proof of concept, design, documentation, implementation, testing, maintenance and production support in an agile environment.
Strong ability to analyze source systems and business requirements, identify and document business rules, design data architecture for cohesive decision support and prepare dimensional data models.
Extensive knowledge of Dimensional Data Modeling like Star and Snowflake schemas and knowledge in designing tools like Erwin and Power Designer.
Strong experience with Informatica tools using real - time Change Data Capture.
Extensively worked in development of Informatica Mappings and Informatica Workflows.
Experience with Informatica Advanced Techniques Dynamic Caching, Memory Management, Parallel Processing to increase Performance throughput.
Extensively involved in Optimization and Tuning of mappings and sessions in Informatica by identifying and eliminating bottlenecks, memory management and parallel threading.
Experience in creating and using Stored Procedures, Functions, Triggers, Views, Synonyms, and Packages in Oracle 12c/11g/10g/9i/8i, SQL Server 2000/2005/2008,Netezza and DB2.
Experience in interacting with Business users in analyzing the Business process requirements and transforming them into documenting, designing, and rolling out the deliverables.
Excellent analytical and logical programming skills with a good understanding at the conceptual level and possess excellent presentation, interpersonal skills with a strong desire to achieve specified goals. Experience in resolving on-going maintenance issues and bug fixes monitoring Informatica sessions as well as performance tuning of mappings and sessions.
Worked extensively with slowly changing dimensions SCD Type1, Type2 & Type 3.
Experience in using Automation Scheduling tool, Control-M.
Good Experience on Managing, Scheduling, and Monitoring of Informatica workflows.
Strong knowledge in using SQL.
Used Batch scripts, Shell scripts, SQL procedures for pre and post session management.
Excellent interpersonal and communication skills, and is experienced in working with senior level managers, business people and developers across multiple disciplines.
04/2011 to Current100 Montgomery St. 10th FloorCognizant Technology Solutions | Windsor, CT,
TVA is a power generation company owned by Federal Government. Involved in the implementation of Data Warehousing for EAM & P6, Change data capture(CDC), eFMS R.1.2, ONIQUA, Maximo v7.5 upgrade, Portfolio optimization project(POP), Business Of Tomorrow(BOT), Migration of oracle on premise to Google BigQuery,Supply Chain Dimension Model and other multiple integration projects.
Responsibilities:
Designed and customized data models for Data warehouse supporting data from multiple sources on real time.
Understanding the business needs and implement the same into the functional database design.
Involved in Requirement gathering, analysis of requirements and solution design.
Development of Informatica mappings, mapplets, workflows and worklets according to the design documents.
Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
Performed data cleansing, troubleshooting, debugging and cache optimization.
Provide recommendations and expertise of data integration and ETL methodologies.
Experience in all phases right from requirement gathering for the data to develop the code, Unit testing and Documenting.
Made substantial contributions in simplifying the development and maintenance of ETL by creating re-usable Mapplets and Transformation objects.
Tuned performance of mapping and sessions by optimizing source, target bottlenecks and implemented pipeline partitioning.
Created and run sessions and Batches using server manager to load the data to the target Database.
Sourced the data from XML files, flat files, SQL server tables and Oracle tables.
Created, scheduled and monitored workflow sessions on the basis of run on demand, run on time, using Informatica Power Center workflow manager.
Strong experience in Dimensional Modeling using Star and Snow Flake Schema, Identifying Facts and Dimensions, Physical and logical data modeling using ERwin.
Designed and developed UNIX shell scripts to automate the entire process.
Responsible for monitoring all the session that are running, scheduled, completed, failed and debugged the mapping of the failed session.
Designed and Developed Oracle PL/SQL and Shell Scripts, Data Import/Export, Data Conversions and Data Cleansing.
Extracted data from multiple operational sources and loading into Staging Area, Data Warehouse and Data Marts using CDC (Power Exchange).
Implemented Error handling logic to capture the invalid data.
Ability to write complex SQL.
Experienced in creating and using Stored Procedures, Triggers, Views, User Defined Functions, Sub - Queries and Joins for complex queries involving multiple tables and exception handlers.
Developed Power BI model used for Supply Chain & financial reporting.
Designed and documented the entire Architecture of Power BI POC.
Used various sources to pull data into Power BI such as Sql Server, BW, Oracle, SQL etc.. .
Create root cause analysis and resolution to fix defects.
Environment: Informatica Power Center 10.2/10.1/9.5.1/9.0.1/ 8.6/7.1, Informatica Power Exchange, Tableau 2018.3,Flat Files, Oracle 12c/11g/10g/9i,TOAD 12.12, ERWIN 4.0, SQL Server 2008/2005, XML, PL/SQL,Json, Unix, GitHub,ITSM, Agile Methodology, TFS.
11/2020 to 01/2022Sr Informatica DeveloperL&T Infotech | Mh, IN,
DaVita is the largest provider of kidney care services in the U.S. and has been a leader in clinical quality and innovation for 20 years. Responsibilities:
Designed and built ETL's to extract data from Oracle and load the data in Google BigQuery using Informatica PowerCenter & PowerExchange.
Involved in enhancements and maintenance activities of the data warehouse.
Implemented Type1, Type2 and Incremental load strategies us Informatica PowerCenter & IICS.
Developed mappings to load into staging tables and then to Dimensions and Facts.
Used various transformations to extract data from different formatted files and relational source system.
Developed and tested Informatica mappings based on the specification.
Designed Mappings, Mapplets, Sessions, Worklets and Workflows.
Involved in Performance tuning at source, target, mappings, sessions, and system levels.
Worked on converting Informatica PowerCenter ETL code to IICS using PC to Cloud Conversion service
Design and develop PL/SQL packages, stored procedure, tables, views, indexes, and functions; implement best practices to maintain optimal performance.
Environment: Informatica Power Center 10.4, Informatica PowerExchange, IICS,Google BigQuery, Oracle, SQL Server,Toad,BitBucket.
08/2010 to 04/2011Informatica ConsultantDepartment Of Human Services | City, STATE,
Vision Integration Platform(VIP) is a real time system, used by the employees of DHS (Department of Human Services, State of Tennessee) to enroll eligible residents of Tennessee in public assistance programs like FF, FS, CC, and TCM. VIP is a larger scale Custom software application, involving the conversion of mainframe systems to highly efficient and accessible server-based application that are fully web-enabled to achieve greater flexibility and a wider range of operational capabilities. When complete, this enterprise level application will enable the state to manage and deliver the full range of public assistance program services to the citizens of Tennessee with speed and efficiency. Responsibilities:
Involved in design and implement complex database and data integration solutions to support a variety of products of our Rating Compliance business.
Proficiently worked together with management (end users) as well as development team.
Design, develop and unit test ETL objects like mappings, sessions and workflows.
Data model changes/maintenance over the period of the requirement changes.
Extensively used Source Qualifier Transformation to filter data at Source level rather than at Transformation level.
Created scripts in PL/SQL to automate the process of creating and dropping indices before and after the ETL process.
Extensively worked in operational support and deployment to Test, DR and Production.
Created static and dynamic deployment groups to deploy the ETL objects from Dev to test and from test to production.
Developed and executed UNIX scripts to schedule loads, through wrapper shell scripts for calling Informatica workflows using PMCMD command.
Actively involved in import and export of XML files, code migration of the folders, Linux files, flat files and database objects.
Daily Data Validation and data quality checks at database level using SQL scripts.
Used Informatica Server Manager to create, schedule, monitor sessions and send pre and post session emails to communicate success or failure of session execution.
Responsible for monitoring all the sessions that are running, scheduled, completed and failed using AutoSys.
Debugged the mapping of the failed session.
Improved the overall performance by tuning the whole ETL process.
Environment: Oracle 10g, Informatica Power Center 8.6.1/7.1, TOAD 8.0, XML, XSD, XBRL, AutoSys (JIL Scripts), UNIX Shell Scripting, Windows XP Client and UNIX Server.
Education and Training
Expected in 4 2010 to to Master of Science | Software EngineeringStratford University, Falls Church, VAGPA:
Expected in 2 2008 to to Bachelor of Technology | Electronics and Communication EngineeringJNTU, Hyderabad, APGPA:
Any information uploaded, such as a resume, or input by the user is owned solely by the user, not LiveCareer. For further information, please visit our Terms of Use.