We provide IT Staff Augmentation Services!

Senior Informatica Developer Resume

Duluth, GA

SUMMARY:

  • Having 11+ years of IT experience with ETL tools Informatica Powercenter, Teradata, IBM Ascential Datastage, IBM Infosphere SQW.
  • Worked in complete Software Development Life Cycle (SDLC), starting from requirement gathering, analysis, design, testing, debugging, implementation, post implementation support and till maintenance.
  • Good in Onsite - Offshore work co-ordination.
  • Strong experience on Informatica Powercenter tools - Mapping designer, Mapplet Designer, Transformations Developer, Informatica Repository Manager, Workflow Manager, Workflow Monitor, Admin console.
  • Good Experience on Teradata load utilities Fast Load, Multi Load, TPump, Bteq, Fast Export and SQL Assistant Manager to write the complex SQL queries
  • Good experience and strong knowledge in Business Intelligence tools such as SAP BO, Cognos and SAS.
  • MDM Hub configurations - Data modeling, Data Mappings, Data validation, Match and Merge rules, Hierarchy Manager, customizing/configuring Informatica Data Director.
  • Good exposure on MDM (Master Data Management) Hub developer.
  • Good exposure on Informatica Data Quality transformations like Address validator, Parser, Labeler, Match, Exception, Association, Standardizer and other significant transformations.
  • Experience on Data integration from multiple source systems, files and loading the data into a single staging area.
  • Strong in Performance tuning of ETL process.
  • Experience on Data Stage, designing and developing jobs using Data Stage Designer, Data Stage Manager, Data Stage Director and Data Stage Debugger
  • Ability to work with limited resources, capable of multi-tasking, planning works around concurrent and time sensitive deliveries.
  • Quick to learn.
  • Experience on Data warehouse methodologies on normalization and dimensional modeling.
  • Worked in Agile & Waterfall model work environments.
  • Good team player, strong interpersonal and communication skills combined with self-motivation initiative and positive attitude.
  • Looking ahead for great personal and professional career in a fair working environment with opportunities to grow.

TECHNICAL SKILLS:

DWH ETL Tools: Informatica Powercenter, Teradata, Ascential Data StageIBM Infosphere SQW, Informatica MDM and Informatica B2B MFT

RDBMS: IBM DB2, Oracle, SQL Server, Netezza, Toad.

Files: Microsoft Visio,Erwin, MS word, MS Excel, XML and Flat Files.

BI Reporting Tools: SAP Business Objects, Cognos, SAS

Programming Languages/Scirpting: Unix Shell Scipting, PL/SQL, Java, C

Operating Systems: IBM AIX UNIX, Windows 8/7/Vista/NT/XP.

Domain Knowledge: Finance, Healthcare, Telecommunications, Insurance, Pharmacy and Retail

PROFESSIONAL EXPERIENCE:

Confidential

Senior Informatica Developer, Duluth, GA

Responsibilities:

  • Involved in understanding of architecture design part, business processes and data modeling design.
  • Interaction with the client on gathering the new requirement for including new entities into the DW
  • Implemented various Performance techniques at mapping and workflow level
  • Using SQL Developer to write SQL or PL/SQL scripts, Views and Materialized views.
  • Working on UC4 scheduler tool to schedule the Informatica workflows and Materialized views refresh jobs.
  • Extensively worked with Lookup, Update Strategy, joiner, aggregator, sorter transformations.
  • Prepared and Maintained different Database environments like Dev, Testing, Staging and Sandbox with the regular Backup and Restore plans
  • Involving in year end activities like preparing backup scripts for tables and schedule planning
  • Working on enhancement change requests and supporting to reporting teams
  • Attending weekly status meetings.

Environment: Informatica Powercenter 10.2, Flat Files, SQL Server, DB2, UC4 Scheduler, Oracle 11g, FTP, Win SCP, SQL, PL/SQL, Unix, Windows, Cognos, Qlikview.

Confidential

Senior Informatica Developer, Broomfield, CO

