Informatica Etl Consultant Resume
SUMMARY
- Eight Plus (8+) years of experience in Requirement Analysis, Functional Analysis, Design, Development, Implementation, Testing, Debugging, Productions Support, and Maintenance of various Data warehousing Applications
- Seven Plus (7+) years of Data Warehousing experience using Informatica Power Center 10.2/9.6/9.1/8.6/8.1/8 x/ 7.1.3/7.1.2/7.1.1/6.2/6.1/5.1.2 , Power Mart 5.0, Repository Admin console, Repository Manager, Designer, Workflow Manager, workflow Monitor, Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Task Developer, Worklet Designer, Workflow Designer, ETL, OLAP, OLTP.
- Five Plus (5+) years of Solid Modeling experience in Ralph Kimball Methodology, Bill Inmon Methodology, Star Schema, Snow Flake Schema, Fact Tables, Dimension Tables, Dimensional Data modeling, ERWIN 4.x
- Four Plus (4+) years of experience in Business Intelligence tools like Business Objects, Cognos, Microstrategy, Actuate and Crystal Reports
- Two plus (2+) years of experience in unix shell scripting
- Five Plus (5+) years of work experience Database Systems like Oracle 11g/10g/9i/8i/8.0/7.3, Sybase 12.5/12.0/11. x/10, MS SQL Server 2000/7.0/6.5/6.0 , DB2, Teradata V2R5/V2R3, SQL, PL/SQL, SQL*Loader, Stored Procedures, Triggers, Views, Materialized Views, Indexes, TOAD, MS Access, MS Excel, Netezza
- Excellent Team Player, self - motivated with solid communications skills
TECHNICAL SKILLS
Data Warehousing: Informatica PowerCenter 10.2/9.6/9.1/8.6/8.1/7.1.4/ 7.1.3/ 7.1.2/ 7.1.1/ 6.2/ 6.1/ 5.1.2 , Informatica PowerMart 5.1.2/5.0/4.7.2 , Repository Admin console, Repository Manager, Designer, Workflow Manager, workflow Monitor
Databases: Oracle 11g/10g/9i/8i/8.0/7.3, Sybase 12.5/12.0/11. x/10, MS SQL Server 2000/7.0/6.5/6.0 , DB2, Netezza, Teradata V2R5/V2R3
Data Modeling: Ralph Kimball Methodology, Bill Inmon Methodology, Star Schema, Snow Flake Schema, Fact Tables, Dimension Tables, Erwin 4.0, Dimensional Modeling, Physical and Logical Modeling, Normalization and De normalization
Programming: Java 2.0, ASP,HTML, Unix Shell Scripting, SQL, and PL/SQL
Environment: Windows 7/XP/2000, Win NT 4.0, Sun Solaris, HP AIX, Linux, Unix
PROFESSIONAL EXPERIENCE
Confidential
Informatica ETL Consultant
Responsibilities:
- Analyzing the existing tables for impact analysis as new tables will be added to the existing data model
- Documenting and tracing the lineage of tables at different stages at high level and detailed level
- Responsible for providing the impact analysis for different data mart tables, outbound vendor transmission flat files, outbound data push to other HAEA systems, transfer to CVA database
- Responsible to provide the different views and synonyms used at the table level to understand the impact of reports
- Involved in providing the details list of outbound interfaces which are in turn written to different outbound flat files and tables
- Understanding business requirements and translate business knowledge to Technical Design Document
- Provides estimates for Work required to be completed based on requirements.
- Creates high level and detailed level design documents which have all the details required for the implementation of jobs
- Responsible for implementing data warehouse solutions using Informatica, tuning and customizing ETL jobs
- Responsible to load data to different levels like stage1, stage2, Dimensions and data marts
- Perform development and unit testing throughout the standard development life cycle and assist with functional analysis as needed
- Read the data from different sources like SAP, AS400, Oracle and implementing transformation logic in Informatica for effectively loading the data in database tables for different stages
- Create mapping and ETL instruction documents to map the source and target tables
- Responsible for loading the data to database tables and validations
- Involved in writing the SQL queries to analyze and validate the data
- Responsible for migration of ETL jobs to different environments and to Production
- Participate in go live and production support activities
- Co-ordinate and work with Informatica admin and team for any issues
Environment: Informatica PowerCenter 10.2(Designer, Work Flow Manager, Work Flow Monitor, Repository Manager), Oracle 11g, Flat Files, SQL, UNIX, Windows XP, SQL, TOAD, EDW
Confidential, San Jose, CA
Informatica ETL Consultant
Responsibilities:
- Understanding business requirements and translate business knowledge to Technical Design Document
- Provides estimates for Work required to be completed based on requirements.
- Codes, tests, debugs data issues and complex SQL Queries and enhance existing code to ensure that the product continue to meet user needs.
- Creates high level and detailed level design documents which have all the details required for the implementation of jobs
- Responsible for implementing data warehouse solutions using Informatica, tuning and customizing ETL jobs, creating data models for customizations, troubleshooting performance problems, and applying Oracle maintenance packs and bundles.
- Creating shell scripts to read the files and load the files into tables on database using Unix shell scripts
- Perform development and testing throughout the standard development life cycle and assist with functional analysis as needed.
- Evaluate, determine root cause and different issues by providing first/second level troubleshooting, technical and operational support.
- Read the data from different sources like SAP Hana, Hadoop, flat files, Hive and implementing transformation logic in Informatica for effectively loading the data in database tables/flat files
- Run the queries in Hadoop/Hive for analysis for different production issues
- Scoop the data from Hadoop to different environments for testing different products meets and requirements
- Participate in data remediation activities to fix the data issues in Production
- Create Hive external tables using Flat files sourced from Oracle tables using Informatica process.
- Create Hive Queries for analyzing huge volume of historical data in Hadoop.
- Worked on Sqoop scripts to load data from Hadoop cluster to HANA and vice versa
Environment: Informatica PowerCenter 10.2(Designer, Work Flow Manager, Work Flow Monitor, Repository Manager), Oracle 11g, Flat Files, SQL, UNIX, Windows XP, Shell scripting, SQL, JIRA, Visio, Hadoop, Hive
Confidential
Informatica ETL Consultant
Responsibilities:
- Extensively worked with the business team and business analyst to gather the requirements
- Extensively worked with different vendors to send the input files with the required format and required data for each field
- Extensively worked with the DBA’s to create the tables, update the table structures according to the requirements
- Highly involved in working with Data modelers to design the tables in staging and PROPS
- Responsible to work on the high level design document including process flow diagram, business flow diagram
- Extensively worked on developing the mappings/workflows to load the tables in PROPS for different vendors
- Involved in working on the unix scripting for file validations and archival of source files
- Extensively worked on ABC framework to make use of wrapper scripts in order to run the Informatica jobs
- Highly involved in writing SQL Queries, analyzing the data in tables to meet the requirements
- Extensively worked on analyzing the error reports for each vendor to check and see that all the errors are generating accordingly
- Responsible to work with testing team to support testing in UAT and QA team
- Involved in fixing the defects that were raised in UAT and QA and promote the code accordingly
- Highly involved in promoting the code to UAT,QA, Release test, break fix and Production environments
- Involved in production support for release and go live
- Extensively worked with Tidal development team to give the requirements for scheduling the jobs in Tidal
- Worked with Sterling team to set up to receive/send the inbound and outbound files
- Environment: Informatica PowerCenter 10.2(Designer, Work Flow Manager, Work Flow Monitor, Repository Manager), Oracle 11g, Flat Files, SQL, Tidal Scheduling, UNIX, Tortoise SVN, Windows XP, Shell scripting, SQL, ALM, JIRA, Visio
Confidential
Informatica ETL Consultant
Responsibilities:
- Extensively worked with the business team to design the tables in pricing stg based on Radar extract file
- Extensively worked with the DBA’s to create the tables, update the table structures according to the requirements
- Responsible to work on the design documents for each individual Informatica job
- Highly involved in developing the mappings/workflows to load the tables in pricing stg
- Highly involved in doing the QC validation check for the tables loaded in pricing stg
- Highly involved in writing SQL Queries, analyzing the data in tables to meet the requirements
- Extensively worked on analyzing and documenting the structure difference between Radar and Ratabase
- Worked with the pricing analyst to make changes to Radar files to meet the requirements for Ratabase
- Involved in iteration planning meetings for the team
- Highly involved in maintaining and updating the RTC for Day to day tasks