Aniruddha Samanta Email and Phone Number

Department :- UDMF, BI and BIG DATA.

*********************Current Project*****************************
--- > Currently, I am working as an ETL Developer of Rogers Telecommunications
Inc Canada. ( Client )
--- > Interacted with end users and line managers to gather business requirements and conducted user acceptance.
---> Interacted with third party vendors and identified different external and internal homogeneous and heterogeneous sources and extracted and integrated data from flat files, Oracle, SQL Server sources and migrated those applications to Oracle Exadata platform using INFORMATICA BI tool.
---> Created Informatica Data quality plans according to the business requirements to standardize, cleanse data and validate addresses.
---> Co-ordinate monthly road map releases to push enhanced/new informatica code to production.
---> Wrote various technical documents, including Business Requirements, Functional and Technical Specifications, SDS, SDD,Change Summary Documents, Data Flow and Process diagrams using MS Power Point and MS Word.
---> Developed and maintained ETL (Data Extraction, Transformation and Loading) mappings using Informatica Designer 9.6 to extract the data from multiple source systems that comprise databases like Oracle 10g, SQL Server 7.2, flat files to the Staging area, EDW and then to the Data Marts.
---> Created mappings using different look-ups like connected, unconnected and Dynamic look-up with different caches such as persistent cache.
---> Performed Impact Analysis of the changes done to the existing mappings and provided the feedback.
---> Worked on Informatica Source Analyzer, Mapping Designer, and various Transformations like Source Qualifier, Expression, Router, Aggregator, Filter,
Update Strategy, Joiner, etc.
Environment:- Informatica Power Center 9.6.1, BMC Control M, UNIX, Oracle SQL Developer 10g