Data Informatica

Location:

Posted:

April 02, 2020

Resume:

SUMMARY:

Over **+ years of IT Experience as Informatica Certified Integration Analyst, Informatica Data Quality(IDQ) and AWS certified Cloud Practitioner. Experience in Requirement Analysis, Requirement gathering, Functional Analysis, System Design, Process flow, Workflow Design, Use Case and Test Case Analysis, Software Development Life Cycle (SDLC), System Testing, Agile methodology, Bug fixing, Application Production support, Documentation, Implementation, Production Support, Maintenance and Integration of various warehouse’s

Primary Skills:

ETL/BI - Informatica Powercentre/Informatica,Developer(IDQ)/Informatica Cloud Services

(ICS)/Informatica BigDataManagement (BDM), Micro Strategy, Informatica

Enterprise data catalog(EDC), MDM

Languages - Unix Shell Scripting, Python

Database - SQL Server/Oracle/DB2/PL-SQL, SNOWFLAKE and AWS Athena

Data Modelling - Erwin/Microsoft Visio/Lucid chart

AWS - S3/EC2/CloudWatch/Lambda/RDS/VPC/CFT

Scheduler - Control-M/IBM Maestro Tivoli/Redwood

Big Data - HDFS, Hive and SCOOP

Secondary Skills:

IBM Mainframe - COBOL/JCL/VSAM/MVS-OS/IBM DB2/IMS DB-DC/Expediter/File-Aid

Certifications: - Informatica Powercentre Data Integration 10X specialist

Informatica Powercentre Data Integration 9X specialist

AWS Certified cloud practitioner

EDUCATION: Bachelor of Science, Major in Computer Science and Engineering, Bangalore University, India.

Experienced in Star-Schema and Snow-Flake data modeling, Normalization, Data Cleansing, Logical & Physical data model, Multi-Dimensional Data modeling using Erwin.

Exclusively worked on Informatica Cloud Services (ICS) to integrate data from Salesforce

Hands on expertize in analyzing relational database environment using SQL, PL/SQL, DB2, Stored Procedures.

Exclusively worked on Support project with SNOW as ITIL creating Incidents, change requests, Problem tickets and following up to their resolution being primary support person for entire DWH application.

Excellent knowledge in Agile methodology of project execution (Sprint planning, Creating and updating tasks in Kanban, Sprint retrospective meetings etc)

Worked exclusively on Informatica (IDQ) for data profiling, data cleansing and data visualization.

Very strong in implementation of data profiling, creating score cards, Creating reference tables and documenting Data Quality metrics/dimensions like Accuracy, completeness, duplication, validity, consistency.

Holds basic know knowledge on informatica Enterprise Data catalog(EDC).

Experienced in designing complex business rules through Informatica transformations, Workflows/Worklets, Mappings/Mapplets, Test Plans, Test Strategies and Test Cases for Data Warehousing projects.

Experienced in job scheduling using Informatica Scheduler, Control-M and IBM Tivoli Workload Scheduler

Exclusively worked on AWS stack (EC2, S3, RDS, CloudWatch, Lambda etc)

Experience in Online and Batch Mainframe environments and production supports for both.

Experience in working on Banking, Automobile, Insurance, Medical, Retail and Telecom domains.

Received appreciations from management for proactive learning of new tools and technologies and achieving certifications on Informatica and AWS.

Quick learner and adaptive to new environments.

PROFESSIONAL EXPERIENCE:

Company : Toyota, Plano, TX, USA (Nov/2019 – Till Date)

Position : Sr ETL Consultant

Environment : Informatica PowerCenter 10.1.1, Unix, Oracle, Flat Files, XML Files, SQL, Redwood Scheduler, Putty and File Transfer, SNOW, Shell Scripting.

Responsibilities:

Analyzing existing informatica data mappings/workflows and end to end business process for different loads.

Analyzing source and target systems and end to end ETL batch process.

Addressing Jira tickets assigned for application defects or enhancements on timely manner.

Liaison between offshore and client for tasks assigned and representing daily standup.

Addressing daily testing requests from upstream and downstream teams during testing phase and also communicating with external teams to ensure the arrival of files transferred as expecting.

Exclusively worked on creating new and updating existing shell scripts for transferring incoming and outgoing files.

