We provide IT Staff Augmentation Services!

Etl Informatica/denodo - Tech Lead – Onsite Resume

3.00/5 (Submit Your Rating)

Norwalk, Ct

SUMMARY:

  • Over 10+ years of total IT experience on Informatica Power Center 10.1, Data Virtualization tool: Denodo 6.0, Web - based applications on J2EE, Oracle 9i, Teradata 13.1, UNIX, Exadata.
  • 5+ years of experience in Data Warehousing and ETL using Informatica Power Center 10.1(Workflow Designer, Workflow Manager, Workflow Monitor, Repository Manager, Informatica Metadata manager - IMM), Unix, Oracle, Teradata, Appworx.
  • 3+ years of experience in J2EE (Casper, Struts, spring and Hibernate Frameworks) & Oracle.
  • 3+years of experience in Denodo Data Virtualization 5.5,6.0 tool(Denodo VDP, Denodo Scheduler, JConsole, Diagnostic Monitoring tool)
  • Created Connections in Denodo VDP to connect to Oracle, Green plum, MS SQL, Excel Files.
  • Created Derived Views on top of the Base Views for the mentioned preceding Data Sources.
  • Implemented three layer architecture in Denodo as Connection, Combine& Integration and data consumption for downstream applications.
  • Created Denodo Cache for Derived views and refreshed the cache through Denodo Scheduler and trigger the mail communication for Success and Failure Notifications.
  • Implemented Full and Partial Cache in Denodo VDP using dis cache for making joins and Unions as per downstream reporting requirement.
  • Created Derived Views on top of Base Views and accommodate the Business logics as per User requirement.
  • Implemented the Unions and Joins among the derived views to get the expected result.
  • Involved in Denodo Code deployment from Dev to QA and QA to Production.
  • Experience in working on different phases like Requirement Gathering, Development, Analysis, Documentation, Testing, Migration Project, Production and Post Production support.
  • Involved in preparation of Requirement Traceability Matrix (RTM), Defect Report, and Weekly Status Reports.
  • Worked closely wif Clients, Business Analysts, Data architects, Database Administrators, Developers and BI Reporting teams to ensure the ETL solution meets business requirement.
  • Experience in developing and maintaining software applications in Domain areas of GE Manufacturing, Energy, capital & Treasury.
  • Expertise in Data Warehousing, ETL design and development process using Informatica Power Center (Source Analyzer, Data Warehousing Designer, Mapping Designer, Mapplet, Transformations).
  • Having knowledge on Dimension modeling Star/Snowflake schemas, Dimensional Data modeling, Fact & Dimension tables, Physical & logical data modeling, SCD.
  • Experience wif Data Extraction, Transformation and Loading (ETL) from different data sources like Oracle, MS SQL, Teradata, File System (Text Files, XML files, .csv) into a common analytical data model using Informatica Power Center 9.5 and 10.1.
  • Experience in handling Performance improvement. Well versed wif database partitioning and Informatica mappings performance improvement using partitioning. Processed large volumes of data and large files.
  • Expertise in error handling, debugging and problem fixing in Informatica.
  • Informatica upgrade from 9.5 to 10.1

TECHNICAL SKILLS:

Programming languages: C, C++, Java 5, R-3.4, Python

Web Technologies: XML, XSLT, JSP, Java Script, Servlets, HTML, Spring and Hibernate.

Scripting Language: Unix Shell Scripting and Perl

Database RDBMS: Oracle 10g, TERADATA 13, Greenplum, Exadata.

Integration Tools: Denodo 6.0

Development/ETL Tools & Utilities: Informatica 10.1, Teradata SQL Assistant, Toad, PGAdmin, SQL Developer, MS Office, WinSCP, Putty, Support Central(GE Product), MES, Kronos, MS Office 2010, Jenkins, Tortoise SVN, uDeploy, Aginity, R Studio 1.0, Anaconda

Scheduling Tools: Appworx, Unix Cron Jobs

Business Support Process Management: ITIL Process: Incident, Problem, Change Request, Requests (Hewlett Packard Service Desk 2.0(HPSD), HP QC, GE Service Now, Rally)

Operating Systems: Unix, Linux, Windows NT/2010/XP/98/2000

Trainings Attended: DB2, Informix, Salesforce.com, OBIEE, Denodo 6.0, Hadoop Bigdata, Machine Learning in R, Python

PROFESSIONAL EXPERIENCE:

Confidential, Norwalk, CT.

ETL Informatica/Denodo - Tech Lead - Onsite

