Data Expert

Experience 11 - 15 yrs
Job Location Gurugram
CTC Best in Industry
Skills sql, tsql, plsql, python, perl, shell, data manipulation, etl, data integration, data automation, client deployment, integration, migration, data warehousing, data lake concepts, big data, cloud architecture, aws View More

Job Description

Responsibilities :
- Lead a team of Data Engineers to determine database structural requirements by
analyzing client operations, applications, and programming; reviewing objectives with
clients and evaluating current systems.
- Design and drive the ETL development: Plan, organize and drive development work.
Undertake complex analysis to accomplish the project objective. Develop ETL core
modules and lead junior resources in the development of remaining ETL
- Develop database solutions by designing proposed system; defining database physical
structure, functional capabilities
- Maintain database performance by identifying and resolving production and application
development problems; calculating optimum values for parameters; evaluating, integrating,
and installing new releases; completing maintenance and answering questions
- Provide database support by coding utilities, responding to user questions, and resolving
problems.
- Optimization & Automation: Work on existing sub-optimized processes to identify room for
improvements. Design and drive the work plan for the optimization/automation and
standardization of the processes
- Presentation of results: Independently design presentations to summarize the result of
analysis
- Develop deep understanding of the domain/function (across pricing, promotions, trade
architecture and assortment)
- Teamwork: Develop cross-site relationships to enhance idea generation. Set and manage
partner expectations. Coach and mentor new hires by sharing Business, Functional and
Technical expertise.
- Quality End products: Collaborate with the team in coding, testing and executing project
requests. Support ongoing business processes by delivering high quality products on time
and performing quality checks.

Desired Skills
- Expertise in handling large amounts of data through SQL, T-SQL or PL-SQL
- Strong knowledge and experience in scripting languages such as Python, Perl or Shell
- Strong coding/development abilities in the field of data manipulation and ETL
- Experience with integration of data from multiple data sources and automation of data
processes
- Experience overseeing the data stream of multiple projects including client deployment,
integration & migration
- Strong understanding of data-warehousing and data lake concepts
- Experience working in Big Data and cloud architecture including Amazon Web Services is
good to have

Education & Prior Experience :
- 11+ years of relevant and professional work experience with a reputed analytics firm
- Bachelor's degree / Master's Degree with high rankings from top / reputed colleges

Mindset & Competency :
- Excellent written and verbal communication skills in English
- Flexibility and willingness to learn new tools and techniques as per organization needs
- Comfortable with ambiguity, ability to interact in a fluid, demanding and unstructured
environment
- Self-motivated with strong sense of ownership and action-oriented mindset
- Able to work well within teams across continents/time zones with a collaborative mindset
- Ability to act autonomously, bringing structure and organization to work
- Collaborative and able to motivate team members
- Ability to travel for working sessions and meetings with Service Management team
- Ability to interact in a fluid and demanding environment where priorities evolve constantly
- Excellent analytical and problem-solving skills
- Ability to work under pressure and deliver on tight deadlines
- Ability to disaggregate issues, identify root causes and recommend solutions
- Outstanding project management skills (on time, within budget, according to scope etc.)
- High level of entrepreneurship, creativity, resilience and people leadership skills