We provide IT Staff Augmentation Services!

Etl Developer Resume

2.00/5 (Submit Your Rating)

New York, NY

SUMMARY:

  • Over 13 years of IT experience in the Analysis, Design, Development, Testing and Implementation of business application systems for Financial, Health care, Pharmaceutical, Retail, and Hospitality.
  • Worked on all phases of SDLC from gathering requirements to testing, implementation, and support.
  • Experience in ETL (Extract - Transform - Load) using Informatica PowerCenter 9.X/8. X/7.x/6.X, SQL Server Integration Services (SSIS) and Pentaho DI 7.1/6.1/6.0/5.1 .
  • Experience in Informatica PowerExchange to connect to Mainframes/Salesforce, Informatica Cloud Services, Informatica LDAP connector and Informatica Web Services.
  • Experience in building reports using Business Objects and Tableau Desktop.
  • Experience in SQL, PL/SQL Stored Procedures, Functions in Oracle, SQL Server, Vertica and Teradata.
  • Experience in UNIX and PERL Scripting in UNIX and Linux platform.
  • Experience in Batch and PowerShell Scripting in windows platform.
  • Experience in writing scripts in Python.
  • Experience with AGILE Methodologies
  • Experience in using the scheduling tools like Cronacle, Autosys, ESP, and Tidal.
  • Experience in Test Tracking client tools like Quest Central, HP Quality Center.
  • Experience in Performance Tuning and optimization of ETL process.

TECHNICAL SKILLS:

ETL Tools: Informatica PowerCenter 9.X/8.X/7.X/6.X, Power Exchange 9.X/8.X, SSIS, Pentaho DI 7.1/6.1/6.0/5.1

BI & Reporting: Business Objects XI R2/6.0/5.0, Microstrategy 8 Desktop, SSRS, Tableau 9.2

Cloud Services: Informatica Cloud Services(ICS), Amazon Web Services (AWS familiarity)

Languages: SQL, PL/SQL, C#, UNIX Shell scripting, Batch Scripts, PowerShell, Python

Databases: Oracle 11g/10g/9i/8x, SQL Server 2012, Teradata V2R5, UDB, Sybase, Netezza

Schedulers: Redwood Cronacle 6.0, Autosys, Windows Task Scheduler, JAWS

Tools: Erwin 5.0/4.0, SQL*Plus, SQL*Loader, TOAD, SQL Developer, Aginity, SQL Server Management Studio, Teradata SQL Assistant 12, CA-7, DB2 Artesian, Quest Central, HP Quality Center, PyCharm, Visual Studio 2013, SOAP UI

Operating Systems: Windows, UNIX/LINUX/Solaris

PROFESSIONAL EXPERIENCE:

Confidential, New York, NY

ETL Developer

Responsibilities:

  • Designed and coded application components in an agile environment utilizing a test driven development approach.
  • Involved in design, development, and testing phases of software development life cycle.
  • Developed innovative software solutions in coordination with analytical and agile programmers.
  • Assisted in customization and development of designs and programs for all application systems.
  • Provided technical assistance for software architecture and project design for all assigned projects.
  • Used Agile Methodology: Involved in Weekly meetings to streamline and define requirements and business rules to arrive at a consensus between the analysts, business users, and software development team.
  • Created transformations using various steps like Table input, Table output, Text file output, CSV file input, Insert/Update, Add constants, Filter, Value Mapper, Stream lookup, Join rows, Merge join, Sort rows, Database Lookup, Set Environment Variables, Copy rows to result.
  • Developed transformations and jobs using various steps in PDI Spoon.
  • Developed a new Rest Call step in Pentaho to make calls to Nexen gateway to consume API based on consumer key and secret key instead of SSL Truststore.
  • Experienced in the use of agile approaches, including Extreme Programming, Test-Driven Development and Scrum.
  • Used JIRA to track user stories, sub-tasks, bugs, and impediments for Sprints and Product Backlogs.
  • Attended daily stand-up Scrum calls.
  • Used Confluence to create project artifacts by creating pages and using file-list in the project space.
  • Used GIT for version control of source code to track changes and maintain history.
  • Utilized pair programming approach to ensure high quality code.

Environment: Pentaho DI 7.1/6.1/6.0, Unix, Oracle 11g, HPE Vertica, JIRA, Confluence, GIT

Confidential, New York, NY

ETL Developer Lead

Responsibilities:

  • Developed mappings, sessions, workflows to extract data into Data Warehouse.
  • Used Informatica LDAP connector to pull the data from Active Directory and load into database.
  • Developed and configured data integration mappings in Informatica Cloud.
  • Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
  • Developed Tableau visualizations and dashboards using Tableau Desktop.
  • Developed Tableau workbooks from multiple data sources using Data Blending.
  • Wrote T-SQL Queries, Functions and Procedure in SQL server.
  • Wrote Batch and PowerShell scripts to run jobs through windows task scheduler.
  • Managed offshore team and reviewed their development work.
  • Created Unit testing, QA migration and Production Turnover documents.

Environment: Informatica Power Center 9.6.X, SQL Integration Services (SSIS), Batch Scripts, PowerShell scripts, Tableau desktop.

Confidential, Roseland, NJ

ETL Developer

