PROFESSIONAL SUMMARY:

• Over 6 plus years of experience in development and coding business requirements in ETL
• Experienced in ETL methodology for supporting Data extraction, Transformations and Loading process in corporate - wide ETL solution using SQL BI Data stage, Informatica Power Center 9.0, experience in testing database applications of RDBMS in Oracle and SQL Server
• Experience in working with Views, Materialized Views, Triggers, Stored Procedures, Functions, SQL Queries, Joins
• Experience in Transformations like Expression, Joiner, Router, Update Strategy, Filter, Lookups, Normalizer, Rank, Sorter, Transaction Control, Aggregator, Sequence Generator, Stored Procedures
• Experience in DML, DDL, string functions, Numeric Functions and Aggregate Functions
• Experience with reporting tools like Power BI, Tableau and worked on visualizing client data
• Executed PL/SQL, SQL queries using TOAD, Oracle SQL Developer to find useful test data to verify various functionalities of the application and done the back- end verification
• Experience in Azure Data Factory to develop pipelines to migrate data from on-premises to Azure cloud
• Attended Databricks seminar as part of migration project requirement
• Strong Knowledge in End-to-End Software Development Life Cycle, Application Development Methodology (ADM) and Agile Methodologies, ER Diagram.
• An effective leader with proven abilities in working with cross cultural teams during the project phase, guiding team members and enabling knowledge sharing among the team.
• Enthusiastic about learning new technologies and able to implement solutions
• Ability to work in a fast-paced environment where continuous innovation is occurring
• Strong problem-solving skills and ability to prioritize conflicting requirements.
• Strong working skillset and experience with Microsoft Excel, Experience with Microsoft Word and Microsoft PowerPoint
• Interest in exploring the various aspects of data analytics or data science
• Ability to multi-task and work independently in a fast-paced environment and act with a sense of urgency
• Passionate about data and been part in Projects to develop and build data sets according to the requirements provided.
• Worked with large data sets and have clear understanding on Architecture.
• Understood process requirements and provided use cases for business, functional & technical requirements
• Interacted with users for requirement gathering, prepared functional specifications and low- level design documents.

TECHNICAL SKILLS:

Tools: Microsoft SQL Server, Microsoft Azure, Azure Data Factory Informatica 9.1, IICS cloud Informatica, Toad, SQLDeveloper, Tableau, Power BILanguages: SQL, Python, PL/SQL

Database: Oracle 11g SQL Server 2005/2008 R2/2012, MySQL 4/5, Oracle 8i/9i (PL/SQL), SQL Developer, SSMS, Toad, SQL Lite, SQL Workbench

Methodologies& Tools: Agile, SCRUM, JIRA

WORK EXPERIENCE:

Confidential, Irving, TX

Senior Data Engineer

Responsibilities:

• Worked on ETL mapping & workflows in IICS informatica cloud.
• Worked on migration project on Azure Data Factory including SSMS.
• Developed Pipelines in Azure Data Factory to load data to cloud storage blocks.
• Coding for workflows and worked with IICS transformations.
• Unit Testing & Resolution of various Bottlenecks came across
• Documenting the business requirements in Confluence and share it with the business stakeholders for review and sign-off.
• Manage the Client Relationship, Service quality, Timeline and Deliverables of the Project
• Create a detailed work plan which identifies and sequences the activities needed to successfully complete the project
• Review the project schedule with senior management and all other staff that will be affected by the project activities; revise the schedule as required
• Determine the objectives and measures upon which the project will be evaluated at its completion
• Identifies bottlenecks in delivery and proposes effective solutions and practices to eradicate the same
• Used ServiceNow and Jira to raise tickets and track current updates.
• Used to handle Microsoft Team calls to discuss data modeling and data reporting implementations.
• Documented and stored requirements in the SharePoint.
• Provide IT and Business Intelligence Solutions to customers for new business requirements
• Extensively used SQL, PL/SQL, Triggers, and Views using IBM DB2.
• Performed integration testing of the modules.
• Involved in peer code reviews.

Confidential

Data Engineer

Responsibilities:

• ETL mapping & workflows as per requirement and design documents
• Sessions, Workflows with respective mappings in Power Center Manager, Designer
• ETL Specifications & ETL Design Documents
• Have worked on end-to-end implementation for Analytics and big data solutions that have provided Data to various business teams by following processes, methodology, technology, appropriate framework to deliver high business growth.
• Have experienced on working with diverse stakeholders across Insurance and Pharmacy different vendor teams to drive innovative solutions that achieve business goals and align with the customer’s long-term vision. Key success factors include a customer-first mindset, proficient project leadership abilities, ability to function in a fast-paced environment requiring multitasking, problem solving skills, translating business requirements into technology solutions, and executing projects.
• Coding for more than 10 workflows, consisting of mappings designed with transformations like Expression, Lookup, Filter,
• Highly complex business requirements analysis, designs, write technical specifications
• Code migration through various environments and verify the migration
• Unit Testing & Resolution of various Bottlenecks came across

Confidential

Data Engineer

Responsibilities:

• Worked on migration project on Azure Data Factory, SSMS
• Teams to create high quality solution Design, developed, test and deploy data integration initiatives.
• Differentsource/targetrelationalsystemslikeMainframeDB2,Oracle11g.Scheduling Informatica runs in production.
• Used to handle Microsoft Team calls to discuss data modeling and data reporting implementations.
• Documented and stored requirements in the SharePoint.
• Tracking, monitoring, and providing guidance and support to the developers / team members during the software development life cycle (SDLC) activities on a regular frequency. My strong technical knowledge is an added advantage for understanding the challenges faced by the team and thus helping them out by providing apt inputs, guidance and support for completing the deliverables.
• Foresee and manage risk and work out a solution to mitigate the problem and align the expectation of the stakeholders for smooth project delivery.
• Business requirement and translated into technical specification
• Production issues and defects to determine root cause and resolution
• Effectively communicated to broad and diverse audience with differing needs.
• Used Jira to raise tickets and track current updates.