We provide IT Staff Augmentation Services!

Etl Informatica Developer Resume

New Albany, OH

SUMMARY:

  • 10+ years of IT experience in Design, Development, Implementation, Testing and Support of Data Warehousing and Data Integration Solutions using Informatica Powercenter and also involve to develop dynamic web applications using coldfusion, java.
  • 6+ years of experience in using Informatica Power Center (8.6.1/9.6)
  • Proficiency in developing SQL with various relational databases like Oracle, SQL Server.
  • Knowledge in Full Life Cycle development of Data Warehousing.
  • Have extensively worked in developing ETL program for supporting Data Extraction, transformations and loading using Informatica Power Center.
  • Experience with dimensional modeling using star schema and snowflake models.
  • Understand the business rules completely based on High Level document specifications and implements the data transformation methodologies. using UNIX shell scripts to run the Informatica workflows and controlling the ETL flow.
  • Strong with relational database design concepts.
  • Hands on experience using query tools like TOAD, SQL Developer, PLSQL developer, Teradata SQL Assistant.
  • Extensively worked with Informatica performance tuning involving source level, target level and map level bottlenecks.
  • Independently perform complex troubleshooting, root - cause analysis and solution development.
  • Used ESP to automated job control system for scheduling, monitoring and report.
  • Ability to meet deadlines and handle multiple tasks, flexible in work schedules and possess.

TECHNICAL SKILLS:

Operating Systems: Windows, Linux, UNIXETL: SSIS, SSRS, Informatica Power Center 8.x/9.x.

Software / Applications: MS officeDatabase: SQL Server 2012/2005/2000, Oracle 11g/10g/9i, MySQL,MS ACCESS.

ETL: SSIS, SSRS, Informatica PowerCenter 8.x/9.x.

Scripting Languages: SQL, PL/SQL, and CFScript, JavScript.

Languages: Coldfusion, Java, HTML, XML,SQL, PL/SQL.

Web/Apps Servers: IIS, Tomcat, IBM Web Logic .

Tools: TOAD, Dreamweaver, Eclipse,PL/SQL Developer, Auto Sys, ESP.

Version Control Tools: SVN, STAR team and Visual Sourcesafe.

Software Methodology: Agile and Waterfall.

PROFESSIONAL EXPERIENCE:

Confidential, New Albany,OH

ETL Informatica developer

Responsibilities:

  • Using Informatica Designer, developed mappings, which populated the data into target files .
  • Interacted with business users and translate business requirements into technical specifications .
  • Used tools like TOAD to run SQL queries and validate the data.
  • Production Support has been done to resolve the ongoing issues and troubleshoot the problems.
  • Performance tuning was done at the functional level and map level. Used relational SQL wherever possible to minimize the data transfer over the network.
  • Integration with different legacy systems and source types such as SQL server,Oracle, XML, Fixed & Delimited Flat files etc. .
  • Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.
  • Involved in the design, development and testing of the PL/SQL stored procedures, packages for the ETL processes. .
  • Designed workflows with many sessions with decision, session, event wait, and event raise tasks, used informatica scheduler to schedule jobs.
  • Reviewed and analyzed functional requirements, mapping documents, problem solving and trouble shooting.
  • Used various report items like tables, sub report and charts to develop the reports in SSRS.
  • Deployed and generated reports on to the server using the Reporting Services Report Manager
  • Performed unit testing at various levels of the ETL and actively involved in team code reviews.
  • Monitoring Schedule jobs using ESP.
  • Monitored data warehouse month-end loads to ensure successful completion.

Environment: Informatica powercenter9.6, Oracle 11g,SQL server2012,Flat Files, Windows XP, Unix, ESP. Toad v12

Confidential, Columbus,OH

ETL Informatica developer

Responsibilities:

  • Worked on Informatica Utilities Source Analyzer, warehouse Designer, Mapping Designer and Transformation Developer. Involved to execute Teradata RDBMS using Fast Load and SQL Assistant used to import/export the data.
  • Created Mappings using Mapping Designer to load data from various sources, using different transformations like Source Qualifier, Expression, Lookup, Aggregator, and Update Strategy, Joiner, Filter and Router transformations
  • Extensive experience in creation of ETL mappings and transformations to reflect business rules using Informatica Power Center to move data from multiple sources into target area, source systems are mainly relational tables, and flat files.
  • Worked with (Fact and Dimensional tables) OLAP (Star schema, Snowflake schema) Extensively worked with Debugger using breakpoints and various test conditions to test the logic and the validity of the data moving through the mappings.
  • Worked with Variables and Parameters in the mappings to pass the values between sessions.
  • Used various transformations like Source Qualifier, Lookup (connect, unconnected), Update Strategy, Router, Filter, Sequence Generator, and Joiner on the extracted source data according to the business rules and technical specifications.
  • Performance Tuning of SQL Queries and ETL Mappings. Responsible for monitoring all the sessions that are running, scheduled, completed and failed Debugged the mapping of the failed session.
  • Code validation of the mappings migrated to QA and production environment. .
  • Responsible for performance tuning ETL process to optimize load and query Performance.
  • Involved in performance tuning of the Informatica mapping and identifying the bottlenecks.
  • Expertise in testing the applications and creating test cases for Unit Testing, Integration Testing and make sure the data extracted from source is loaded into target properly in the right format .

