3 Normalizer Jobs

Required Qualifications: 3-5 years of production support experience on Informatica/Python/AWS Technologies and applications. Must have good understanding and technical knowledge on Informatica architecture/client components such as Workflow Manager, Mapping Designer, workflow monitor and Repo manager. Excellent knowledge on AWS/Python concepts. Informatica to Cloud Migration. Hands-on expertise in debugging Informatica ETL Mapping to narrow down the Issue. Hands-on experience in ETL transformation such as lookup/joiners/source qualifier/normalizer. Hands-on experience in dealing with various types of sources such as Flat files/Mainframes/XML files and Databases. Experience on AWS environment, Data Pipelines, RDS, Reporting tools. Hands-on experience in Unix scripting/file operations. Strong knowledge of SQL/PL-SQL and oracle Databases. Able to debug complex queries. Good understanding on scheduling tool such as TWS/TIDAL/Others Worked at least 2 years on ServiceNow for application incident management, problem management in a 24*7 model. Strong communication skills both written and verbal with the ability to follow the processes Preferred qualifications: Experience working with US Clients and Business partners. Exposure to BFSI domain is a good to have. Experience in mainframe technologies will be plus. Job responsibilities: Provide production support for Informatica/Python/AWS suit of applications in 24X7 environment. Good understanding of Informatica/Python and AWS environment and able to handle batch recoveries and provide batch support. Assess & recommend solutions for permanent fixes to improve application stability and resiliency. Ability to handle production incident bridge calls for P1 and high priority P2 incidents Strong analytical capability to do independent ticket analysis and resolution. Incident Management/Problem management and Change management. Ability to do the Root cause analysis, recap the issues and problem in an email and communicate to all stakeholders and cross commit teams. Ability to drive production issues bridges and able to work across the teams to collate the impacts and send leadership communications. Propose solutions to perform complex troubleshooting. Should be able to identify the areas of improvement and re-engineering scope. Helping other team members to resolve their technical issues. Mentoring the interns and new joiners. Monitor and report issues and work with the required team/vendor for quick resolution

Back Sr Data Engineer JOB_DESCRIPTION.SHARE.HTML CAROUSEL_PARAGRAPH JOB_DESCRIPTION.SHARE.HTML Uttar Pradesh, India Data Science & Business Intelligence Corporate Remote 48831 McGraw Hill LLC. mail_outline Get future jobs matching this search or Overview Job Description Build the Future At McGraw Hill we create best-in-class, next-generation learning platforms that are used by millions of students and educators worldwide from kindergarten through graduate school. Our goal is to accelerate student success through intuitive and effective learning tools and content that maximize a teacher’s time and a student’s learning experience. Our engineering team drive progress and help build the future of learning. If you have the passion and technical expertise to thrive in an innovative and agile environment, we want to learn more about you. What is this role about? McGraw-Hill Education, the leading provider of digital and print educational materials is looking for a Senior Data Engineer for our Data Analytics Group. The Senior Data Engineer in Data and Analytics is responsible for enhancing McGraw-Hill Education’s (MHE) business intelligence and data services capabilities, ensuring the delivery of actionable and timely insights to support financial, product, customer, user, and third-party data. This role also involves managing and monitoring the performance of the Data Platform, ensuring efficiency and reliability with hands-on data engineering, designing and architecting dynamic reporting, analytics, and modeling solutions to drive success in the education domain. The ideal candidate will have a strong data engineering background, with expertise in Oracle Cloud Infrastructure (OCI) with Exadata, Informatica Intelligent Cloud Services (IICS) and/or Databricks, AWS, with tht advanced proficiency in SQL queries. Additionally, this role requires close collaboration with stakeholders to ensure the successful delivery of projects. What You Will Be Doing Senior Data Engineer must have prior hands-on experience developing and delivering data solution with AWS and/Or Oracle technologies. Strong knowledge working with data from financial and operational systems, such as Oracle ERP Sales, Oracle DB and data modelling architecture with slow changing dimension (SCD). Experience in running cloud platform with optimized solution architecture with the ability to meet the daily runbook SLA. Strong experience with version control software like GIT and project management software like Jira with Agile/Kanban. Strong experience with Data Modelling concepts and Modern data architecture including cloud technologies. Ability to translate business requirements into technical requirements and deliveries. Design and develop parallel processing ETL solutions for optimal resource usage and faster processing. Understand ETL specification documents for mapping requirements and create mappings using transformations such as the Aggregator, Lookup, Router, Joiner, Union, Sorter, Normalizer and Update Strategy. Create UNIX shell scripts as Informatica workflow wrapper and perform housekeeping activities like cleanup and archive files. Experience in technical specification design - Proven experience in designing and building integrations supporting standard data modelling objects (Fact dimensions, aggregations, star schema, etc.) Ability to provide end-to-end technical guidance on the software development life cycle (requirements through implementation). Ability to create high quality solution design documentation for end-to-end solutions What You Need To Be Considered Expertise in Data warehousing and modern data lake concepts. 5+ years of experience in Data Engineering using tools such as:Informatica/IICS, Oracle DB and Oracle packages. AWS services. Data platforms like Athena with iceberg, lambda, EMR, and glue, Data bricks. Scripting languages like Python, Scala, Java or node. 1+ years of experience in Unix shell scripting 3+ years of experience working with Cloud like OCI, AWS, and Azure on Data technologies. Preferred Experience with Publication and Education domain. Prior experience or familiarity with Tableau/Alteryx. Experience working with financial data like sales, revenue, cogs and manufacturing etc. Experience with IBM planning Analytics (TM1). Why work for us? At McGraw Hill, you will be empowered to make a real impact on a global scale. Every day your individual efforts contribute to the lives of millions. There has never been a better time to join McGraw Hill. In our culture of curiosity and innovation, you will be able to own your growth and develop as we do. The work you do at McGraw Hill will be work those matters. We are collectively designing content that will build the future of education. Play your part and experience a sense of fulfilment that will inspire you to even greater heights. If you are curious, open to new ideas and ready to make a difference, we want to talk to you. We have a collective passion for the work we do and a curiosity to find new solutions. If you share our determination, together we will drive learning forward. Here’s What We Offer At McGraw Hill, you will be empowered to make a real impact on a global scale. Every day your individual efforts can contribute to the lives of millions. McGraw Hill recruiters always use a “@mheducation.com” email address and/or from our Applicant Tracking System, iCIMS. Any variation of this email domain should be considered suspicious. Additionally, McGraw Hill recruiters and authorized representatives will never request sensitive information in email. 48831 McGraw Hill uses an automated employment decision tool (AEDT) to assist in the screening process by recommending candidates with “like skills” based on resume and job data. To request an alternative screening process, please select “Opt-Out” when asked to “Consent to use of Automated Employment Decision Tools” during the application. Apply JOB_DESCRIPTION.SHARE.HTML CAROUSEL_PARAGRAPH JOB_DESCRIPTION.SHARE.HTML Show more Show less

