Syed Amin
Saddle Brook,NJ
Summary
Highly skilled professional with 10+ years of hands-on experience in analyzing, architecting, developing and designing solutions (ETL,Data Warehouse, Data Mart, ODS) in OLTP technologies using star and snowflake dimensional modeling. Hands-on exposure with Informatica Cloud(IICS)/ETL technologies. Self-motivated team performer with experience as Senior Informatica /Informatica cloud(IICS)/SSIS Developers.
Overview
24
24
years of professional experience
Work History
Sr. Informatica/IICS Developer
Harris Computer Systems
04.2022 - Current
- Analyzed business requirements and functional specifications.
- Working closely with business teams to understand along with the Business Analyst & ETL Architect team.
- Develop integration processes using IICS and Informatica PowerCenter using best practices around data movement including audit, balance, control, and error handling.
- Developed ETL process using IICS to implement business requirements.
- Document creating source to target mapping and technical design documents.
- Created mappings using IICS transformations Source and Target, Data mask, Expression, Filter, Hierarchy Builder, Hierarchy parser, joiner, lookup, Router, Sequence Generator, and Sorter to load data from File System, database to database, and vice versa.
- Developed audit, parameterization, and error logging framework in IICS for better tracking of the data.
- Developed IICS mapping to load data from Oracle to Normalized and De-Normalized XMLs.
- Experience in creating databases in Snowflake for different projects.
- Involved in Migrating legacy data warehouse.
- Extensively used Oracle Developer and MS Management Studio for executing SQL scripts and worked on SQL to enhance the performance of conversion mapping.
- Created tasks, sequential and concurrent batches for proper execution of mappings using task flow.
- Documented describes program development, logic, coding, testing, changes, and corrections.
- Created Test cases for developed mappings and created integration Testing documents.
- Worked on resolving different ETL production tickets with Tier 1 team
- Migrated code into different environments using Bitbucket
Senior Data Warehouse Engineer
EScholar LLC
04.2007 - 04.2022
- Experience on Analysis, Design, Development, Implementation, and Level 2 support data warehouse and data integration using Informatica PowerCenter.
- Extensive knowledge on developing SQL with various relational databases like SQL, DB2, and Oracle.
- Developed ETL Mapping for supporting Data Extract, transformations, and loading using Informatica PowerCenter.
- Strong with relational database design concepts.
- Worked on Informatica performance tuning involving Source, Target, and Mapping Level bottlenecks.
- Performed data manipulation using various Informatica Transformations like Filter, Expression, Lookup (Connected and un-connected), Aggregate, Update Strategy, Normalizer, Joiner, Router and Union.
- Developed Workflow using Task Developer, Worklet, and Workflow Designer in Workflow Manager and monitored the results using Workflow Monitor.
Informatica Developer
Merrill Lynch
04.2004 - 04.2007
Application Developer
YourNet
02.2000 - 03.2004
Education
Master of Science - Software System
University of St. Thomas
Saint Paul, MN05.2004
Bachelor of Science - Network Modeling And Data Simulation
Saint Cloud State University
Saint Cloud, MN05.2000
Skills
- Informatica Power Center 10x/9x/8x
- IICS (Informatica Cloud) Data Integration
- API/Web Services using application integration REST Endpoint connecter
- Informatica Cloud Data Integration (IICS – CDI Service) For Google Analytics
- XML generator , XML parser, Java and HTTP transformation within Informatica for realtime transfer of ActiveMQ messages
- Scope and Roadmap for DW ,ETL
- Data Modelling,ETL High Level and Low Level Design
- SQL Server and Oracle(PL/SQL)
- KPIs and Reporting specific calculations
- Developing/Designing ETL Informatica processes/mappings
- Tuning ETL/Informatica mappings/processes
- Best practices for developing ETL jobs
- UNIX Shell Scripting and ETL automation
- Tuning of complex SQL Queries/Processes
- SCD 1, 2 ,3 and Change Data Capture (CDC)
- Resolving production ETL failures
- Optimal performance strategy in Oracle using indexes,joins indexes,partitioning,statistics etc
- Good team player, constant learner, excellent analytical & logical skills
Additional Information
- Sagent - ETL Tool
- SSIS - ETL Tool
- Snowflake - Created snowflake connection, database, table, and loaded data using IICS - CDI Mapping.
- AWS - Created connection, and loaded data into S3 Bucket using IICS - CDI mapping.
- GCP - Created connection, configured BigQuery, and loaded data using IICS - CDI mapping.
Timeline
Sr. Informatica/IICS Developer
Harris Computer Systems
04.2022 - Current
Senior Data Warehouse Engineer
EScholar LLC
04.2007 - 04.2022
Informatica Developer
Merrill Lynch
04.2004 - 04.2007
Application Developer
YourNet
02.2000 - 03.2004
Master of Science - Software System
University of St. Thomas
Bachelor of Science - Network Modeling And Data Simulation
Saint Cloud State University
Similar Profiles
Eric SundayEric Sunday
Cloud Security Analyst at Harris Computer SystemsCloud Security Analyst at Harris Computer Systems
Steven FavalaroSteven Favalaro
Regional Sales Manager at CityView, a division of Harris Computer SystemsRegional Sales Manager at CityView, a division of Harris Computer Systems
Kristin TaylorKristin Taylor
Support Analyst at PrismRBS/Harris Computer SystemsSupport Analyst at PrismRBS/Harris Computer Systems