Responsibilities:

  • Involved in understanding of architecture design part, business processes and data modeling design.
  • Working as a data analyst
  • Working with the clients to create Technical design documents and field-field level mapping spread sheets.
  • Working as a developer creating mappings, sessions and workflows in Informatica powercenter.
  • Writing DB PL SQL scripts using Oracle TOAD.
  • Performing Unit testing of the developed mappings and workflows and documenting the results.
  • Developing UNIX shell scripts to invoke informatica workflows and testing them.
  • Performing data population tests against target system to ensure accuracy and quality of data.
  • Interacting with IDQ team to understand the source data with the business required format and the same address format is to be loaded in the target files using informatica powercenter.
  • Involving in performance tuning to improve the performance of long running workflows
  • Developed Stored Procedures, Functions, database Triggers and created Packages to access databases and called in Informatica mappings.
  • Configuring and scheduling the batch jobs using Crontab scheduler tool.
  • Deploying the code into other environments by creating the linux and Informatica deployment packages and plan document.
  • Attending weekly status meetings.

Environment: Informatica Powerncenter 10.1, Informatica Cloud, IDQ, XML files, Flat Files,DB2, Crontab Scheduler, Oracle 11g, FTP, Win SCP, SQL, PL/SQL, Unix, Windows 10.

Confidential

Senior Informatica Developer, Weston, MA

Responsibilities:

  • Involved in understanding of architecture design part, business processes and data modeling design.
  • Working with the clients to create Technical design documents and field-field level mapping spread sheets.
  • Working as a developer creating mappings, sessions and workflows in Informatica powercenter.
  • Writing DB PL SQL scripts using Oracle TOAD.
  • Performing Unit testing of the developed mappings and workflows and documenting the results.
  • Developing UNIX shell scripts to invoke informatica workflows and testing them.
  • Performing data population tests against target system to ensure accuracy and quality of data.
  • Extracting the data from MDM landing tables and loading into the target files through Informatica Powercenter.
  • Interacting with IDQ team to understand the source data with the business required format and the same address format is to be loaded in the target files using informatica powercenter.
  • Involving in performance tuning to improve the performance of long running workflows
  • Developed Stored Procedures, Functions, database Triggers and created Packages to access databases and called in Informatica mappings.
  • Configuring and scheduling the batch jobs using ActiveBatch scheduler tool.
  • Deploying the code into other environments by creating the linux and Informatica deployment packages and plan document.
  • Attending weekly status meetings.

Environment: Informatica Powerncenter 9.6.1, Informatica Cloud, Informatica MDM, IDQ, Salesforce service cloud, salesforce Marketing cloud, Flat Files,DB2, ActiveBatch Scheduler, Oracle 11g, FTP, Win SCP, SQL, PL/SQL, Unix, Windows 7.

Confidential

Senior Informatica Developer & Release Management, Woonsocket, RI

Responsibilities:

  • Involved in understanding of architecture design part, business processes and data modeling design.
  • Worked with the clients to create Technical design documents and field-field level mapping spread sheets.
  • Worked as a developer creating mappings, sessions and workflows in Informatica powercenter.
  • Written DB SQL scripts using Oracle SQL developer.
  • Worked on Power exchange CDC on Oracle DB source.
  • Used Power exchange data source to import the tables on powercenter.
  • Performed Unit testing of the developed mappings and workflows and documenting the results.
  • Developed UNIX shell scripts to invoke informatica workflows and testing them.
  • Defined the Base objects, Staging tables, foreign key relationships, static lookups, dynamic lookups, queries, packages and query groups.
  • Created Mappings to get the data loaded into the Staging tables during the Stage Process.
  • Defined Trust and validation rules before loading the data into the base tables.
  • Involved with IDQ team while working on the source files using standardized, parser, expression transformations and validated and formatted the address data using Address validator.
  • Performed data population tests against target system to ensure accuracy and quality of data.
  • Migrated all the ETL- Workflows, Mappings, sessions, UNIX shell scripts, Parameter files, and Env files thru SVN Version to various Environments.
  • Configuring and scheduling the batch jobs using control M.
  • Involved in Informatica admin activities to bring up or down the services.
  • Worked with DBA on database admin activities.