Overview Build the Future At McGraw Hill we create best-in-class, next-generation learning platforms that are used by millions of students and educators worldwide from kindergarten through graduate school. Our goal is to accelerate student success through intuitive and effective learning tools and content that maximize a teacher’s time and a student’s learning experience. Our engineering team drive progress and help build the future of learning. If you have the passion and technical expertise to thrive in an innovative and agile environment, we want to learn more about you. What is this role about? McGraw-Hill Education, the leading provider of digital and print educational materials is looking for a Senior Data Engineer for our Data Analytics Group. The Senior Data Engineer in Data and Analytics is responsible for enhancing McGraw-Hill Education’s (MHE) business intelligence and data services capabilities, ensuring the delivery of actionable and timely insights to support financial, product, customer, user, and third-party data. This role also involves managing and monitoring the performance of the Data Platform, ensuring efficiency and reliability with hands-on data engineering, designing and architecting dynamic reporting, analytics, and modeling solutions to drive success in the education domain. The ideal candidate will have a strong data engineering background, with expertise in Oracle Cloud Infrastructure (OCI) with Exadata, Informatica Intelligent Cloud Services (IICS) and/or Databricks, AWS, with tht advanced proficiency in SQL queries. Additionally, this role requires close collaboration with stakeholders to ensure the successful delivery of projects. What you will be doing: Senior Data Engineer must have prior hands-on experience developing and delivering data solution with AWS and/Or Oracle technologies. Strong knowledge working with data from financial and operational systems, such as Oracle ERP Sales, Oracle DB and data modelling architecture with slow changing dimension (SCD). Experience in running cloud platform with optimized solution architecture with the ability to meet the daily runbook SLA. Strong experience with version control software like GIT and project management software like Jira with Agile/Kanban. Strong experience with Data Modelling concepts and Modern data architecture including cloud technologies. Ability to translate business requirements into technical requirements and deliveries. Design and develop parallel processing ETL solutions for optimal resource usage and faster processing. Understand ETL specification documents for mapping requirements and create mappings using transformations such as the Aggregator, Lookup, Router, Joiner, Union, Sorter, Normalizer and Update Strategy. Create UNIX shell scripts as Informatica workflow wrapper and perform housekeeping activities like cleanup and archive files. Experience in technical specification design - Proven experience in designing and building integrations supporting standard data modelling objects (Fact dimensions, aggregations, star schema, etc.) Ability to provide end-to-end technical guidance on the software development life cycle (requirements through implementation). Ability to create high quality solution design documentation for end-to-end solutions What you need to be considered: Expertise in Data warehousing and modern data lake concepts. 5+ years of experience in Data Engineering using tools such as:Informatica/IICS, Oracle DB and Oracle packages. AWS services. Data platforms like Athena with iceberg, lambda, EMR, and glue, Data bricks. Scripting languages like Python, Scala, Java or node. 1+ years of experience in Unix shell scripting 3+ years of experience working with Cloud like OCI, AWS, and Azure on Data technologies. Preferred: Experience with Publication and Education domain. Prior experience or familiarity with Tableau/Alteryx. Experience working with financial data like sales, revenue, cogs and manufacturing etc. Experience with IBM planning Analytics (TM1). Why work for us? At McGraw Hill, you will be empowered to make a real impact on a global scale. Every day your individual efforts contribute to the lives of millions. There has never been a better time to join McGraw Hill. In our culture of curiosity and innovation, you will be able to own your growth and develop as we do. The work you do at McGraw Hill will be work those matters. We are collectively designing content that will build the future of education. Play your part and experience a sense of fulfilment that will inspire you to even greater heights. If you are curious, open to new ideas and ready to make a difference, we want to talk to you. We have a collective passion for the work we do and a curiosity to find new solutions. If you share our determination, together we will drive learning forward. Here’s what we offer: At McGraw Hill, you will be empowered to make a real impact on a global scale. Every day your individual efforts can contribute to the lives of millions. McGraw Hill recruiters always use a “@mheducation.com” email address and/or from our Applicant Tracking System, iCIMS. Any variation of this email domain should be considered suspicious. Additionally, McGraw Hill recruiters and authorized representatives will never request sensitive information in email. 48831 Show more Show less