We provide IT Staff Augmentation Services!

Etl Developer Resume Profile

Chicago, IL

SUMMARY

  • Around 7 years' experience in IT with about 6 years' experience in Data Warehousing based applications on UNIX, Windows.
  • Expertise using Informatica PowerCenter at all ETL stages. Very good at using Repository Manager, Mapping Designer, Workflow Manager and Workflow Monitor.
  • Expertise using Talend tool for both Open Source and Enterprise Edition for BigData.
  • Expertise using BigQuery browser tool and BigQuery CommandLine.
  • Strong knowledge on OLAP systems, Kimball and Inmon methodology and models, dimensional modeling using Star and Snowflake schemas.
  • Outstanding experience dealing with complex database structures: PL/SQL Stored Procs, Packages, triggers, materialized views.
  • Experience of handling production issues. Capability to understand complex systems in short span.
  • Worked on various phases of Software Development Life Cycle SDLC such as Project Requirement Study, high level design, low-level design, Coding, Testing, Quality assurance Documentation, Implementation and Project Planning.
  • Extensive experience working in various UNIX environments. Excellent skills at Shell, Perl Scripting.
  • Involved in the data analysis for source and target systems. Experienced in integration of the various data sources such as Oracle and various types of flat files.
  • Expert in performance tuning, clearing performance bottlenecks at various levels like sources, targets, mappings, sessions and databases.
  • Technical proficiency in handling RDBMS databases. Particularly using Oracle 8i/9i/10g.
  • Expertise using SQL, PL/SQL, SQL Loader, Import/Export utilities on UNIX, WINDOWS XP/2000.
  • Pro-active, Self-motivated and responsible person with excellent interpersonal communication skills and proven Track record of quality deliveries.

Technical Environment:

ETL Tools: Informatica PowerCenter 9.5/9.1/8.6,

Talend Enterprise Edition for Big Data 5.5, Talend Open Studio for Data Integration 5.1

Data Modeling Tool: Erwin

Operating System: Windows NT /XP /2000, UNIX

Programing Languages: Core Java, C , Visual Basic, COBOL

Data Bases: Oracle 9i/10g, DB2, Sybase, Teradata

Database Utilities: SQL, SQL Loader, PL/SQL Stored Procedures, Functions,

Packages, Triggers, Exception handling

Scripting: Shell, Perl

Job Schedulers: Autosys, Control-M, Tidal

WORK EXPERIENCE

Confidential

ETL Developer

Environment:

Informatica PowerCenter 9.5, Oracle 10g, Tableau, UNIX, Shell/Perl scripting.

Responsibilities Accomplishments:

  • Extracted the data from various relational databases, flat files, webservices and XML files.
  • I am responsible for Shipment and activation data reconciliation.
  • Written queries in BigQuery to lookup all the Customer, Product, Order level data.
  • Worked on dimensional modelling to design and develop star schema, identifying facts and dimensions.
  • Extensively used Stored Procedures, Triggers and Joins in interaction with backend databases using PL/SQL.
  • Created data break points and error breakpoints for debugging the mappings.
  • Development of mapping documents and analyzing the data sources.
  • Responsible for reducing the fallout count in Shipments data.
  • Inspecting the data for quality issues.
  • Responsible for scheduling, error logging andmonitoring the jobs.
  • Closely worked with reporting people to ensure correct data is present in reporting.

Confidential

ETLDeveloper

Environment:

Informatica PowerCenter 9.1, Oracle 10g, MySql, SQL Server,QLikView,SQL, PL/SQL,UNIX, shell/Perl scripting.

Responsibilities:

  • Development of Informatica mappings to onboard new sources and changes to the existing ones. I am responsible for Operative upgrade to V3.
  • Worked with mapping parameters, variables and session variables.
  • Developed various wrapper scripts bash/Perl for the management of the system.
  • Tuned the performanceof mappings, decreased the load time of workflows.
  • Responsible for production support of the system on rota basis.
  • Created test cases for the mappings, then created integrated testing document.
  • Responsible for peer code reviews.

