We provide IT Staff Augmentation Services!

Data Warehouse Analyst /etl Developer Resume

Greenville, SC

SUMMARY:

  • Over 14 years as a Project Manager with experience managing multiple mid - level to large enterprise cross-functional projects, Analysis, Design and Development in various business applications as an ETL developer with major contribution in Informatica B2B Data Transformation (DT) studio, Informatica Power Center 9.x/8.x, Informatica B2B Data Exchange (DX).
  • Extensive experience of design\architecture and project management for complex solutions involving Informatica B2B.
  • Experience in implementing Data transform solutions involving most industry standard file formats like EDI, ACCORD etc using Informatica B2B.
  • Experienced in analyzing Business and Functional requirements, studying the Source Systems, thoroughly designing the target by going through the Functional Specification Document and one - to-one interaction.
  • Extensively worked on Streamer, Parser, Mapper, Serializer concepts and intake of several input formats varying from Banking Industry layouts, Healthcare Industry layouts.
  • Extensively worked on Informatica Designer Components- Source Analyzer, Designer, Transformation Developer, Mapplet and Mapping Designers.
  • Extensively worked on Informatica B2B Data Exchange Setup from Endpoint creation, Scheduler, Partner setup, Profile setup, Event attributes creation, Event status creation, etc.
  • Experience in designing complete MFT platform using Informatica MFT and Informatica B2B and implementing the framework and various accelerators.
  • Experience in different project methodologies such as Agile and Waterfall.
  • Experience in SQL, PL/SQL.
  • Experience in scheduling meetings with Business Users and Coordinating with offshore team.
  • Enthusiastic and goal-oriented team player possessing excellent communication, interpersonal skills and leadership capabilities with high level of adaptability.
  • Development and implementation experience of a Long Term Project using Informatica B2B & Informatica Power Center.
  • Experience in Insurance, Utility and Telecommunication domains.
  • Experience in leading project both from offshore and onsite.
  • Delivered data warehouse projects end to end ETL solution using Informatica Power Center, Unix & Maestro.
  • Delivered B2B projects end to end solution using Informatica B2B DX, Informatica B2B DT, Informatica Power Center, Unix & Maestro.
  • Excellent knowledge and experience in data warehouse development life cycle, dimensional modeling, repository management and administration.
  • Day-to-day responsibilities include reviewing system documentation, identifying development objectives, developing/updating change requests, fixes, defects, and executing functional and regression Informatica batch testing scenarios.
  • Experience in Performance tuning of sources, transformations, targets, mappings, worklets, workflows, sessions and batches .
  • Involved in User Acceptance testing in different modules of the project
  • Hands on experience in all aspects of Software Development Life Cycle (SDLC).
  • Sound knowledge in the development of relational database environment using SQL, PL/SQL, Stored Procedures and Triggers
  • Developed UNIX shell scripts to ftp, control and schedule Power Center workflows, emailing, archival for B2B Project.
  • Worked in Integration of Informatica with web services, MQ and databases.
  • Strong problem solving, analytical and decision-making skills.
  • Excellent team player and self-starter with good communication and interpersonal abilities.

TECHNICAL SKILLS:

Data Warehousing: Informatica B2B DX, Informatica B2B DT, Informatica Power Center 9.0.1/8.* /7.*, Actuate, Informatica MFT, BPEL

Databases: Oracle, DB2,SQL

Programming: UNIX Shell Scripting. Python, Machine learning

Environment: UNIX, Windows, AIX

PROFESSIONAL EXPERIENCE:

Confidential

Data warehouse Analyst /ETL Developer

