Etl Developer Sql
Resume:
TN visa
email : **************@*****.***
Summary:
An experienced Unix ETL Developer and Oracle PL SQL Developer with over 8 years of experience in designing, developing, and implementing data integration solutions. Proficient in using various ETL tools, UNIX Shell scripting, Oracle database, and PL SQL programming to transform and load data from different sources into the target systems. Strong problem-solving and analytical skills with excellent communication and teamwork abilities.
Skills:
●Expertise in ETL tools such as Informatica PowerCenter, IBM DataStage, and Oracle Data Integrator (ODI)
●Strong knowledge of UNIX Shell scripting for automating ETL processes and system administration tasks
●Proficient in Oracle database and PL SQL programming for data modeling, database design, and data manipulation
●Experience in creating complex SQL queries, stored procedures, and functions for data retrieval and reporting
●Knowledge of Oracle Exadata, RAC, and Data Guard for high availability and disaster recovery solutions
●Familiarity with Hadoop, Spark, and NoSQL databases for big data processing and analytics
●Understanding of software development life cycle (SDLC), agile methodology, and project management principles
●Excellent communication, interpersonal, and teamwork skills
●Familiarity with data warehousing concepts and dimensional modeling techniques
●Experience in working with data integration solutions for cloud-based platforms such as AWS, Azure, and Google Cloud
●Knowledge of data quality and data governance principles and best practices
●Proficiency in data visualization and reporting tools such as Tableau, Power BI, and QlikView
●Understanding of data security and compliance regulations such as GDPR, HIPAA, and PCI DSS
●Ability to write and maintain technical documentation for ETL processes, database design, and system administration
●Experience in performance tuning and optimization of ETL workflows, database queries, and system resources
●Familiarity with source code version control tools such as Git, SVN, and TFS
●Knowledge of scripting languages such as Python, Perl, and Ruby for automation and data processing tasks
●Understanding of virtualization and containerization technologies such as Docker, Kubernetes, and VMware
●Familiarity with machine learning and artificial intelligence concepts and their application in data analytics and data processing.
Professional Experience:
Enhance IT, Atlanta (GA), Apr 2022 - current.
UNIX ETL Developer.
●Designed and developed ETL processes using Informatica PowerCenter to extract, transform, and load data from multiple sources into the target systems.
●Created UNIX Shell scripts for automating ETL workflows, data archiving, and system maintenance tasks.
●Developed PL SQL code for database design, schema creation, and data manipulation using Oracle database.
●Created complex SQL queries, stored procedures, and functions for data retrieval and reporting.
●Worked with Oracle Exadata, RAC, and Data Guard for high availability and disaster recovery solutions.
●Collaborated with cross-functional teams including business analysts, data architects, and testers to deliver high-quality solutions.
●Participated in project planning, estimation, and status reporting activities.
●Mentored junior developers and conducted knowledge-sharing sessions.
Radiomovil dipsa, Jan 2016 - Mar 2022
ETL Developer.
Responsibilities:
●Designed and developed ETL processes using IBM DataStage to extract, transform, and load data from various sources into the target systems.
●Created UNIX Shell scripts for automation of ETL workflows, data validation, and error handling.
●Developed PL SQL code for database design, schema creation, and data manipulation using Oracle database.
●Created complex SQL queries, stored procedures, and functions for data retrieval and reporting.
●Worked with Oracle RAC for high availability and performance tuning.
●Collaborated with cross-functional teams including business analysts, data architects, and testers to deliver high-quality solutions.
●Participated in project planning, estimation, and status reporting activities.
●Conducted training sessions for new hires and provided technical guidance and support.
SmartByte, Oct 2013 - Dec 2016.
Oracle PL SQL Developer.
●Developed ETL workflows using Oracle Data Integrator (ODI) to extract, transform, and load data from multiple sources into the target systems.
●Created and maintained UNIX Shell scripts for automation of ETL workflows, data validation, and system administration tasks.
●Designed and developed PL SQL code for database design, schema creation, and data manipulation using Oracle database.
●Created complex SQL queries, stored procedures, and functions for data retrieval and reporting.
●Worked with Oracle Exadata for high performance and scalability.
●Collaborated with cross-functional teams including business analysts, data architects, and testers to deliver high-quality solutions.
●Participated in code review, testing, and deployment activities
●Provided technical support and troubleshooting for production issues.
Education:
Bachelor's Degree: Computer systems Engineering, 2013.
Master’s degree : MBA in Finance – In progress.
Contact this candidate