Informatica Lead Resume Samples

An Informatica Lead is an experienced professional who architects and develops Extract Transform Load Mappings. Primary job duties associated to the post are listed on the Informatica Lead Resume as follows – writing technical specifications to be provided to the Informatica ETL developers; supporting in ETL related project development, producing ETL codes; using Informatica standards; implementing data integration best practices and conventions; performing tuning and partitioning; being responsible for deployment; helping with data architecture and data warehousing and data mart modeling; identifying potential issues, and working closely with database administration team members for handling concurrent ETL and reporting query jobs.

The nature of the job demands the following skills – experience in delivering ETL solutions; a thorough understanding of the Data warehousing system, and good knowledge of Windows Power Shell Scripting and batch Scripting. A professional qualification in Informatica is seen on most of the resumes.

Informatica Lead Resume example

Informatica Lead Resume

Headline : 12+Years of work experience in areas of Data Warehousing, Data Migration, Agile Methodology while managing assignments for global multi-national client in various domains like Banking ,Insurance and capital markets ,Retail Banking , Healthcare and Energy sectors. Extensive knowledge on the SDLC development life cycle.

Skills : MS Office, Management.

Description :

    1. Responsible for Current lines of codes cross reference both ISTAGE and IDW, IDIST, IMETA database into one code.
    2. Responsible for Development of Separation of the IDW and ISTGE codes of the Data Warehouse Did Impact analysis of the existing system and prepared the task list of the activities required for it.
    3. Conducted daily scrums meetings for the update of the project and the task assignment for the current sprint.
    4. Co-ordinated with the bas for the requirements update.
    5. Did design and development for the project based on the FSD provided by the BA.
    6. Did Code reviews with the team members.
    7. Written Unit Test scripts for testing ETL workflows and End to end testing.
Years of Experience
Experience
5-7 Years
Experience Level
Level
Executive
Education
Education
B.E


Sr. Informatica Lead Resume

Summary : Informatica Lead developer is responsible for the requirements gathering, analysis, development, testing, deployment, monitoring and ongoing support of data extracts, imports, and Data Warehouse transformations and modeling for both business and clinical systems at Nemours.

Skills : Management, Organizing.

Description :

  • Creates and enhances data solutions enabling seamless delivery of data and is responsible for collecting, parsing, managing and analyzing large sets of data across different domains for analysis.
  • Uses different Data warehousing concepts to build a Data warehouse for internal departments of the organization.
  • Designs and develops data pipelines, data ingestion and ETL processes that are scalable, repeatable and secure for stakeholder needs.
  • Builds Data architecture to support data management strategies to support business intelligence efforts for various stakeholders.
  • Leads the design of the logical data model and implements the physical database structure and constructs and implements operational data stores and data marts.
  • Supports deployed data applications and analytical models by being a trusted advisor to Data Scientists and other data consumers by identifying data problems and guiding issue resolution Data Pipeline Management.
  • Develops real-time and batch ETL data processes aligned with business needs, manages and augments data pipeline from raw OLTP databases to data solution structures.
  • Documents data flow diagrams, security access, data quality and data availability across all business systems.
Years of Experience
Experience
10+ Years
Experience Level
Level
Senior
Education
Education
B.E


Jr. Informatica Lead Resume

Objective : 12 Years of IT Experience 10 Years of ETL Informatica Experience 10 Years of Oracle, Pl/SQL Experience 6 Years of UNIX Shell Scripting Experience SUMMARY: Oracle Certified Associate with over 12 years of experience in Software Development in Informatica and Oracle applications.

Skills : Management, Organizing.

Description :

    1. Analyzed the STM sheet for mapping between source and target columns, prepare the mappings for it.
    2. Implemented SCD type2 using Checksum functionality for the dimensions.
    3. Raised the requests for UAT, PROD environments using Service now tool.
    4. Analyzed and prepared the connections required for the source and target databases Worked on agile methodology with sprints and the scrum calls.
    5. Responsible for development, support and maintenance of the ETL (Extract, Transform and Load) processes using Informatica Power Center.
    6. Decided the service account and the connectors required for the mappings.
    7. Understood STM sheet and prepare the issue log which is required for clearing the transformation logic.
    8. Prepared the required reusable transformation for the mappings Prepare the functions needed for checksum functionality with MD5 logic in the mappings.
    9. Communicated with business and the offshore team regarding the gaps in transformation logic.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Junior
Education
Education
Bachelors

Informatica Lead I Resume

