01/02/2026 updated


100 % available
Software developer (Android WebApps Database development MS Access Website development)
Pune, India
India
Bachelor of Engineering in Computer ScienceJava (Programming Language)Batch ProcessingBusiness IntelligenceGoogle BigQueryC Sharp (Programming Language)UnixC++ (Programming Language)Cloud ComputingCryptographyData GovernanceExtract Transform Load (ETL)Data Vault ModelingData WarehousingDatabase DesignDatabase Development
- ETL Development
- Tools: SQL Server Integration Services (SSIS), Informatica, Talend,
- Languages: SQL, Python, Shell scripting
- Real-time & batch processing pipelines with error handling, logging, and performance tuning
- Data Warehouse Design
- Architectures: Star Schema, Snowflake Schema, Data Vault
- Platforms: Microsoft SQL Server, Oracle, PostgreSQL, Snowflake, Redshift, BigQuery
- Cloud-native solutions with AWS Redshift, GCP BigQuery
- Transactional Systems
- OLTP database design ensuring ACID compliance
- High-availability clustering, replication, and disaster recovery strategies
- Performance optimization with indexing, partitioning, and query tuning
- Analytical Solutions
- OLAP cube design for multidimensional analysis
- BI Tools: Power BI, Tableau, Qlik, Looker
- Data Governance & Security
- Role-based access control, encryption, masking, GDPR/CCPA compliance
- Metadata management and lineage tracking
Experience
Professional experience10+ years
Freelancer since2012
Languages
ChineseBasic knowledgeEnglishNative speakerHindiNative speaker
Project history
Requirement analysis and design of the datawarehouse and datalake solutions
Leverage underlying database systems to build robust and scalable solutions for data analytic needs
Build the Aggregate layer for reporting needs
Oversee multiple teams and plan the technical implementation
Co-ordinate with stakeholders to ensure project co-ordination from requirement gathering to solution delivery and post delivery maintenance
Design and develop accelerated data integration framework for Insurance client.
Design framework to ensure seamless data collection and integration and development of DWH architecture on snowflake
Orchestration of the pipelines using Python franework with audit, notification and restart capabilities
- Design and development of datawarehouse layer for an Insurance client
- Collaboration with Business for developing solutions for project migration from current on premise to AWS cloud
- Develop datamarts using AWS S3, Hive QL, Aws Lambda and Aurora DB for the business teams
- Enhancement and bug fixing for existing datamart jobs
- Perform automation of tasks for data delivery using Python scripting
- Lead a small team for effective development and communication with onsite counterparts.