2 Etl Mappings Jobs

As a Teradata Analyst at our company, you will leverage your 8+ years of experience to handle data analysis, ETL deployment, and Datawarehouse support using tools like Informatica Power center, SQL, Teradata, and Unix. Your primary responsibilities will include applying data analysis techniques, data modeling, and quality assurance methods to establish, modify, or maintain data structures and associated components. You will design, code, test, correct, and document complex programs or processes based on agreed specifications and standards to achieve well-engineered results. In this role, you will design and construct large ETL mappings, packages workflows, and deliver efficient and scalable Data Warehouse solutions in a high data growth environment. Your expertise in technology leadership with hands-on experience in Teradata and Informatica will be crucial. You should also have a strong understanding of data warehousing and ETL concepts, proficient skills in SQL and PL/SQL coding and scripting, and experience in requirement analysis and architecture design. Collaboration with onsite teams for requirement gathering, development, and testing will be part of your responsibilities. Your in-depth knowledge of Agile processes and principles will be beneficial in overseeing team activities related to coding, unit testing, system testing, and defect resolution. Excellent communication, presentation, organizational, and time management skills are essential for this role. In return, we offer a competitive salary and benefits package, a culture focused on talent development with quarterly promotion cycles, company-sponsored higher education, and certifications. You will have the opportunity to work with cutting-edge technologies and participate in employee engagement initiatives like project parties, flexible work hours, Long Service awards, and annual health check-ups. Insurance coverage including group term life, personal accident, and Mediclaim hospitalization for self, spouse, two children, and parents is provided. At our company, we foster a values-driven and people-centric work environment that enables employees to accelerate both professional and personal growth, make a positive impact using the latest technologies, enjoy collaborative innovation, and unlock global opportunities to work and learn with the industry's best. Join us at Persistent to unleash your full potential and be part of an Equal Opportunity Employer that prohibits discrimination and harassment of any kind.,

As an ODI developer you will have multiple responsibilities depending on project type. One type of project may involve migrating existing ETL to Oracle cloud infrastructure. Another type of project might involve building ETL solution on both on-premises and Oracle Cloud. The key responsibilities may involve some or all the areas listed below: Engage with clients to Conduct workshops, understand business requirements and identify business problems to solve with integrations. Lead and build Proof-of-concept to showcase value of ODI vs other platforms socialize solution design and enable knowledge transfer drive train-the trainer sessions to drive adoption of ODI partner with clients to drive outcome and deliver value Collaborate with cross functional teams to understand source applications and how it can be integrated analyze data sets to understand functional and business context create Data Warehousing data model and integration design understand cross functional process such as Record to Report (RTR), Procure to Pay (PTP), Order to Cash (OTC), Acquire to Retire (ATR), Project to Complete (PTC) communicate development status and risks to key stakeholders Lead the team to design, build, test and deploy Support client needs by delivering ODI jobs and frameworks Merge, Customize and Deploy ODI data model as per client business requirements Deliver large/medium DWH programs, demonstrate expert core consulting skills and advanced level of ODI, SQL, PL/SQL knowledge and industry expertise to support delivery to clients Focus on designing, building, and documenting re-usable code artifacts Track, report and optimize ODI jobs performance to meet client SLA Designing and architecting ODI projects including upgrade/migrations to cloud Design and implement security in ODI Identify risks and suggest mitigation plan Ability to lead the team and mentor junior practitioners Produce high-quality code resulting from knowledge of the tool, code peer review, and automated unit test scripts Perform system analysis, follow technical design and work on development activities Participate in design meetings, daily standups, backlog grooming Lead respective tracks in Scrum team meetings, including all Agile and Scrum related activities Reviews and evaluates designs and project activities for compliance with systems design and development guidelines and standards; provides tangible feedback to improve product quality and mitigate failure risk. Develop environment strategy, Build the environment & execute migration plans Validate the environment to meets all security and compliance controls Lead the testing efforts during SIT and UAT by coordinating with functional teams and all stakeholders Contribute to sales pursuits by helping the pursuit team to understand the client request and propose robust solutions Ideally, you should also have Expertise in database development (SQL/ PLSQL) for PL/SQL based applications. Experience in designing and developing Oracle object such as Tables, Views, Indexes, Partitions, Stored Procedures Functions in PL/SQL, Packages, Materialized Views and Analytical functions Working knowledge of GIT or similar source code control system Experience of creating PL/SQL packages, procedures, Functions, Triggers, views, and exception handling for retrieving, manipulating, checking and migrating complex datasets in oracle Experience in SQL tuning and optimization using explain plan and SQL trace files Partitioning and Indexing strategy for optimal performance Good verbal and written communication in English, Strong interpersonal, analytical and problem-solving abilities. Experience of interacting with customers in understanding business requirement documents and translating them into ETL specifications and High- and Low-level design documents. 6+ years ETL Lead / developer experience and a minimum of 3-4 Years experience in Oracle Data Integrator (ODI) Expertise in the Oracle ODI toolset and Oracle PL/SQL, ODI Minimum 2-3 end to end DWH Implementation experience. Should have experience in developing ETL processes - ETL control tables, error logging, auditing, data quality, etc. Should be able to implement reusability, parameterization, workflow design, etc. knowledge of ODI Master and work repository Knowledge of data modelling and ETL design Design and develop complex mappings, Process Flows and ETL scripts Must be well versed and hands-on in using and customizing Knowledge Modules (KM) Setting up topology, building objects in Designer, Monitoring Operator, different type of KMs, Agents etc. Packaging components, database operations like Aggregate pivot, union etc. Using ODI mappings, error handling, automation using ODI, Load plans, Migration of Objects Design and develop complex mappings, Process Flows and ETL scripts Must be well versed and hands-on in using and customizing Knowledge Modules (KM) Experience of performance tuning of mappings Ability to design ETL unit test cases and debug ETL Mappings Expertise in developing Load Plans, Scheduling Jobs Integrate ODI with multiple Source / Target Experience in Data Migration using SQL loader, import/export Consulting Requirements 6-10 years of relevant consulting, industry or technology experience Proven experience assessing clients workloads and technology landscape for Cloud suitability Experience in defining new architectures and ability to drive project from architecture standpoint Ability to quickly establish credibility and trustworthiness with key stakeholders in client organization. Strong problem solving and troubleshooting skills Strong communicator Willingness to travel in case of project requirement Preferred Experience in Oracle BI Apps Exposure to one or more of the following: Python, R or UNIX shell scripting. Location: Mumbai/ Hyderabad/ Bangalore/ Delhi/ Pune/ Kolkata/ Chennai