SUMMARY

• Over 6+ years of experience in years of IT experience in the Requirement Analysis, Data Analysis, Application Design, Application Development, Implementation and Testing of Applications in Data warehousing.
• Good Experience in working with Informatica IICS tool effectively using it for Data Integration and Data Migration from multiple source systems in Azure Sql Data Warehouse.
• Experience working with IICS concepts relating to Data Integration,Monitor,Schedules,Deployments.
• Solid experience in development and design of ETL methodology for supporting data transformations and processing, in a corporate wide ETL Solution using Informatica Power Center(Workflow Manager, workflow Monitor, Source Analyzer, Data Warehousing Designer, Mapping Designer, Mapplet Designer, Transformation developer).
• Good working Knowledge on GCP cloud platform services like Compute,Storage,Networking,Operations, Data Analytics,AI and Machine Learning.
• Experience working with Azure Sql Datawarehouse Integration with IICS and connectors(V2 and V3).
• Experienced with Data Extraction, Transformation and Loading (ETL) from disparate Data Source databases like Oracle, SQL Server, MS Access, flat files, CSV files, SAP and XML files and loaded into target warehouse by using various transformations in Informatica.
• Strong experience in development in BI tool Informatica Power Center, Informatica cloud (IICS) and Informatica Developer(IDQ).
• Worked with wide variety of sources like Relational Databases,Flat Files,XML Files,Unstructured data files.
• Experience in using Oracle, Azure Data Factory, Teradata, Snowflake, SQL, PL/SQL.
• Solid experience in using tools Power BI and Tableau as part of data visualization and data reporting tools.
• Experience in Production Support, extensively worked on production support issues and resolved them using session logs, workflow logs, and used e - mail task for capturing issues via e-mail along with the Session logs.
• Experienced in Debugging and Performance tuning of targets, sources, mappings and sessions and experience in optimizing the Mappings and implementing the complex business rules by creating re-usable transformations and Mapplet.
• Experience in Data analysis, source system analysis, data transformation, data mapping from source to target database schemas and data cleansing, data migration, data domain procedures.
• Experience in Interacting with Business Users to gather Business Requirement Specifications Document and Prepare System Requirement Specifications document.
• Experienced in using IDQ tool for profiling applying rules and develop mappings to move data from source to target system.
• Worked in Informatica mapping/mapplet/workflows/sessions development.
• Good knowledge on using various transformation like Aggregator, Expression, Filter, Update Strategy (Implemented slowly changing dimensions Type1 and Type2), Sequence Generator, Sorter, and Router.
• Proficient in using Informatica workflow manager, workflow monitor, PMCMD (Informatica command line utility) to create, schedule and control workflows, tasks, and sessions.
• Worked in Mappings &Sessions for Extract transform and load the data Using Informatica Power Center Designer, Workflow Manager &Monitor tools.
• Experienced in working with SQL and data warehousing concepts.
• Good understanding of relational database management systems and extensively worked on Data extraction, transformation, loading with Oracle, DB2, Teradata and SQL Server using Informatica.
• Good working experience with Unix shell scripting.
• Data warehousing concepts like Schema, Dimension and Facts.
• Involved in writing scripts using SQL, Teradata as per Business requirements.
• Worked with different data sources like Oracle, Delimited and Excel files.
• Implemented Error Handling Strategies in all dimension loads.
• Optimizing Mappings and Sessions to improve the performance.
• Performed various kinds of tests that include Unit Testing.
• Good working experience in SDLC(Software Development Life Cycle) methodologies like waterfall and Agile.
• Good working experience in different scheduling tools like UC4, control-M, TWS.
• Excellent Interpersonal and Communication skills, efficient time management and organizational skills, ability to handle multiple tasks and work well in a team environment.

TECHNICAL SKILLS

ETL tools: Informatica Power Center, Informatica Developer(IDQ),IICS Informatica Cloud, Azure Data Factory.

Databases: Oracle, Teradata, Netezza, SQL Server.

Data modeling tools: Toad, Oracle Designer, PL/SQL Developer

Operating systems: UNIX, Windows

Languages: SQL, PL/ SQL, JAVA, PYTHON, Unix Shell scripting

Scheduling Tools: Control-M, UC4

Reporting Tools: Power BI, Tableau

PROFESSIONAL EXPERIENCE

Confidential, San Jose, CA

Informatica IICS Developer

Responsibilities:

