Exciting Urgent Opportunity: Technical Corporate Trainer

Exciting Urgent Opportunity: Technical Corporate Trainer

Location: Mumbai-Yosemite

compensation : Attractive & Competitive

Type: Short-Term Assignment (ASAP Start)

Compensation: Competitive & Attractive

Schedule: 20th Oct 2025 to

24th Oct 2025

About CalxMap

At CalxMap, we connect corporations and academia with top-tier professionals like Chartered Accountants, Corporate Lawyers, and Industry Trainers, transforming corporate excellence through strategic talent solutions. Our mission is to bridge knowledge and opportunity, unlocking workforce potential and driving measurable results by addressing skill gaps, escalating costs, and stalled projects. We offer employee development programs boosting productivity by up to 40% via AI and role-specific workshops, on-demand senior experts (15+ years' experience) deployed in 24-48 hours, and free intern hiring with 75% conversion rate. Our advantages: rapid deployment, cost-effectiveness, proven results (e.g., 38% productivity increase for Magicpin), and long-term partnerships. Join our trailblazing team to shape the future of tech training

The Role

As a Technical Trainer for BI I&D (Basic SQL + ETL) Program, you will:

Deliver engaging offline training sessions.

Cover key topics as outlined in course details.

Blend theoretical knowledge with practical hands-on data warehousing and ETL.

Commit to flexible duration based on content, starting ASAP.

Who Should Apply

We seek passionate experts with:

3-10 years' experience in Oracle SQL, Informatica ETL, and Python analytics in corporate/training roles.

Hands-on expertise in data warehousing, Unix scripting, SQL queries, and transformations.

Excellent presentation and online training skills.

Passion for sharing industry knowledge.

Availability for evening IST sessions, starting ASAP.

How to Apply

Email your resume with subject line "BI I&D (Basic SQL + ETL) Trainer" to

Create your profile at:

Share the Opportunity

If unavailable, kindly share with colleagues who may be interested.

Course Details

Course: BI I&D (Basic SQL + ETL) Program

Overview: This course provides comprehensive hands-on training in data warehousing, Oracle SQL basics, ETL using Informatica, Unix shell scripting, and Python for analytics. Covers database concepts, ETL processes, scripting, and data manipulation for enterprise data projects.

Audience:

• Developers (freshers & experienced) in data technologies

• Data engineers working on warehousing and ETL

• Technical consultants in SQL and Informatica solutions

• Project managers overseeing data deployments

Prerequisites:

• Basic understanding of databases and programming

• Familiarity with SQL or scripting tools

• Experience with data tools is helpful

Detailed Course Outline:

Topic 1: Data Warehouse Concepts

• Business Intelligence: Need, terms, components

• Data Warehouse: History, architecture, features, data marts

• Dimensional Modeling: Fact/dimension tables, star/snowflake schemas

• ETL and Metadata: Process, usage in warehousing

• Best Practices: Successful warehouse recipe, pitfalls, tools, trends

Topic 2: Unix Shell Scripting

• Introduction: OS, basic commands

• File System: Types, permissions, related commands

• Filters: Simple/advanced

• Vi Editor: Input/save/quit, cursor movements

• SED/GREP/AWK Commands

• Shell Programming: Variables, operations, arguments, conditionals

Topic 3: Oracle SQL Basics

• Introduction: DBMS characteristics, models, integrity, normalization

• Structured Query Language: SQL*Plus, rules, datatypes, constraints

• DML: Insert/update/delete rows

• Database Objects: Index, synonym, sequence, views

• DQL: Select, distinct, operators, order by

• Aggregates: Functions, group by, having, rollup/cube

• SQL Functions: Character/number/date/misc

• Transactions: Commit/rollback/savepoints

• Joins/Subqueries: Inner/outer/self, correlated, exists

• Set Operations: Union/intersect/minus

• DCL: Grants

• Oracle Architecture/Data Dictionary

• PL/SQL: Block structure, variables, SQL in PL/SQL, constructs

Topic 4: ETL Basics using Informatica

• Basic Concepts: Warehouse strategies/architecture, ETL need/process

• ETL Process: Extraction/transformation/loading

• Operational: Exceptions, alerts, restartability, scheduling

• ETL Tools: Vendors, strengths, choosing tools

• Informatica PowerCenter: Components, domain, integration service

• Designer: Mappings, modes, sources/targets

• Transformations: Source qualifier, expression, aggregator, lookup (caches), filter, joiner

• Flat Files: Properties

• Mapplets: Input/output

• Workflow: Manager/monitor, connections, tasks, session, debugger, processes

• Schedule: Options, editing/deleting

• Logs: Tracing levels

• Additional Transformations: Sequence generator, update strategy, router, sorter, stored procedure, union, SQL

Topic 5: Python

• Introduction: Overview for analytics, setup (Python/Jupyter/Anaconda)

• Basics: Variables/types/operators, input/output, control flow

• Data Structures: Lists/tuples/sets/dicts, comprehensions

• Functions/Modules: Defining/calling, built-ins (sum/len/map), imports (math/random)

• NumPy: Arrays, operations

• Pandas: DataFrames/series, reading/writing (CSV/Excel), cleaning

• Visualization: Matplotlib/Seaborn, plots (line/bar/scatter), customizing

• Descriptive Analytics: Stats (mean/median/mode/variance), aggregations/grouping

• EDA: Trends/patterns, data cleaning