We provide IT Staff Augmentation Services!

Etl Developer Resume Profile

5.00/5 (Submit Your Rating)

CA

PROFESSIONAL SUMMARY

  • Focused, detail and quality oriented Data Warehouse Developer with over 20 years IT experience designing/implementing business-critical database / data warehouse projects using Oracle / Netezza and Informatica ETL tools in Unix/Linux environments. Pivotal resource in diverse industries including online advertising, ecommerce, health insurance, banking/financial services and public data services. Extensive expertise with data warehouse concepts and methodologies. Possess both MS and BS degrees in Computer Science.
  • Tenacious troubleshooter, bringing enthusiasm, follow-through skills and leadership to problem resolution.
  • Keenly analytical and innovative, with proven ability to improve process performance issues.
  • Proficient in working with IT/business managers to prioritize activities and achieve defined objectives. Effectively translate business requirements into IT solutions.
  • Exceptional organization and time-management skills, consistently delivering top-quality projects under the tightest deadlines.

TECHNICAL SKILLS

  • Languages: Perl, Python, Shell, Bash, C, Java, JavaScript, PHP
  • Databases: Oracle PL/SQL, SQL Loader, Pro C, Informix 4GL and ESQL/C
  • Platforms: Solaris, HP-UX, Linux, IBM RS6000/AIX, Windows, EC2, S3
  • Tools: Informatica 8.5, Business Objects XI

PROFESSIONAL EXPERIENCE

Confidential

ETL Developer

  • Improved internally developed ETL tools to make them more robust and flexible.
  • Played a key role in ensuring consistent flow of customer-facing data from the data warehouse to Amonzon EC2/S3.
  • Reduced/rectified data discrepancy between source and the data warehouse.

Environment: Oracle, Netezza, Bash, Perl Module, Python, Business Objects, JSON, DeZign

Confidential

Senior Programmer Analyst

  • Developed complex ETL workflows to effectively load medical and pharmacy claims data from various vendors to Health Net data warehouse.
  • Automated workflow control processes using Unix shell and Perl scripts and enhanced job performance.
  • Developed ETL mappings to retrieve medical records from various sources. Consolidated/imported data to a 3rd party application CRMS data warehouse.
  • Modeled data warehouse table schemas using ERwin.
  • Created Web applications to communicate with business users, using PHP and JavaScript

Environment: Informatica 8.5, Oracle, Unix Shell Script, Perl, PHP, JavaScript, Business Objects

Confidential

Senior Programmer Analyst

  • Developed custom ETL programs to process large amounts of data from over 50 sources.
  • Automated/improved job performance with Perl and Unix shell script
  • Consistently maintained 100 uptime all 4 years of managing this vital application.
  • Established methods that ensured each new software version operated correctly, without any additional C API purchases.

Environment: Oracle, Informix, C, Unix Shell, Perl, Java

We'd love your feedback!