RAUSHAN KUMAR
Gurugram
Summary
Dynamic Data Specialist with over 10 years of experience at Code Experts India, proficient in designing scalable ETL workflows utilizing Informatica Cloud and optimizing data integration processes.
Overview
10
10
years of professional experience
1
1
Certification
Work History
Data Specialist
Code Experts India
Bangalore
08.2021 - Current
- Led the design and implementation of data integration solutions using Informatica Cloud Application Integration (IICS) to extract data from Salesforce, Marketo, and Workday.
- Architected and developed scalable ETL workflows in IICS to load data into Google BigQuery (GBQ), ensuring data accuracy and consistency.
- Led a team of data engineers in the development, testing, and deployment of data pipelines, ensuring adherence to project timelines and quality standards.
- Collaborated with stakeholders to gather business requirements and translate them into technical specifications for data integration.
- Designed and implemented data models and schemas in GBQ to support business intelligence and reporting needs.
- Optimized IICS workflows and GBQ performance for efficient data processing and retrieval.
Lead Data Engineer
Allstate India
Bangalore
06.2019 - 08.2021
- Managed the ETL processes for Allstate protection plan data from merchants like Amazon and eBay.
- Collaborated with merchants to define requirements and oversaw data governance and profiling.
- Developed mappings in Informatica PowerCenter and Informatica Developer.
- Automated Tableau report generation for weekly, monthly, and yearly reports.
- Provided support during high data volume periods like Black Friday and Christmas.
ETL Developer
Capgemini Technology Services
Bangalore
06.2018 - 06.2019
- Standardized data from US and Japan (Mitsubishi and Union Bank) for unified reporting.
- Built Informatica pipelines for data quality checks and warehouse loading.
- Extracted data from Mainframe and DB2, transforming it using Informatica PowerCenter and Developer.
- Developed IDQ mappings for completeness, conformity, and continuity, using transformations like Match and Standardizer.
- Created profiles to check data uniqueness.
ETL Developer
Cognizant Technology Solutions
Bangalore
03.2015 - 05.2018
- Worked on an anti-money laundering project (ELZ) to prevent fraud.
- Developed an Informatica layer to remove anomalies, cleanse data, and load it into the data warehouse.
- Extracted data from Mainframe and transformed it using Informatica PowerCenter and Developer.
- Prepared unit test cases and performed unit testing.
- Contributed to solution design, delivery, and client interfacing.
Education
Bachelor of Engineering - ECE
Nagpur University
Nagpur, India06-2014
Skills
- Informatica Cloud (IICS) - CDI
- Informatica Cloud (IICS) - CAI
- Cloud Data Warehouses (Snowflake, GBQ)
- Legacy Databases (SQL, Oracle)
- SaaS Tools (Salesforce, Workday, Marketo)
- Scripting (shell scripting, batch scripting)
- Python (basic)
- Tableau
Certification
- Tableau Desktop Certified
- Snowflake Snow Pro Certified
- Azure Data Engineer Certified
Timeline
Data Specialist
Code Experts India
08.2021 - Current
Lead Data Engineer
Allstate India
06.2019 - 08.2021
ETL Developer
Capgemini Technology Services
06.2018 - 06.2019
ETL Developer
Cognizant Technology Solutions
03.2015 - 05.2018
Bachelor of Engineering - ECE
Nagpur University
Similar Profiles
Sunil KalkunteSunil Kalkunte
Managing Director/Head Of Engineering/Board Member at Code And Theory IndiaManaging Director/Head Of Engineering/Board Member at Code And Theory India
Prakash UmarnaniPrakash Umarnani
Enterprise Account Manager at Crayon Software Experts India Pvt LtdEnterprise Account Manager at Crayon Software Experts India Pvt Ltd
ROHIT SINGHROHIT SINGH
Cloud Consultant at Crayon Software Experts India Pvt Ltd.Cloud Consultant at Crayon Software Experts India Pvt Ltd.