JINCY GEORGE
Los Angeles,United States
Summary
Data Engineer with 10+ years of experience in data migration/integration, data warehousing, Oracle database, and Cloud. Skilled in ELT, SQL, PL-SQL, data modeling, and performance tuning. Proven track record in improving operational performance, automating ETL processes, and accelerating OLAP data processing. Experienced in leading data engineering teams and implementing strategic enhancements. Proficient in Agile and Scrum methodologies with a strong foundation in leasing, retail, and insurance domains. Excited to leverage expertise in Data Engineering to drive innovation and optimize processes for future success.
Overview
11
11
years of professional experience
Work History
Lead Data Engineer -TESCO
Sopra Steria
03.2018 - 02.2022
- On Premise HCM to Oracle HCM Cloud Data Integration and Data Migration from Oracle e Biz to Fusion Financial Team using Agile Methodologies
- Strong experience in design, development, implementation, and maintenance of large Enterprise Data Solutions
- Development/Review and implementation of business requirements to detail technical specifications,ETL/ODI mappings/packages, boosting data analysis output, aligned with JIRA technical design documents
- Revamped and optimized DB designs, increasing analytical capabilities and data retrieval speed
- Streamlined end-to-end package data migration processes using ODI12c ,Oracle PLSQL,SQL and Oracle HCM
- Performing unit testing and supporting system testing and user acceptance testing phases.
- Good knowledge on production Load plans run and debug batch jobs in ODI Enterprise
- Housekeeping activities of ODI /database platform, ODS and data flows and Monitoring of implemented ODI flows and rerouting tickets as needed
- Proven ability to provide technical guidance and mentorship to team members
- Comfortable with picking up new technologies
- Adapted quickly to evolving project demands, ensuring seamless operations in environments with frequently changing requirements
- Research and stay abreast of technology trends and IT best practices, with a focus on continuous learning and possible application to the business.
- Self-motivated, with a strong sense of personal responsibility.
- Excellent communication skills, both verbal and written.
Senior Software Engineer -DEUTSCHELEASING Germany
Hexaware Technologies
06.2013 - 03.2018
- Delivered a comprehensive Enterprise Datawarehouse application, streamlining analytics and reporting across complex systems
- Exposure in Developing Project requirements for end-to-end Data integration process using ETL for Structured, semi-structured and Unstructured Data.
- Experienced in investigate, Analyze and understand data contents of source data systems
- Knowledge on dimensional modeling (relational and dimensional) techniques for data warehouse design
- Engineered and deployed robust PLSQL packages,procedures and functions
- Streamlined ETL mappings,PLSQL objects,SQL scripts
- Involved and led SIT/ UAT/PROD phases, fixing performance bottlenecks.
- Worked on Onsite -Germany-Offshore Business Model
- Demonstrated expertise in performance tuning in various DB environments with large volume and velocity of data
- Expertise in Relational Databases, data mining and transformation, Integration Patterns.
- Developed scalable applications using agile,waterfall methodologies for timely project delivery.
- Managed multiple projects simultaneously while maintaining strict deadlines and high-quality standards.
- Maintained comprehensive documentation of development work, facilitating knowledge sharing among team members.
- Streamlined development workflows to increase team efficiency and reduce time spent on repetitive tasks.
- Delivered exceptional client support by promptly addressing concerns and implementing requested changes or enhancements to software solutions.
- Mentored junior developers, fostering professional growth and enhancing team productivity.
Datawarehouse Analyst
Bajaj Allianz General Ins. Co.Ltd
03.2011 - 06.2013
- Extensive experience in interacting with business users to analyze their business processes and requirements. Gather and validate those requirements into database and ETL mapping and designs to ingest and transform the data and help the user visualize the data and key insights through the reports using SAP BO,OWB,SQL,PLSQL
- Designed PL/SQL packages, tables, stored procedures, and triggers aligned with business objectives
- Created Unit test cases and test queries
- experienced on trouble-shooting ETL session failures and the ability to performance tune mappings/DB objects.
- Implemented automation for monthly insurance data submissions to IIB/IRDA, ensuring 100% compliance and reducing manual effort
- Strong skills in all phases of the Software Development Life Cycle (SDLC)
- Established clear documentation guidelines for all phases of development, fostering better communication among team members and stakeholders alike.
- Maintained knowledge on emerging developments/trends for assigned area(s) of responsibility, assessed the impact, and collaborated with senior management to incorporate new trends and developments in current and future solutions.
Education
Bachelor of Computer Applications -
IGNOU
01.2010
Skills
- SQL
- ODI12c
- PL-SQL
- Data Warehousing
- Extract Transform Load (ETL)
- Performance Tuning
- Scrum Methodology
- Python (Programming Language)
- Databricks
- OWB
- GIT
- SAP BO
- Snowflake
- Unix shell scripting
- Oracle Cloud
Visa
H4 EAD
Timeline
Lead Data Engineer -TESCO
Sopra Steria
03.2018 - 02.2022
Senior Software Engineer -DEUTSCHELEASING Germany
Hexaware Technologies
06.2013 - 03.2018
Datawarehouse Analyst
Bajaj Allianz General Ins. Co.Ltd
03.2011 - 06.2013
Bachelor of Computer Applications -
IGNOU