Etl Informatica/denodo - Tech Lead – Onsite Resume
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.