We provide IT Staff Augmentation Services!

Etl Developer | Edw Resume

Dallas, TX

SUMMARY:

  • 5 years of total IT experience and Technical proficiency in the Data Warehousing teamed with Data Analysis, BI, Data Modeling, and ETL Development & ETL Design with full life cycle Implementation of Enterprise Data Warehouse.
  • Strong knowledge and experience in various sectors like banking, finance, health care
  • Strong Data Warehousing experience in ETL Application using Informatica Power Center 9.x/8.x and Power Exchange
  • Extensive work experience in developing ETL Design and reconciliation process.
  • Strong understanding of Performance tuning in Informatica
  • Developed complex mapping logic using various transformations like Expression, Lookups (Connected and Unconnected), Joiner, Filter, Rank, TCL, Sorter, Router, Update strategy and Sequence generator, SQL, Stored Procedure etc.
  • Extensive work experience Design and development of CDC process using time - stamping method and Implemented SCD methodology including Type 2 to keep track of historical data.
  • Strong Experience in extracting data from various sources like Oracle, DB2, Flat file, SQL SERVER, XML files, Teradata and loading into Teradata, Oracle database.
  • Extensive experience in using tools like SQL Plus, TOAD, SQL Developer and SQL Loader.
  • 5 years with Autosys and Unix which include Development of Autosys “ JIL ”.
  • Monitor Production jobs using Autosys to ensure successful execution.
  • Assisted in defining and resolving failed jobs.
  • Design Unix Shell Script for application using Autosys and assisted in Reviewing Autosys logs.
  • Directly involved in gathering requirements, analysis and realization from the client. Deriving testable functional / non-functional system requirements, providing strategic and tactical inputs and coordinating with business functions and technical project teams from conception through deployment.
  • Involved in Data Modeling, ETL Development, Implementations and Data Quality in different Data warehouse Projects.
  • Involve in preparing word documentation and Visio diagrams to depict business processes better.
  • Experience working with multiple Data Sources including Legacy Data and Third Party Data Providers.
  • Familiar with Agile development and waterfall methodologies.
  • Ability in Strong presentation, verbal and written communication skills.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.x,8.x, SSIS, IDQ

Databases: Oracle, SQL Server, Teradata, Netezza, DB2

Database Tools: TOAD, SQL Developer, SQL plus, SQL Assistant

Data Modeling tools: COMSOL

MS Products: MS Visio, MS Project, MS office Suite, MS SharePoint

Programming Languages: PL/SQL, UNIX Shell scripting, C++, MatLab

Operating Systems: Windows 7, Windows NT, Windows 2000/XP, Unix, Linux

Source Systems: Flat Files, XML, Main Frames, Web-services

Scheduling Tools: Autosys, Informatica Scheduler

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

ETL Developer | EDW

Responsibilities:

  • Developed high level and detailed level technical documents to define the system components, development environment and implementation planning/strategies.
  • Profiled and automated the validation process.
  • Data & Column Profiling using IDQ.
  • Address cleanings and phone number validation using IDQ.
  • Responsible for scheduling of jobs using Autosys
  • Build logical and physical data model and built the use cases.
  • Developed ETL procedures to ensure conformity, compliance with standards and lack of redundancy, translates business rules and functionality requirements into ETL procedures.
  • Gather the requirements from the stake holders
  • Creating a SSIS package for SQL server ETL jobs.
  • Experience in Creation of ETL mappings using Informatica Power Center to move information from multiple sources into a common target area such as Data Marts and Data Warehouse.
  • Created Sessions and Workflows to load data from the SQL Server, Oracle, flat file, and XML file sources on servers located at various locations all over the country.
  • Extensively used Source Qualifier Transformation to filter data at Source level rather than at Transformation level. Created different transformations such as Source Qualifier, Joiner, Expression, Aggregator, Rank, Lookups, Filters, Stored Procedures, Update Strategy and Sequence Generator.
  • Created and monitored workflows and task using Informatica Power Center Workflow Manager.
  • Created workflows using Workflow manager for different tasks like sending email notifications, timer that triggers when an event occurs, and sessions to run a mapping.

