Pavan Kumar Balla
Sr Etl Informatica Cloud Developer @CIBC
Signup · Get unlimited contacts
WORK HISTORY
Sr Etl Informatica Cloud Developer @CIBC
Toronto, ON, CA
Key Deliverables:• Work with IT architect, Program managers in requirement gathering and project coordination.• Work with the ETL development team and design, develop and enhance the ETL process flows to various Integration points based on new project Intakes.• Analyze existing ETL Datawarehouse process and Application Interfaces end to end and create /modify the mappings/sessions/workflows using Informatica PowerCenter based on the design document.• Design, Develop and Implement new Data Integration Platform components/processes using Informatica Intelligent Cloud service (IICS).• Create re-usable transformations and mapplet for file data error handling.• Import the source files using Power exchange and consume them in the mappings.• Create/alter the Database objects (Tables/views/synonyms and stored procedures) and work with DBA to implement the database components.• Understand and adopt an agile software development process.• Support and mentor intermediate and senior developers by sharing knowledge, collaborating and problem solving.• Provide technical direction to the team regarding Informatica best practices that will help the team deliver on time and high-quality deliverables.• Create application design documents for the new Intakes from SRD.• Performed Unit testing and maintained test logs and test cases for all the mappings.• Promote the code to SIT and UAT and provide the support during testing.• Follow the Change ticketing process for code migration from lower region to upper regions.
SKILLS
ABOUT PAVAN KUMAR BALLA
16+ years of Professional experience in IT industry, related to various aspects involving Data Integration and Data Warehousing techniques using ETL Informatica Power Center, Informatica BDM/DEI & Informatica Intelligent Cloud Services (IICS).• Experience Integrating data to/from On-Premise database and cloud-based database solutions with API using Informatica Intelligent Cloud Services (IICS) and Informatica Power Center.• Worked with Relational and Non-relational databases such as Oracle, SQL server, DB2, Teradata, Netezza, Postgres, SharePoint, XML, Json and Flat files.• Experience working with Informatica BDM platform with execution modes Native and Spark to ingest the data from Flat files, Sql server, Teradata & Oracle to AWS S3 buckets, HIVE external tables and NO SQL Mongo DB.• Experience in all phases of Software Development life cycle (Analysis, Requirements, Design Documentation, Development, Testing, and Implementation).• Good understanding and Knowledge on Snowflake, Azure data factory, Azure Synapse and Azure Data Lake store. • Experience in writing, SQL queries, UNIX shell scripts, BTEQ and TPT scripts in Teradata, testing and implementation of tables, views, stored procedures, Functions, Packages, triggers using Oracle PL/SQL.• Worked with different Informatica Performance tuning issues like source, target, mapping, transformations, session optimization issues and fine-tuned transformations to make them more efficient in terms of session performance.• Experience in resolving on-going maintenance issues, bug fixes, monitoring and supporting Informatica workflows and sessions.• Well versed with Star-Schema and Snowflake schemas for designing the Data Marts and DWH and Good understanding in Data Warehouse/Data Mart, ODS, OLTP and OLAP concepts.• Awareness of Kimball and Inmon data warehouse methodologies.• Capable of processing large sets of data like unstructured, structured, and supporting architecture and applications.• Experience working in Agile SCRUM methodology and have used JIRA, Bit bucket, GIT, Jenkins to deploy the codes from one environment to other.• Experience working in diverse multicultural environment with different vendors, onsite/offshore vendor team etc.• Excellent communication skills, self-motivated, positive attitude, ability to work independently and co-operatively in a team.
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.