Exclusively worked on creating new or enhancing Informatica PowerCenter mappings, Sessions, workflows and Redwood scheduler jobs.

Production batch run monitoring on weekly basis and addressing production issues if any on timely manner.

Involved in creation of code promotion packages from Dev to SIT and SIT to UAT and UAT to PROD.

Co-ordinating with different admin teams like DBA, Informatica and Unix to plan for code promotion. Also involved in evaluation of code after promotion to respective environments to ensure changes are promoted correctly.

Performance tuning on existing Informatica mappings for different types of source and Targets.

Conducting weekly Changes handover meetings with build team and reviewing support artifacts like Deployment document, Job details and Project business process.

Company : Neiman Marcus, Irving, TX, USA (Dec/2018 – NOV/2019)

Position : ETL Lead Analyst

Environment : Informatica PowerCenter 10.1.1, Amazon Cloud Services, Oracle, Flat Files, SQL, Unix, Control-M, Putty and File Transfer, SNOW, Shell Scripting, SNOWFLAKE

Responsibilities:

Application support lead with a team of 6 members involved in day to day support activities including creation of support Incidents, Problem tickets, change requests and attending approval meetings conduction P1/P2 triage meetings for high priority problem resolutions.

Interacting with Business teams, Testing teams and Deployment teams for ongoing change requests.

Analyzing existing informatica data mappings/workflows and end to end business process for different loads.

Analyzing source and target systems and end to end ETL batch process.

Conducting weekly Changes handover meetings with build team and reviewing support artifacts like Deployment document, Job details and Project business process.

Proactively responding to Production incidents and change requests in SNOW to ensure SLA is not breached.

Attending weekly Department/unit Change request and Problem resolution meeting and communicating the status of tasks actively working on.

Job tracking and code analysis for any ongoing job failures and finding the root cause.

System impact analysis for all new integrations to the existing system and offshore onsite co-ordination.

Conducting daily offshore calls to address priority change requests status and providing clarifications.

Debugging existing informatica mappings and workflows upon production failures and conducting root cause analysis.

Conducting code review and test results review for ongoing development done by offshore teams.

Creating SNOW tickets for incidents, Change requests as per existing ticketing process.

Company : Gensquared Inc, Toronto ON, Canada (Nov/2017 – Nov/2018)

Position : Sr ETL Data Analyst

Environment : Informatica PowerCenter 10.1.1, Informatica Developer 10.1.1, Informatica Cloud Services (ICS), Amazon Cloud Services, SQL Server 2012, Flat Files, SQL, MS SQL server Management studio 11.0, Shell Scripting, Informatica Scheduler, Putty and File Transfer, Erwin Data Modeler4.0, Python scripting, Lucid chart etc.

Responsibilities:

Business requirement analysis and Requirement documents creation.

Involved in Data Model designs for multiple projects from different business areas (Medical, Retail).

Data Integration Architecture document preparation which includes all sources and types of loads.

Informatica Mappings/mapplets/Sessions/Workflows development in Informatica Powercentre and Informatica Developer Data integration tools.

Exclusively worked on Informatica Cloud Services (ICS) to create Data integration tasks.

Worked on HTTP/Web Services transformation to communicate with web-based applications/services

Python/Unix scripting for file management and File transfer scripts.

Designed POC to load data into HDFS using Informatica Big Data Management tool.

Established and Executed Hive Queries to query data from HDFS.

Exclusively worked on Data Quality tool for data cleansing and creating Data Quality rules and reporting the Data quality reports to business users through Informatica Analyst tools.

Have good skills on understanding and development of business rules for its Standardization, Cleanse and Validation of data in various formats.

Performed Unit testing, Integration testing and User Acceptance testing in different environments.

Analyzing Complex join queries, table creation scripts and indexes in Sql server database.

Exclusively worked on Debugging and performance tuning of Informatica mappings and parameterization using mapping and workflow variables.

Using Informatica Developer Tool, created Sources to Targets mappings for Data cleansing, validating, integrating and matching.

Exclusively worked on AWS Athena tables creation and establishing ODBC connection to Athena from Informatica.

AWS EC2 instances creation, CloudWatch Monitoring and Lambda functions creation to start/stop EC2 instances.

