Etl Informatica Developer Resume
East Rutherford, NJ
SUMMARY
- Software professional with over 7 yrs. of extensive experience in ETL tools (Informatica, ODI, Cognos Data manager), SQL,PL/SQL, Oracle DB,UNIX
- Extensive experience in Analysis, Design, Development, Implementation, Testing and Support of Data Warehousing and Data Integration Solutions using Informatica Power center
- Proficient in Requirement gathering, Analysis, Business Intelligence strategy, Design, Development, Testing, Implementation and Support.
- Experience in understanding business/ process requirements and translating them to technical requirements.
- Knowledge in Full Life Cycle development of Data Warehousing.
- Experience in the developing BI strategies, data modeling, Flow diagram, mapping and technical specification documents for BI applications.
- Expertise in databases like Oracle, SQL Server.
- Exposure to Domains like Core Banking, financial and production.
- Excellent technical, logical, code debugging and problem solving capabilities and easy grasping of new things.
- Used Cognos reporting tool to generate reports, graphical representation like pi - charts and also familiar with framework manager.
- Used XML in transferring data across various platforms, performing data validations, reading and writing data using XML parsers.
- Basic Knowledge in Business Objects.
- Familiar with all phases of software product and project development life cycles. Serious advocate of test first methodology, Team Player, quick learner and self-starter with effective communication, motivation and organizational skills combined with attention to details and business process improvements.
TECHNICAL SKILLS
ETL Tools: ODI, Cognos DM, Informatica 9.1
Operating System: Windows XP/7, LINUX, UNIX
Database: Oracle 10G, 11G, SQL Server, DB2
Database tools: SQL developer, SQL Loader
Reporting Tool: Cognos 8, Business Objects
Programming Languages: C, C++, Java, SQL, PL/SQL, HTML
XML Technologies: XML, DTD, Schemas, XQuery
Scripts: UNIX Shell Scripting, CSS, Java Script
PROFESSIONAL EXPERIENCE
Confidential, East Rutherford, NJ
Senior ETL Developer
Responsibilities:
- Developed various builds using different transformations in Designer to load the data from source to targets.
- Extraction, transformation and loading were done in the project to create a new Data art which is used further for generating reports.
- Expertise in Extraction, Transformation and loading of Data.
- Created Various Fact Build and Dimension builds to load by using various transformations like Look Ups and Templates.
- Created various Workflows, Job Streams and sessions to ensure the data has sustained correctly.
- Unit testing of Builds developed in Development environment.
- Also used database to test the data while mapping from source to target and after loading in the target.
- Created DDL script for table creation and modification.
- Requirement Analysis
Confidential, Middletown, NJ
Senior ETL Developer
Responsibilities:
- Developed ODI interfaces to perform ELT(ETL) operation from source database MS-Access and oracle and target Oracle database Exadata.
- Developed load plans which calls interfaces in serial or parallel orders.
- Created map document for each table which explains source and target columns and transformation logic.
- Created Unit Test case document for each interface and updaload them into SVN
- Review and analyse project low level documents (LLD) with onsite and make corrections in them.
- Tested the reports generated in cognos and created projects in framework manager.
- Developed buils in Cognos DM from source database (Access ref data),Oracle and target Oracle db.
- Developed jobstreams and test cases for the builds.
Confidential
ETL Developer
Responsibilities:
- Understanding the specification accordingtoclient requirement.
- Involved in implementing the Technical analysis design documentation and technical implementation design document.
- Created and manipulated BTEQ Scripts to load data from file to Teradata work tables.
- Created identity columns on Teradata target tables in place of sequences for oracle.
- Worked extensively on Teradata stored procedures and Teradata user defined functions.
- Worked extensively to the SQL sub queries, joins, set operations and Functions.
- Involved in writing scripts using Teradata SQL and ANSI SQL as per requirements
- Extensively workedindata Extraction, Transformation and loading from sourceto target systemusingBTEQ, Fast Load and Multi Load.
- Used appropriate indexes such as PI, SI, etc.
- Errorhandlingand performance tuninginTeradataqueries and utilities
- Creating Unit test cases and implemented unit test results.
Environment: Informatica ETL Tool, Oracle, Teradata and their utilities (BTEQ), Putty, Windows XP/7.
Confidential
ETL Informatica developer
Responsibilities:
- Developed ETL programs using Informatica to implement the business requirements.
- Communicated with business customers to discuss the issues and requirements.
- Created shell scripts to fine tune the ETL flow of the Informatica workflows.
- Production Support has been done to resolve the ongoing issues and troubleshoot the problems.
- Performance tuning was done Confidential the functional level and map level. Used relational
- SQL wherever possible to minimize the data transfer over the network.
- Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.
- Involved in enhancements and maintenance activities of the data warehouse including tuning, modifying of stored procedures for code enhancements.
- Effectively worked in Informatica version based environment and used deployment groups to migrate the objects.
- Effectively worked on Onsite and Offshore work model.
- Pre and post session assignment variables were used to pass the variable values from one session to other.
- Designed workflows with many sessions with decision, assignment task, event wait and event raise tasks, used Informatica scheduler to schedule jobs.
- Reviewed and analyzed functional requirements, mapping documents, problem solving and trouble shooting.
- Performed unit testing Confidential various levels of the ETL and actively involved in team code reviews.
- Identified problems in existing production data and developed one time scripts to correct them.
- Fixed the invalid mappings and troubleshoot the technical problems of the database.
Environment: Informatica 8.6.1, Teradata V14, SQL, PL/SQL, MS Office Suites, Windows XPUNIX, HP Quality Centre 9.5 ALM
ETL Informatica developer
Confidential
Responsibilities:
- This project was covered under the FLP training.In this project we have been delivered the reports to client for analysis of auto insurance policies generated by auto insurance company in the past and to compare those policies with the present time policies.
- We created Star Schema Data Model for the data ware house.
- Informatica 8.5.1 has been used as ETL to load the qualified data into DM.
- IBM Cognos 8.0 and Frame Work Manager have been used to generate the reports.
Environment: Windows XP, Informatica 8.5.1, Cognos 8.0, SQL, PL/SQL