Responsibilities:

  • Interacting wif the Clients on a regular basis to discuss day-to-day issues and enhancement tasks.
  • Providing Development & support for 800+ Informatica workflows/Mappings (developed using Informatica 9X) which are running into Production environment at client Location.
  • Providing Development & support for more TEMPthan 100+ Denodo Jobs in Denodo 6.0 tool using Denodo VDP, Denodo Scheduler
  • Created Connections in Denodo VDP to connect to Oracle, Green plum, MS SQL, Excel Files.
  • Created Derived Views on top of the Base Views for the mentioned preceding Data Sources.
  • Implemented three layer architecture in Denodo as Connection, Combine& Integration and data feeding for downstream applications.
  • Created Denodo Cache for Derived views and refreshed the cache through Denodo Scheduler and trigger the mail communication for Success and Failure Notifications.
  • Implemented Full and Partial Cache in Denodo VDP using dis cache for making joins and Unions as per downstream reporting requirement.
  • Created Derived Views on top of Base Views and accommodate the Business logics as per User requirement.
  • Implemented the Unions and Joins among the derived views to get the expected result.
  • Involved in Denodo Code deployment from Dev to QA and QA to Production.
  • Analyze the Informatica and Denodo Job failures and work wif respective stakeholders for resolution and ensure they do the changes permanently.
  • Resolving the Incidents/Request/Problem wif ITIL standards.
  • Involved in code & data analysis and handling the ad hoc requests by interacting wif Business Analysts, Clients and Customers and resolve the issues as part of production support for Denodo, Informatica tools.
  • Reviewing Project tasks wif offshore team and ensuring they complete on time.
  • Understand\Document the project requirement as per Business needs and convert the Project requirement to technical specification document.

Confidential

ETL Informatica Developer/Lead - Offshore

Responsibilities:

  • Understanding the Business Requirement Document’s as well as technical aspects of the Project.
  • Involved in the low level designing of Commercial Finance EDW.
  • Involved in clarification calls on requirements wif Business Analysts/Client and freeze the requirement for every sprint.
  • Involved in Scheduling calls, tracking and control.
  • Modifying the Teradata BTEQ scripts as per the requirement.
  • Creating and modifying the mappings and workflows as per the requirement.
  • Creating and modifying the chain in Appworx scheduler tool.
  • Preparing the test case documents for moving to Production environment.
  • Understanding the existing BTEQ scripts and Mappings.

Confidential

ETL Informatica Developer - Offshore

Responsibilities:

  • Collecting the requirements from the Client and understanding the Business Requirement and Functional Document’s as well as technical aspects of the Project.
  • Creating Low level and High level and technical design documents in Informatica.
  • Worked on Informatica Power Center Designer - Source analyzer, Mapping Designer and Transformation developer.
  • Used various Informatica transformations to load data in the data warehouse
  • Used Lookup, Sequence generator, Router and Update Strategy transformations to insert, delete, and update the records for Slowly Changing Dimension tables
  • Extensively used Mapplet’s and Reusable Transformations to prevent redundancy of transformation usage and maintainability
  • Created database objects like tables, views, indexes, sequences and performing DML operations using insert, update and delete statements.
  • Involved in different phase of testing like User Acceptance Testing, Unit testing.

Confidential

ETL Informatica Developer - Offshore

Responsibilities:

  • Understanding the requirements as per the specification document.
  • Repointing the Source connections to new application.
  • Helping the dependent teams (WebMethods) to point their integrations to Venture application.
  • Creating the new Mappings for taking data from BTP instead of SSP5.
  • Loading the Legacy ISPT Data to Venture application.
  • Creating the workflows and scheduling them as per business requirement.
  • Used trigger based mechanism to handle dependencies.
  • Troubleshoot the errors during load.

Confidential

ETL Informatica Developer - Offshore

Responsibilities:

  • Analysis of the specifications provided by the clients
  • Design to approach to integrate the Applications wif IPS
  • Development - Creating Informatica Mappings to support the integration requirement.
  • Testing - unit testing & integration testing
  • Interacting wif the client on a daily basis to update the project status.
  • Migration to QA and conduct UAT.
  • Production migration & Post Production Support for 15 days.

Confidential - Atlanta

Java Developer/Production Support - Offshore

Responsibilities:

  • Providing access to see the turbine information etc. using SAM tool to view in the CMF tool.
  • Also looking into Parts Edge application Production issues.
  • Making code changes at JSP/Java/Configuration files.
  • Making required DB level changes in case any back end logic or query needs to be changed.
  • Raising a Change Requests to Deployment team.
  • Migrating the code from Dev to QA.

Confidential

Java Developer/Production Support - Offshore

Responsibilities:

  • Production Support for the Java Modules.
  • Making code changes at JSP/Java/Configuration files.
  • Making required DB level changes in case any back end logic or query needs to be changed.
  • Raising a Change Requests to Deployment team.

Confidential

Support central developer/Java Production Support - Offshore

Responsibilities:

  • Going through the existing design of the UI built on Visual basic.
  • Attending the calls wif the Client
  • Undergone the training on Support central.
  • Developed the Data Form and Workflows in Support central and also doing Production support for Java related issues.

We'd love your feedback!