Debugging session logs and identifying root cause for ongoing issues and resolving them.

Code promotion to TEST and PROD environments and post production support.

Company : CIBC (Canadian Imperial Bank of Commerce), Toronto ON, Canada (Mar/2017 – Aug/2017)

Position : ETL Data Analyst (Consultant)

Environment : Informatica PowerCenter 9.5, SQL Server 2012, Flat Files, SQL, Shell Scripting, Autosys, Tectia client and File Transfer, Erwin Data Modeler4.0 and MS SQL server management studio

Responsibilities:

Built the Enterprise Data Management Ecosystem for Data transfer to third party system (ICM). This includes contributing to the architectural design for the Enterprise Data Warehouse that address the business requirements, including data modeling, data flows, metadata development, and ETL development

Provide architectural oversight and end to end solution design right from scratch to fulfill the business requirement

Development of a robust data profiling/data quality program to ensure the accuracy of the data in the new Enterprise Data Management Ecosystem

Mentoring existing team at all phases from development to Delivery on Informatica PowerCenter ETL tool.

Data Modelling for all Database objects in the solution using Erwin Data modeler tool.

Preparing project artifacts like Design, System Interface, Architecture, Process and Date agreement documents.

Data cleansing and profiling of all data discrepancies from the data pulled from source systems.

Review and agree on requirements and designs with relevant business owners

Assist and coordinate user testing, ensuring issues are resolved in a pragmatic and appropriate manner

Provide technical support for projects and existing systems in cooperation with other team members including issue identification, log review, job flow dependencies and resolution. Client support for on call, after hours, weekends, and public holidays when required

Consult with various solution architects across multiple technology groups in order to design and implement a robust end to end solution. Execute the bank-wide data governance framework. Implement proof-of-concept prototypes

Develop and unit tested mappings, Sessions and Workflows with sources like relational tables and Flat files. Developed Relational table definitions, views and write complex override SQL’s. Implemented CDC, SCD1, SCD2, incremental load, Snapshot and transactional fact tables, headers and footers to Flat File, File list.

Promote Code to SIT and Production using ICEM code management tool.

Subject Matter Expert (SME) in the team for Informatica Power Center 9.1 for reading VSAM/COBOL sources.

Work in Agile Methodology Environment for projects with multiple sprints.

Developed Unix Schell scripts to validate all the incoming flat files from source systems and business.

Debug Informatica jobs for complex mappings and data flows.

Conduct and proactively participate in Defect/Change request triage meetings on daily and weekly basis.

Resolve Priority tickets as P1/P2/P3. Use HP ALM to update the status of ongoing defects

Company : Scotia Bank, Toronto ON, Canada (May/2016 – Dec/2016)

Position : Sr DWH Consultant (Consultant)

Environment : Informatica PowerCenter 9.6, DB2, Flat Files, SQL, Shell Scripting, TWS Maestro, WinSCP Universal SQL Developer and ICem (IC environment manager)

Responsibilities:

Built the Enterprise Data Management Ecosystem for Campaign Management Data. This includes contributing to the architectural design for the Enterprise Data Warehouse and Data Marts that address the business requirements, including data modeling, data lineage, data flows, metadata development, and ETL development

Provide architectural oversight and monitoring of the technical implementation offshore team’s work to ensure adherence to enterprise architectural standards, as well as compliance with business requirements, IT policies and procedures, and regulatory requirements

Identify areas of architectural risks and provide recommendations to mitigate risks

Identify areas of potential improvement and provide solutions for the Enterprise Data Management process

Synthesizes, aggregates, and validates data from disparate sources to create reporting key metrics

Troubleshooting and identifying data discrepancies between data sources, including interpretation and validation of specialized campaign data

Review and agree on requirements and designs with relevant business owners

Assist and coordinate user testing, ensuring issues are resolved in a pragmatic and appropriate manner.

Promote Code to SIT and Production using ICEM code management tool.

Subject Matter Expert (SME) in the team for Informatica Power Center 9.1 for reading VSAM/COBOL sources.

Work in Agile Methodology Environment for projects with multiple sprints.

Developed Maestro Schedules and Jobs for running Unix, Informatica and Db2 load jobs. Debug Informatica jobs for complex mappings and data flows.

