Parthiban Soundararajan
Eagan,MN
Summary
Results-driven Data Engineer with a proven record of high productivity and efficient task completion. Proficient in ETL Development using Informatica and Talend, database management with SQL, and data visualization using Tableau. Strong problem-solving, collaboration, and adaptability skills to develop innovative data solutions.
Overview
14
14
years of professional experience
1
1
Certification
Work History
Data Engineer
Compunnel
Eagan, MN
10.2021 - Current
- Analyzed user requirements, designed and developed ETL processes to load enterprise data into the Data Warehouse.
- Designed data warehousing solutions, applying dimensional modeling techniques for optimized data retrieval.
- Streamlined data flow from diverse sources using ETL tools such as Talend, Informatica, and Airflow.
- Configured and maintained cloud-based data infrastructure on platforms like AWS, Azure, and Google Cloud to enhance data storage and computation capabilities.
- Designed, constructed, and maintained scalable data pipelines for data ingestion, cleaning, and processing using Python and SQL.
- Optimized SQL queries and database schemas for performance improvements in data retrieval operations.
- Managed version control and deployment of data applications using Git, Docker, and Jenkins.
- Participated in agile development processes, contributing to sprint planning, stand-ups, and reviews to ensure timely delivery of data projects.
- Established and enforced data governance policies and procedures to comply with regulatory requirements and ensure data privacy.
- Monitored data systems performance, identifying bottlenecks and implementing solutions to maintain system efficiency.
- Developed and managed enterprise-wide data analytics environments.
ETL Developer
Cognizant
Eagan, MN
10.2016 - 09.2021
- Worked closely with Business Analysts, System Analysts, Data Architects in gathering requirements for developing ETL solutions.
- Designed customized technical solutions to meet functional specifications outlined by database customers.
- Created conceptual, logical and physical data models for use in different business areas.
- Wrote and coded logical and physical database descriptions, specifying identifiers of database to management systems.
- Developed ETL packages to extract, transform, and load data from multiple sources into a data warehouse.
- Monitored performance of the ETL processes by creating log files with SSIS logging features.
ETL Developer
Cognizant
Chennai, Tamil Nadu
02.2011 - 09.2016
- Involved in creating database objects such as tables, views, indexes based on business requirements.
- Maintained source system metadata information in order to ensure accuracy of the ETL process.
- Implemented best practices while developing ETL packages like error handling, logging.
- Performed unit testing of all the mappings developed in the ETL layer before delivering it to production environment.
- Performed troubleshooting of existing production jobs when needed.
- Optimized queries by analyzing query plans using SQL profiler tool.
- Participated in code reviews with other developers providing feedback on design techniques used in programming tasks.
Education
Bachelor of Science - B.Tech - Information Technology
Mailam Engineering College
Mailam, Tamil Nadu, India05-2010
Skills
- Data Modeling
- Informatica
- Talend
- AWS
- GCP
- Azure
- Oracle
- Teradata
- Snowflake
- Python
- Performance Tuning
- SQL and Databases
- Database Design
- SQL Programming
- RDBMS
Certification
- AWS Cloud Practitioner
- Google Cloud Professional Data Engineer
Timeline
Data Engineer
Compunnel
10.2021 - Current
ETL Developer
Cognizant
10.2016 - 09.2021
ETL Developer
Cognizant
02.2011 - 09.2016
- AWS Cloud Practitioner
- Google Cloud Professional Data Engineer
Bachelor of Science - B.Tech - Information Technology
Mailam Engineering College
Similar Profiles
Princy RaiPrincy Rai
Product Owner at CompunnelProduct Owner at Compunnel
Mackenzie TibballMackenzie Tibball
Registered Nurse at CompunnelRegistered Nurse at Compunnel
Abinash Abinash null
Associate Director, MSP IT Practice at CompunnelAssociate Director, MSP IT Practice at Compunnel