• Us Citizen

• Green Card

• EAD (OPT/CPT/GC/H4)

• H1B Work Permit

• Corp-Corp

• Consulting/Contract

• UG :- - Not Required

• PG :- - Not Required

• No of position :- ( )

• Post :- 27th Sep 2021

Designs and develops complex and large scale data structures and pipelines to organize, collect and standardize data to generate insights and addresses reporting needs.

-Writes complex ETL (Extract / Transform / Load) processes, designs database systems and develops tools for real-time and offline analytic processing.

- Collaborates with BI Data Scientists to transform data and integrate algorithms and models into automated processes.

-Develop frameworks, standards & reference material for architecture and associated products.

-Designs data marts and data models to support Data Science and other internal customers.

-Behaves as mentor to junior team members to provide technical advice.

-Applies knowledge of Aetna systems and products to consult and advise on additional efforts across multiple domains spanning broader enterprise.

-Integrates data from a variety of sources, assuring that they adhere to data quality and accessibility standards.

-Experiments with available tools and advises on new tools in order to determine optimal solution given the requirements dictated by the model/use case.

Required Qualifications

-Advanced knowledge in MSSQL Server and/or DB2, SSIS, Microsoft .Net Framework, ASP, C#, Visual Studio, SAS, & SQL or similar.

- Hands on Experience in SSRS, Crystal Reports , SAS or other report builder tools.

- Strong programming skills in Python, Java or any of the popular scripting languages to build robust data pipelines and dynamic systems

-Advanced knowledge in Hadoop architecture, HDFS commands and experience designing & optimizing queries against data in the HDFS environment.

- Knowledge on Cloud architecture and Cloud Db setup on GCP, AWS or Azure.

-Experience building and implementing data transformation and processing solutions.

-Prior Database modeling experience preferred.

- Strong collaboration and communication skills within and across teams.

- Ability to leverage multiple tools and programming languages to analyze and manipulate large data sets from disparate data sources.

- Ability to understand and build complex systems and solve challenging analytical problems.

-Multiple years of progressively complex related experience.

Preferred Qualifications

- Experience with data visualization tools preferred.

- Working knowledge of Star Rating methodology and Data preferred.