Environment: Oracle 11 G, Teradata14.1.0, Teradata SQL Assistant, PL/SQL Developer,, Fast load, UNIX, Informatica powercenter8.6,Windows XP.

Confidential, Downtown,OH

ETL Informatica developer/Web Developer

Responsibilities:

  • Used Informatica Power Center for (ETL) extraction, transformation and loading data from heterogeneous source systems into target database.
  • Created mappings using Designer and extracted data from various sources, transformed data according to the requirement.
  • Involved in extracting the data from the Flat Files and Relational databases into staging area.
  • Mappings, Sessions, Workflows from Development to Test and then to UAT environment.
  • Developed Informatica Mappings and Reusable Transformations to facilitate timely Loading of Data of a star schema.
  • Developed the Informatica Mappings by usage of Aggregator, SQL overrides usage in Lookups, source filter usage in Source qualifiers, and data flow management into multiple targets using Router.
  • Created Sessions and extracted data from various sources, transformed data according to the requirement and loading into data warehouse.
  • Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Router and Aggregator to create robust mappings in the Informatica Power Center Designer.
  • Imported various heterogeneous files using Informatica Power Center 8.x Source Analyzer.
  • Developed several reusable transformations and mapplets that were used in other mappings.
  • Involved in Unit Testing and Resolution of various Bottlenecks came across.
  • Modified existing website and added new web pages using Cold Fusion, Ajax and Jquery
  • Added new functionality to the existing system as per the user requirements
  • Responsible for tested and debugged the project
  • Created tables, views and stored procedures using TOAD to display web pages
  • Responsible to create documentation
  • Created database tables, views and Stored Procedures in Oracle

Environment: Informatica Power Center 7.1, Workflow Manager, Workflow Monitor, Informatica Power Connect, Oracle 10g, SQL Server, UNIX, TOAD 11, Cold Fusion Server 9, CFE Clipse.

Confidential, Memphis, TN

Programmer

Responsibilities:

  • Imported flat files into SQL tables using custom developed DTS packages.
  • Responsible for testing and debugging the project
  • Designed and coded the database objects which included stored procedures.
  • Involved in the design and development of CF Reports (CFR) using Coldfusion Builder.
  • Involved to Create/modify SQL Stored procedures and Tables
  • Participated in business meetings and worked with users and Functional specificationwriters to figure out the problems encountered in developing the project.
  • Created Technical Specifications for the modules.
  • Added new functionality to the existing system as per the user requirements.
  • Designed the Database Tables and integrated the database diagram.
  • Developed data services, Business services in this project using Cold Fusion, CFML
  • Involved in fixing the Bugs, which they encountered in Unit Testing and Regression testing under pressure to meet the Deadlines.
  • Used HTML, DHTML and used CSS for the entire web site.
  • Used Star Team for Check in and Check out the files.

Environment: ColdFusion 8.0, Sql Server 2005, HTML, Java Script, IIS, Eclipse 3.2, CSS,, StarTeam, CuteFTP 8.0.

Confidential, CT

Cold fusion Developer

Responsibilities:

  • The ARAMARK building commissioning system spans over more than 20 years- Primary
  • For education institutions. Supporting future operations and maintenance efforts and verifying that unique school requirements are met. This system ensuring that all design intent. Requirements are satisfied and energy efficient systems and equipment are operating as intended.
  • Create static and dynamic web pages using Flex, Coldfusion, and Sql Server.
  • Importing flat files into SQL tables using custom developed DTS packages.
  • Responsible for tested and debugged the project
  • Responsible taking SQL Server backup and restore from Production server to Development server.
  • Involved to improve Application performance using Server Monitor.
  • Used WEBSERVICE to call ColdFusion remote components.
  • Designing and coding of the database objects which include Stored Procedures.
  • Involved in the design and development of CF Reports (CFR) using Coldfusion Builder.
  • Involved in the design and development of CF components to facilitate reusable code.
  • Used MVC methodology to build OptimaWEB.
  • Used CuteFTP to upload files from Development server to Production Server.
  • Part of the ticket resolution team to resolve and fix level 1 and 2 bugs.

Environment: Cold fusion 8.0, SQL Server 2005, Query Analyzer, Java Script, Apache Tomcat 6, Eclipse 3.2,CSS, Dream weaver 8, FTP,CVS repository control,, CuteFTP 8.0

Confidential - MI

Programmer

Responsibilities:

  • Modified existing website and added new web pages using Cold Fusion MX, HTML and JavaScript.
  • Developed document validation, conditional and form validation modules using JavaScript.
  • Designed presentation layer using HTML and Dream Weaver
  • Added new functionality to the existing system as per the user requirements
  • Responsible for tested and debugged the project
  • Modified existing class files and creating new java and JSP files for the Java web site
  • Created tables, views and stored procedures using TOAD to display web pages
  • Used RDS to upload CF files
  • Responsible for Modifying and added Portlets using Oracle Portal
  • Created dynamic Web pages for the site utilizing Cold Fusion Studio
  • Created the Stored Procedures utilizing Oracle Procedure Builder
  • Responsible for custom and CF tags required for the site.
  • Created database tables, views and Stored Procedures in Oracle

Environment: Cold Fusion Server MX, Dream Weaver MX, HTML, JavaScript, CFScript, TOAD 8.0, Oracle Portal, PL/SQL,Oracle J-Developer 9/10g, Oracle 9i and windows2000

Hire Now