Thej Pradeep Mootala
Fishers,IN
Summary
Senior Data Engineer with [X years] of experience in architecting, designing, and implementing large-scale data solutions across on-premises and cloud environments. Expertise in Massive Parallel Processing (MPP) databases, ETL design, cloud data engineering, and analytics platforms. Adept at building scalable data pipelines, optimizing performance, and enabling advanced analytics and BI reporting. Proven ability to lead end-to-end data engineering initiatives, mentor teams, and deliver business-critical insights across utilities, finance, and enterprise domains.
Overview
1
1
Certification
Work History
Data Engineer / ETL Developer
Previous Company
- Designed and implemented Informatica ETL workflows to support enterprise data warehouse.
- Developed complex SQL/PLSQL and BTEQ scripts for MPP systems (Teradata, Oracle 12c).
- Worked on data modeling, performance tuning, and query optimization for billing and customer care applications.
- Integrated OBIEE reports with enterprise data warehouse, providing actionable insights to business users.
- Automated batch job scheduling using Autosys and Control-M.
Senior Data Engineer
Company Name
- Current
- Designed and optimized high-volume ETL pipelines in Informatica, Matillion, and IICS for enterprise-wide data integration.
- Migrated on-premises Teradata workloads to Snowflake on AWS, improving cost efficiency and scalability by X%.
- Developed Python and Shell scripts to automate data ingestion, quality checks, and monitoring.
- Built and maintained data marts for analytics and reporting in Power BI and Tableau.
- Partnered with data scientists to enable machine learning use cases by preparing large structured/unstructured datasets.
- Implemented CI/CD pipelines with Git and DevOps tools, reducing deployment time and errors.
- Mentored junior engineers and collaborated with business stakeholders for data strategy alignment.
Education
Master of Science - Computer Science
Sri Krishnadevaraya University
INDIA06-2006
Skills
- Databases & MPP: Teradata, Oracle 12c, SQL Server, Teradata Vantage, Snowflake
- Programming & Scripting: SQL, PL/SQL, Unix Shell Scripting, Python, BTEQ
- Data Integration & ETL: Informatica, TDE, Matillion, Informatica IICS
- Big Data & Analytics: AWS (S3, Redshift, Glue, Lambda, EMR), Machine Learning (applied use cases)
- BI Tools: OBIEE, Power BI, Tableau
- Scheduling Tools: Autosys, Control-M
- Version Control & DevOps: Git, CI/CD, DevOps frameworks
- Operating Systems: Unix, Linux, Windows
- Applications: Oracle CC&B
- Data pipeline design
- Performance tuning
- Data migration
- Scripting languages
- Machine learning
- Data governance
- Real-time analytics
- Data pipeline control
- Data integration
- Database design
- SQL programming
- Relational databases
- Data analysis
- Technology leadership work streams
- SQL and databases
- Business intelligence
- RDBMS
- Advanced analytics
- Data analytics
- Technical support
- Problem-solving aptitude
- Analytical skills
- Data warehousing expertise
- Database development
- Adaptability and flexibility
- Professional demeanor
- Continuous improvement
- Relationship building
- Decision-making
- Problem-solving abilities
- Active listening
- Excellent communication
- Self motivation
- Teamwork
- Data visualization
- ETL processes
- Data quality management
- Database management
- Project management
- System analysis
- Microsoft SQL server
- Software development
- Report generation
- Team collaboration
- SQL transactional replications
- Big data technologies
- Risk analysis
- Backup and recovery
- Data quality assurance
- Data warehousing
- SQL expertise
- ETL development
- Data modeling
- Big data processing
Accomplishments
- Collaborated with team of [Number] in the development of [Project name].
- Achieved [Result] through effectively helping with [Task].
- Supervised team of [Number] staff members.
Certification
- Snowflake SnowPro Certification (if applicable)
- AWS Certified Data Analytics – Specialty (if applicable)
- Informatica PowerCenter / IICS Certification (if applicable)
Languages
English
Native or Bilingual
Timeline
Data Engineer / ETL Developer
Previous Company
Senior Data Engineer
Company Name
- Current
Master of Science - Computer Science
Sri Krishnadevaraya University
Similar Profiles
Megha PohaniMegha Pohani
Research Executive at Previous CompanyResearch Executive at Previous Company
WANDA QUEENWANDA QUEEN
Cost Accountant & Budget Analyst at Previous CompanyCost Accountant & Budget Analyst at Previous Company
Umer Bin YaqoobUmer Bin Yaqoob
Staff Accountant I at [Previous Company Name]Staff Accountant I at [Previous Company Name]
Joe SyrusJoe Syrus
Co-Founder at 20/40 Outdoor ServicesCo-Founder at 20/40 Outdoor Services
Kyle O'RileyKyle O'Riley
Sr Mech and Robotics Technician at AmazonSr Mech and Robotics Technician at Amazon