ETL Developer – Resume Sample in PDF

• Analyzed PL/SQL code across source, staging, and presentation areas.
• Developed and maintained DataStage ETL jobs for complex customer data sources.
• Managed development in Test, Int, and PROD environments.
• Supervised ETL modules including Designer, Director, and Quality Stage.
• Imported and exported data to in-house reporting systems.
• Analyzed and optimized Oracle 11g/12c PL/SQL and DB2 databases.
• Documented ETL processes and provided training to junior developers.

• Developed SSIS/CDC ETL processes.
• Administered SQL Server 2014 databases.
• Integrated data into Teradata target databases.
• Analyzed and fixed ETL workflow bugs and optimized performance.
• Proposed and implemented Upsert strategies and Sort transformation optimizations.
• Managed DEV, UAT, and PROD SSIS environment migrations.
• Conducted performance tuning and optimization of SQL queries.
• Collaborated with cross-functional teams to ensure seamless data integration.

• Maintained and developed new mappings in Informatica 9.x.
• Optimized existing SQL Server scripts for performance.
• Addressed data quality issues for TV, VOD, HULU, and Foxnow data.
• Collaborated with cross-functional teams to ensure data integrity.
• Conducted code reviews and provided feedback to improve code quality.
• Created detailed documentation for ETL processes and data flows.

• Developed DataStage ETL jobs and workflows.
• Designed staging and target tables based on business requirements.
• Analyzed data warehouse models and provided detailed documentation.
• Implemented data extraction jobs and automated scheduling.
• Ensured data accuracy and consistency during ETL processes.

• Integrated multiple data sources into the MicroStrategy reporting system using SSIS ETL.
• Administered SQL Server 2012 databases.
• Analyzed and fixed ETL mapping, session, and workflow bugs.
• Proposed solutions for ETL workflow optimization and data quality issues.
• Developed and maintained SSIS packages for data migration.
• Created technical documentation and conducted user training sessions.

• Developed SSIS ETL processes and best practices.
• Administered SQL Server 2012 databases.
• Integrated data into MicroStrategy reporting systems.
• Analyzed and resolved data quality issues.
• Developed SSIS packages for data transformation and loading.
• Provided technical support and troubleshooting for ETL processes.

• Developed DataStage ETL jobs and workflows.
• Imported data to in-house reporting systems.
• Developed SQL Server 2012 and Oracle data warehouse models.
• Proposed and executed POC for building PDC algorithms within MicroStrategy.
• Ensured data integrity and consistency during ETL processes.
• Collaborated with stakeholders to gather requirements and provide solutions.

• Developed Informatica 9.0 ETL processes.
• Administered Oracle databases.
• Analyzed and fixed ETL mapping, session, and workflow bugs.
• Designed and ran SQL scripts for source, staging, and target tables.
• Conducted data quality checks and resolved data discrepancies.
• Provided documentation and training for ETL processes.

• Developed ETL processes using Pentaho.
• Created MicroStrategy schema and reports/dashboards.
• Conducted training sessions for senior BI staff.
• Loaded mockup data and developed cloud-based MicroStrategy platforms.
• Ensured data accuracy and consistency during ETL processes.
• Provided technical support and troubleshooting for ETL and BI tools.

• ETL development of fully automatic system to extract data from XLS files and
load to MySQL database
• Remote Access of Job execution configuration
• Complete documentation, FAQ and instructions for users creation
• Completed workshop for educational purposes

• Supported Oracle aviation DWH systems.
• Developed ETL logic and J2EE reporting applications.
• Analyzed changes in data warehouse models.
• Provided first-line technical support and created system schemas.
• Conducted performance tuning and optimization of ETL processes.
• Collaborated with stakeholders to gather requirements and provide solutions.
• J2EE application (report tool for users) development, troubleshooting

• Tested GSM/GPRS/EDGE platform bugs.
• Conducted regression and user acceptance tests.
• Developed documentation for Java/J2EE technologies.
• Assisted in the integration of software components.
• Ensured quality and compliance with industry standards.
• Collaborated with cross-functional teams to resolve technical issues.