Environment: PowerCenter 9.6.1,IDQ, Oracle, SQL Server 2012, SQL, PL/SQL, shell scripts, Mainframe MySQL, MS Visio, Toad 8.0, Windows 2000,UNIX, Autosys, Jira

Confidential, Albuquerque, NM

ETL Developer/Informatica Developer

Responsibilities:

  • Developed high level and detailed level technical documents to define the system components, development environment and implementation planning/strategies.
  • Data, Column Profiling by using IDQ.
  • Providing production support and part of Performance tuning team if any issues come up.
  • Developed ETL procedures to ensure conformity, compliance with standards and lack of redundancy, translates business rules and functionality requirements into ETL procedures.
  • Gathered business and technical requirements from both formal and informal sessions through NetMeeting, questionnaire, video conferencing and conference calls.
  • Experience in Creation of ETL mappings using Informatica Power Center to move information from multiple sources into a common target area such as Data Marts and Data Warehouse.
  • Created Sessions and Workflows to load data from the SQL Server, Oracle, flat file, and XML file sources that exist on servers located at various locations all over the country.
  • Extensively used Source Qualifier Transformation to filter data at Source level rather than at Transformation level. Created different transformations such as Source Qualifier, Joiner, Expression, Aggregator, Rank, Lookups, Filters, Stored Procedures, Update Strategy and Sequence Generator.
  • Created and monitored workflows and task using Informatica PowerCenter Workflow Manager.
  • Responsible for creating business solutions for Incremental and full loads.
  • Created different parameter files and changed Session parameters, mapping parameters, and variables at run time.
  • Created workflows using Workflow manager for different tasks like sending email notifications, timer that triggers when an event occurs, and sessions to run a mapping.
  • Executed Workflows and Sessions using Workflow Monitor.

Environment: PowerCenter 9.5, DQ, Oracle, SQL Server 2012, Netezza, Tera Data, SQL, PL/SQL, shell scripts, Mainframe MySQL, MS Visio, Toad 8.0, Windows 2000,UNIX, Control-M

Confidential, Richmond, VA

Jr. Informatica Developer

Responsibilities:

  • Responsible for gathering the requirements both functional and technical and documentation of the same and creating the mapping documentation, leading the team, preparing various standard template,
  • Worked with the business analysts in requirement analysis to implement the ETL process
  • Used loading techniques like Slowly Changing Dimensions and Incremental Loading using parameter files and mapping variables.
  • Requirement gathering and analysis with business users and onsite subject matter experts
  • Extensively worked with OLTP and Record creation/management systems in data extraction, manipulation and masking in/out of record management systems.
  • Loaded data into various star schema data warehouse dimension and fact tables.
  • Responsible for gathering functional specifications and converting it into mapping documents.
  • Handled Performance tuning by increasing buffer block size, creating various Named-Caches for Connected and un-Connected lookups, error handling.
  • Created re-runnable SQL scripts to create tables, triggers, indexes, views, packages and procedures.
  • Responsible for data conversion from SQL Server to Oracle 10g.
  • Responsible for working with DBAs for DDL Changes in Oracle 10g and 11g (Tables/Views/Stored Procs/Packages/Functions).
  • Planned/participated in application risk management planning and effective backup and recovery planning for applications.
  • Extensively participated in various testing like, Development Unit Testing, Integration testing, User Acceptance testing and regression & performance testing.
  • Smooth coordination, managed team meetings, transition between customer to the current support team and among the onsite-offshore teams.
  • Worked on Various Teradata utilities like FLOAD,MLOAD and TPump.
  • Bringing up the same level of knowledge shared among resources
  • Managing the customer communication and escalations
  • Resource management and updating customer on timely basis.
  • Managing other prod adhoc issues and supporting the production system.
  • Coordinate Onsite and offshore team, managing various calls related to requirements, development, testing and migration.

Environment: PowerCenter8.1, Oracle9i, SQL Server 2000, SQL,PL/SQL, shell scripts, Mainframe DB2, MySQL, MS Visio, Toad 8.0, Windows 2000,UNIX, postgresql, Tera Data

Hire Now