SUMMARY

• 8+ years of total IT experience in Analysis, Design, Development, Implementation and Testing of Data Warehouse applications, Client/Server Applications, using Object Oriented Analysis, Design and Methodologies.
• Worked for various client engagements in Healthcare, Telecom and Banking have gained exposure to many phases of the project development.
• Data Profiling, Data Cleansing, Data Standardization, Data De - Duplication using Informatica Data Quality and MDM tools (Web methods One Data).
• Experience in BI projects using Ab Initio, Informatica Power Center 10.1.1/9.6.1/8.6.1 (Repository Manager, Server manager, Mapping Designer, Mapplet Designer, Transformations Designer, Warehouse Designer), MDM and Power Exchange.
• Experience in understanding the data model and implementing it in MDM
• Expertise in hub Match and Merge Rules, Batch Jobs and Batch Groups
• Experience on Implementing hierarchies, relationships types, Packages and profiles for hierarchy management in MDM hub implementation.
• Experience in designing E360, C360, and P360 for end user
• Experience in designing the IDD screen for the end user
• Configured Workflow for IDD and E360 for approval management
• Working experience with SIF SOAP API’s.
• Generation and maintaining of IDQ workflows for defined rules.
• Strong business understanding of consumer direct business model.
• Strong Experience with architecting highly performant databases using postgre sql, MYSql and MySQL access.
• Expertise in Data warehouse/Data mart implementations including project scoping, requirements gathering and dimensional modelling using star and snowflake schema design.
• Experienced in using advanced concepts of Informatica like push down optimization.
• Worked extensively with Data migration, Data Cleansing, ETL Processes and Web reporting.
• Worked with users to review business requirements, functional specifications and creating technical specification documents.
• Understanding process and project specific standards on development and mentoring best practices, Configuration and change management mechanisms.
• Responsible for all activities related to the development, implementation, administration and support of ETL processes for large-scale data warehouses using Power Center and Power Exchange.
• Experience in Informatica Data Quality (IDQ), Data Explorer and Power Exchange.
• Expert in coding SQL, PL/SQL (Stored Procedures, Triggers and Packages).
• Having hands on in writing shell script.
• Experience in databases like Oracle, Snowflake, Teradata and SQL Server.
• Extensively worked on Informatica Metadata.
• Experience in complete life cycle of Analysis, Design, Development, Testing, Maintenance and Documentation of Data Marts.
• Works on loading data into Snowflake DB in the cloud from various sources.
• Hands-on experience in bulk loading and unloading data into Snowflake tables using COPY command.
• Experience in uploading data into AWS-S3 bucket using information amazonS3 plugin
• Experience in using Python programming in data transformation type activities.
• Realtime experience with loading data into AWS cloud, S3 bucket through Informatica.
• Experience in identifying and debugging bottlenecks in targets & sources and tuning Performance of mappings and sessions. Involved in production support.
• Ability to effectively manage time and resources and prioritize tasks in order to consistently complete projects according to specifications and on time.
• Creative problem-solving capabilities, analytical approach and exceptional technical writing skills.
• Excellent communication with good interpersonal and team organizing skills.

TECHNICAL SKILLS

ETL Tools: Informatica Powercenter8.6.1, 9.6.1, 10.1.1, MDM, IICS, E360, C360, IDD, IDQ, Ab InitioOWB

Data Modelling: Erwin, ER/Studio

Databases: Oracle 9i,10g, Snowflake, Teradata, SQL Server

Reporting Tools: BO, OBIEE, QlikView

Versioning Tools: GitHub, SVN tortoise

Operating System: Windows, UNIX

Other Tools & Languages: PL/SQL, SQL, Control - M, DAC, Python, UNIX

Cloud Applications: AWS, Snowflake

PROFESSIONAL EXPERIENCE

Confidential, North Carolina

Informatica Developer

Responsibilities:

• Analyzed the business requirements and functional specification. Worked closely with Data Architects to prepare ETL specification documents. Worked on Dimensional modelling to design and develop STAR schemas using ER-win, Identifying Fact and Dimension Tables.
• Created the High-Level Design and Mapping sheets for the mappings.
• Created detailed ETL Standards documents for Design, Development, Release Management and Production Support.
• Created Informatica mappings using various transformations like Source Qualifier, Expression, Look up, stored procedure, Aggregate, Joiner, Filter and Router.
• Used Snowflake, AWS Cloud and data migration from On-Premises systems into a Snowflake Cloud data warehouse.
• Developed a web service on the postgre database using python flask framework which served as a backbone of the real -time dashboard.
• Created Snow pipe for continuous data load.
• Bulk loading and unloading data into Snowflake tables using COPY command.
• Created DWH, Databases, Schemas, Tables, write SQL queries against Snowflake.
• Extracting and uploading data into AWS S3 buckets using Informatica Aws plugin.
• In-depth no ledge of the postgre SQl architecture, database design and Relational Database Systems.
• Provide estimations for ETL deliverables and oversee the progress for quality ETL Deliverables.

Environment: Informatica 10.1.1, IICS, Veeva Salesforce CRM, Snowflake, AWS

Confidential

Informatica MDM Developer

Responsibilities:

