Pradeep Nair
Markham,Canada
Summary
Dynamic Integration Analyst with extensive experience at TCS, specializing in Informatica and SQL for data warehousing solutions. Proven track record in optimizing ETL processes and mentoring teams, enhancing performance by identifying bottlenecks. Adept at requirements gathering and Agile methodologies, delivering high-quality results under tight deadlines.
Overview
20
20
years of professional experience
Work History
Integration Lead
BMO[TCS]
Toronto, Canada
05.2020 - Current
- Engineered Informatica PowerCenter workflows to streamline data processing tasks.
- Developed robust ETL pipelines using SQL for effective data transformation in Azure SQL Database.
- Automated web service message dispatch to specific targets according to schedule.
- Performed thorough documentation of workflows for reference and quality assurance.
- Collaborated with business users to gather requirements for data solutions.
- Designed mappings and workflows to enhance data transformation efficiency.
- Created documentation for processes, workflows, and standards used in development.
- Deployed developed objects into different environments such as Development, QA, UAT and Production.
- Constructed workflows incorporating notification emails, and rollback procedures for error handling.
- Conducted performance tuning across source, target, mapping, and session levels to resolve bottlenecks.
- Handled various transformations, including source qualifier, aggregator, and lookup, among others.
- Built and managed Data Pipelines and Jobs with Databricks (Delta Live Tables, SQL) and Azure Data Factory to streamline data processing.
- Established tables and views in landing and staging areas per client specifications.
Architect
CPP[TCS]
Toronto, Canada
11.2019 - 04.2020
- Preparing Logical Data Model Diagram.
- Understanding the AS_IS architecture and documenting the key artifacts.
- Engaged in Conceptual Data Model.
- Understanding the business and creating different diagrams based on data domains.
- Involved in interviewing and capturing the needful information for AS_IS.
Senior Developer
FCC[TCS]
Regina, Saskatchewan
10.2016 - 10.2019
- Working with Agile methodology, providing knowledge and mentoring the team members.
- Created the Staging Area and loading raw data to cleanse it there.
- Understanding the business and creating different diagrams based on data domains.
- Developed mappings, sessions and workflows (ETL) for SCD types I and II to meet the above requirements. Tested the data using PowerCenter Data Validation Option.
- Involved in Analysis, Documentation and Testing of workflows.
- Created tables and generated views using them per the business requirement.
- Involved in the creation of Oracle Tables, Views, and Materialized views in all Tiers.
- Kept track of the Sprint progress and providing all the necessary help in areas of testing and modelling. Also tested mappings and sessions using various test cases in the test document.
- Tracked impediments for the stories and interacting with the Analysts/Clients to figure out a resolution.
- Parameterized the mappings and increased its reusability.
- Extensively worked on Pushdown Optimization.
- Used the PL/SQL procedures for Informatica mappings for truncating the data in target tables.
- Worked on complex development involving several transformations.
- Worked on Teradata TPT to load data from Oracle to Teradata.
- Created various profiles using IDQ from existing sources and shared those profiles with business analysts for their analysis on defining business strategies in terms of activities such as assigning matching scores for different criteria etc.
- Provided technical support to resolve production incidents and testing defects arising in ETL jobs.
- Identified problems and formulated alternative solutions.
- Provided QA and UAT support.
- Followed Informatica recommendations, best practices and methodologies.
- Involved in creating tables on landing and staging areas based on the requirements from the clients.
- Deployment of ETL and DB changes to higher environments using Liquibase.
- Analyzed existing Data Model and accommodated changes according to the business requirements.
- Was involved in developing as well as enhancing Cognos Reports.
- Drilled out each of the data flow along with source to target mapping document for the ETL team.
- Create runbooks and documentation essential for production deployment.
- Used Error handling strategy for trapping errors in a mapping and sending errors to an error table.
- Deliverables conform to client standards and meet the specified requirements.
- Worked efficiently even in tight deadlines.
Senior Technical Consultant
CGI
Halifax, Canada
01.2015 - 10.2016
- Worked extensively in developing ETL for supporting data extraction, transformations and loading using Informatica PowerCenter.
- Managed projects to replace existing Oracle PL/SQL processes with Informatica ETL.
- Responsible for mentoring developers and conducting Code Review of Mappings developed by other developers.
- Analyzed and compared PLSQL results with Informatica and fixed broken requirements and existing prod bugs.
- Responsible for best practices like naming conventions, Performance tuning, and Error Handling.
- Responsible for implementing Incremental Loading mappings using Mapping Variables and Parameter Files.
- Responsible for Performance Tuning at the Source level, Target level, Mapping Level and Session Level. Determined the bottlenecks and fixed it with performance tuning.
- Involved in Low Level Design and leading of small projects.
- Worked with Session Logs and Workflow Logs for Error handling.
- Extracted data from various heterogeneous sources like Oracle and Flat Files.
- Responsible for Unit Testing and Integration testing of mappings and workflows.
- Created technical Design Document of the Transform and Load processes.
- Worked closely with QA assisting them in understanding the requirements and validate test scenarios.
- Tufts Health Plan is a leader in healthcare information systems integration and healthcare solutions provides analytics, decision support, process automation and related information technology solutions that help governmental and commercial healthcare payers to improve patient outcomes, enhance market position and reduce costs.
Senior Technical Consultant
Teradata India Pvt. Ltd
Mumbai, India
11.2012 - 12.2014
- Interacted with business teams to have a clear understanding of the requirements.
- Prepared technical requirement specification document.
- Developed Informatica workflows using various transformations.
- Built mapplets to reuse the code.
- Assisted the QA team with System Testing.
- Developed shell scripts to perform sanity checks like data file availability and embedded PMCMD commands for calling sessions/batches.
- Involved in performance tuning of the SQL Queries and Informatica ETL mappings/sessions.
- Worked on MDM UI to create Users and to assign responsibilities.
- Reviewed codes developed by other developers and guided them on best practices.
- Mentored new team members and provided business knowledge to reduce the learning curve.
- Preparing Unit test cases to ensure data quality.
- Troubleshooting issues at the UAT and production end.
- Implementing enhancements for Data warehousing.
- Westpac is one of Australia's big four banks. Vodafone is a mobile telecommunications company and internet service provider that operates the Vodafone brand in Australia.
Team Lead
Essar Information Technology Ltd
Mumbai, India
11.2005 - 08.2012
- Handled integration for SCM related products which includes Demand Manager, Sales and Product Planning, Supply Capacity Planning, Capacity Reservation Planning, Order Promising, Factory Planner and Material Allocator.
- Was responsible for business meeting, conversion of business rules into technical specifications.
- Responsible for analyzing, designing and developing ETL processes using Informatica PowerCenter. Informatica was used as the interface development tool for the conversion and migration between the Legacy and new systems [Oracle].
- Optimized the SQL to improve the performances.
- Created and designed ETL system test cases using SQL.
- Trained the team on Oracle and to conduct training for the end users.
- Developed Slowly Changing Dimension Mappings for Type 2 SCD.
- Worked on Master Data Management (MDM), knowledge of Performance Manager (Reporting Tool) and Data warehousing concepts.
- Worked for error handling and problem fixing in Informatica.
- Handled data integrity issue if any throughout all the modules associated with S&OP.
- Worked with various tasks like Session, E-Mail, Workflows, Worklets, and Command.
- Participated in design and code reviews.
- Involved in performing Informatica Administrative tasks like creating login/passwords, taking backups, registering repositories and restoring the repository.
- Created Workflows/Worklets and scheduled them using workflow manager and Unix.
- Wrote numerous Pre/Post session SQL and Unix Scripts.
- Mentor team members in performance tuning, design, and best practices, functional and technical aspect of the project and ensured the project timelines were met.
- Supported users functional, UAT and during performance testing.
- Essar Steel used S&OP to reach consensus on a single operating plan to which executives of the management team hold themselves accountable and allocate the critical resources of people, equipment, material, time, and money to most effectively satisfy customers in a profitable way.
Education
Masters - Commerce
Mumbai University
04.2004
Skills
- INFORMATICA
- SQL
- DATA WAREHOUSING
- UNIX
- PL/SQL
- ActiveBatch
- Requirements Gathering
- Agile
- Oracle
- Microsoft SQL Server
- SSIS
- ADF
Personal Information
Citizenship: Canada
Timeline
Integration Lead
BMO[TCS]
05.2020 - Current
Architect
CPP[TCS]
11.2019 - 04.2020
Senior Developer
FCC[TCS]
10.2016 - 10.2019
Senior Technical Consultant
CGI
01.2015 - 10.2016
Senior Technical Consultant
Teradata India Pvt. Ltd
11.2012 - 12.2014
Team Lead
Essar Information Technology Ltd
11.2005 - 08.2012
Masters - Commerce
Mumbai University