11+ ETL management Jobs in Pune | ETL management Job openings in Pune

Your key responsibilities

• Create and maintain optimal data pipeline architecture. Should have experience in building batch/real-time ETL Data Pipelines. Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources
• The individual will be responsible for solution design, integration, data sourcing, transformation, database design and implementation of complex data warehousing solutions.
• Responsible for development, support, maintenance, and implementation of a complex project module
• Provide expertise in area and advanced knowledge of applications programming and ensure application design adheres to the overall architecture blueprint
• Utilize advanced knowledge of system flow and develop standards for coding, testing, debugging, and implementation
• Resolve variety of high impact problems/projects through in-depth evaluation of complex business processes, system processes, and industry standards
• Continually improve ongoing reporting and analysis processes, automating or simplifying self-service support.
• complete reporting solutions.
• Preparation of HLD about architecture of the application and high level design.
• Preparation of LLD about job design, job description and in detail information of the jobs.
• Preparation of Unit Test cases and execution of the same.
• Provide technical guidance and mentoring to application development teams throughout all the phases of the software development life cycle

Skills and attributes for success

• Strong experience in SQL. Proficient in writing performant SQL working with large data volumes. Proficiency in writing and debugging complex SQLs.
• Strong experience in database system Microsoft Azure. Experienced in Azure Data Factory.
• Strong in Data Warehousing concepts. Experience with large-scale data warehousing architecture and data modelling.

• Should have enough experience to work on Power Shell Scripting

• Able to guide the team through the development, testing and implementation stages and review the completed work effectively
• Able to make quick decisions and solve technical problems to provide an efficient environment for project implementation
• Primary owner of delivery, timelines. Review code was written by other engineers.
• Maintain highest levels of development practices including technical design, solution development, systems configuration, test documentation/execution, issue identification and resolution, writing clean, modular and self-sustaining code, with repeatable quality and predictability
• Must have understanding of business intelligence development in the IT industry
• Outstanding written and verbal communication skills
• Should be adept in SDLC process - requirement analysis, time estimation, design, development, testing and maintenance
• Hands-on experience in installing, configuring, operating, and monitoring CI/CD pipeline tools
• Should be able to orchestrate and automate pipeline
• Good to have : Knowledge of distributed systems such as Hadoop, Hive, Spark

To qualify for the role, you must have

• Bachelor's Degree in Computer Science, Economics, Engineering, IT, Mathematics, or related field preferred
• More than 6 years of experience in ETL development projects
• Proven experience in delivering effective technical ETL strategies
• Microsoft Azure project experience
• Technologies: ETL- ADF, SQL, Azure components (must-have), Python (nice to have)

Ideally, you’ll also have

Job description – Oracle Fusion Finance Functional

· As a Senior Oracle Senior Functional Consultant, you willstep into a world of innovation and transformation. You

will collaborate closely with clients, leveraging your deep knowledge of Oracle ERP cross functional development

to craft tailored solutions that optimize financial processes and business operations.

· Picture yourself leading the charge in development of Oracle and other engaged technology solutions, ensuring

seamless integration and customization. You will be the go-to expert for troubleshooting complex cross functional

challenges, all while providing top-notch training and support to clients.

What you'll do:

· Provide subject matter expertise and lead functional tracks on Oracle ERP Cloud Applications for the Financial modules.

· Provide solutions based on accounting principles and rulesfor the financial modules.

· Complete project tasks and deliverables as per established project timelines. Written deliverables should be of the highest quality as per established project templates.

· Engage with clients and lead workshops to define business requirements.

· Conduct gap analysis between delivered functionality and client requirements. Provide solutions to Gaps along with recommended solution for the financial modules.

· Document Gaps, Issues and Solution Process Flows.

· Create RAID items as necessary per direction of the PMO, update the status on RAID items for items assigned and coordinate with the client for timely closure of items.

· Map customer s business process to Oracle Cloud Applications processes

· Configure the modules to align with customer s business processes.

· Migrate customer financial data from Legacy to Oracle Cloud Applications

· Prepare the functional design for all technical objects in customer driven template along with documentation of the test criteria for each technical object.

· Develop testing scenarios and test scripts. C2- Restricted Restricted use

· Lead testing events like unit, integration, and acceptance testing. Tasks include finalizing scenarios with the client, prepping data for testing, providing the schedule for the events, coordination of completion of testing and ensuring accuracy in testing.

· Facilitate knowledge transfer.

· Be available during the working hours and Client communication tools for the project.

· Work and engage with other project team and counterparts of different module leads and technical team for project work

· Lead on cross functionalsolutions i.e. roll mapping, integration, data exchange frequency in coordination with

other modules Functional lead to map the cross functionalsolution.

· Execute the project work based on Client defined project process, project execution methodology and templates.

What We are Looking For:

· 8 to 12 years of experience with Oracle ERP Applications

· Experience with Oracle Financials module: GL, AP, AR, Fixed Assets and Cash Management and Shared HR.