Objective : 9 Plus (9+) years of IT experience in Analysis, design, development and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL and Unix platforms in various verticals such as Health Care, Pharmaceutical. Good knowledge on SDLC. Data Warehousing / ETL: Eight Plus (9+) Years of DW Experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, Client/Server applications.

Skills : Management, Organizing.

Description :

    1. Participated in User meetings, gathering requirements, discussing the issues to be resolved.
    2. Translated user inputs into ETL design docs.
    3. Performed Data Analysis.
    4. Participated in Design Reviews of Data model and Informatica mapping design.
    5. Extensively used Informatica power center for extraction, transformation and loading process.
    6. Developed unix shell script to perform exporting file from work folder to inbox for business processing.
    7. Developed real-time and batch ETL data processes aligned with business needs, manages and augments data pipeline from raw OLTP databases to data solution structures.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Junior
Education
Education
Bachelors

Informatica Lead II Resume

Headline : 14 years of experience in design,Development,Production,Deployments and HIS implementation in IT industry Expertise Informatica,Idr,Idq,Dvo,Autosys,PL/SQL, Shell scripting and HIS implementation Strong functional knowledge on Utility, Health Care, Telecom, HIS (Hospital information system). Used water fall & Agile methadologies.

Skills : Management, Organizing.

Description :

    1. Generates and provides gas and electricity for both business and residential customers.
    2. Improves data management and analytics capabilities at Ameren.
    3. Extensive experiences in Informatica development with good client management skill IDR used to replicate the initial Load data Audit method used for incremental data to get from the Logs which are available at the mount point.
    4. Responsible for coding and modifications to enforce business rules and to improve performance of the system.
    5. Involves in Detail design, Functional Mapping, Etl Mappings, development, Client Software installation Extensively used Informatica client tools.
    6. Responsible for extract data stored in different databases such as, Oracle, flat files, JMS, Cobal files on a variety of sources to load into a single data warehouse repository, which is in Teradata TPT connection and teradata utilities are used to load data.
    7. Develops real-time and batch ETL data processes aligned with business needs, manages and augments data pipeline from raw OLTP databases to data solution structures.
Years of Experience
Experience
5-7 Years
Experience Level
Level
Executive
Education
Education
Bachelors

Informatica Lead III Resume

Summary : 10+ years of IT Experience in Designing, Development, Administration, Implementation of Data Warehouse & Data marts with Informatica Products 9.x/8.x/7.x/6.x as an ETL tool. Hands on Informatica 9.x installation, configuration, debugging, tuning and administration. Systems implementation, operations and its optimization as Informatica admin Extensive experience in develop, maintain and implementation of EDW, Data Marts and Data warehouse with Star schema and snowflake schema.

Skills : Management, Organizing.

Description :

    1. Implemented Oracle 11.5.10.2 for its spare parts business.
    2. Extensively worked with Source Analyzer, Warehouse Designer, Transformation Designer, Mapping Designer and Mapplet Designer.
    3. Created the procedures to load the data into the Oracle tables Developed transformation logic and designed various Complex Mappings and Mapplets using the Designer.
    4. Developed mappings/sessions using Informatica powercenter for data loading.
    5. Designed various mappings using transformations like LookUp, Router, Update Strategy, Filter, Sequence Generator, Joiner, Aggregator, and Expression Transformation.
    6. Tested of the existing Informatica workflows/mappings, Fix the bugs.
    7. Designed and implemented of ETL process which is to convert data sources into an industry-standard based data repository known as OMOP;
    8. Created and maintained ETL specifications and process documentation to produce the required data deliverables;
Years of Experience
Experience
7-10 Years
Experience Level
Level
Management
Education
Education
Bachelors

Asst. Informatica Lead Resume

Objective : Over 12+ years of experience (8+ years in Informatica and 5+ years in Mainframe) in all phases of Software Development Life Cycle (SDLC) including analysis, design, development, implementation, migration and project co-ordination of various projects. Experience in Health care and Automotive (CRM) domains.

Skills : Informatica Powercenter, Oracle.

