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