Informatica Lead Resume Samples

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.

Experience

5-7 Years

Level

Executive

Education

B.E

Description :

1. 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.
2. Uses different Data warehousing concepts to build a Data warehouse for internal departments of the organization.
3. Designs and develops data pipelines, data ingestion and ETL processes that are scalable, repeatable and secure for stakeholder needs.
4. Builds Data architecture to support data management strategies to support business intelligence efforts for various stakeholders.
5. Leads the design of the logical data model and implements the physical database structure and constructs and implements operational data stores and data marts.
6. 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.
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.
8. Documents data flow diagrams, security access, data quality and data availability across all business systems.

Experience

10+ Years

Level

Senior

Education

B.E

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.

Experience

2-5 Years

Level

Junior

Education

Bachelors

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.

Experience

2-5 Years

Level

Junior

Education

Bachelors

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.

Experience

5-7 Years

Level

Executive

Education

Bachelors

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;

Experience

7-10 Years

Level

Management

Education

Bachelors

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.

Experience

2-5 Years

Level

Junior

Education

Bachelors

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.

Experience

5-7 Years

Level

Executive

Education

Executive

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.

Experience

7-10 Years

Level

Consultant

Education

Bachelors

Description :

1. 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.
2. Ability to administers the ETL system and upgrade to new releases
3. Develops data warehouse process models, including sourcing, extracting, transforming and loading as per business requirements.
4. Designs Extract-Transform-Load (ETL) Workflows for data migration from various sources to data warehouse using batch or incremental loading strategies.
5. Documents database design including data modeling, metadata and business process flow for the new business integration requirements.
6. Creates test plans and scripts for data warehouse testing, ranging from unit to integration testing.
7. Ensures delivered Data warehouse code is running and conforms to specifications and design guidelines.

Experience

0-2 Years

Level

Entry Level

Education

Bachelors