Informatica Cloud - Iics\cai Consultant Resume
NY
SUMMARY
- Over 12 years of I.T experience in System Analysis, Design, Development, Maintenance, and Implementation.
- 4 years of experience with Informatica Server installation, configuration and Administration.
- Installed and configured Informatica10.2 server on four EC2 servers and build grid with four nodes and configured informatica highly availability for fail over.
- Excellent experience in ETL using Informatica PowerCenter 10.2/9.6/9.0.1/8.6/8.5 /8.1 , Informatica Cloud IICS, SSIS and Data base Development.
- Involved in the installation, configuring and upgrade the Informatica PowerCenter server and applying Hotfixes in windows and UNIX.
- Excellent Exposure in Informatica Repository manager and code migrations using deployment groups and XML export and import methods.
- Exposure in Dimensional Data Modeling based on Ralph Kimball and Bill Inman methodologies and designing Star Schema, Snowflake schema with FACT and Dimensions.
- Extensively worked on Informatica Designer components including Source Analyzer, Target Designer, Transformation Developer, Mapping Designer, Mapplet Designer and workflow manager.
- Designed and developed complex ETL mappings using Source Qualifier, Application source Qualifier, XML Source Qualifier, Lookup, Filter, Expression, Router, Normalizer, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, Sequence Generator and web services transformation.
- Excellent experience in implementing slowly changing dimensions (SCD1, SCD2 and SCD3) in data warehouse.
- Experience with different source systems including Oracle, MS SQL Server, SAP, Salesforce, web services and CSV, XML, COBAL files.
- Experience with Data cleansing using Informatica Data Quality and Third - party web services.
- Experience in writing SQL queries, stored procedures, functions, triggers and PL/SQL, T-SQL programs.
- Experience in writing UNIX shell scripting, automation of ETL process and scheduling of ETL jobs.
- Extensive experience in data quality, unit testing, System testing and User Acceptance Testing.
- Experience with Informatica metadata manager and Business Intelligence tools like Business Objects, Cognos and Defect management tools.
- Experience in writing Requirements specification documents, design documents and testing documents.
- Excellent Experience working with offshore and onsite co-ordination.
TECHNICAL SKILLS
- Informatica Power Center 10.2 9.1.1 8.6/8.5/8.1
- Informatica Cloud integration application integration
- Informatica Data Quality
- AWS Redshift
- Aurora s3
- Oracle Exadata 11i/10g/9i/8i
- SQL Server 2008/2005/2000
- DB2
- AS400
- Netezza
- SAP
- Salesforce
- Zuora
- PL/SQL
- T-SQL
- Unix
- Linux
- Toad
- SQL-Loader
- SQL-Developer
- Tidal
- ESP
- Business Objects.
PROFESSIONAL EXPERIENCE
Confidential, NY
Informatica Cloud - IICS\CAI Consultant
Responsibilities:
- Developed Informatica cloud mappings, mapping configuration to integrate salesforce objects with Zoura.
- Created Data synchronization tasks to load oracle staging tables for contacts, accounts, subscriptions, debit memo and credit memo information.
- Salesforce objects are updated using rest API calls in application integration.
- ETL frame work has been created to handle incremental updates from different systems.
- Advanced taskflows has been implemented to handle restart ability for failures.
- Linear taskflows, Processes, Application connections, Relational connections, schedules has been created and migrated to different environments using Import and export methods, ADO process has been used to promote code into different environments.
- Redshift database has been loaded using informatica mappings for data warehouse and data marts.
- Dynamic parameter files has been created using informatica mappings to handle incremental loads.
- Performed analysis for secure agent migration from on prem to cloud environment.
- Performed unit testing and integration testing between systems in lower environments.
- Supported production deployment and post production issues.
Environment: Informatica Cloud (CI/CAI), Zuora, Salesforce, Oracle, Acrtive, SQL Developer, ADO.
Confidential, TN
Informatica Cloud - IICS Consultant
Responsibilities:
- Worked on design and customized framework for process simplification.
- Created IICS mappings and mapping tasks from various interfaces and integrated into ODS with functionalities like SCD type 2. Handling historical data sets from source for CDC Change data capture.
- Loaded all vendor transaction data form UberEATS, Postmates, Door Dash and Grub Hub data from aws S3 buckets and SFTP sites to Staging. Implemented error handling and loaded into ODS database.
- Created a reconciliation process for vendor transaction amount to deposit data.
- Build a Data Integration framework and distributed data to the downstream learning management application of time sensitive, accuracy and data completeness.
- Used various transformations and integrated in task flow for file processing, data masking and loading data commands, decision and alert notification tasks.
- Used data synchronization task for file processing, fixed width file layouts.
- Extensively used file processor for move, copy, archive, encrypt the data files from source to destination locations.
- Created Windows PowerShell and Batch scripts to integrate in informatica to implement various functionalities like sending email notification alerts, erasing special characters, sending files and archiving files etc.
Environment: Informatica Cloud (IICS), SQL Developer, Windows PowerShell, Oracle 12 c, SQL Server Management Studio (SSMS) - RDS, Peoplesoft, Azure Cloud VM, MS Visio
Confidential, Fairfax, VA
ETL Lead/Admin
Responsibilities:
- Installed and configured Informatica10.2 server on four EC2 servers.
- Configured informatica grid environment with four nodes and configured informatica highly availability for fail over.
- Created Repository service, integration service and model repository.
- Restored informatica repository content from existing backup file for code reference.
- Created informatica user groups and native user account and granted permissions based on roles.
- Configured informatica root directory with EFS file storage for centralized file location in grid environment.
- Configured ODBC server level connections to read data from PGSQL and oracle.
- Installed and configured informatica DVO (data validation option)
- Created shell scripts to take the repository content backup and run jobs using Cron job.
- Actively participated in data modeling and build strategy to migrate data into new system.
- Migrated informatica code from one environment to other environments.
- Build restart ability in informatica to restart failed informatica workflows.
- Created informatica mappings to read source files and load into application database.
- Created informatica mappings to migrated data from existing legacy oracle stems to PGSQL using different transformations.
- Created test data using Imformatica Test data management (TDM) to populate test data.
- Performed unit testing to check the quality of the migrated data in target systems.
- Used informatica data validation option (DVO) to compare data between source target systems.
- Created reconciliation report to verify source and target record counts.
Confidential, Sterling, VA
ETL Lead
Responsibilities:
- Participate in ETL design process and create Functional documents which assist the developers in coding.
- Create technical design documents to integrate new RTM system with existing reporting layer.
- Create new ETL jobs which load data into downstream systems like PCDM, OBDM, SCM, CCDM systems.
- Creating Informatica mappings, mapping configurations using Informatica Cloud.
- Created CDC mappings using Informatica Power Exchange and loaded data into redshift.
- Creating task flows in Informatica cloud to load data into Amazon redshift, Hive through schedules and unloaded data into S3.
- Data is unloaded from S3 to Big data EMR cluster hives for reporting.
- Preparing ETL cut over activities and documentation for Production Migration.
- Developed informatica mappings using Pushdown optimization.
- Supporting production cut over and postproduction issues.
- Supporting Testing team and Report user for any data issues.
- Performance tuning on ETL jobs which runs through Informatica cloud.
- Created Informatica cloud Data synchronization, data replication and Mapping configuration.
- Coordinating with offshore team for Development and testing activities. Worked in Agile based development environment
Confidential, Fairfax, VA
Sr. ETL Developer
Responsibilities:
- Worked on Gap analysis to find out missing database objects and columns to refactor the existing data mart and extracts.
- Designed the ETL Process which pulls data from Pecos application Replica database and loads into ODS.
- Created technical design documents for new mappings and enhanced mappings.
- Informatica mappings are created to Load data from Replica to ODS and ODS to extracts.
- Created mappings to load data from ODS to Data Mart Dimension and Fact tables and halper tables.
- Extensively worked on Power Center Designer, Workflow manager to create Mappings, Mapplets, reusable transformations and sessions, Worklets and workflows.
- Created mapping, Worklet and workflow parameters and variables and parameterized source and target connections.
- Implemented workflow restart ability using control tables and mapping, Worklets and workflow variables.
- Migrated the code to different lower environments using import and export methods from Informatica Repository manager.
- Created SQL queries for SQL overrides and Pre-& Post Session SQL Scripts.
- Created test cases to perform unit testing for developed objects and documented.
- Worked with ETL testing team to guide testers to speed up testing process.
- Worked in Agile based development environment
- Used Active batch to create, schedule and monitoringETL jobs.
Confidential, Smithfield, RI
Sr. ETL Developer
Responsibilities:
- Designed the ETL Process which pulls data from source and loads into Data marts, warehouse systems.
- Streamlined the process for fetching and loading the data and created technical design documents for new mappings and enhanced mappings.
- Extensively worked on Power Center Designer, Mapping and Mapplets designer, workflow manager, repository manager to develop ETL code and migrate the code to different environments.
- Developed Informatica mappings using different transformation to load SCD1 and SCD2 target tables in Oracle, db2.
- Created SQL queries for SQL overrides and Pre & Post Session SQL Scripts.
- Address cleansing and validation process has been implemented using Informatica Data Quality.
- Created table, UNIX scripts and parameters files for new batch jobs.
- Maintained all the project source code in source control tools like Bit bucket.
- Informatica workflows sessions has been created for batch jobs.
- Created test cases to perform unit testing for developed objects and documented.
Confidential, Canton, MA
Sr. Informatica Developer
Responsibilities:
- Designed the ETL Process which pulls data from different sources like Oracle EBS, flat files, XML files and third-party sources and loads into Data marts.
- Participated in designing the Functional documents which assists the developers in coding.
- Streamlined the process for fetching and loading the policy data after discussing with Data Architect.
- Created technical design documents for new mapping and enhanced mappings.
- Worked on various ETL Production issues and deployed changes in Production.
- Populated Date dimensions using PL/SQL scripts.
- Developed Informatica mappings using different transformations to load SCD1 and SCD2 target tables.
- Created SQL queries for SQL overrides and Pre & Post Session SQL Scripts
- Created Workflows and sessions to create new batch jobs in Informatica.
- Created parameters and variables for new batch jobs.
- Performed Unit testing and documented test cases and results.
- Created test cases to perform unit testing for developed objects and documented.
Confidential, Boston, MA
Sr. Informatica Developer
Responsibilities:
- Gathered the Business requirements from users and converted them into technical design documents.
- Worked in part of the agile team and developed the ETL solutions within sprint releases.
- Developed ETL Mappings, mapplets using different transformations like Source qualifier, Lookups, Aggregator, Sorter, Router, Filter, Expression, Sequence generator, Update strategy, SQL transformation, FTP transformation and web service consumer transformations.
- Converted existing oracle procedure and packages into Informatica mappings.
- Created web services mappings in Informatica and published web services workflows in Informatica hub.
- Created staged web services workflows and input and output request workflows and validated web service response against WSDL files.
- Generated XML documents using XML generator transformation from relations database tables and validated XML documents against XSD schemas.
- Created Informatica mapping, workflow and connection variables to pass input values from parameter files and workflow variables.
- Created reusable tasks like decision task, command and email tasks and sent success, failure notifications.
- Created concurrent and sequential workflows in Informatica workflow manager and scheduled them using Informatica scheduler.
- Created SQL queries for SQL overrides and Pre & Post Session SQL Scripts and UNIX scripts.
- Source data has been cleansed using Informatica Data quality.
- Debugged the issues by running sessions in verbose level and Informatica debugger.
- Created test cases to perform unit testing for developed objects and documented.
Confidential, Pawtucket, RI
Sr. Informatica Developer
Responsibilities:
- Collaborated with Business users for requirements gathering and performed impact analysis on existing data warehouse system.
- Designed ETL solution to extract data from the heterogeneous source systems like SAP, MS SQL Server, flat files and loading into Staging and Data Warehouse system.
- Created technical design documents for new mapping and enhanced mappings.
- Extracted data from SAP ECC 6.0, SAP R3 using SAP BCI extractors.
- Developed Informatica mappings using different transformation to load SCD1 and SCD2 target tables.
- Created SQL queries for SQL overrides and Pre & Post Session SQL Scripts
- Created reusable transformations and mapplets and sessions and tasks.
- Workflows and sessions are cloned to create new batch jobs from existing batch jobs.
- Created parameters and variables for new batch jobs.
- Source data has been cleansed using Informatica Data quality.
- Informatica debugger is used to debug Informatica mappings.
- Created test cases to perform unit testing for developed objects and documented.
- Involved in Production Support and various product release activities.
- Monitored Informatica jobs using tidal scheduler.
- Coordinated off shore and on shore developers in development, testing and reviewed the objects.
Confidential
Sr. Informatica Developer
Responsibilities:
- Collaborated with Business users to gather business requirements.
- Analyzed existing SSIS packages and created technical designed documents.
- Converted SSIS packages into Informatica mappings.
- Created SCD 1, SCD 2 mappings to handle slowly changing dimensions.
- Consumed third party web services in Informatica using web service consumer transformation and developed mappings.
- Created Informatica mappings to load data into Salesforce objects.
- Developed Informatica Mappings, mapplets using Source qualifier, Application source qualifier, Lookups, Salesforce lookup, Aggregator, Sorter, Router, Filter, Expression, Sequence generator, Update strategy, Java transformation and web service consumer transformations.
- Implemented Informatica mappings using XML source files.
- Implemented partitions in web services mappings to improve session performance.
- Created sequential and concurrent Sessions and workflows to load data into data warehouse systems and Salesforce systems.
- Exported and imported Informatica objects from Informatica repositories.
- Data has been cleansed using third party web services.
- Configured emails to notify status of the scheduled jobs.
- Performed unit testing for mappings and documented.
- Scheduled Informatica mappings using ESP scheduler and monitored the scheduled jobs.
Confidential, Baltimore, MD
Informatica Developer
Responsibilities:
- Converted business requirements into technical design documents to implements data loads from different source systems.
- Involved in data modeling design and data base development to build data warehouse systems.
- Created ETL mappings using Informatica to data into data warehouse systems.
- Created Informatica Mapping, Mapplets using Lookups, Aggregator, Sorter, Router, Filter, Expression, Union, Rank, Sequence generator, Stored Procedures, Update strategy transformations.
- Created sequential and concurrent Sessions and workflows to load data into data warehouse systems and data marts.
- Created mappings, connection variable and parameters to pass dynamic values.
- Scheduled workflows based on load orders using Informatica scheduler.
- Responsible for Unit Testing and Integration testing of mappings and workflows.
- Created unit testing and functional testing documents.
- Determined various bottle necks and successfully eliminated them to great extent.
- Debugged and sorted out the errors and problems encountered in the production environment.
Confidential, San Rafael, CA
Informatica Developer
Responsibilities:
- In agile methodology Collaborated with Business analysts and Stake holders for requirements gathering, business analysis.
- Created mapping specification documents to implement data flows and business logic.
- Extensively worked with Informatica client tools Informatica designer, Workflow Manager, Repository Manager, Workflow monitor.
- Designed and developed ETL Mappings, Mapplets using Lookups, Aggregator, Sorter, Router, Filter, Expression, Union, Rank, Sequence generator, Stored Procedures, Web service consumer transformation, java transformation, Update strategy transformations.
- Created complex mappings with shared objects/Reusable Transformations/Mapplets using mapping/mapplet Parameters/Variables.
- Designed SCD 1, SCD 2, SCD3 mappings to handle slowly changing dimensions.
- Created sequential/concurrent Sessions/ Batches for data loading process and used Pre & Post Session SQL Script to meet business logic.
- Configured workflows with Email Task, which would send mail with session, log for Failure of a sessions and for Target Failed Rows.
- Created Informatica deployment groups in repository manager and migrated to different environments.
- Used PLSQL developer, TOAD to run SQL queries and validate the data.
- Tuning the Mappings for Optimum Performance, Dependencies and Batch Design.
- Designed and developed aggregated tables to improve the reports performance.
- Involved in Unit testing with SAP source systems, Oracle data warehouse systems to check whether the data is loading into target, which was extracted from different source systems according to the user requirements.
Confidential, Minneapolis, MN
Informatica Developer
Responsibilities:
- Worked with Business analysts and the DBA for requirements gathering, business analysis and designing and participated document review meetings.
- Involved in Informatica9.0.1 Installation and upgraded existing Informatica8.5 to Informtica9.0.1
- Performed Informatica repository management including repository backups & restore and creating folders, shared objects& code purge.
- Extensively worked on the Repository Manager to create/modify/delete users/group/roles.
- Worked with different kinds of Code migration including XML import and XML export, folder migration, deployment groups, Manual migration
- Designed and created mappings, sessions and workflows and schedule the workflow as per the Functional & Technical specifications.
- Extracted the data from Oracle11g/10g, XML, Flat files load the data into Oracle data warehouse.
- Involved in Performance Tuning at various levels including Target, Source, Mapping and Session for large data files.
- Worked extensively in PL/SQL procedures to load the data.
- Involved in Unit testing, User Acceptance Testing to check the data loads into target.
Confidential, Danbury, CT
Informatica Developer
Responsibilities:
- Worked closely with the Business Analyst while preparing and reviewing the business specifications of the project.
- Extensively used all the transformations like source qualifier, aggregator, filter, joiner, Sorter, Lookup, Update Strategy, Router, and Sequence Generator to create mappings and mapplets.
- Involved in extraction of data using delimited and fixed width flat files and various XML sources and targets
- Created Stored Procedures to transform the Data and worked extensively in T-SQL, PL/SQL for various needs of the transformations while loading the data into Oracle database
- Responsible for Unit Testing and Integration testing of mappings and workflows.