• Involved in Data model discussion with various business units.
• Creating technical specs for various functional specs received from the business.
• Implementing the data model in MDM by creating the BO, and relationship.
• Prepared the Source target mapping and LLD documents as per the business requirement.
• Contributed in developing the mapping for data load from different source to MDM through ETL and IDQ tools.
• Created the match rules at hub level and set the validation rules where required.
• Setting the trust score and applied the cleanse rules on the records
• Designing the IDD screen for customers.
• Working experience on SIF API on Soap.
• Understanding and Debug of user exit in java.
• Involved in training the end user on the IDD screen usage.
• Leading the offshore team and weekly reporting the client on the work progress.
• Trained team members on the MDM fundamentals and hub usage.
• Created MV and Stored procedure to extract data for downstream applications
• Design and configuration of Message queue in Batch process.
• Profiled the data using IDQ to understanding the data for each source
• Developed DQ rule using IDQ tool.

Environment: Informatica 9.6.1, MDM, Oracle, UNIX, Control-M, QlikView

Confidential

Informatica Developer

Responsibilities:

• Communicating with the client to gather the requirements.
• Analysis of the specifications provided according to the requirement.
• Analyzing the ETL specification document.
• Involved in creating the mappings for the warehouse according to the business requirements.
• Developed simple & complex mappings using Informatica to load Dimension & Fact tables.
• Development of Informatica mappings using various transformations such as Source Qualifier, Aggregator, Lookup (connected and unconnected), Update Strategy.
• Extensively used various types of transformations such as Expression, Aggregator, Filter, Joiner, and Update strategy, Lookup (Connected and Unconnected) in mappings to load the data.
• Improved performance of mappings by implementing Push Down Optimization in Mappings.
• Implemented Incremental and Full refreshments.
• Implemented Slowly Changing Dimensions.
• Implementing error handling strategy.
• Worked on making reusable components in Informatica.
• Working on performance tuning of ETLs & SQLs.
• Providing the Technical design approach to the ETL mappings.
• Unit testing & Integration testing and documenting the Test results.
• Code migration to environments.
• Scheduling jobs for the workflows.
• Preparation of ETL Detailed Design documents.

Environment: Informatica 9.6.1, Oracle 10g, UNIX, DAC, OBIEE 11.1.1.5.

Confidential

Informatica Developer

Responsibilities:

• Understanding and analyzing the requirements (ETL specifications).
• Involved in creating the mappings according to the business requirements.
• Creating/Enhancing mapping using Informatica.
• Slowly changing dimension creation.
• Implementing error handling strategy.
• Working on performance tuning of ETLs & SQLs.
• Code migration to environments.
• Scheduling jobs for the workflows.
• Monitoring the Informatica Power Exchange jobs and issue resolution.
• Involved in handling production problem tickets and issue resolution.
• Prepared and reviewed the design documents, mapping specification documents and Migration documents.
• Identifying errors occurring during unit and UAT testing and providing prompt resolution for the same.
• Testing, debugging.
• Supporting ETL test phase (Functional testing).

Environment: Informatica 8.6.1, Informatica Power Exchange 8.6.1, Oracle 10g, UNIX, BO.

Confidential

Informatica Developer

Responsibilities:

• Understanding and analyzing the requirements (ETL specifications).
• Creating documents for design and mapping.
• Creating/Enhancing mappings using Informatica.
• Working on performance tuning of ETLs & SQLs.
• Identifying errors occurring during Unit and UAT testing and providing prompt resolution for the same.
• Testing, debugging.
• Supporting ETL test phase (Functional testing).
• Supporting the production Go-live for one week and regular production support activities.
• Handling daily batch and providing quick resolution for the same.
• Participating in weekly calls with clients coordinating with business Analysts on the production data issues.

Environment: Informatica 8.6.1, Oracle 10g, UNIX

Confidential

Informatica Developer

Responsibilities:

• Involved in creating the mappings according to the business requirements (ETL specifications).
• Developed data Mappings between source systems and Warehouse Components using Mapping Designer.
• Used most of the Transformations such as Source Qualifier, Aggregator, Lookup, Filter, Sequence generator, Router, Update strategy etc.,
• Worked with various active and passive transformations.
• Used Informatica Workflow manger to create Sessions, Workflows to run the mappings.
• Creating documents for design and mapping.
• Working on performance tuning of ETLs & SQLs.
• Identifying errors occurring during conversion and integration and providing prompt resolution for the same.
• Testing, debugging.
• Supporting ETL test phase (Functional testing).

Environment: Informatica 8.6.1, Oracle 10g, UNIX

Confidential

Software Engineer

Responsibilities:

• Involved in Production Support.
• Monitoring the jobs in Control-M and checking the logs.
• Raising IOC same day requests.
• Monitored the jobs for successful completion and resolved the data issues.
• Coordinated closely with on-site team to support the application.
• Timely escalation of the production batch failure issues.
• Analyzing the production data quality issues and resolving the user queries
• Providing the timely production jobs and user tickets status report metrics to management.
• Monitored the load process and took corrective actions on time during failure to ensure the availability of reports to the customers on time.

Environment: Ab Initio, Oracle 9i, UNIX, Control-M.