Description :

    1. Provides audit, tax, consulting, enterprise risk and financial advisory services with more than 200,000 professionals in over 150 countries.
    2. Serves as a single point of entry to allow seamless eligibility processing for Georgians requesting assistance and support from participating agency's staff or contractors in their processing procedures and workflows.
    3. Designs and implements of a technical framework that will serve as the foundation for the IES.
    4. Supports the current Medicaid categories, PeachCarefor Kids, Food Stamps, TANF, LIHEAP, WIC and Child Care and the associated data is converted, the COMPASS, SUCCESS, VIDA and CRS applications will be retired.
    5. Designs complex ETL mapping using Informatica PowerCenter to load data from Flat Files to Oracle.
    6. Extensively uses transformations like Joiner, Sorter, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Sequence Generator, Normalizer and Rank in Informatica PowerCenter Worked on Shared Folders, Shortcuts, Mapplets, Reusable Transformations, Reusable tasks, Worklets.
    7. Works with Parameters and Variables at mapping and session level.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Junior
Education
Education
Bachelors

Associate Informatica Lead Resume

Headline : An articulate Informatica Data Quality Expert with vast 9 years of extensive experience on Informatica Data Quality IDQ and Informatica PowerCenter with strong business understanding and knowledge of Extracting, Transforming and Loading of data from heterogeneous source systems like Oracle, SQL Server, Flat files, Excel, XML, UDB, Sybase.

Skills : Management, Organizing.

Description :

    1.  Involved in complete understanding of business descriptions, analyzing the sources, transforming sources of data and loading this transformed datainto the Teradata warehouse.
    2. Designed Sources to Targets mappings from SQL Server, Excel/Flat files, Xml Files to Teradata using Informatica Power CenterData cleansing, integating, and matching using Informatica Data QualityIDQ Responsible for working with DBA and Data Modelers for project coordination.
    3. Responsible for developing complex Informatica mappings using different types of transformations like UNION transformation, Connected and Unconnected LOOKUP transformations, Router, Filter, Aggregator, Expression and Update strategy transformations for Large volumes of Data.
    4. Implemented Slowly Changing Dimension (SCD) Type 1 and Type 2 for Change data capture.
    5. Responsible for Error Handling in Workflows and sessions using Informatica workflow manager and monitor the workflow run and statistic properties on Informatica Workflow Monitor.
    6. Responsible for Defining Mapping parameters and variables and Session parameters according to the requirements and performance related issues.
    7. Wrote test plans and executed it at UNIT testing and also supported for system testing, volume testing and User testing.
    8. Provided production support by monitoring the processes running daily.
Years of Experience
Experience
5-7 Years
Experience Level
Level
Executive
Education
Education
Executive

Informatica Lead/Consultant Resume

Summary : Over 9+ Years of experience in Analysis, Design and Development of software applications and Business Intelligence projects under different environments. Expertise in Installation and Configuration of Informatica Power Center and technical hands on expertise in using 9x/8x/7x(Repository Manager, Mapping Designer, Workflow Manager, Workflow Monitor).

Skills : Management, MS Office, Organizing.

Description :

    1. Created various technical spec and design document for each deliverable.
    2. Understood the data structure of guidewire and how the data is being populated into operational data store.
    3. Setup environment to pull data for all the deliverables that's in production currently to support regression testing.
    4. Worked with various teams for ex: DBAs, PC team, Billing Team to bring in the required data and sync up the database with new changes in pre prod environment.
    5. Created several mappings, workflows to migrate data efficiently.
    6. Setup Real-time jobs to capture realtime data from Policy Center and Billing Center Along with the team, we successfully setup around 100 job flows manually during AIT phase to support regression testing.
    7. Responsible for Reverse engineered on many mappings (Since the SME was no longer there) to understand the data flow and logic behind it to include South Dakota changes to these flows.
Years of Experience
Experience
7-10 Years
Experience Level
Level
Consultant
Education
Education
Bachelors

Informatica Lead Resume

Objective : Informatica Lead responsible to present and communicate with key stakeholders and support the data sciences team with documentation, research, data ingestion, and troubleshooting projects.

Skills : Management, Organizing.

Description :

  • Designs, develops and supports all aspects of data movement for a data warehouse environment, with emphasis on the Extract-Transform-Load (ETL) process using Informatica.
  • Ability to administers the ETL system and upgrade to new releases
  • Develops data warehouse process models, including sourcing, extracting, transforming and loading as per business requirements.
  • Designs Extract-Transform-Load (ETL) Workflows for data migration from various sources to data warehouse using batch or incremental loading strategies.
  • Documents database design including data modeling, metadata and business process flow for the new business integration requirements.
  • Creates test plans and scripts for data warehouse testing, ranging from unit to integration testing.
  • Ensures delivered Data warehouse code is running and conforms to specifications and design guidelines.
Years of Experience
Experience
0-2 Years
Experience Level
Level
Entry Level
Education
Education
Bachelors