Imran Shaik
Bengaluru
Summary
Results-driven Data Engineer with a proven track record in SQL Server, SSIS, and Informatica PowerCenter. Expertise in optimizing ETL processes to achieve higher performance and operational efficiency. Strong collaboration with cross-functional teams ensures alignment of technical solutions with business objectives. Analytical skills and effective communication foster data-driven decision-making across the organization.
Overview
3
3
years of professional experience
Work History
Data Engineer
Schneider Electric
Bengaluru
02.2023 - Current
- Created stored procedures for automating periodic tasks in SQL Server.
- Creating indexes, like clustered indexes and non-clustered indexes, to improve query performance.
- Expertise in using ranking functions, string functions, date functions, and aggregate functions.
- Expertise in creating temporary tables, table variables, and common table expressions (CTE).
- Optimized existing queries to improve query performance by creating indexes on tables.
- Collaborated with cross-functional teams to gather requirements and translate business needs into technical specifications for data solutions.
- Created mappings, sessions and workflows to move data from source systems to target systems using Informatica PowerCenter.
- Worked closely with Business Analysts and End Users for gathering requirements and providing technical solutions during design phase .
- Coordinated with DBA team for creating new databases, tablespace configurations, user accounts creation and privileges management, when required for development purpose or migration purpose across different environments .
- Identified data quality issues and worked with business users to resolve them in a timely manner.
- Provided production support for all ETL related issues involving Informatica PowerCenter.
- Designed complex transformations using various transformation objects like Joiner, Lookup, Aggregator, Sorter in Informatica PowerCenter.
- Implemented Slowly Changing Dimensions Type 1 and 2 in SSIS Packages to capture changes in the source data over time.
- Optimized existing SSIS packages by performing performance tuning activities like reducing redundant operations, replacing Lookup and Merge Join with Hash Match.
- Generated automated reports that monitored successful completion of ETL processes on a daily basis.
- Created complex SSIS packages with multiple transformations, such as derived columns, lookups, conditional splits, merges, merge joins, execute SQL tasks, and so on.
- Created and maintained database objects including tables, views, indexes, and triggers to ensure data integrity and performance efficiency.
- Deployed SSIS packages from development environment to QA, UAT, Production environments successfully.
- Designed and developed complex SQL queries for data analysis and extraction to support business decisions.
- Developed complex mappings using transformations such as Aggregator, Expression, Connected Lookup, Unconnected Lookup, Router transformations, transaction control, and Normalizer Transformation.
- Developed Python scripts for extracting data from APIs and loading it into an SQL table.
ETL Developer
Starcom Information Technology
Bengaluru
01.2022 - 01.2023
- Documented all processes related to database development activities such as creating stored procedures or migrating databases from one server to another.
- Expertise in creating temporary tables, table variables, and common table expressions (CTE).
- Created mappings using transformations such as Derived Column, Data Conversion, Conditional Split, Row Count, Union All, Lookup, Sort, etc. Using Data Flow Task.
- Developed stored procedures, triggers and functions using T-SQL for data manipulation, retrieval and updating of databases.
- Implemented complex queries to retrieve data from SQL Server database by joining multiple tables with different conditions.
- Created SSIS packages to extract, transform and load data between heterogeneous sources like Oracle, MS Access and flat files into the SQL Server database.
- Integrated and organized diverse datasets with SSIS components like Union All, Sort, Aggregation.
- Converted unstructured data from multiple sources using SSIS transformations including DFT, multicast, and conditional split.
- Created documentation such as technical specifications for each task involved in ETL process.
- Implemented Slowly Changing Dimensions Type 1 and 2 in SSIS Packages to capture changes in the source data over time.
- Debugged errors encountered during development or testing phases of ETL processes.
- Optimized existing SSIS packages by performing performance tuning activities like reducing redundant operations, replacing Lookup and Merge Join with Hash Match.
- Generated automated reports that monitored successful completion of ETL processes on a daily basis.
- Created complex SSIS packages with multiple transformations such as derived columns, lookups, conditional splits, script tasks and execute SQL tasks.
- Deployed SSIS packages from development environment to QA, UAT, Production environments successfully.
- Designed and developed custom logging framework using Event Handlers and Log Providers within SSIS packages to log progress of package execution.
- Created and maintained database objects including tables, views, indexes, and triggers to ensure data integrity and performance efficiency.
Education
Vikrama Simhapuri University
Skills
- SQL Server
- Transact-SQL
- Informatica PowerCenter
- SSIS
- Amazon Redshift
- Data warehousing
- Snap logic
- Data modeling
- WinSCP
- FileZilla
Accomplishments
- Got Appreciation from the leadership team for delivering a high valued project in a short span.
Languages
Hindi
Native language
English
Advanced (C1)
C1
Telugu
Advanced (C1)
C1
Timeline
Data Engineer
Schneider Electric
02.2023 - Current
ETL Developer
Starcom Information Technology
01.2022 - 01.2023
Vikrama Simhapuri University
Similar Profiles
Abhishek SinhaAbhishek Sinha
R&D Manager at AVEVA Group PLC, A Schneider Electric, Schneider Electric SoftwareR&D Manager at AVEVA Group PLC, A Schneider Electric, Schneider Electric Software
Süleyman KEYKUBATSüleyman KEYKUBAT
R&D Mold and Project Executive at GÜNSAN ELECTRIC (SCHNEIDER ELECTRIC)R&D Mold and Project Executive at GÜNSAN ELECTRIC (SCHNEIDER ELECTRIC)
JitendraKumar SharmaJitendraKumar Sharma
Senior General Manager -Industry Services,Gr India at Schneider ElectricSenior General Manager -Industry Services,Gr India at Schneider Electric
Bernard RuzzoBernard Ruzzo
Territory Account Executive at Schneider ElectricTerritory Account Executive at Schneider Electric
Ritu A. MullurRitu A. Mullur
Project Coordinator (PMO) at Persistent SystemsProject Coordinator (PMO) at Persistent Systems