Confidential

ETLDeveloper

Environment:

Informatica PowerCenter 8.6,Talend Open Studio 5.0, Oracle 10g, DB2, Cognos, UNIX,SQL, PL/SQL, AUTOSYS, shell/Perl scripting.

Responsibilities:

  • Gathering requirements for feeding the Health Exchange DB.
  • Developed stored procedures in PL/SQL and UNIX shell scripts for automated execution of jobs.
  • Worked with Target Load Plan for loading the data into targets.
  • Worked with SQL Override in the Source Qualifier and Lookup transformations.
  • Worked with XML Source Qualifier for extracting the XML sources.
  • Created Mapplets to reuse all the set of transformations for all mappings.
  • Implemented Slowly Changing Dimensions as per the requirements.
  • Responsible for monitoring scheduled, running, completed and failed sessions.
  • Worked with Static, Dynamic and Persistent Cache in the Lookup transformations.
  • Used Debugger to debug the flow of the data from sources to targets.
  • Worked mainly with Lookup, Expression, Router, Union, Joiner, Java, Update Strategy transformations.
  • Used Update Overwrite option for updating the non-key ports in the session level.
  • Contributed significant design inputs for dimensional db schema design. Looking forward for a role involving db design responsibilities.

Confidential

Informatica Developer

Environment:

Informatica Power Center 8.6, Power Exchange, Oracle 10g, Tidal Scheduler, SQL, MicroStrategy, Unix and Shell scripting.

Responsibilities:

  • Requirements procurement: Worked with business personnel, Data Modelers to understand the source to target mapping documents, the structure of the tables, target schema definition.
  • Worked with legacy systems for extracting data from mainframes.
  • Designed mappings using Filter, Expression, Aggregator, Joiner, Sorter, Rank, Source Qualifier and Router transformations.
  • Designed complex mappings to load data into target using Connected Lookup, Unconnected Lookup, Update Strategy, and Sequence Generator transformations.
  • Created Mapplets to reuse all the set of transformations in Mapplet Designer.
  • Created Workflows and Sessions for each mapping that we are extracting from Source Systems to Staging areas, Staging areas to target.
  • Performed Unit testing on the Informatica code.
  • Used UNIX shell scripting for processing flat files to move them onto the server and importing as the source and for merging the data.
  • Participated in the enterprise performance tuning of Informatica for Sources, Targets, Mappings and Sessions.
  • Worked with DBA group to resolve performance.
  • Used Informatica Scheduler to schedule the Workflows.

Confidential

ETL Consultant

Environment:

Informatica PowerCenter 7.1, Oracle, Teradata, SQL Server 2008 and SQL Developer.

Responsibilities:

  • Used Informatica tools including Repository Manager, Designer, Workflow Manager and Workflow Monitor.
  • Created Reusable Transformations and Mapplets to use in multiple mappings.
  • Designed and developed various mappings, sessions and workflows to extract data from flat files, Oracle sources and load to Oracle and flat files.
  • Worked with TPUMP, Fast load, BTEQ utilities in Teradata.
  • Used Workflow monitor to monitor tasks, workflows and also to monitor performance.
  • Worked on tuning the existing mappings for better performance.
  • Performed unit testing, performed tuning of SQL queries.

Confidential

Oracle Developer

Environment:

Oracle, Oracle Forms 5.0/4.5, Reports 2.5, SQL, PL/SQL, Windows NT/98/95, SQL Navigator, Erwin3.5, and UNIX

Responsibilities:

  • Designed and developed stored procedures and database views.
  • Maintained user roles and privileges at the database level. It involved enrolling users, maintaining the system security, controlling and monitoring user access.
  • Used SQL to extract the data from the database.
  • Worked with Development Life Cycle teams.
  • Wrote Stored procedures, Stored functions, Packages and used Forms and Reports
  • Wrote database triggers for automatic updating the tables and views.
  • Designed and developed forms and reports.

Hire Now