• Interacted with the data modeler and business users on a regular basis to understand the functional requirements.
• Was Involved and created technical requirements and detail level documents.
• Source data from relational tables and flat files is transformed in the stage layer by applying the business logic.
• Used IICS data integration console to create mapping templates to bring data from staging layer from different sources like oracle,Teradata,salesforce,flat files,Excel.
• Used IICS transformations like Expression,joiner,lookup,filter,normalizer,filter and various macro concepts to templatize column logic,smart match fields,renaming bulk fields and more.
• Experience with PWX concepts including registration maps,logger,condense files.
• Used custom built query to load dimensions and facts in IICS.
• Used FULL push down automation to push data from staging to Ods at scale using data integration templates.
• Experience working with Key Range partitioning in IICS,handling File Loads with File list option.
• Used Informatica features to implement Type 1, Type 2 changes in slowly changing dimensions.
• Prepared user requirement documentation for mapping and additional functionality.
• Involved in creating Repositories, Folders, Versions, and Repository Objects using Repository Manager under the Informatica Power Center.
• Used the mapping operators like sorter, Lookup, aggregator, expression, joiner, filter in the creation of mappings.
• Worked with various Informatica Power Center objects like Mappings, transformations, Mapplet, Workflows and Session Tasks.
• Cleansed the source data, extracted and transformed data with business rules, and built reusable mappings, known as ‘Mapplets’ using Informatica Designer.
• Extensively written SQL and /PLSQL scripts while testing, using update strategy and Expression.
• Create Repository, Users and Groups. Analyze and import the Source definitions. Create target definitions, logical and physical designing of target tables.
• Tested the target data against source system tables by writing the PL/SQL Procedures.
• Responsible for the performance tuning of the ETL process at source level, target level, mapping level and session level.
• Extensively worked with performance tuning at mapping levels like implementing active transformation like filter as early as possible in the mapping.
• Written scripts while migrating to testing and production.
• Deployed the mappings into testing and production environments.
• Created SQL queries, stored procedures, functions, joins.
• Responsible for performance tuning and optimization of SQL queries and indexes.
• Conducted peer design and code reviews and extensive documentation of standards, best practices, and ETL procedures.
• Performed database design by analyzing business requirements.
• Reviewed applications and database design for compliance with best practices standards.

Environment: Informatica PowerCenter 10.0/10.2, IICS, Oracle, Oracle Toad, SQL, UC4, Control-M, Hive, Python, Azure Data Factory, Power BI.

Confidential, Atlanta, GA

Informatica Developer

Responsibilities:

• Collect business requirements from the users/Business Analysts & Converted the Business logic into functional specs with enhancements to get better performance of the system.
• Created and Worked technical requirements and detail level documents.
• Involve in the entire SDLC (Software Development Life Cycle) process that includes implementation, testing, deployment and maintenance.
• Experience working with Key Range partitioning in IICS,handling File Loads with File list option.
• Used FULL push down automation to push data from staging to target databases.
• Experience working with Microsoft ODBC drivers to enable Full PDO while doing loads within sql datawarehouse.
• Experience working with IICS monitoring,administrator concepts.
• Used custom built query to load dimensions and facts in IICS.
• Used IICS transformations like Sorter,Expression,joiner,lookup,filter,normalizer,filter and various macro concepts to templatize column logic,smart match fields,renaming bulk fields and more.
• Used IICS data integration console to create mapping templates to bring data from staging layer from different sources like oracle,Teradata,salesforce,flat files,Excel.
• Experience with PWX concepts including registration maps,logger,condense files.
• Analyzed different data sources like Oracle and Flat files, XML files, Cobol, Text Files, SAP from which movies, sales data, contract and billing data is coming and understand the relationships by analyzing the OLTP Sources and loaded into Oracle data warehouse.
• Performed Oracle Data Warehousing development including data modeling and backend processes, specifically, Extraction, Transformation and Loading (ETL) of data into staging tables and then into Data Marts/Warehouses for presentation.
• Extensively worked on developing Informatica Mappings, Mapplets, Sessions, Workflows and Worklets for the data to target warehouse using Informatica Workflow Manager.
• Mapplets and Reusable Transformations were used to prevent redundancy of transformation usage and maintainability.
• Source data from relational tables and flat files is transformed in the stage layer by applying the business logic.
• Used Informatica features to implement Type 1, Type 2 changes in slowly changing dimensions.
• Prepared user requirement documentation for mapping and additional functionality.
• Involved in creating Repositories, Folders, Versions, and Repository Objects using Repository Manager under the Informatica Power Center.
• Used the mapping operators like sorter, Lookup, aggregator, expression, joiner, filter in the creation of mappings.
• Worked with various Informatica Power Center objects like Mappings, transformations, Mapplet, Workflows and Session Tasks.
• Extensively worked with performance tuning at mapping levels like implementing active transformation like filter as early as possible in the mapping.
• Written scripts while migrating to testing and production.
• Deployed the mappings into testing and production environments.
• Created SQL queries, stored procedures, functions, joins.
• Responsible for performance tuning and optimization of SQL queries and indexes.
• Conducted peer design and code reviews and extensive documentation of standards, best practices, and ETL procedures.
• Performed database design by analyzing business requirements.
• Reviewed applications and database design for compliance with best practices standards.

