Informatica Architect Resume
New York, NY
SUMMARY
- Extensive experience in IT industry with good exposure in data modeling, data architect, solution architect, data warehousing & business intelligence concepts and master data management (MDM) concepts.
- Informatica Certified Developer & Informatica Certified Data Quality Specialist
- Strong Knowledge of all phases of Software Development Life Cycle and have worked in large scale projects with incremental deliverables
- Experience in OLTP Modeling (2NF, 3NF) and OLAP Dimensional modeling (Star and Snow Flake) using ERwin (conceptual, logical and physical data models)
- Good experience in Big Data tools - Cloudera Hadoop, Sqoop, Hive, Impala, Spark
- Extensive knowledge in architecture design of Extract, Transform, Load environment using Informatica Power Center
- Experience in implementing the complex business rules by creating Informatica transformations, re-usable transformations (Lookup (Connected and Un-connected), Joiner, Union, Sorter, Aggregator, Rank, Normalizer, Filter, Router and Update Strategy), and developing complex Mappings & Mapplets
- Experience in data quality tools like Informatica Data Quality (IDQ)
- Profiled the data from disparate source systems using Informatica Data Explorer (IDE)
- Imported metadata from different sources such as Relational Databases, Informatica mappings to build data lineage using Informatica Metadata Manager
- Experience in integration of various data sources definitions like SQL Server, Oracle, Sybase MySQL AB, ODBC connectors & Flat Files
- Expertise in debugging and performance tuning of Informatica mappings and sessions & SQL stored procedures
- Experience with relational databases such as Oracle 8i/9i/10g/11g, SQL Server, Sybase, MS Access
- Strong skills in SQL, PL/SQL packages, functions, stored procedures & triggers
- Hands on experience in UNIX shell scripting
- Experience in working with various scheduling tools (Control M scheduler & CA scheduler)
- Team Player; Excellent Interpersonal skills; Ability to work effectively with different stakeholders in a project
TECHNICAL SKILLS
Core Competency: Data modeler, Data architect, ETL solution architect, Master Data Management (MDM) specialist, Business Intelligence (BI) reporting
Operating System: Windows, UNIX
Data warehouse Utilities: Informatica, Informatica Data Quality, Informatica Data Explorer, Informatica Metadata Manager, Oracle Warehouse Builder, Business Objects, Crystal Reports
Databases: Oracle, SQL Server, Sybase, MS Access
Database Tools: Embarcadero Rapid SQL, Embarcadero DBArtisan, TOAD
Big Data Tools: Hadoop, Sqoop, Hive, Impala, Spark
Schedulers: Control M scheduler, CA scheduler
Programming Languages: Visual Basic, ASP, Java Script, VB Script, HTML
Other Tools: MS Office, MS Project Plan, MS Visio, SharePoint
PROFESSIONAL EXPERIENCE
Confidential - Jersey City, NJ
ETL/Big Data Architect
Responsibilities:
- As a lead architect, I led designers and other developers in the team to guide them and help providing right technical solutions to the business.
- Set up the Cloudera platform and various tools (Sqoop, Hive, Impala, Spark).
- Migrated the existing data to the Big Data platform using Sqoop.
- Created Hive tables and Impala metadata to access the data from HDFS.
- Redesigned the existing Informatica ETL mappings & workflows using Spark SQL.
- Lead various business initiatives and BAU functions in the existing data warehouse application.
- Supported the daily/weekly ETL batches in the Production environment
- Prompt in responding to business user queries and changes.
Environment: Informatica, Sybase, Linux, CA Scheduler, Hadoop, Sqoop, Hive, Impala, Spark
Confidential - New York, NY
ETL/Big Data Architect
Responsibilities:
- Performed business analysis, requirements gathering and converted them into technical specifications
- Architected all the ETL data loads coming in from the source system and loading into the data warehouse
- Built a robust client reporting platform that streamlines generation and delivery of client reports for Private Banking Americas clients
- Developed Informatica Sessions & Workflows using Informatica workflow manager
- Optimized the performance of the Informatica mappings by analyzing the session logs and understanding various bottlenecks (source/target/transformations)
- Used Informatica debugging techniques to debug the mappings and used session log files and bad files to trace errors that occur while loading
- Implemented all the data quality rules in Informatica data quality.
- Imported metadata from different sources such as Relational Databases, Informatica mappings to build data lineage using Informatica Metadata Manager
- Involved in Oracle PL/SQL query optimization to reduce the overall run time of stored procedures
- Created UNIX shell scripts to invoke the Informatica workflows & Oracle stored procedures
- Created UNIX shell scripts to file move, file archive & FTP data files to other downstream applications.
- Designed Control M scheduler jobs to invoke the UNIX shell scripts
- Involved in unit testing of various objects (Informatica workflows/Oracle stored procedures/UNIX scripts)
- Migrated large volume of PB data warehouse data to HDFS.
- Developed Spark jobs to transform the data in HDFS
- Supported various testing cycles during the SIT & UAT phases.
- Involved in creation of initial data set up in the Production environment and involved in code migration activities to Production.
- Supported the daily/weekly ETL batches in the Production environment
- Prompt in responding to business user queries and changes.
Environment: Informatica, Informatica Data Quality, Informatica Metadata Manager, Oracle 11g, Rapid SQL, UNIX, Control M Scheduler, Hadoop, Sqoop, Hive, Impala, Spark
Confidential - New York, NY
Informatica Architect
Responsibilities:
- Performed business analysis, requirements gathering and converted them into technical specifications
- Designed the MIS data mart (star schema dimensional modeling) after analyzing various source systems and the final business objects reports
- Architected all the ETL data loads coming in from the source system and loading into the MIS data mart
- Designed all the slowly changing dimensions to hold all the history data in the data mart
- Developed all the ETL data loads in Informatica Power Center to load data from the source data base into various dimensions and facts in the MIS data mart
- Implemented Slowly Changing Dimensions (Type 2) while loading data into dimension tables to hold history
- Created reusable transformations, Mapplets and used them in the mappings and workflows
- Developed Sybase stored procedures to load data into some of the fact tables
- Designed CA scheduler jobs to invoke the UNIX shell scripts
- Involved in unit testing of various objects (Informatica workflows/Sybase stored procedures/UNIX scripts)
- Supported various testing cycles during the SIT & UAT phases.
- Involved in creation of initial data set up in the Production environment and involved in code migration activities to Production.
- Supported the daily/weekly ETL batches in the Production environment
- Prompt in responding to business user queries and changes.
Environment: Informatica, Sybase, DB Artisan, UNIX, CA Scheduler
Confidential - Chicago, IL
Solution Architect
Responsibilities:
- Worked closely with the Business Partners and Source System SMEs to finalize on the data requirements and ETL requirements
- Designed robust customer centric data warehouse to provide single view of customer information across the enterprise
- Profiled the data from various source systems and enriched and augmented the data using various data cleansing and data quality tools and techniques.
- Standardized various address formats and address information and validated the correctness of address against the US postal database and other global address databases
- Standardized various forms of names into a single format
- Seamlessly integrated the application with Informatica data quality tool for addressing the data quality issue and standardizing the data formats.
- Matched common counterparties and legal entities using the third-party tool and assigned an unique legal entity ID for the related counterparties and legal entities
- Integrated the application with the third-party data service provider (D&B) to identify the hierarchy of the legal entity.
- Instrumental in end to end implementation of complex MDM solution.
- Led Business Objects reporting team to implement analytical functionalities like Drill Down, Slice & Dice, Drill Through
Environment: Informatica, Informatica Data Quality, Oracle 10g, Business Objects XI R2, Rapid SQL, UNIX, Control M Scheduler
Confidential - Houston, TX
Lead Developer
Responsibilities:
- Monitor service queue and respond to problem tickets in Remedy.
- Involved in analysis of various problem tickets and identify the root cause of the issue
- Fixed various issues based on the analysis within the stipulated SLA time period
- Attended the weekly status calls with the business to give a precise status on various ongoing activities
- Prepared technical design documents for various small work items (SWI)
- Involved in application effort estimation and managing a team of developers
- Written PL/SQL queries to extensively test the data between source and target applications.
Environment: Oracle 10g, SQL Server, Visual Basic, ASP, Crystal Reports 8.5
Confidential, Melville, NY
Developer
Responsibilities:
- Involved in Analysis of business requirements and preparation of high level design documents (HLD).
- Involved in designing the technical architecture & program specifications of the application
- Developed Web based interfaces and wrappers for backend business objects using HTML, JavaScript, VB script, ASP
- Developed various Oracle stored procedures to handle the business logic
- Designed various MIS reports, commission statement reports, month end reports and year-end reports using Crystal Reports 8.5
- Involved in the system performance load testing.
Environment: Oracle 10g, ASP, VB Script, Java Script, HTML, IIS 5.0, Crystal Reports 8.5