Etl Developer Resume
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.