Data Engineer with 5+ years in Oracle, SQL, ETL & BI development
AI is analyzing your overall score…
Identifying your key strengths…
Evaluating your skill match against the job requirements…
Assessing your cultural and operational fit
Highly skilled professional with 5.7 years of experience leading full-cycle SDLC for data-driven applications, transforming complex needs into impactful, scalable software solutions. Expertise includes building complex PL/SQL functions, optimizing T-SQL and Oracle query performance, streamlining ETL workflows with Informatica PowerCenter, and maintaining robust Oracle databases. Proficient in creating Power BI dashboards and leveraging Microsoft BI Stack for data integration, analysis, and reporting.
Anand Institute of Higher Technology
B.E
August 1, 2017 – June 30, 2017
Infosys
Technology Analyst
December 1, 2022 – April 1, 2025
Chennai, Tamil Nadu, India
Apexon
Software Engineer
August 1, 2019 – November 1, 2022
India
Project 1
December 1, 2022 – April 1, 2025
Responsible for developing complex PL/SQL packages and procedures to enhance data processing efficiency and automation. Collaborated with stakeholders to design and implement database solutions, including creating high-impact business reports like Customer Statements and AR Invoices. Played a key role in migrating data to new systems, ensuring seamless transition and data integrity. Implemented robust error handling frameworks in T-SQL and managed Informatica PowerCenter for smooth data integration. Designed high-performance data conversion interfaces leveraging SQL*Loader and PL/SQL. Automated billing operations with shell scripts and customized Oracle FLEXCUBE. Optimized Snowflake performance using clustering keys and caching, and developed intricate SQL queries for analytics. Utilized Microsoft BI Stack (SSIS, SSAS, SSRS) to build analytics workflows and interactive dashboards.
Project 2
August 1, 2019 – November 1, 2022
Architected and implemented robust SSIS packages for seamless data integration, improved data quality, and actionable insights. Applied row-level and role-based security within SSRS for sensitive information protection. Created detailed mapping documents for data consistency across source systems and data marts. Optimized database performance by creating Indexes, Views, Synonyms, Sequences, and Materialized Views. Developed complex queries using Joins, Subqueries, Windows functions, and CTE tables. Utilized Explain Plan and AWR reports for SQL performance tuning. Developed interfaces for item data conversion using SQL*Loader and PL/SQL. Employed BULK COLLECT and FORALL for high-performance data processing. Documented processes and leveraged advanced PL/SQL constructs for database triggers and data management.
Cultural Fit Analysis
The candidate has worked for two different companies (Infosys and Apexon) on banking domain projects, indicating adaptability to different organizational cultures and project requirements. The breadth of skills across various database technologies (Oracle, Snowflake), ETL tools (Informatica, SSIS), and reporting tools (Power BI, SSRS) suggests a willingness to learn and apply diverse technologies, which is a positive indicator for cultural fit in dynamic environments. The experience level of 5.7 years aligns well with a senior Data Engineer role.
Soft Skills & Operational Fit
The candidate's resume highlights collaboration with stakeholders, documentation of processes, and proactive issue resolution, indicating good operational fit and communication skills. The English test score of 60 suggests a foundational level of communication clarity, which could be further developed for senior-level roles requiring extensive stakeholder interaction and technical writing.