Responsibilities:

  • Involved in design, analysis and preparing ETL specifications from source to target.
  • Developed mappings, sessions, workflows to extract data into Data Warehouse using Informatica.
  • Developed transformations and jobs using various steps in PDI Spoon.
  • Wrote SQL Queries in Oracle and Microsoft SQL server.
  • Troubleshoot data related problems in the data warehouse.

Environment: Informatica Power Center 9.1.0, Pentaho DI 5.1, Oracle 11g/10g, SQL Server 2012, Unix

Confidential, Newark, NJ

ETL Developer Lead

Responsibilities:

  • Designed and coded application components in an Agile environment utilizing a test driven development approach.
  • Developed mappings, sessions, workflows to extract data into Data Warehouse.
  • Provided programming estimates, identified potential problems and recommended alternative solutions.
  • Collaborated with other members of the product development team.
  • Coordinated configuration of back-end components in support of application development.
  • Utilized pair programming approach to ensure high quality code.
  • Preparation of Unit Test Plans and verification of functional specifications.
  • Monitor and review development work from offshore team.
  • Utilized pair programming approach to ensure high quality code.

Environment: Informatica Power Center 9.1.0/8.6.0, Oracle 11g/10g, MS SQL Server, Unix

Confidential, Parsippany, NJ

ETL Developer/Support

Responsibilities:

  • Development, implementation, administration and support of ETL processes for large-scale data warehouse using Informatica PowerCenter.
  • Used Informatica PowerExchange to capture data in real-time mode and load it into data warehouse.
  • Wrote SQL, PL/SQL Stored Procedures, and Functions in Oracle. Involved in performance tuning and troubleshooting of mappings and sessions. Wrote shell scripts in UNIX.
  • Created boxes, jobs, file watcher and scheduling the Informatica jobs through Autosys.
  • Worked closely with QA team in testing the defects. Performed SQL and PL/SQL tuning and Application tuning using EXPLAIN PLAN.
  • Provided fix for critical bugs and assists in code move to QA and Prod. Provided support to team in all technical issues.
  • Provided on-call support to resolve P1/P2 issues. Monitored and reviewed development work from offshore team.

Environment: Informatica Power Center/Power Exchange 9.5.0/ 9.1.0/8.6.0, Oracle 11g/10g, MS SQL Server, UNIX, Autosys

Confidential, New York, NY

ETL Developer

Responsibilities:

  • Involved in design, analysis and preparing ETL specifications from source to target.
  • Developed mappings, sessions, workflows to extract data into Data Warehouse. Created database objects like tables, views, and materialized views using oracle tools.
  • Used ERWIN Data modeler tool to design tables and columns, user defined data types, and relationships.
  • Wrote SQL, PL/SQL Stored Procedures, and Functions in Oracle. Wrote shell scripts in Perl.
  • Involved in performance tuning and troubleshooting of mappings and sessions.

Environment: Informatica Power Center 8.1.1, Oracle 10g, Unix.

Confidential, Exchange Place, NJ

ETL Developer

Responsibilities:

  • The project focused on developing common Reporting Solution platform for distributed systems ITS & TMS.
  • Developed mappings, sessions, workflows to extract data into Data Warehouse.
  • Prepared ETL functional and technical specification. Wrote shell scripts in UNIX.
  • Used the Quest Central tool for tracking the user’s test cases and logging the defects. Created boxes, jobs, file watcher and scheduling the Informatica jobs through Autosys.
  • Involved in performance tuning and troubleshooting of mappings and sessions. Prepared Unit Test Plans and verification of functional specifications.
  • Developed reports and ad-hoc reports using Business Objects. Monitored and review development work from offshore team.

Environment: Informatica Power Center 8.1.1, Power Exchange 8.1.1, DB2, Autosys, Business Objects

Confidential, Milwaukee, WI

ETL Developer/Support

Responsibilities:

  • Developed mappings, sessions, workflows to extract data into Data Warehouse.
  • Prepared ETL functional and technical specification. Wrote SQL & PL/SQL stored procedures in Teradata.
  • Used Teradata Loader Utilities (MIoad/Tpump/FastLoad) in Informatica to load data into database.
  • Wrote BTEQ scripts in Teradata to Import and Export data. Involved in performance tuning and troubleshooting of mappings and sessions.
  • Used redwood to Create Cronacle job for scheduling the workflows.

Environment: Informatica Power Center 6.2/7.1, Oracle 9i, Teradata V2R5, BTEQ, Cronacle.

Confidential

ETL Developer

Responsibilities:

  • Developed mappings, sessions, workflows to extract data into Data Warehouse.
  • Worked on enhancement of existing mappings.
  • Used Business Objects to create Universe and generate Ad-hoc reports.

Environment: Informatica Power Center 6.2, Oracle 9i, Business Objects.

Confidential

ETL Developer

Responsibilities:

  • Developed mappings, sessions, workflows to extract data into Data Warehouse.
  • Worked on SQL*Loader to load data from flat files
  • Preparation of Unit Test Plans and verification of functional specifications.
  • Used Business Objects to create Universe and generate Ad-hoc reports.

Environment: Information Power Center 6.2, Oracle 9i, SQL Developer, Tortoise CVS.

We'd love your feedback!