Job Description
To support our extraordinary teams who build great products and contribute to our growth, we’re looking to add Senior ETL Consultant – IT in Chennai Location.
Reporting to Senior Manager and the role involves
What a typical day looks like:
Hands on experience of Informatica Power Center (Preferred v9.6.1 and above) and must have worked on Power Exchange CDC for oracle project implementations.
At least 8 years of architecting & design experience in Data Warehouse space is must.
Should have good knowledge of databases Oracle and Snowflake
Hands on experience in Unix/Linux and shell scripting.
Strong knowledge of data analysis, data transformation, conceptual data modelling, data transformation and metadata management.
Should have Cloud data integration tools experience
Should be proficient enough to design and develop ETL for any data warehouse projects.
Should have very good technical skills to optimize/tune the SQL queries or workflow to reduce cycle times to process huge data set
Must have good communication and problem-solving skills
Experience:
8-12 years of experience in design, development, testing using Informatica, Oracle, Snowflake & Unix shell scripting
Proficient in Data modelling & Strong Exposure to Data Warehousing Concepts.
Hands on experience in Query tuning, Query Re-writing.
Able to write the Unix shell scripts
Good Written & Verbal Communication.
Job Requirements:
Design and Develop Informatica mappings, mapplets and workflows
Snowflake – Hands on experience with Cloud Data Integration tools and Snowflake database will be a PLUS
Able to write Unix shell scripts and debug the existing ones
Job description in detail:
Extensive experience in handling Data Warehousing systems
Should be able to understand the business requirements and propose apt data warehousing solution considering existing technologies in place and also by looking newer products in the market
Proficient in Data modelling and Data warehousing concepts
Strong hands-on experience in Design, Development and Testing using the technologies like Informatica, Snowflake, Oracle PL SQL & Unix
Improvise system performance by query tuning, query re-writing, or any other means
Hands on with writing Unix shell scripts
Hands on with reporting tools like MicroStrategy and Tableau would be a plus
Exposure to ERPs such as BaaN, ERP have greater advantage
Should envision end-to-end business process and reporting requirements
Self-learner who can also train and coach other members in the team
Understand process related to project delivery and on-going support
Job Requirements:
Work close with business and solution team to gather requirement and deliver right solution
Design and Develop Informatica mappings, mapplets and workflows using Informatica 9.6.1 or higher versions
Write SQL queries/procedures Oracle SQL/PL SQL
Review existing queries and enhance their performance
Writing low to medium complete Unix shell scripts
Interacting with various teams such as Operations, Support, and Business etc.
Share the workload and flexible enough to get into other technologies
Coach and guide other members in the team
Following defined process for project delivery and on-going support
What you’ll receive for the great work you provide:
Health Insurance
Paid Time Off
NK99
Job Category
IT
Flex pays for all costs associated with the application, interview or offer process, a candidate will not be asked for any payment related to these costs.
Flex does not accept unsolicited resumes from headhunters, recruitment agencies or fee based recruitment services. Flex is an Equal Opportunity Employer and employment selection decisions are based on merit, qualifications, and abilities. Flex does not discriminate in employment opportunities or practices based on: age, race, religion, color, sex, national origin, marital status, sexual orientation, gender identity, veteran status, disability, pregnancy status or any other status protected by law. Flex provides reasonable accommodation so that qualified applicants with a disability may participate in the selection process. Please advise us of any accommodations you request to express interest in a position by e-mailing: [email protected]. Please state your request for assistance in your message. Only reasonable accommodation requests related to applying for a specific position within Flex will be reviewed at the e-mail address. Flex will contact you if it is determined that your background is a match to the required skills required for this position. Thank you for considering a career with Flex.
Job Summary DG Micropronix is a leading IT & Industrial Automation service provider which offer its extensive service around the...
Apply For This JobHiring for Our client is an InsureTech Company delivery world-class solutions to its focused markets From 10 to 20 year(s)...
Apply For This JobBrightcove is a team of smart, passionate people who are revolutionizing the way organizations deliver video. We’re currently looking for...
Apply For This JobJOB Description Background: Siemens Financial Services (SFS) is globally rolling out new Contract Management System (CMS). As part of this...
Apply For This JobJob Description (For Website and Mobile App) Experience: 2+ Years of relevant industry experience Skills: Project management Eligibility: Any IT/...
Apply For This JobOPS IT – Solution Architect Macclesfield (UK) Sodertalje (Sweden) Gaithersburg (USA) Chennai (India) AMA.V6 ABOUT THE OPERATIONS IT TEAM Operations...
Apply For This Job