SUMMARY

• Having 8 Years of IT experience in Data Warehousing with extensive use of ETL tools such as Informatica intelligent Cloud Services (IICS), Informatica Cloud (ICS), informatica cloud real time (ICRT), Informatica Power Center 8X/9X/10X.
• Involvement in all phases of SDLC (Systems Development Life Cycle) from analysis and planning to development and deployment.
• Expertise in integrating various applications like Oracle Cloud, Oracle Database using Informatica Intelligent Cloud Services.
• Expertise in using IICS Rest API to perform various platform operations like running the Tasks, Checking the present running tasks in Data integration, connections updating using rest API.
• Expertise in integrating the various third - party applications using REST and SOAP web services.
• Worked with Assignment step, create step, jump step and data decision step, Service call step, wait step, sub process in application integration services.
• Expertise in various informatica products like Power Center, Informatica intelligent Cloud Services (IICS), Informatica Cloud B2B and Informatica Cloud Data Quality.
• Implemented Data Profiling created Rules, Mapplets and generated Scorecards in informatica Cloud Data Quality Services.
• Expertise in various services of IICS like data integration, application integration, monitor, application integration services, Administrator, Data Quality and Profile.
• Worked with Assignment step, create step, jump step and data decision step, Service call step, wait step, sub process in Cloud Application Integration services.
• Expertise in creating Data Synchronizing Task, Mapping Task, Mapping Configuration Tasks.
• Extensively worked with File Listeners, Schedulers, Connections, Swagger Files, Task Flows, Mapplets, Parameterized Mappings and configuring re-usable code.
• Involved in code migration/deployments in IICS.
• Involved in pre-release environment validations.
• Expertise in of XML and JSON type files parsing and payload creation integration.
• Extensively worked with Task flows to create the dependencies between various tasks.
• Expertise in using the various advanced transformations like Hierarchy Builder, Hierarchy Parser, Structure Parser, Web service Transformation, Aggregator, Joiner, Lookup, Normalizer etc.
• Extensively worked with various components like Business Services, Intelligent Structure Model, File Listeners, Fixed width file Formats.
• Good exposure in various Microsoft Azure Services like Azure Data Factory, Azure Logic Apps.

TECHNICAL SKILLS

ETL/DQ Tools: Informatica Intelligent Cloud Services IICS (CDI, CDQ, CAI) and Informatica Power Center

Databases: Oracle 11g/10g/9i/8i, SQL Server 2013, DB2

Languages: UNIX Shell Scripts, XML and SQL

SQL Tools: SQL plus, TOAD, Oracle SQL developer

UNIX Tools: Putty, WinSCP, Jump Server secured access

Other Tools: SoapUI, MS Office, Service Now, HP QC, JIRA, Remedy

Operating Systems: Windows (NT,2000/03/XP/Vista/7), Linux (Red Hat), Unix AIX 5.0/5.2/6.0

Scheduler Tools: Autosys, Control-M and Informatica Scheduler

PROFESSIONAL EXPERIENCE

Confidential - Atlanta, GA

ETL Informatica / Integration Specialist

Responsibilities:

• Gather the requirement by participating in the meetings with stake holders along with Project Managers.
• Design, Orchestrate and Develop the solution using Informatica Cloud.
• Creating complex mappings using various transformations like Source, target, Lookup, Joiner, Hierarchy Builder, Hierarchy Parser, Mapplet, Structure Parser, Joiner, Aggregator, Web service Transformations.
• Walking over the High-level design to the Business Users/Stakeholders and getting approval over the High-level design.
• Extensively worked with Data Synchronizing Task, Mapping Task, Mapping Configuration Task, task flows in Cloud Data Integration.
• Implementing the complex solution using various informatica cloud services like Data Integration, Application Integration, Administrator, Application integration console, Monitor and Cloud B2B Gateway.
• Creating complex components like File Listeners, Schedulers, Connections, Swagger Files, Task Flows, Mapplets, Parameterized Mappings and configuring re-usable code.
• Ensuring best practices has been followed for developing to ETL/Process using Informatica Cloud/Informatica Power Center.
• Extensively worked with RestV2 connector to integrate data with REST Services using Business service and Web service transformation.
• Work with business and IT executives from the client to identify the business needs and define the business & technical solution architectures to fulfill the business needs.
• Created Users and Assigned Roles to the users using Administrator Services.
• Implemented Changed Data Capture logic to extract the delta loads using in-out parameters.
• Involving in the various stages of SDLC process like requirement gathering, assigning the development tasks to the peers, and assisting in various testing phases like unit testing, functional testing, user acceptance testing.
• Worked in integrating third-party web applications using REST and SOAP Web Services using Web Service Transformations in Informatica Intelligent Cloud Services.
• Worked in Informatica intelligent Cloud Services (IICS), Informatica Cloud Application Integration.
• Worked with Assignment step, create step, jump step and data decision step, Service call step, wait step, sub process in Cloud Application Integration services.