· Experience in 2 to 3 implementations

· Experience with Data migration - Legacy to New system or EBS to Cloud

· Knowledge of P2P, O2C, A2R - how the information is flowing into Finance module.

· Experience with Revenue management and advance collections module are preferred.

· Experience in Business Process Consulting, problem definition, facilitating global design workshops, business

process analysis, providing subject matter guidance.

KEY RESPONSIBILITIES

·      Develop high-quality database solutions.

·      Use T-SQL to develop and implement procedures and functions.

·      Review and interpret ongoing business report requirements.

·      Research required data.

·      Build appropriate and useful reporting deliverables.

·      Analyze existing SQL queries for performance improvements.

·      Suggest new queries.

·      Develop procedures and scripts for data migration.

·      Provide timely scheduled management reporting.

·      Investigate exceptions with regard to asset movements.

MUST-HAVES FOR THIS GIG

T-SQL, Stored Procedure, Functions, Triggers, XML Operations, JSON support on SQL 2016 and above SSIS, SSRS, CTE, EAV Data structure, Integration with NoSQL(MongoDB), SQL Server Indexes, Bulk Insert, BCP, CMD Shell ,Memory Optimization, Performance Tunning, Query Optimization, Database Designing, Table Joins, SQL Server Job agent

Backup and Maintenance plan ,Data Migration, Good Communication

NICE-TO-HAVES FOR THIS GIG:

• Working knowledge of mobile development activity.
• Working knowledge of web hosting solution on IIS7.

Experience working with an offshore –onsite development process 

Profile:

We are a Funded Startup developing a Gamified EdTech Mobile App. We are looking for an experienced Backend Developer (at least 4 years) who has hands-on experience of NodeJS (at least 2 years) and PostgreSQL (at least 2 years). You will be responsible for Defining, Developing and Maintaining all Server-Side Logic, Components, and Database.

Responsibilities: 

• Developing and Maintaining all Server-Side Logic and Components
• Defining and Maintaining all Schemas and Database
• Writing Cron Jobs in NodeJS
• Writing Database Triggers in PostgreSQL
• Testing, Repairing Defects and providing Technical Support.
• Documenting Node.js Processes, Database Schemas, and Preparing Reports
• Collaborating with Frontend Developers and Integrating with Frontend Components

Requirements: 

• Bachelor’s Degree in Computer, Information Technology, or similar
• Hands-on experience as a Backend Developer (at least 4 years)
• Hands-on experience of NodeJS (at least 2 years)
• Hands-on experience of PostgreSQL (at least 2 years)
• Hands-on experience of ExpressJS and Docker
• In-depth knowledge of Database Architecture
• Working knowledge of Multithreading in NodeJS
• Working knowledge of Python and ReactJS
• Basic knowledge of HTML5 and CSS3

Product marketers play a crucial role in positioning products/services the right way to the right people because they have a deep understanding of your target customers and how our products and services fulfil their needs. As a product marketing specialist, you will be on the team responsible for telling the world (and enterprises) the story of our product. You will be expected to be an avid advocate for our product feature set and its benefits. We’re looking for a passionate, go-getter who will have the opportunity to make a big impact on a tightly knit team that is building enterprise software. 

This could be an excellent opportunity to take your career to the next level and learn a lot more along the way, hopefully you’ll teach us a few things too!

• You will be required to create product content (e.g. sales enablement documentation, case studies, product videos, website copy, blog posts, Quora/forum responses) to articulate the benefits of our products to the world.
• Work on thetactical campaign execution. Daily hands-on work will include email builds/sends, landing pages, dynamic content, A/B tests, list imports, and database management.
• You will also set up, test, maintain, and report on recurring and triggered campaigns. Improve initiatives around lead targeting, A/B testing, and deliverability.
• You may be required to manage the company’s social media profiles and presence, including Facebook, Twitter, LinkedIn, and additional channels that may be deemed relevant.
• You will be expected to build product page content, optimize the conversion paths on those pages, and use dynamic call-to-action to create and test buyer stage-specific calls-to-action.
• Manage both on-page SEO and off-page SEO for the company.
• Collaborate with content marketing and blog contributors to create high-quality content around important, relevant terms.
• Manage and improve organic search engine performance and goal-setting based on clickthrough rates, traffic, and conversions. Track lead generation activities.

·       Primarily responsible for working on various service requests related to maintaining database security (roles, privileges, authentication), creating schema and copying data

·       Work on installation, configuration, creation and administration of HP Vertica database clusters and AWS RDS MySQL database.

·       Work with platform, product and other support teams to participate in release and change management processes to implement new features/functions as well support mandatory patches or upgrade activities on weekends.

·       Responsible for database performance tuning, query tuning and database operations including migration and upgrade.

·       Plan and implement periodic upgrades of database schema and perform testing and verification of released database schema upgrades.

·       Configure and manage database backup and restore, participate in Disaster Recovery

·       Create and maintain documentation, procedures and best practice guides for database deployment and maintenance.