| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
EMAIL AVAILABLESUMMARYIT Professional with 7+ years experience in the Analysis, Design, Development, Testing and Implementation of business application systems for Financial Sectors.Strong experience in Extraction, Transformation and Loading (ETL and ELT) data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Metadata Manager), Power Exchange, Power Connect as ETL tool on Oracle, SQL Server Databases and flat files and dbt(ELT) on Snowflake Data Warehouse.Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, systems integration and user acceptance testing.Good understanding of DataVault modeling principles and methodologies.Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions.Create and execute manual test cases/scenarios, perform tests including functional, integration, and regression performance and create test reports subsequently communicating reports to stakeholders.Create test strategies for manual execution and automation scope in collaboration with team members and business partners to ensure test coverage.Extensively worked preparing test cases during integration of various data sources like Oracle, DB2, SQLServer, Flat Files and Mainframe into Warehouse.Experience with running workflows using Autosys.Do CODE Builds and Deploy using Jenkins and UDeploy in Non Prod regions.TECHNICAL SKILLSDatabase: SQL SERVER 2008 R2/2012/2016, OracleETL Tools: Informatica Power CenterCloud Technologies: Snowflake and dbtLanguages: UNIX, SQL, PL/SQL and SnowSQLOthers: GITHUB, Autosys, Jenkins and UdeployHP QUALITY CENTER and JIRAMainframe: JCL, SEQUENTIAL files.EDUCATIONAL QUALIFICATIONBachelors Degree, Computer Science Engineering, 2009PROJECT EXPERIENCEBank Of America Mar 22 - Mar 24Role: Software Engineer.Responsibilities:Developed ETL programs using Informatica to implement business requirements.Communicated with business customers to discuss the issues and requirements.Loading data into snowflake tables from the internal stage using snowsql.Used SNOWFLAKE FLATTEN table function to produce a lateral view of VARIANT, OBJECT and ARRAY columns.Involved in building the ETL architecture and Source to Target mapping to load data into the Data warehouse.Created mapping documents to outline data flow from sources to targets.Wrote PL/SQL procedures for data migration and validation.Design, develop, and maintain database objects such as tables, views, stored procedures, functions, and triggers using PL/SQL.Involved in Dimensional modeling (Star Schema) of the Data warehouse and used Erwin to design the business process, dimensions and measured facts.Understand the business rules completely based on High Level document specifications and implement the data transformation methodologies.Created SLA documents by coordinating with up/down stream applications.Team player, motivated, able to grasp things quickly with analytical and problem solving skills.Wells Fargo Mar20 Oct21Role: Software Engineer.Responsibilities:Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.Parsed high-level design specification to simple ETL coding and mapping standards.Designed and customized data models for Data warehouse supporting data from multiple sources in real time.Extracted the data from the flat files and other RDBMS databases into the staging area and populated onto the Data warehouse.Maintained stored definitions, transformation rules and targets definitions using Informatica repository Manager.Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.Developed mapping parameters and variables to support SQL override.Created mapplets to use them in different mappings.Developed mappings to load into staging tables and then to Dimensions and Facts.Used existing ETL standards to develop these mappings.Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment, Timer and scheduling of the workflow.Created sessions, configured workflows to extract data from various sources, transformed data, and loaded into data warehouse.Involved in Performance tuning at source, target, mappings, sessions, and system levels.Prepared migration document to move the mappings from development to testing and then to production repositories.Analyze the source data using SQL queries and prepare the test scripts based on requirement.Track the defects/bugs using ALM and JIRA and discuss with the developer team during meetings.Prepared migration document to move the mappings from development to testing and then to production repositories.CITI. Jun16 Feb20Role: Software EngineerResponsibilities:Using Informatica PowerCenter created mappings and mapplets to transform the data according to the business rules.Used various transformations like Filter, Router, Expression, Lookup (connected and unconnected), Aggregator, Sequence Generator, Update Strategy, Joiner, Normalizer, Sorter and Union to develop robust mappings in the Informatica Designer.Implemented slowly changing dimensions (SCD) for some of the Tables as per user requirement.Documented Informatica mappings in Excel spreadsheet.Extracted data from Flat files, DB2, SQL and Oracle to build an Operation Data Source. Applied business logic to load the data into Global Data Warehouse.Maintained source and target mappings, transformation logic and processes to reflect the changing business environment over time.Written documentation to describe program development, logic, coding, testing, changes and corrections.Created a detailed Unit Test Document with all possible Test cases/Scripts.Conducted code reviews developed by my teammates before moving the code into QA.Migrated the code into QA (Testing) and supported QA team and UAT (User).Provided support to develop the entire warehouse architecture and plan the ETL process.Modified existing mappings for enhancements of new business requirements.Works as a fully contributing team member, under broad guidance with independent planning & execution responsibilities. |
