08/03/2026 updated
100 % available
Database / Database Architect / Data Engineer / Python
Ranchi, India
Only remote
B.Tech in Information TechnologyAbout me
Database Architect & Data Engineer with 12+ years of experience in designing scalable data platforms, ETL/ELT pipelines, and cloud modernization. Skilled in Python automation, performance tuning, and leading teams to deliver high‑impact, business‑driven solutions.
dbtData ArchitectureDatabase DesignDatabase DevelopmentPython (Programming Language)PostgreSQLOracle SQL DeveloperScrum MethodologyPL-SQLSQL DatabasesSQLAlchemyDatabase EnginesSystems IntegrationSQL OptimizationSnowflake
PostgreSQL Database Development
Expertise in designing and implementing scalable Postgres solutions including functions, stored procedures, PL/pgSQL, materialized views, views, indexing strategies, partitioning, JSONB, window functions, CTEs, and foreign data wrappers for high-throughput enterprise applications.
Data Engineering & ETL/ELT Pipelines
Design and implementation of ETL/ELT pipelines, Medallion Architecture (Bronze/Silver/Gold), CDC patterns, data validation and quality checks, and data lineage for pharma and enterprise clients.
Python Programming & Automation
Proficiency in Python 3 for data processing, Excel automation, report generation, and building custom ETL scripts; additionally experienced with PowerShell and Shell scripting, Git, and CI/CD for data pipelines.
Oracle SQL & PL/SQL
Knowledge of Oracle SQL, PL/SQL, and data modeling for application integration in enterprise environments.
Cloud & Migration (AWS, Snowflake)
Hands-on experience with AWS SCT (Schema Conversion Tool), AWS S3, Snowflake, and basic familiarity with AWS Glue, Lambda, and managed data services for cloud migrations.
Orchestration & Transformation (Airflow, dbt)
Practical knowledge of Airflow and dbt concepts for scheduling, orchestration, and modular data transformations.
Analytics & Reporting (Tableau, BI)
Experience with Tableau, BI integration, flat-file exports, and report automation to deliver analytics-ready data products to business stakeholders.
DevOps & Collaboration
Familiarity with Git, Jira, Confluence, and CI/CD pipelines; experienced in Agile/Scrum environments, code reviews, mentoring, and technical design documentation.
GEN-AI, LLM & ML
Knowledge and hands-on experience in generative AI, large language models, and machine learning concepts applied to data engineering contexts.
Expertise in designing and implementing scalable Postgres solutions including functions, stored procedures, PL/pgSQL, materialized views, views, indexing strategies, partitioning, JSONB, window functions, CTEs, and foreign data wrappers for high-throughput enterprise applications.
Data Engineering & ETL/ELT Pipelines
Design and implementation of ETL/ELT pipelines, Medallion Architecture (Bronze/Silver/Gold), CDC patterns, data validation and quality checks, and data lineage for pharma and enterprise clients.
Python Programming & Automation
Proficiency in Python 3 for data processing, Excel automation, report generation, and building custom ETL scripts; additionally experienced with PowerShell and Shell scripting, Git, and CI/CD for data pipelines.
Oracle SQL & PL/SQL
Knowledge of Oracle SQL, PL/SQL, and data modeling for application integration in enterprise environments.
Cloud & Migration (AWS, Snowflake)
Hands-on experience with AWS SCT (Schema Conversion Tool), AWS S3, Snowflake, and basic familiarity with AWS Glue, Lambda, and managed data services for cloud migrations.
Orchestration & Transformation (Airflow, dbt)
Practical knowledge of Airflow and dbt concepts for scheduling, orchestration, and modular data transformations.
Analytics & Reporting (Tableau, BI)
Experience with Tableau, BI integration, flat-file exports, and report automation to deliver analytics-ready data products to business stakeholders.
DevOps & Collaboration
Familiarity with Git, Jira, Confluence, and CI/CD pipelines; experienced in Agile/Scrum environments, code reviews, mentoring, and technical design documentation.
GEN-AI, LLM & ML
Knowledge and hands-on experience in generative AI, large language models, and machine learning concepts applied to data engineering contexts.
Experience
Professional experience10+ years
Freelancer since2026
Languages
EnglishFluent
Project history
Lead Postgres development for Pfizer finance dashboards: designed and implemented functions, procedures, materialized views, partitioned tables, and indexes to support high-throughput reporting. Implemented data ingestion pipelines from multiple upstream systems into Postgres; built validation layers and automated reconciliation reports consumed by Tableau. Collaborated with BI and analytics teams to optimize data models for dashboard performance; reduced dashboard latency by approximately 30% through targeted schema and view redesign. Mentored junior developers on PL/pgSQL best practices, code reviews, and unit testing for database code.
Built ETL processes to ingest training records via CSV and flat files; implemented validation, enrichment, and integration logic in Postgres and Python. Automated Excel report generation and formatting using Python scripts to support compliance and training audits. Designed data pipelines to feed Tableau dashboards and downstream flat-file consumers.
Directed the successful decommissioning of legacy mainframe systems and migration to AWS-hosted PostgreSQL environments. Managed zero-loss data integrity audits and compliance checks during enterprise-wide cloud transitions. Mentored junior engineers on advanced SQL tuning and cloud data architecture best practices.