Postgres SQL
Nikhil Nehal
Software Engineer
Patna
Summary
"ETL Developer with 5 years of experience in designing, developing, and maintaining Extract, Transform, Load (ETL) processes to facilitate seamless data integration across heterogeneous systems. Proficient in utilizing tools such as Informatica PowerCenter, Informatica Developer, Informatica Intelligent Cloud Services (IICS)and DataStage to extract data from various sources, transform it according to business requirements, and load it into target databases or data warehouses.
Overview
5
5
years of professional experience
4
4
years of post-secondary education
4
4
Languages
Work History
Data Engineer
Pacific Data Integrators
5 2022 - Current
- Experienced IICS (Informatica Intelligent Cloud Services) Developer proficient in leveraging cloud-based ETL solutions to drive data integration, transformation, and management initiatives. Skilled in developing scalable and reliable data pipelines tailored to the unique requirements of diverse industries, with particular expertise in the banking sector.
- Experienced Informatica PowerCenter Developer specializing in the banking sector, adept at architecting and implementing robust ETL solutions to meet the complex data integration needs.
- Proficient in SQL for querying, manipulating, and analyzing data from relational databases.
- Proven ability to work on migration projects, ensuring smooth transitions while maintaining data integrity.
- Experience in performance tuning and optimization of ETL processes to enhance efficiency and reduce processing time with strong understanding of data warehousing concepts and methodologies.
- Excellent problem-solving skills and ability to troubleshoot issues in ETL workflows with effective communication and collaboration skills, with experience working in cross-functional teams to deliver high-quality solutions.
- Skilled in developing and executing comprehensive testing strategies to validate ETL processes and ensure data accuracy.
- Certified Cloud Data and Application Integration as well as PC to IDMC Migration expert.
- Certified Databricks Analyst Associate and Engineer.
- Certified as Snowflake Snowpro Core Expert.
Data Engineer
Larsen & Toubro Infotech
05.2019 - 04.2022
- Tested compliance frameworks for multi-site data warehousing efforts to verify conformity with bank and data security and integrity guidelines.
- Analyzed complex data and identified anomalies, trends and risks to provide useful insights to improve internal support.
- Tested, updated and organized databases to handle customer and data.
- Contributed to internal activities for overall process improvements, efficiencies and innovation.
- Tested programs and databases to identify issues and make necessary modifications.
- Eliminated downtime by accurately implementing database.
Education
B.Tech - Information Technology
SRM Insititute Of Science And Technology
Chennai 05.2015 - 05.2019
Skills
- Good telephone etiquette
Excellent work ethic
Cultural awareness
Verbal and written communication
Software
Apache Hive
Informatica Developer
Informatica PowerCenter
IICS
Informatica Admin
Data Governance
Timeline
Data Engineer
Larsen & Toubro Infotech
05.2019 - 04.2022
B.Tech - Information Technology
SRM Insititute Of Science And Technology
05.2015 - 05.2019
Data Engineer
Pacific Data Integrators
5 2022 - Current
Similar Profiles
Shane BerlinShane Berlin
Press Operator at GKM/ Pacific Data FormsPress Operator at GKM/ Pacific Data Forms
Eslavath DeepikaEslavath Deepika
Process Associate at Compu Pacific International Data Services Pvt Ltd.Process Associate at Compu Pacific International Data Services Pvt Ltd.
Scott KellyScott Kelly
Senior Data Technician at Data PacificSenior Data Technician at Data Pacific