Environment: Informatica Powercenter 9.6.1, Power Exchange CDC, Flat Files,DB2, Control M, Informatica Data Quality, Oracle 11g, FTP, Win SCP, SQL, PL/SQL, Unix, Windows 7.

Confidential

Senior Informatica Developer & Admin, Warwick, RI

Responsibilities:

  • Involved in understanding of architecture design part, business processes and data modeling design.
  • Involved with Informatica B2B MFT team and IDQ team interactively before starting the ETL process with the source files and after completing the ETL process with the target files to make ensure with the file format and its naming conventions as per the business user needs.
  • Have prepared requirement understanding documents at the time of estimation on planning on design and implementation of ETL flows as per the business flow
  • Used complex transformations like Lookup, Update Strategy, Sequence Generator and Normalizer transformations while developing mappings using Mapping designer and created the sessions and other tasks using Workflow Manager and used Workflow Monitor to run and monitor the workflows.
  • Lead the Offshore team, actively coordinated with client people and updated them with the project status.
  • Prepare the road-map for the completion of tasks and plan to share the work among the team as per each individual capability.
  • Extensively worked on Workflow monitor to run the workflows and monitoring the session logs, workflow logs and evaluating on performance statists, thread statistics.
  • Involved in Informatica admin activities.
  • Involved with IDQ team and Developed rules and mapplets that are commonly used in different mappings
  • Used various transformations in IDQ like Address validator, parser, joiner, filter, matching to develop the maps
  • Used IDQ to complete initial data profiling and removing duplicate data
  • Performance tuning has been done to increase the through put for both mapping and session level and SQL Queries Optimization as well.
  • Worked on Linux shell scripting, FTP.
  • Enhanced the reusability of the sessions across different workflows.
  • Interactively coordinated with QA team
  • Documented ETL test plans, test cases, test scripts, and validations based on design specifications for unit testing, system testing, functional testing, regression testing, prepared test data for testing, error handling and analysis.

Environment: Informatica Poercenter 9.5.1, Informatica B2B, Informatica Data Quality, Flat Files,DB2, Autosys, Oracle 11g, Netezza,FTP, Win SCP, AQT, SQL, PL/SQL, Linux, SAS, Windows 7.

Confidential

Senior Informatica Developer

Responsibilities:

  • Involved in understanding of business processes and coordinated with business analysts to get specific user requirements.
  • Interacted with data analyst to understand the data format and standards on file naming conventions as per the business requirement and setting up the file frequency to generate the workflows.
  • Studied the existing data sources with a view to know whether they support the required reporting and generated change data capture request.
  • Involved in Developing Mappings, Sessions and Workflows using Informatica Powercenter tools Mapping Designer, Workflow Manager and scheduled the workflows using Autosys
  • Involved in Creating sessions and Workflows using Informatica Workflow Manager
  • Involved in Performance Tuning at mapping level and session level
  • Involved in writing shell scripting for file validation and executing the workflows.
  • Used Teradata SQL assistant to write the complex sql queries.
  • Involved in writing Fastload, Multiload, Fastexport, BTEQ scripts.
  • Involved with IBM Cognos team creating the reports based on the business adhoc requirements using Cognos studio, Report studio and framework manager tools.
  • Worked on enhancement change request and involved in Production support
  • Performed performance tuning of the jobs by interpreting performance statistics of the jobs developed.
  • Documented ETL test plans, test cases, test scripts, and validations based on design specifications for unit testing, system testing, functional testing, regression testing, prepared test data for testing, error handling and analysis.

Environment: Informatic Powercenter, Teradata 12, Flat files, XML files, IBM DB2, Oracle10g, IBM Cognos 10.2.1, Toad, PL/SQL,Unix, Autosys, Windows NT/XP

Confidential

Informatica Developer