Conduct and proactively participate in Defect/Change request triage meetings on daily and weekly basis.

Resolve Priority tickets as P1/P2/P3. Use HP ALM to update the status of ongoing defects

Responsible for project deliverables to be documented thoroughly like Recovery specifications, Project Change Request Form(PCRF), Promotion worksheet etc.

Company : Rogers Communications, Brampton ON, Canada (Oct/2015 – March/2016)

Position : Sr DWH Consultant (Consultant)

Environment : Informatica PowerCenter 9.5.1, Oracle 11g, Oracle Exadata (Real Application Clusters), Flat Files, XML Files, TOAD, SQL, PL/SQL, Shell Scripting, BMC Control-M, Oracle Golden Gate, WinSCP and SQL Developer.

Responsibilities:

Analysis of existing Legacy ODS for Migration into new Environment.

Evaluated client’s new design changes and suggested few corrections for better quality and performance.

Leading and coordinating offshore team and providing clarifications.

Identifying and extracting data from varied sources, applying business rules and loading them to target Data Marts using Informatica Power Center 9.1 ETL solution environment.

Developed Complex Mappings in Informatica using Power Center transformations (Source Qualifier, Joiner, Lookups, Filter, Router, Aggregator, Expression, XML and Sequence generator transformations), Mapping Parameters/Variables, Parameter files, SQL overrides, Transformation Language.

Developed shell scripts for File copy and database table purge etc.

Migration of database objects from Oracle to Oracle Exadata under Real Application server (RAC) environment.

Data Quality checks for source files using Control Frame Work (CFW) and Mapplets.

Designed and developed stored procedures for table truncation before loading.

Implemented CDC, SCD1, SCD2 dimension tables, incremental load, Snapshot and transactional fact tables, headers and footers to Flat File, File list.

Scheduled the Workflows to run on a daily, weekly and Monthly basis using Control-M Scheduling tool.

Prepared QA and Production implementation documents for multiple releases.

Involved in Design pattern discussions for new environment and client meetings.

Performed Unit testing for developed ETL mappings before deploying to QA.

Interacting with Data base DBA’s and Informatica Admin’s and conducted business meetings for implementation.

Documenting mapping specifications, STM, Unit Test cases, procedure and results.

Company : Ford of Canada, Oakville, ON, Canada (April/2014 – Sep/2015)

Position : DWH Consultant (Consultant)

Environment : Informatica PowerCenter 9.5/9.1, Oracle 11g, Flat Files, COBOL Files, Erwin, Control-M, SQL, PL/SQL, Shell Scripting,

Responsibilities :

Worked with Stakeholders regarding business requirements, functional specifications and enhancements, based on the business needs created technical design and functional specification documents.

Active participation in weekly calls with data modeling and analyst teams to understand and work on any new requirements.

Analyzing data from source systems to design the solution for the business requirement.

Developed Complex Mappings in Informatica using Power Center transformations (Source Qualifier, Joiner, Lookups, Filter, Router, Aggregator, Expression, XML Update and Sequence generator transformations), Mapping Parameters/Variables, Parameter files, SQL overrides, Transformation Language.

Data profiling the source files and developing data model and mappings for smaller requirements.

Implemented CDC, SCD2, SCD1 Delta load, Snapshot and transactional fact tables, headers and footers to Flat File, File list.

Developed Unix scripts for SFTP file transfers and Target table truncate operations.

Implemented partitioning at database level for better performance.

Scheduled the Workflows to run on a daily and weekly basis using Control-M Scheduling tool.

Provided support to the QA team for various testing phases of ETL development.

Involved in unit testing and Unit test plan document preparation.

Documenting mapping specifications, STM, Unit Test cases, procedure and results.

Implemented Push Down Optimization (PDO) for better performance when source data is huge.

Company: Tech Mahindra, Toronto, Canada (Feb/2010 – Mar/2014)

Position: Sr Software Developer

Environment: Informatica PowerCenter 9.1, Flat files, COBOL files, Oracle 11gR2, PL/SQL, Erwin, Toad, UNIX, SQL * Loader, PL/SQL, Control-M, JCL, COBOL, MVS, VSAM and SPUFI.