Responsibilities:

  • Build and test a proof of concept using confidential IDW workbench and Informatica B2B tool suite to perform file transmission between 2 Client Servers, 2 remote Servers. Use various cryptography algorithm in performing open PGP encryption . Create proof of concept for secure file transfer for various authentication methods including key based authentication. Key based authentication secure file transfer in addition to open PGP encryption provides the best possible security towards Batch Data movement over Internet.
  • Analyze current infrastructure for Data Integration and Managed File transfer platform and prepare report highlighting future readiness considering scalability, adaptability, security and performance type parameters . This analysis will be done based on confidential’s Data practice experience in evaluating platform readiness for other Customers in Partnership with Product providers. Few rounds of performance testing analysis will be performed using Cognizant IDW workbench’s automated tester . Based on the current health of platform, recommend new software and hardware configuration for optimal scenario.
  • Gather Business scenarios \ Use Cases for Data Integration working with Business side people directly following the process and guidance established by confidential for requirement gathering . Understanding business scenarios is key to be able to recommend a good solution . A solution given should not only aspect industry standard, compliance etc requirements but should be able to support Customer’s Business needs . Business needs such as being able to go to a Customer’s network and retrieve Data meeting Customer side security requirements, being able to deliver data to a Customers secure Mailbox . All such Use Cases are critical for various Business needs .
  • Post documentation of Use Cases, work on Customizing confidential provided IDW workbench towards Customer’s Unique Use Cases . Confidential  workbench at the core uses Informatica provided B2B solution and azure cloud .
  • Once the accelerators on the workbench are ready, will work on using the Meta Data and accelerators in producing MFT objects for thousands of Legacy jobs to replace the Legacy jobs on MFT platform . Mammoth effort of converting these Legacy jobs will be reduced significantly which helps Customer in meeting the goal of providing best platform and solution towards Business to Business Data Integration as quickly as possible

Confidential, Greenville, SC

Responsibilities:

  • Design an accelerator which can bulk create MFT set up using Legacy information as input.
  • Review high level design, solution approach for final approval,
  • Upon approval prepare low level design and work on accelerator programming . Accelerator should be convenient for usage for a person who is not a SME on Cleo MFT and Informatica B2B DX.
  • Work with rest of the Team for development of the solution using Cleo APIs, Customized Informatica coding, Customized Unix scripting etc.
  • Hand over the built modules for functional testing, Integration testing, Performance testing and support all types of testing along with rest of the Team for final sign-off.
  • Assist Admin team through all environment deploys until production.
  • Through out the phase use a tool like Partner engagement portal to engage with Partners and do a co-ordinated delivery.
  • Provide post production support along with rest of the Team.

Environment: Operating Systems: AIX, Linux, Windows

Programming Languages: Informatica Power Center, Informatica B2B Data transformation, Informatica B2B Data Exchange, Cleo MFT

Confidential, Greenville, SC

Responsibilities:

  • Involved in requirement gathering, analysis, design, development and deployment from onsite.
  • Not only understand the requirement but give required guidance to Confidential for loopholes and solutions in making their functional design better.
  • Understand and explain all complexity, nuances to Offshore and give design guidance.
  • Giving Offshore Informatica related guidance & develop complex parts myself.
  • Informatica special services (Source Transformation Factory ), DTA had been used which are not as it is products available in the Market.
  • All outside box design, outside box methodology are used in this project .
  • Use transformations like Java transform, SQL transform and other advanced Informatica 9.0.1 transforms in this project.
  • Create the current database by adding proper constraints, rules and defaults to tables.
  • Used DX repository lookups extensively providing knowledge on DX repotisory.

Environment:

Operating Systems:AIX, Linux, Windows

Programming Languages:Informatica Power Center, Informatica B2B Data transformation, Informatica B2B Data Exchange, Cleo MFT

Confidential

Responsibilities:

  • Worked as Module lead in this project.
  • Developed mid-size Projects for Confidential Integration coordinating with Offshore.
  • Creating and maintaining project plans Microsoft project Plan .
  • Project estimation, impact analysis laying out end to end high level design.
  • Worked with Confidential BA in understanding the requirement, channelizing to Offshore.
  • Worked with Infrastructure team in setting up environment which involves Informatica Power Center, web services & MQ making the environment extremely complex.
  • Developed complex Informatica Power Center mappings, Web Services using BPEL.

Environment: Operating Systems: AIX, Linux, Windows

Programming Languages: Informatica Power Center, Informatica B2B Data transformation, Informatica B2B Data Exchange, Cleo MFT

Confidential

Senior ETL Developer

Responsibilities:

  • Involved in requirement gathering, analysis, design, development and deployment from onsite.
  • Not only understand the requirement but give required guidance to Confidential for loopholes and solutions in making their functional design better.
  • 8 BA, 50 requirement documents define the size of the project for one single Onsite Project Lead.
  • Understand and explain all complexity, nuances to Offshore and give design guidance.
  • Giving Offshore Informatica related guidance & develop complex parts myself.
  • Informatica special services (Source Transformation Factory ), DTA had been used which are not as it is products available in the Market.
  • All outside box design, outside box methodology are used in this project .
  • Use transformations like Java transform, SQL transform and other advanced Informatica 9.0.1 transforms in this project.
  • Create the current database by adding proper constraints, rules and defaults to tables.
  • Used DX repository lookups extensively providing knowledge on DX repotisory.