Responsibilities:

  • Analyzed the existing business model.
  • Interacted with business users on weekly basis in finalizing high-level business requirements.
  • Prepared detail-level design documents based on the discussions to get sign-off from business.
  • Analyzed the impact and provided estimations in PD’s to Client whenever there was a change in client requirements.
  • Created Informatica jobs to extract data from different external sources and populate into data warehouse tables/flat files by transforming the data as per business rules.
  • Involved in Unit testing and Integration testing of Informatica workflows.
  • Responsible for tuning the Performance of Informatica ETL mappings.
  • Reviewing and testing of mappings, sessions, workflows.
  • Worked on SQL Assistant to write the complex SQL queries
  • Involved in writing the Bteq scripts and load utilities Fast Load, Multi Load and Fast Export.
  • Involved with OBIEE team and created the reports based on the adhoc requirements.
  • Extensively used Designer to design universes for different business groups.
  • Used joins concept by taking different tables from different data sources in the Universe.
  • Provided the warranty support by interacting with production support teams.

Environment: Informatica 8.1,Teradata V2R6, Autosys, Oracle 10g,DB2, SQL, PL/SQL, UNIX, OBIEE, Windows 2003.

Confidential

Senior Data Stage and Infosphere SQW Developer

Responsibilities:

  • Interacted with End user to understand the business requirements and in identifying data sources.
  • Analyzed the existing informational sources and methods to identify problem areas and make recommendations for improvement. This required a detailed understanding of the data sources and researching possible solutions.
  • Worked with Data stage Manager for importing metadata from repository, new job Categories and creating new data elements
  • Integrated the data from source relational source systems and files and loaded into staging area.
  • Designed and developed ETL processes using Data Stage designer to load data from Oracle, MS SQL, Flat Files (Fixed Width) and XML files to staging database and from staging to the target Data Warehouse database.
  • Used Data Stage stages namely Hash file, Sequential file, Transformer, Aggregate, Sort, Datasets, Join, Lookup stages in accomplishing the ETL Coding.
  • Taken complete role of Migration from Datastage to IBM Infosphere SQW and Lead the migration team and reviewed and validated the codes from Datastage to Infosphere SQW and performed the data validation using sql queries on Oracle and DB2.
  • Involved with Business Objects team and created the reports and universes and optimized the complex sql queries.
  • Verified the BO Reports by extracting data from the Staging Database using SQL queries
  • Implemented row and object level security in business objects universe Designer.
  • Performed unit testing of the reports.
  • Developed job sequencer with proper job dependencies, job control stages and triggers.
  • Excessively used DS Director for monitoring Job logs to resolve issues
  • Documented ETL test plans, test cases, test scripts, and validations based on design
  • Specifications for unit testing, system testing, functional testing, prepared test data for testing, error handling and analysis. Participated in weekly status meetings.
  • Designed Control Flows, Sub processes, Dataflows in Infosphere SQW
  • Created single Master Control Flow for all dimensions by incorporating some dimensions to run in parallel using parallel container step and all dimensions based on their dependency and time priority
  • Automated some run time parameters in Infosphere SQW.

Environment: IBM Ascential Data Stage client 7.5.1 (Designer, Director, Manager), Infosphere SQW, IBM DB2, Oracle 10g, SQL Server 2008, Flat files, Sequential files, AIX UNIX, SAP Business Objects.

Confidential

Data Stage Developer

Responsibilities:

  • Interacted with Business Analyst to understand the business requirements and in identifying data sources.
  • Analyzed the existing informational sources and methods to identify problem areas and make recommendations for improvement. This required a detailed understanding of the data sources and researching possible solutions.
  • Worked with Data stage Manager for importing metadata from repository, new job Categories and creating new data elements
  • Designed and developed ETL processes using Data Stage designer to load data from Oracle, MS SQL, Flat Files (Fixed Width) and CSV files to staging database and from staging to the target Data Warehouse database.
  • Used Data Stage stages namely Hash file, Sequential file, Transformer, Aggregate, Sort etc stages in accomplishing the ETL Coding.
  • Involved with Business Objects team and created the reports and universes and verified the BO Reports by extracting data from the Staging Database using SQL queries
  • Excessively used DS Director for monitoring Job logs to resolve issues
  • Documented ETL test plans, test cases, test scripts, and validations based on design specifications for unit testing, system testing, functional testing, prepared test data for testing, error handling and analysis.

Environment: IBM Ascential Data Stage client 7.5.1 (Designer, Director, Manager), Oracle 10g,SQL Server 2008,IBM DB2, Flat files, Sequential files, AIX UNIX, Business Objects

Hire Now