Qualification B.Tech. / B.E. in Computers/Electronics or equivalent/MCA Good to have Mandatory - Alteryx, SQL, Excel. Good to have - Python, Power BI, Database integration
Role & Responsibilities :
Ability to interact with business users and understand their requirements
Perform end to end Data validation & Data modeling if required
Communicate complex topics to team through both written and oral communicationsTake complete ownership of end to end project management from understanding the requirement from business, suggesting improvement (To be process flow), preparing the design document, developing, conducting unit testing and ensuring timely delivery of the project.
Design and develop ETL workflows and datasets in Alteryx to be used by the BI
Solid, deep experience with data extract, transform and load (ETL) tools as Alteryx
Prepare technical specifications and documentation for Alteryx workflows supporting BI reports Write Complex SQL queries on multiple tables using complex joins
Knowledge of Python, tools used and its libraries, should have some bit of hands on coding experience.
Conduct unit tests and develop database queries to analyze the effects and troubleshoot any issues that arise
Develop and update technical documentation for senior leaders and colleagues to serve as a reference guide
Understand if there is technical or business limitation to implement technology control/configuration
Provide recommendations to strengthen current processes, controls pertaining to technology platforms
Understand and document the compensating control for managing or mitigating security risk that might exist due to the technical or business limitation
Ensure all discussions with business to be documented and change management process to be adhered
Provide regular updates on assign tasks to team members
Develop impactful presentations and documents
Skill Set :-
Technical Alteryx (Mandatory) 2+ years of related experience with Alteryx
Hands-on skills and experience in Alteryx Designer, Alteryx Server, and the tools with Alteryx such as Predictive, Parsing, and Transforms.
Experience with data ETL (SQL, Alteryx) and ability to manipulate data and draw insights from large data sets. .
Strong analytical, problem solving, and troubleshooting abilities
Good understanding of unit testing, software change management, and software release management
Good understanding the star schema and data models in the existing data warehouse.
Sql (Mandatory) & Python good to have :-
Develop efficient MS-SQL queries and procedures to extract reports from database Understanding of data modeling and how to implement the same
Design, build, and maintain efficient, reusable, and efficient Python code along with other common libraries
Exp. In Tesseract or similar OCR engine and Camelot is preferable
Hands on experience in pdf data extraction using python libraries and Regex Unstructured to Structured text data processing experience is a plus
Python deployment experience with pip and wheel packages
Should be Proficient with GIT.
Essential :-
Strong communication skills and analytics
Self-Starter and able to self-manage
Ability to prepare accurate reports for all levels of staff in a language and tone appropriate to the audience.
Good team player, ability to work on a local, regional and global basis
Able to perform under pressure.
Ability to drive to succeed and go beyond the extra mile
Other programming experience
Financial services industry experience
General knowledge/skills: Databases, Excel, PowerPoint