Environment: DB2, Oracle databases, Unix servers, Informatica tools of 9.0.1 version .

Confidential

Responsibilities:

  • Analyzed the functional specs provided by the data architect and created technical specs documents for all the mappings.
  • Prepared ETL Design & Development approach document.
  • Designed and developed Informatica Mappings to load data from Source systems to ODS and then to Data Mart.
  • Used pmcmd command, for running of the sessions, inside the UNIX shell scripts.
  • Created and scheduled workflows using Workflow Manager to load the data into the target Database.
  • Performance tuning of the Informatica mappings using various components like Parameter files, Variables and Dynamic Cache.
  • Monitored the jobs on a daily basis and looked at the session logs to see if jobs completed successfully.
  • Tested the UNIX scripts which support the data loading in Data warehouse.
  • Reviewed the code to maintain proper logic implementation/quality standard.
  • Worked in Informatica 8.1 - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet and Transformations.
  • Created unit test case documents and performed unit testing & resolved issues.

Environment:DB2, Oracle databases, Unix servers, Informatica tools of 9.0.1 version Informatica

Confidential

Sr. ETL Developer

Responsibilities:

  • Developed mid-size Projects for Confidential Integration coordinating with Offshore.
  • Creating and maintaining project plans Microsoft project Plan .
  • Project estimation, impact analysis laying out end to end high level design.
  • Worked with Confidential BA in understanding the requirement, channelizing to Offshore.
  • Worked with Infrastructure team in setting up environment which involves Informatica Power Center, web services & MQ making the environment extremely complex.
  • Developed complex Informatica Power Center mappings, Web Services using BPEL.
  • Proposing modifications and enhancements to the interface for reducing production defects which in turn creates new enhancement projects
  • Maintaining informatica, BPEL and MQ servers
  • Delivering minor enhancements.
  • Participating in meetings, workshops to understand and document requirements
  • Participate in regular calls with offshore for sharing the requirement understanding .
  • Taking up and resolving queries from offshore by discussion with Business users, business analysts and other stake holders like QA team etc.
  • Provide UAT support of the newly built interface.
  • Provide production warranty support

Environment: Informatica Power Center 8.6.0 / 7.1.1, Informatica Power Connect / Power Exchange for web services & MQ, Oracle, PL/SQL, UNIX Shell Script, Toad

Confidential

Informatica Developer

Responsibilities:

  • Analyzed the functional specs provided by the data architect and created technical specs documents for all the mappings.
  • Prepared ETL Design & Development approach document.
  • Designed and developed Informatica Mappings to load data from Source systems to ODS and then to Data Mart.
  • Used pmcmd command, for running of the sessions, inside the UNIX shell scripts.
  • Created and scheduled workflows using Workflow Manager to load the data into the target Database.
  • Performance tuning of the Informatica mappings using various components like Parameter files, Variables and Dynamic Cache.
  • Monitored the jobs on a daily basis and looked at the session logs to see if jobs completed successfully.
  • Tested the UNIX scripts which support the data loading in Data warehouse.
  • Reviewed the code to maintain proper logic implementation/quality standard.
  • Worked in Informatica 8.1 - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet and Transformations.
  • Created unit test case documents and performed unit testing & resolved issues.
  • Support the System Testing and Defect fixing.
  • Implementation in the Production Rollout.
  • Defined various facts and Dimensions in the data mart including Fact less Facts, Aggregate and Summary facts.
  • Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.

Environment: Informatica Power Center 7.1, PL/SQL, Oracle 9i, TOAD, Unix

Confidential

Data Warehouse Developer

Responsibilities:

  • Involved in business analysis and technical design sessions with business and technical staff to develop requirements document and ETL design specifications.
  • Involved in Dimensional Modeling to design and develop STAR Schemas.
  • Worked with various relational sources and flat files to populate the data mart.
  • Extract data from various source systems like flat files and Oracle databases and to schedule the workflows.
  • Created stored procedures to extract data from flat files.
  • Defined Target Load Order Plan and Constraint based loading for loading data correctly into different Target Tables.
  • Used Debugger to test the mappings and fix the bugs.
  • Involved in Performance Tuning of ETL jobs by tuning the SQL used in Transformations.
  • Worked extensively on SQL, PL/SQL and UNIX Shell Scripts.
  • Involved in Unit Testing, Integration and User Acceptance Testing of mappings.
  • Created high-level Technical Design Documents.

Environment: Oracle8i, Informatica Power Center, PL/SQL, Windows, UNIX, TOAD.

Hire Now