Environment: Informatica PowerCenter 10.0/10.2, IICS, Oracle, Teradata, SQL, UC4, Control-M, Hive, Python, Azure Data Factory.

Confidential, Highland Falls, NY

Informatica Developer

Responsibilities:

• Worked with Business analysts for requirement gathering, business analysis, and testing and project- coordination.
• Developed number of complex Informatica Mappings, Mapplets, and reusable Transformations to implement the business logic and to load the data incrementally.
• Developed the transformation logic, identifying and tracking the slowly changing dimensions (SCD) Type-1 and Type-2.
• Cleansed the source data, extracted and transformed data with business rules, and built reusable mappings, known as ‘Mapplets’ using Informatica Designer.
• Involved extensively in the mapping development for the data flow using Informatica ETL tool
• Performed an error handling process during the loading process so that if any error occurred then the record will be loaded into the error table for further processing for the data coming from Legacy systems.
• Monitored batches and sessions for weekly and Monthly extracts from various data sources across all platforms to the target database.
• Responsible for migration activities of oracle and Informatica objects from Development to QA environment and worked on data standardizing rules, and matching algorithm changes.
• Developed source to target mapping document for ETL processing and prepared design documents for changes describing impact to Analytical Data Store.
• Involved in creating Shell scripts to automate Pre-Session and Post-Session Processes.
• Provide on-call support to monitor/troubleshoot any ETL failures and database issues.
• Created reusable Transformations and Mapplets to use in multiple mappings.
• Responsible for designing, testing, deploying, and documenting the data quality procedures and their outputs.
• Involved in Code migration from Informatica to Snowflake development.
• Analyzed the Sources, targets, transformed the data, and mapped the data and loaded the data into Snowflake using Queries.
• Developed number of complex Informatica Mappings, Mapplets, and reusable Transformations to implement the business logic and to load the data incrementally.
• Performance tune ETL mappings, Maintenance, enhancements and deployment of ETL code.
• Worked on Stored Procedures handling bulk insert/update logic between staging and target DBs.
• Maintained standard documentation and templates related to development.

Environment: Informatica PowerCenter 10.0/10.2, Informatica Developer, Oracle, Oracle Toad, SQL, UC4, Control-M, Python, Unix Scripting.

Confidential, San Mateo, CA

Informatica Developer

Responsibilities:

• Collect business requirements from the users/Business Analysts & Converted the Business logic into functional specs with enhancements to get better performance of the system.
• Created and Worked technical requirements and detail level documents.
• Involve in the entire SDLC (Software Development Life Cycle) process that includes implementation, testing, deployment and maintenance.
• Used IICS transformations like Sorter,Expression,joiner,lookup,filter,normalizer,filter and various macro concepts to templatize column logic,smart match fields,renaming bulk fields and more.
• Used IICS data integration console to create mapping templates to bring data from staging layer from different sources like oracle,Teradata,salesforce,flat files,Excel.
• Experience with PWX concepts including registration maps,logger,condense files.
• Analyzed different data sources like Oracle and Flat files, XML files, Cobol, Text Files, SAP from which movies, sales data, contract and billing data is coming and understand the relationships by analyzing the OLTP Sources and loaded into Oracle data warehouse.
• Performed Oracle Data Warehousing development including data modeling and backend processes, specifically, Extraction, Transformation and Loading (ETL) of data into staging tables and then into Data Marts/Warehouses for presentation.
• Extensively worked on developing Informatica Mappings, Mapplets, Sessions, Workflows and Worklets for the data to target warehouse using Informatica Workflow Manager.
• Mapplets and Reusable Transformations were used to prevent redundancy of transformation usage and maintainability.
• Implemented and extensively worked on Slowly Changing Dimensions (SCDs, Both Type 1 & Type2 & Type3).
• Configured the sessions using Workflow Manager to have multiple partitions on Source data and to improve performance.
• Used Informatica Debugger, session logs and Toad to resolve problems in a timely manner.
• Experienced in tuning informatica Mappings to identify and remove processing bottlenecks and developed, deployed and monitored informatica mappings into production.
• Coordinate and develop all documentation related to ETL design and development.
• Created Shell scripts to execute/automate the Informatica Workflows, Oracle PL/SQL stored procedures and Packages.
• Troubleshoot problems by checking sessions and error logs also used debugger for complex problem troubleshooting.
• Improve the slow-running reports, Queries, Stored Procedures.
• Used transformations such as the Source Qualifier, Expression, Aggregator, Filter, Lookups, Joiner, Update Strategy and Stored Procedures.

Environment: Informatica Power Center 10.0/10.2, Informatica Developer, Oracle 10g/11g, Toad, PL/SQL, Linux, UNIX Shell Scripting, Excel.