Environment: IICS, Informatica Power Center, SoapUI, Postman, Agile, TOAD, Putty, PL/SQL, UNIX Shell Scripting, Flat Files

Confidential, Dallas -TX

Informatica Developer

Responsibilities:

• Lead analysis sessions gather requirements and write specification and functional design documents for enhancements and customization.
• Understand the existing subject areas, source systems, target system, operational data, jobs, deployment processes and Production Support activities.
• Created the High Level and low-level Design Document for the ETL Process.
• Worked on dimensional modeling to design and develop star schemas by identifying the facts and dimensions. Designed logical models as per business requirements using Erwin.
• Extracted, transformed data from various sources such as Flat Files, Oracle 11g and transferred data to the target data warehouse Oracle 11g and XLS files.
• Done transformations like Lookups, Aggregator, Update Strategy, Stored Procedure, Sequence generator, Joiner transformations, SQL overrides usage in Lookups and source filter usage in Source qualifiers and data flow management into multiple targets using Routers.
• Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.
• Developed Database Triggers in order to enforce complicated business logic and integrity constraints, and to enhance data security at database level.
• Worked on different tasks in Workflow Manager like Sessions, Events raise, Event wait, Decision, E-mail, Command, Worklets, Assignment, Timer and Scheduling of the workflow.
• Developed the Match paths, Match Columns and Match rules (Exact and Fuzzy) in the Match and Merge Process.
• Designed and developed Informatica Mapping for data load and data cleansing.
• Responsible for Pre and Post migration planning for optimizing Data load performance, capacity planning and user support.
• Used Informatica debugging techniques to debug the mappings and used session log files and bad files to trace errors occurred while loading.
• Used the PL/SQL procedures for Informatica mappings for truncating the data in target tables at run time.
• Partitioned sources and used persistent cache for Lookup’s to improve session performance.
• Involved in Fine tuning SQL overrides in Source Qualifier and Look-up SQL overrides for performance Enhancements.
• Good experience on performance tuning of ETL jobs and SQL queries.
• Designed and developed UNIX shell scripts as part of the ETL process.
• Created Auto-sys jobs for scheduling.
• Created various documents including high-level design documents, mapping documents and knowledge transfer documents.

Environment: Informatica Power Center 10.2.1/10.4.1 , SQL, Oracle 11g/10g, Autosys, SQL Server, SQL* Loader, SQL developer, PLSQL developer, TOAD, Putty, PL/SQL, UNIX Shell Scripting, Flat Files, Control-M

Confidential, CT

Informatica Developer

Responsibilities:

• Prepared High-level Design and Low-Level Design based on Functional and Business requirements of the project.
• Designing & documenting the functional specs and preparing the technical design.
• As a team conducted gap analysis and Discussions with subject matter experts to gather requirements, emphasize on problem areas and define deliverables.
• Supported the development, optimization, and maintenance of Informatica mappings with various source data including Oracle and SQL.
• Designed and developed UNIX Shell scripts for creating, dropping tables which are used for scheduling the jobs.
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Developed several complex mappings in Informatica a variety of Power Center transformations, Mapping Parameters, Mapping Variables, Mapplets & Parameter files.
• Developing workflows with Worklets, Event waits, Assignments, Conditional flows, Email and Command Tasks using Workflow Manager.
• Expertise in Performance Tuning by identifying the bottlenecks at sources, targets, Power Center transformations and session’s level. Collected performance data for sessions and performance tuned by adjusting Informatica session parameters.
• Worked with the third-party scheduler Autosys for scheduling Informatica Power Center Workflows Involved with Scheduling team in creating and scheduling jobs in Autosys Workload Scheduler.

Environment: Informatica Power Center 10.2.1/9.6.1 , SQL

Confidential, FL

Informatica Developer

Responsibilities:

• Wrote Informatica ETL design documents, establish ETL coding standards and perform Informatica mapping reviews.
• Worked on Power Center 9.6 Client Tools like Power center Designer, Workflow Manager, and Workflow Monitor.
• Worked on Power Center 9.6 Designer client tools like Source Analyzer, Target Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Analyzed the source data coming from different sources (Oracle and SAP Flat files) and worked on developing ETL mappings.
• Developed various Oracle sub functions like Stored Procedures, Functions, and Packages using PL/SQL in order to ensure the data integrity and security.
• Created Process Control and Metadata for informatica jobs.
• Created reusable Sessions, command tasks, worklets and workflows in Workflow Manager.
• Utilized Informatica toolset (Informatica Data Explorer, and Informatica Data Quality) to analyze legacy data for data profiling.
• Responsible for the Performance tuning at the Source Level, Target Level, Mapping Level and Session Level.
• Performed Unit testing and Data validation testing using Validation scripts.
• Proven Accountability including professional documentation and weekly status report.

Environment: Informatica Power Center 8.6, Oracle 10g, Flat Files, UNIX, Win XP, SQL * Plus.