☁️Dillibabu Ramadhoss Email & Phone Number

Greater Bengaluru Area

• Design media, retails data-model for data migration to GCP and visualization via power BI and Looker. Running Cloud composer jobs through Cloud Run. Work on models in DBT dataflow-Staging-intermediate-marts-summary..
• Work on deployment on DBT with GCP project and GitHub Repository through Cloud Run including CI/CD. Create custom script to read Sensitivity high columns from full scan Big Query table. Design scalable patterns and.
• Create policy tags based on PII columns applied masking automation using Cloud Function. Develop understanding of the business domain and enterprise technology inventory to craft a solution roadmap that achieves.
• Write requirements for ETL and BI developers. Test the effectiveness of the database before release for business use. Partner with the data science team to standardize their classification of unstructured data into.

• Created connection profiles source-Cloud SQL target-GCS. Created Stream to load data into GCS from Cloud SQL. Used Dataflow custom script(streaming) to load GCS files to Big Query using Pub/Sub Notification.
• Work end to end DLP automation to apply masking for PII columns in Big Query. Created custom script to read Sensitivity high columns from full scan Big Query table. Create policy tags based on PII columns applied.
• Ensure physical and logical data models are designed with an extensible philosophy to support future, unknown use cases with minimal rework. Work with product managers and data stewards within the enterprise data.
• Partner with IT, data engineering and other teams on the admin and monitoring of all data platforms to ensure the enterprise data model incorporates key dimensions needed for the proper management, business, financial.
• Drive reviews of design, security features implementation performed by data engineers to drive data product development. Develop repeatable data patterns based on cloud-centric, code-first approaches to data management.

Amsterdam, North Holland, Netherlands

Amsterdam, North Holland, Netherlands

• Migrating sources like MS SQL database, Microsoft dynamics, Salesforce Data to Big Query and using of EDH framework for reporting. Build data pipelines in airflow in GCP for ETL related jobs using airflow operators.
• Coordinated with team and Developed framework to generate Daily adhoc reports and Extracts from enterprise data from Big Query. Knowledge about cloud dataflow and Apache beam
• Created Big Query authorized views for row level security or exposing the data to other teams. Experience with architecting, implementing and-or maintaining technical solutions in virtualized environments.
• Experience in design, architecture and implementation of Data warehouses, data pipelines and flows. Diverse experience in all phases of SDLC especially in Analysis, Design, Development, Testing and Deploying of app’s
• Conduct testing and debugging, utilize script tools, and write basic code for design specifications. Assess applicability of similar experiences and evaluate options under circumstances not covered by procedures
• Designing workshops focusing on transformation of the customer’s technology, covering the whole enterprise big data transformation program. Monitor performance and advise necessary infrastructure changes

Chennai, Tamil Nadu, India

• Mainly involved in development of mappings and transformations using Informatica. Extensively used transformations like Filter, Aggregation, Joiner, Expression, Lookup, Router, and Update Strategy.
• Development of Meta data transformations and establishing load schedule. Performance tuning at functional level and map level. Used relational SQL wherever possible to minimize the data transfer over the network.
• Created data validation jobs and loaded the rejected records into the relevant tables to send to the users for re-submitting. Involved in designing the maplet and reusable transformation according to the business needs.
• Reviews for Release Readiness, key milestones and Go/No-Go decisions. Ensure recency in release documentation, runbooks and release schedules. Maintain Build and Release Tools and develop new tools. Take ownership of.