Responsibilities:

Analysis of data in source systems for solution design document of the business requirement.

Designed functional documents and Technical design documents according to business needs for ODS.

Prepared DDL’s for creating new tables and adding new metadata columns as per the design specification.

Implemented database partitioning by HASH and RANGE.

Extensively worked with Data Analyst and Data Modeler to design and to understand the structures of Fact and Dimension tables.

Data profiling and data quality checks using Informatica Data Quality (IDQ).

Created business rules in Informatica Developer and imported them to Informatica power center to load the standardized and good format of data to staging tables.

Exclusively worked on Unix shell scripting for various operations on files.

Created Data quality transformations using IDQ for data quality checks and data conversions.

Prepared Source to Target Mapping documents for the new mappings developed and updated existing.

Developed complex Mappings using Informatica transformations and also developed Reusable Transformations and Mapplets to load OLTP data into OLAP system by using multiple mappings.

Determined bottlenecks at various points like Targets, Sources, Mappings, Sessions and Optimized the Performance which led to better session performance and achieving high response time.

Created target tables in Oracle and Workflows in Informatica to populate the data according to requirements.

Scheduled the Workflows to run on a daily and weekly basis using Control-M scheduling tool.

Performed system integration testing (SIT) and was involved in user acceptance testing (UAT) to ensure business and technical requirements are met and documented the results.

Involved in the documentation of Source to Target mapping, mapping design and implementation steps.

Company: Bank of America (BACI), Hyderabad, India Jun/2009 – Feb/2010

Position: Mainframe QA

Environment: OS/MVS, JCL, COBOL, DB2, Xpeditor, Endevor, File Aid, Sync Sort

Bank of America Borrowers Protection Plan is an optional feature to safeguard borrower and his family from sudden income losses due to any unexpected events. Disability, Involuntary Unemployment, Hospitalization, Loss of Life, Family Leave and Accidental death are the protection types available in BPP. BPP is not an insurance, It is an optional debit cancellation feature offered to mortgage customers. Customer can protect either one or two borrowers. During the first twelve months there is no cost for single protection. Joint protection is offered at discount rate. After the no cost period, the monthly fee for BPP is calculated as percentage of the monthly principal and interest and is collected as a part of monthly mortgage payment. The protection will be cancelled when the loan is 90 days delinquent, paid in full, refinanced or at the customer’s request.

Responsibilities:

Involved in system analysis and impact analysis.

Involved in low level design document preparation.

Prepared project related documents.

Performed offshore and onsite co-ordination.

Executed JCL procedures and Jobs to test Cobol programs in MVS environment

Performed QAT and test result reviews

Wrote scripts in Quality Centre and executed them.

Attending Project and QA meetings.

Company: Tech Mahindra, Toronto, Canada (Jun/2006 – May/2009)

Position: Mainframe Developer

Environment: OS/MVS, JCL, COBOL, DB2, IMS DC, IMS DB, Xpeditor, Endevor, File Aid, Sync Sort

Responsibilities:

Analysis of Design (EDD/GDD) documents.

Involved in clarification meetings with Business team.

Involved in changing IMS DC screen to include a filed as per the requirement.

Involved in code changes to COBOL and Db2 programs as per requirement.

Extensively worked on Unit test data preparation and Unit testing.

Impacted element Retrieval from production and Promotion to IST and UAT through Version control tool Endevor.

Coordinated with IST and UAT teams during their test process.

Executed Mail boxes for code promotion to Production.

Post production support and Plog evaluation and execution.

Company: Visual Soft Technologies, Hyderabad, India (Jun/2004 – May/2006)

Position: Mainframe Developer

Environment : OS/390, JCL, COBOL, DB2, VSAM, Xpeditor, Endevor, File Aid

Responsibilities:

Prepared low level design documents from high level design documents,

Developed programs and changed existing programs in the system to handle and pass the new information to downstream systems.

Coordinated between other applications groups for end to end testing

Developed COBOL programs, DB2 programs and JCLs

Involved in Unit, Integration and User Acceptance testing,

Involved in Peer Reviews and in production parallel testing,

Prepared documentation and knowledge repository,

Proactively identified and resolved issues at implementation,

References can be provided upon request

Contact this candidate